Ooh I've got a few.
First DSLR was a D40 I was given for a birthday - I treasured it after coming from film. Went to Tassie on a holiday after finishing my undergraduate study, first day after I got there, heading into King Solomons Caves, the camera was (I thought) well secured in a lowpro carry case (which was zipped up), as I am walking towards the holding point I hear a crack and feel something hitting me against the legs...I look round and there was my D40 and a 55-200 - the lens shattered and broken from the mount (not before leaving its mounting ring) debris everywhere...Needless to say the lens was a writeoff, but the camera was repaired and still works to this day (and I got a 70-300VR instead via insurance). Lesson learnt: Never trust zips on the lower side of a bag, always bring them to the top - the camera had worked the zip open and eventually pushed through.
Second experience was my D700 with 24-70 falling off my tripod due to a screw that had loosened in the head, complete loss on the 24-70 as it landed on the lens barrel, but the camera was fine, insurance again to the rescue - made me very wary of tripods and encouraged me to change over my tripod head for something rock solid. Not a mistake Ill be making again.
Oh and a fun few with Sony videos: Was chasing storms with my buddy one night in Oklahoma, we both have Sony CX150 HD Videos, and use them regularly. Anyway, his classic was leaving the camera on the roof of the car, and then driving off at full speed - the camera went flying - drove back, picked it up, no worse for wear! Thought...jeez these things are tough. Later that night we were videoing hail falling under a service station roof, (8cm stones), I put mine in the alcove between the bonnet and the windscreen - sure enough a big gust of wind came through and blew it out. End result was mine ended up still working fine and being functional, besides the lens cap no longer closing. Toughest little cameras I have ever seen!
Edit: And despite the situations I use them in I have yet to have had a water incident with my camera, but have had hailstones bouncing off.