Ive forgotten at least once about every piece of dive gear and still entered the water. Once I almost entered the water without the entire scuba unit. Ive entered the water many times with the primary tank off and many more times I finish a dive and discover my back mounted pony is off. I did a 180 ft solo wreck dive with my new steel tank valve barely cracked, open (which made for an abbreviated dive).
Ive got tangled in a lift bag with a large anchor, got the line around my ankle and the bag dumped air at the surface and I got a fast ride to 90 feet (with a near empty tank). Ive been tangled in rope and fishing line and float line at least 100 times. I once removed my entire scuba unit to crawl deep in a wreck to get a lost fish/spear and then got stuck upside down and far away from my tank (while solo). Ive has to fight off sharks with my hands on one occasion and used spears on several others. I experienced dual leg cramps while making a solo surf exit while freediving that nearly killed me. Ive been nearly run over by a boat several times. Ive been bent once and probably several other times. I got lost once in a Florida cave with no guidline and zero training. Ive gotten an unsecured second stage caught in a lift bag and got a very fast, uncontrolled ride from 60 ft to the surface. Once I was dragged to the surface by a fisherman who had lodged his hook around my heel strap of my fin (it was shallow and at night, so not a big deal).
Im sure there are a lot more screw ups, but that is all I can remember right now.