1. Small, fixable failures: software crashed in production every night at 4AM.
2. Utter failures: long ago tried to do something like https://capnproto.org/, wasn't up to it.
3. Worked on many projects that were replaced or cancelled a year later; the largest was an airline reservation system.
4. Started a startup, it failed due to lack of attention to what users wanted.
You can hear full version of these stories and how to avoid other failures of mine at https://softwareclown.com