Thanks for sharing your horror story, I could feel my own gut drop as I read. Question would be, what could you have done to prevent such a calamity? What advise would could be gleaned to avoid similar mistakes? I back up and verify, all camera originals 3 times, before the card goes back, I guess always thinking about the worst case scenario can be quite taxing, especially under high stress, quick turn around projects. Power failure during back up and editing is a big one... so always have a RELIABLE UPS. I have a had a few UPS's fail before, luckily not during critical read write moments. I had a client ask me to prepare for unforeseen catastrophes... There are some things you can do, but others would require too much time and money...
30 years editing and motion graphics, still learning.