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 MKC77FA016Accident · 2 fatalClosedBellanca 8KCAB · Valparaiso, NENTSB MKC77FA015Accident · 6 fatalClosedBeech D50E · Springfield, MONTSB DEN77FA027Accident · 3 fatalClosedCessna U206D · Hanna, UTNTSB DEN77FA026Accident · 2 fatalClosedPiper PA-24 · Broomfield, CONTSB FTW77FA038Accident · 1 fatalClosedCessna 150 · Center, TXNTSB OAK77FA021Accident · 1 fatalClosedPiper PA-24 · Elko, NVNTSB NYC77FA033Accident · 1 fatalClosedMooney M20F · Johnstown, PANTSB DCA77AA012Accident · 8 fatalClosedPiper PA-31T · Bressler, PANTSB MIA77FA035Accident · 1 fatalClosedEnstrom 280C · Ft.Meade, FLNTSB FTW77FA037Accident · 5 fatalClosedPiper PA-31 · Springdale, ARNTSB LAX77FA028Accident · 4 fatalClosedBeech K35 · Big Bear City, CANTSB MIA77FA033Accident · 1 fatalClosedPiper PA-28 · Tampa, FLNTSB CHI77FA030Accident · 1 fatalClosedCessna 150J · Carleton, MINTSB OAK77FA019Accident · 1 fatalClosedBoeing B75N1 · Jean, NVNTSB FTW77FRG27Accident · 1 fatalClosedBeech D18S · Mc Allen, TXNTSB CHI77FA029Accident · 2 fatalClosedAeronca 7AC · St Paris, OHNTSB IAD77FA025Accident · 1 fatalClosedCessna 150M · Burlington, NCNTSB ANC77FA031Accident · 2 fatalClosedStinson 108-2 · Merrill Pass, AKNTSB MKC77FA014Accident · 1 fatalClosedBeech S-35 · Sioux City, IANTSB MIA77FA031Accident · 1 fatalClosedBell 206-A · Jayuya, PRNTSB IAD77FA024Accident · 1 fatalClosedPiper PA-28 · New Castle, VANTSB DEN77FA025Accident · 2 fatalClosedCessna 150C · Reserve, NMNTSB OAK77FA018Accident · 1 fatalClosedTaylorcraft BC12D1 · Las Vegas, NVNTSB DEN77FAO24Accident · 2 fatalClosedMooney M20F · Franktown, CONTSB MIA77FA030Accident · 2 fatalClosedGrum Amer AA1B · St Petersburg, FLNTSB FTW77FA036Accident · 2 fatalClosedCessna 150H · Mer Rouge, LANTSB IAD77DA022Accident · 1 fatalClosedPiper PA-18 · Louisville, KYNTSB SEA77FA019Accident · 1 fatalClosedPiper PA-28R · Port Orchard, WANTSB IAD77FA021Accident · 1 fatalClosedCessna 182 · Lively, VANTSB FTW77FA035Accident · 3 fatalClosedPiper PA-28 · Baton Rouge, LANTSB CHI77FA028Accident · 4 fatalClosedPiper PA-32 · Sugar Grove, ILNTSB MKC77FA013Accident · 6 fatalClosedPiper PA-31 · Anthony, KSNTSB MIA77FA029Accident · 2 fatalClosedBeech B19 · Pensacola Bch, FLNTSB SEA77FA018Accident · 3 fatalClosedPiper PA-28 · Carey, IDNTSB LAX77FA027Accident · 2 fatalClosedStinson JR.S. · Aztec, AZNTSB OAK77FA016Accident · 1 fatalClosedPiper PA-22 · Clearlake Oaks, CANTSB NYC77FA030Accident · 1 fatalClosedCessna 150L · Smithfield, RINTSB LAX77FA035Accident · 1 fatalClosedCessna 182H · Tuscon, AZNTSB FTW77FA033Accident · 2 fatalClosedSwearingen SA266T · Beckmam, TXNTSB CHI77FA026Accident · 1 fatalClosedBeech 58 · Necedah, WINTSB SEA77FA017Accident · 1 fatalClosedPiper PA-23 · Moro, ORNTSB LAX77FUJ27Accident · 1 fatalClosedBoeing A75N1 · Parker, AZNTSB ANC77FA024Accident · 1 fatalClosedChase YC122C · Anchorage, AKNTSB IAD77FA019Accident · 3 fatalClosedPiper PA30 · Dyersburg, TNNTSB IAD77FA018Accident · 2 fatalClosedCessna 177RG · Chattanooga, TNNTSB SEA77FA015Accident · 1 fatalClosedPiper PA-32R · Olympia, WANTSB OAK77DVD12Accident · 1 fatalClosedPiper PA-28 · Pacific Ocean (Pacific Ocean)NTSB MIA77FA026Accident · 2 fatalClosedCessna 411 · Ft Myers, FLNTSB DEN77FA023Accident · 3 fatalClosedBellanca 17-30A · San Mateo, NMNTSB SEA77FA014Accident · 3 fatalClosedCessna 172M · Forks, WA