Funny how the guy dies in a freak accident after being wrapped up in a big scandal.
As far as gym accidents? Just two that I can remember that were a bit worse than minor -
1) Cracked my schnozzola when an overhead press went wrong. Not a huge amount of weight on the bar, but it still left me seeing stars.
2) Snapped cable on a old tricep press down / lat machine. I was on the finished/bottom position of a rep when it snapped, and I remember being scared that it would hit my eye, but I ducked and turned away, and just got a bloody rope burn on my chest and neck.
Other than those two, just banged shins, dropped light weight plates, etc.... type stuff otherwise, knock on wood.