A good book in this space is Normal Accidents[0], which describes (among others) the impressive cumulative failure that caused the Three Mile Island incident. Fascinating read and applicable to software systems as well.

[0]: https://en.wikipedia.org/wiki/Normal_Accidents