may i refer you to the cautionary tale in Beneath the Mountains......
He paused for the first time at the top of Camshaft. It had been one of the trickier rigs in the cave, for there was a rub pointy a short way down which had proved curiously difficult to avoid with rebelays. A few days before, a party found the rope cut to the core, and sensibly they cut it, leaving only just enough for the descent. They arranged a more gymnastic way of getting on the rope which required a shorter length.
Despite the fact that Ian was on a de-rigging trip, he found himself unable to avoid re-rigging this pitch again. He knew that the take-off in this case would be so much simpler and less strenuous if there was an extra back-up from the boulder by the stream, and if the main hang were achieved via a triple belay...he pulled up the rope required and made his adjustments. What he didn't do was to check it there was a knot on the end of the rope. All the ropes on the expedition had knots in the end, even, as was usually the case, if the rope was much longer than required. There was still a knot in the end of the spare rope coiled on the floor. It is tempting to speculate whether a companion would have pointed out to Ian that he should check the rope's end, but Ian didn't have a companion.
What Ian did was to use about fifteen feet of extra rope in his re-rig, so that when he slid down the rope he sailed off the free end and flew bum-first into a serendipitous deep pool of water. It was about nine o'clock in the morning. Back at the camp, above all the pitches, squeezes and across the fell, the other cavers lay dozing in their bags. Not one had started to stir.
Neck-deep in his pool, Ian was far from asleep. His plight was straight out of a caving pub-yarn; at once desperately serious and totally absurd. The rope dangled enticingly above him way out of reach. There were no walls anywhere near to it, nor any movable rocks he could use to build a cairn and get to it. When he recovered from the shock he had a go at climbing up in the downstream passage, where he could bridge with one foot on either wall until he was way, way above the floor, perhaps half the height of the pitch. It wasn't possible to get any higher, and he could see the rope dangling only metres away out of reach. Did it occur to him to leap into space and grab for the rope, or did he accept his fate at once? Whichever, he was marooned.
I;ll let you read the rest to find out his fate - http://www.oucc.org.uk/btm/beneath.htm
lest to say no matter how long your rope - ALWAYS BLOODY WELL PUT A KNOT IN THE END.