What a great article. Several years ago I wrote a (far inferior) post along similar lines, using a famous railway/bridge disaster[1]. Study of these kinds of engineering failures, even those from hundreds of years ago, are so revealing. I'd lay money on similar reports from the days of the ancient Egyptians as being just as valuable.
[1] https://blog.eutopian.io/the-age-of-invisible-disasters/