Oh you mean this one that soooo wasn't used for it's intended purpose ?
Ah PSYCHO-PASS, season one. You were a good show.
Ahh, well I'm sure you're more careful now.
... you yandere. Kidding kidding.
But OUCH!
Well, sometimes it's better to tell a white lie. No harm done in my opinion.
---
I think you've brought up a very interesting topic @Evil Bunny of Doom. Often these types of memories are very vivid, and will stay in your long-term memory for well, a long time.
I have a few moments that come to me, though nowhere near as spectacular as any of yours:
Was filming a short film with a group of friends, and we were driving around several locations to do the filming. I was the driver. At the second location after filming I loaded my camera and tripod and shut the trunk / boot. Then I tried to open the driver's door and it was locked. I searched my pockets. Yes, I locked my keys in the car. Had to call my parents to drop a spare key off. My friends were not amused.
I was in a bit of a rush one morning and was making cereal. I think I was half-asleep as I put the cold milk inside the pantry, and tried to put the cereal box inside the fridge. I eventually figured out the mistake when I figured that cereal box definitely wasn't going inside the fridge.