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 FTW78FA007Accident · 1 fatalClosedEsteen Skyblt · Albany, TXNTSB SEA77FA004Accident · 4 fatalClosedN.American Navion · Yakima, WANTSB MKC78FA004Accident · 4 fatalClosedPiper PA-28 · Blair, NENTSB MKC78FA003Accident · 1 fatalClosedAmer Avco AA-1B · St Louis, MONTSB MKC78FA002Accident · 2 fatalClosedGrumann AA-5A · Pierce, NENTSB FTW78FA006Accident · 2 fatalClosedPiper PA-30 · Wetumka, OKNTSB FTW78FA005Accident · 1 fatalClosedBeech M35 · Dubach, LANTSB LAX78FA002Accident · 2 fatalClosedBeech A23-24 · El Cajon, CANTSB IAD78FA006Accident · 1 fatalClosedPiper J-3 · Pulaski, TNNTSB DEN78FA004Accident · 1 fatalClosedPiper PA-23 · Corona, NMNTSB DEN78FQD02Accident · 1 fatalClosedPiper PA-28R · Columbus, NMNTSB DCA78AA001Accident · 6 fatalClosedConvair 240 · Gillsburg, MSNTSB FTW78FQG03Accident · 1 fatalClosedPiper PA-25 · Smyer, TXNTSB CHI78FA003Accident · 1 fatalClosedBeech 200 · Valparaiso, INNTSB OAK78FA001Accident · 2 fatalClosedCessna 150J · Klamath, CANTSB FTW78FA004Accident · 2 fatalClosedCessna 150L · Dewey, OKNTSB IAD78FA005Accident · 3 fatalClosedBeech D35 · Livingston, KYNTSB MIA78FA006Accident · 3 fatalClosedCessna 150 · Cedar Key, FLNTSB MIA77FA005Accident · 2 fatalClosedPiper PA-28 · Brunswick, GANTSB FTW78FPA02Accident · 2 fatalClosedPiper J3C-65 · Terrell, TXNTSB MIA78FA002Accident · 2 fatalClosedPiper PA-30 · Charleston, SCNTSB IAD78FA003Accident · 1 fatalClosedBellanca 7GCBC · Sparta, TNNTSB FTW78FA003Accident · 2 fatalClosedBell 206B · Grand Chenier, LANTSB IAD78FA002Accident · 4 fatalClosedCessna 182P · Wise, VANTSB SEA78FA003Accident · 3 fatalClosedPiper PA-31P · Vancouver, WANTSB MKC78FA001Accident · 2 fatalClosedNavion A · Caldwell, KSNTSB SEA78FA006Accident · 2 fatalClosedCessna 182J · Umpqua, ORNTSB FTW78FA001Accident · 5 fatalClosedPilatus PC6CH2 · Oklahoma City, OKNTSB SEA78FA002Accident · 2 fatalClosedBellanca 7GCBC · Lowman, IDNTSB DEN78FA003Accident · 2 fatalClosedMooney M20C · Sheridan, WYNTSB DEN78FA001Accident · 2 fatalClosedBellanca 8KCAB · Vernal, UTNTSB SEA78FA001Accident · 7 fatalClosedDehavilland DHC-2 · Stevens Pass, WANTSB SEA77FA055Accident · 2 fatalClosedPiper PA-28 · Reardan, WANTSB MIA77FA095Accident · 1 fatalClosedCessna 182P · Stone Mountain, GANTSB DEN78FA002Accident · 7 fatalClosedPiper PA-32 · Cedar Fort, UTNTSB OAK77FA059Accident · 2 fatalClosedCessna 172N · Pahala, HINTSB NYC77FA099Accident · 2 fatalClosedCessna 402B · Mercer, PANTSB LAX77FVA59Accident · 2 fatalClosedCessna 172M · Bakersfield, CANTSB SEA77FA056Accident · 1 fatalClosedCessna 206 · Cove, ORNTSB FTW77FA076Accident · 1 fatalClosedRyan ST-A · Mason, TXNTSB MIA77FA093Accident · 1 fatalClosedBeech 100 · Auburn, ALNTSB DEN77FA060Accident · 2 fatalClosedBellanca 7GCBC · Tensleep, WYNTSB MIA77FA092Accident · 1 fatalClosedCessna 152 · Delray Beach, FLNTSB OAK77FA058Accident · 2 fatalClosedRepublic RC-3 · No.Las Vegas, NVNTSB MIA77FA091Accident · 2 fatalClosedAeronca 7DC · Cleveland, MSNTSB LAX77FA075Accident · 1 fatalClosedBellanca 7AC · Yucca Valley, CANTSB IAD77FA068Accident · 2 fatalClosedCessna 210L · Smithville, TNNTSB FTW77FA077Accident · 1 fatalClosedChampion 7ECA · Nacogdoches, TXNTSB DEN77FA059Accident · 1 fatalClosedCessna 150K · Cedar Fort, UTNTSB MIA77FA090Accident · 1 fatalClosedCessna 150 · Water Valley, MS