“Those who cannot remember the past are condemned to repeat it.” — George Santayana
As business jet pilots, or just pilots in general, that quote hits close to home, as learning from other people’s mistakes is a big part of making sure we don’t make the same mistakes.
I fly a specific family of business jets and wanted an easier way to gather and review accident and incident data without having to dig through multiple sites each time. So I built a tool that pulls everything together automatically.
Here’s what it does:
-
Queries the Aviation Safety Network for all accidents/incidents related to the aircraft type configured in the workflow
-
Retrieves registration info and any other relevant details
-
Uses SerpAPI to run targeted Google searches and collect additional data
-
Stores everything in a Postgres database
-
Feeds all the data into OpenAI to get a one-paragraph summary
-
Generates a clean HTML page that shows all the information in one place
-
Continuously updates as new data becomes available
Instead of bouncing between websites or running the same searches over and over, this tool keeps everything centralized for me and the other pilots I fly with.
You can find more information and the workflow here:
https://github.com/rjsears/aircraft_accident_tracker/