Our productMarine dealer SaaS
HelmDMS
POS, service work orders, scheduling, parts, boat sales, texting, and an AI agent that answers the phone, in one multi-tenant platform we designed, built, and run.
- SaaS product
- AI phone agent
- POS & payments
Client projectAviation safety research
DTSB Accident Data
Fresh NTSB accident reports, pulled automatically and delivered for review.
A scheduled pipeline that pulls general aviation accident records from the NTSB’s public data API twice a day and delivers new fatal-accident reports to the DTSB for review, with no one checking by hand.
- Scheduled sync, fully automated
- 2x daily
- Scheduled sync, fully automated
- Accident cases kept in sync
- 5,000+
- Accident cases kept in sync
- Reports delivered for review
- 3,600+
- Reports delivered for review
- Fatal finals and prelims filtered automatically
- Part 91
- Fatal finals and prelims filtered automatically
The challenge
The DTSB tracks general aviation accident data, which means keeping up with a steady flow of new preliminary and final reports from federal investigators.
Checking for new reports by hand is slow and easy to miss, and the raw government data is messy: inconsistent registrations, case numbers, and placeholder values make it hard to match against the DTSB’s own records.
What we built
We built an automated pipeline that runs on a schedule twice a day. It sweeps the NTSB’s public accident database for newly completed investigations and newly posted preliminary reports and keeps a local, deduplicated copy so unchanged records are skipped.
New Part 91 fatal-accident finals and preliminaries are filtered out and delivered to the DTSB for review, with the probable cause or preliminary narrative quoted word for word. On a quiet day nothing is sent. We also reconciled the DTSB’s existing accident records against the federal data to flag cases whose status had changed.
Key features
Scheduled, hands-off sync
A scheduled job runs twice a day, so new investigation reports reach the DTSB within hours of being published.
Finals and preliminaries
Sweeps both newly completed investigations and open cases with fresh preliminary reports, tracked separately.
Deduplicated local mirror
Every case is stored once and content-hashed, so re-runs are safe and only genuine changes count as updates.
Targeted filtering
Only the reports the DTSB reviews, fatal general aviation (Part 91) accidents, are selected for delivery.
Verbatim delivery
Each report goes out with the tail number and the official probable cause or narrative quoted word for word, ready to review.
Record reconciliation
Forgiving matching on registrations and case numbers flagged where the DTSB’s own records had fallen behind the federal data.
Technology
- Scheduled jobs (cron)
- NTSB public data API
- SQLite mirror
- Python
- Automated email delivery
Services behind this project
Want something like DTSB Accident Data?
We scope it with you, build it, host it, and stay on the hook after launch. Local to Murray, Kentucky, working with businesses anywhere.
More of our work
All projects →Our product
Our productAI document SaaS
ExoInvoice
An AI invoice-processing platform that reads supplier invoices, matches the customer, applies markup, and produces a branded bill. Built from our own contracting experience.
- SaaS product
- AI document extraction
- Public API
Our productAviation SaaS
FlightWay
Scheduling, flight logging, maintenance, and member billing that post straight to a real double-entry ledger, so a volunteer treasurer runs one system instead of three.
- SaaS product
- Accounting engine
- Installable web app