Once had an app in production that was using two EC2 instances as it's backend. I was "tidying up" and deleted them as I thought I was in a different region. I had a backup and didn't lose anything...
... except ...
I realised almost immediately what happened and the mistake I'd made, as did every other user of the app...
The app?...
So I had to create a new version of the app and roll it out without the bug... Took about 6 hours to resolve it.
My fault.
Completely avoidable.
Everybody makes mistakes.
Taught me the importance of separating environments, CD, and robust release processes.