Beneath the Twisted Tower (1993)
The AD&D 2e Forgotten Realms Campaign Setting boxed set (1993) included the sourcebook Shadowdale, which contained an adventure module named Beneath the Twisted Tower, for players of between 1st and 3rd levels.
A dead-end underwater trap, p.62:
The clear pool is a false exit and deathtrap ... the rope by which the PCs can supposedly pull themselves to another aired chamber is, in fact, a rope to nowhere, installed simply to lure the PCs to their deaths.
A steep narrow winding corridor, p.75:
The passage narrows somewhat so that no more than one can pass through it at a time. In addition, it begins a steady and fairly steep slope upward as it curves in at least two full circles clockwise at an increasingly sharp angle.
A mostly empty drider lair containing a relatively inexpensive gem, p.75:
Most of the openings along the upper reaches of the irregular wall in this cavern are nothing but alcoves formed by swirling water in the dim past of the cavern's formation, but one, above a large rock slab on the west side of the cavern, has been expanded and worked to become the lair of a lone drider. [...]
Hidden in the drider's lair, in a hole under a webbed lid covered with camouflaging dirt and rock are 9 platinum pieces and 2 rubies (30-gp value each). A secret door in the back left of the drider lair leads to the darkened corridor described in 8C3, above.
Also, the read-aloud text box describing the character's inevitable doom in the water trap, p.63:
The rope angles sharply upward and you can tell from the decreased water pressure that you are finally nearing the surface. But as you go to surface, you realize, with a shudder of panic and dismay that the surface is merely the underside of a large rock slab, with no opening or air pocket in sight. It suddenly comes to you in terror that you have literally come to the end of your rope; it is securely attached to the underside of the underwater rock slab. A frantic search of the surrounding area indicates no place to surface and nowhere to go for air.