One time i called a medium sized turn bet with an open-ended straight draw, and the river came and i hit my straight. My opponent bet, and I raised over the top all-in.
He flipped over his two pair, and i threw down my straight ready to take the chips from the pot, when somebody else (not even the guy that had two pair) pointed out that I only had 4 to the straight

Oops.....
Needless to say i was a little embarassed, and i was also busted from the tourney. Rough hand to say the least