I've had very few oh crap moments in my hobby work. I've had some small oops while painting that were quickly and easily fixed.
The one oh crap moment which I can remember was a metal VOR Union Sniper I painted for a painting contest. I had finished it up and got it clear coated nicely. As it was an online painting comp, I had to take pictures of it. I got my camera rig all set up and took pictures, rotating it and taking pictures from all sides. As I finish taking the pictures and I go to grab the miniature, which was sitting on a small box with a cloth or paper on it, I manage bump the box/paper/cloth stack. The miniature leaps forward and bounces off my fingers and proceeds to play plinko with the legs of my tripod. I think it managed to bounce off the legs and braces about 20 times, at least that's what it sounded like, although it was maybe only four times. Once it came to a rest I picked it up and found that the 20 or so hours I had put into it were wasted. It had about five major chips in it. To this day it sits on my shelf in the same state it was. I just haven't gotten the energy to go back and fix it. I was not happy to say the least. To top it all the off the pictures were not that great and I had to make due with what I had.
I've cut myself plenty of times too. Which makes me think of the worst X-acto accident I've seen. Not hobby related, but when I was in school, one of my classmates in the architecture studio accidentally impaled an X-acto blade completely in his leg.
I've never really cut myself bad. Just very minor surface cuts that heal in a couple days. Maybe a couple times jabbing 1/16" of the end of my No. 11 X-acto blade into a fingertip. However I remember one time when my brother cut himself with an X-acto knife. He had a No. 5 handle, which is the big handle and not the smaller one for the standard No. 11 blade. He had one of the wooden boxed sets with the assortment of blades and handles. Well one of the blades for the No. 5 handle is a leaf shaped blade that is sharp on both sides. They still sell these kits, but I don't think they include this blade anymore. I suspect that they may not include it just for this reason. The blade is this one, the No. 23.
Well as a lot of people do when trying to cut something with a normal single sided blade and they are having a hard time cutting they'll take their thumb and press on the back of it to help push it through. Well, not thinking and using this blade, he did just that and pressed his thumb into a razor sharp blade. He ended up with about an inch long cut on his thumb. The worst part about it was that once he realized what he did was started shaking his hand up and down while calling out "Oh crap, oh crap, oh crap!" Much like people do when they smash their finger with a hammer. Of course this caused blood to spray all over our kitchen. Our father wasn't home, so after he calmed down he just wrapped it and let it heal. He probably should have had stitches but he didn't. Needless to say, he's never pushed on the back of a knife again, at least as far as I know.
Then there was the time that my brother and I were doing stupid teen things when our father wasn't home and I shot myself in the finger with the primer cap out of 30-30 shell. All the details aren't important, if you really want to know what happened PM me. However my brother had to dig around in my finger with a tweezers to pull the primer cap out of a hole in my skin that was about a mm in diameter. Suffice to say we stopped taking apart shotgun and rifle shells after that! Luckily something worse didn't happen. Remember kids, bullets are not to be messed around with!
Thinking back, my brother and I had a whole lot of "Oh crap moments when we were young." Mostly when doing stupid teen stuff.