Fatal NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"highestInjuryLevel\" = 'Fatal' ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."highestInjuryLevel" = 'Fatal' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MIA79FLD63Accident · 1 fatalClosedBell 47G · Loghman, FLNTSB ANC78FA052Accident · 1 fatalClosedCessna 150M · Cantwell, AKNTSB SEA78FA045Accident · 1 fatalClosedHiller FH1100 · Clearlake, WANTSB NYC78FA070Accident · 1 fatalClosedPiper PA-22 · Huntingdon, PANTSB MKC78FER74Accident · 1 fatalClosedJ Lowers T-WIND · Fergus Falls, MNNTSB IAD78FA083Accident · 1 fatalClosedLuscombe 8A · Fairfield, NCNTSB CHI78FEC40Accident · 1 fatalClosedRyan ST3KR · Petersburg, MINTSB ANC79FA051Accident · 1 fatalClosedBrantly B2-B · Nome, AKNTSB LAX78FA062Accident · 2 fatalClosedGrum Amer AA1C · Prescott, AZNTSB NYC78FNE27Accident · 1 fatalClosedSchempp-Hir Cirrus · Fitchburg, MANTSB MKC78FA055Accident · 6 fatalClosedBeech 60 · Faribault, MNNTSB CHI78FA049Accident · 1 fatalClosedBellanca 17-30A · Rhinelander, WINTSB SEA78FA044Accident · 1 fatalClosedBeech B24R · Vashon, WANTSB MKC78FCD39Accident · 2 fatalClosedSkylark WC-3 · Eagle Grove, IANTSB MIA78FA103Accident · 3 fatalClosedPiper PA-30 · Albany, GANTSB DEN78FA054Accident · 6 fatalClosedBeech 65-A90 · Aurora, CONTSB SEA78DA042Accident · 1 fatalClosedCessna 170A · Billings, MTNTSB NYC78FA069Accident · 4 fatalClosedPiper PA-32 · Westerly, RINTSB MKC78FA054Accident · 1 fatalClosedCessna 175B · Turtle Lake, NDNTSB CHI78FEX23Accident · 1 fatalClosedHunter Mong GH-1 · Roll, INNTSB DEN78FTM28Accident · 1 fatalClosedClark Focke 190A3 · Cedar City, UTNTSB ANC78FA045Accident · 1 fatalClosedCessna 180 · Iliamna, AKNTSB MIA78FKG60Accident · 1 fatalClosedPiper PA-25 · Cordele, GANTSB LAX78FA061Accident · 1 fatalClosedSikorsky S-62A · San Pedro, CANTSB IAD78FA078Accident · 1 fatalClosedPiper PA-32 · Deep Gap, NCNTSB FTW78FA058Accident · 1 fatalClosedBell 206B · Cameron, LANTSB CHI78FA046Accident · 1 fatalClosedCessna 170B · Ann Arbor, MINTSB OAK78FA037Accident · 5 fatalClosedPiper PA-34 · Ysmite Nat Pk, CANTSB MIA78FA102Accident · 2 fatalClosedBellanca 17-31A · Lake City, FLNTSB LAX78FA060Accident · 2 fatalClosedCessna 195 · Grand Canyon, AZNTSB IAD78FA077Accident · 3 fatalClosedPiper PA-24 · Deerfield, VANTSB IAD78FA076Accident · 2 fatalClosedAeronca 7AC · Vanceboro, NCNTSB ANC78FA048Accident · 1 fatalClosedCessna A185F · Coronation Is, AKNTSB OAK78FVG59Accident · 1 fatalClosedVarieze · Dorris, CANTSB FTW78FA056Accident · 3 fatalClosedCessna 182P · Hollis, OKNTSB DEN78FA053Accident · 1 fatalClosedCessna TU206 · Canyon, WYNTSB OAK78FAO36Accident · 4 fatalClosedCessna 182A · Red Bluff, CANTSB LAX78FA059Accident · 3 fatalClosedMooney M20E · Ajo, AZNTSB FTW78FA055Accident · 2 fatalClosedBellanca 7GCBC · San Jose Isl, TXNTSB MKC78FA053Accident · 4 fatalClosedPiper PA-32 · Denison, IANTSB MIA78FA101Accident · 2 fatalClosedPiper PA-28R · Courtland, ALNTSB LAX78FUJ74Accident · 1 fatalClosedPitts S-1T · Taylor, AZNTSB LAX78FA058Accident · 1 fatalClosedCessna 182 · San Diego, CANTSB FTW78FPJ29Accident · 1 fatalClosedBellanca 8GCBC · Hinton, OKNTSB SEA78FA041Accident · 2 fatalClosedCessna 210L · Belgrade, MTNTSB ANC78FA042Accident · 1 fatalClosedCessna 207 · Omalik, AKNTSB SEA78FA040Accident · 2 fatalClosedHughes 369D · New Meadows, IDNTSB LAX78FA057Accident · 3 fatalClosedCessna 170 · Grand Canyon, AZNTSB MIA78FA100Accident · 1 fatalClosedBeechcraft 65-80 · Mobile, ALNTSB FTW78FA054Accident · 2 fatalClosedPiper PA-28 · Hebbronville, TX