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 ANC77FA066Accident · 5 fatalClosedCessna 170-A · Portage Pass, AKNTSB SEA77FA045Accident · 1 fatalClosedCessna 182Q · Elk City, IDNTSB NYC77FHA30Accident · 1 fatalClosedTaylorcraft BC12D · Sciota, PANTSB MIA77FA072Accident · 3 fatalClosedPiper PA-32 · Clanton, ALNTSB IAD77FA054Accident · 3 fatalClosedBeech 95 · Fletcher, NCNTSB ANC77FA064Accident · 1 fatalClosedCessna 150 · Anchorage, AKNTSB ANC77FA063Accident · 1 fatalClosedHiller 12EJ3 · Ketchikan, AKNTSB SEA77FTI16Accident · 2 fatalClosedCessna 150M · Helena, MTNTSB MIA77FA071Accident · 5 fatalClosedCessna 172L · Vienna, GANTSB IAD78FA010Accident · 1 fatalClosedStinson 108-3 · Knoxville, TNNTSB MIA77FKQ24Accident · 1 fatalClosedPiper PA-18 · Louisville, MSNTSB SEA77FA043Accident · 5 fatalClosedPiper PA-32R · Bernard Creek, IDNTSB DEN77FA050Accident · 1 fatalClosedCessna 152 · Garfield, CONTSB SEA77FA042Accident · 1 fatalClosedKr-2 · Arlington, WANTSB OAK77FA044Accident · 2 fatalClosedPiper PA-32R · Tahoe Paradise, CANTSB MKC77FA031Accident · 3 fatalClosedBeech C35 C35 · Omaha, NENTSB FTW77FPA21Accident · 1 fatalClosedWolf-Hirth HI-27 · Sherman, TXNTSB FTW77FA064Accident · 1 fatalClosedMooney M20 · Shelbyville, TXNTSB MIA77FLT04Accident · 2 fatalClosedGrumman G-164A · Tunica, MSNTSB DEN77FA049Accident · 4 fatalClosedBeech D35 · Bakersville, CONTSB OAK77FA043Accident · 4 fatalClosedPiper PA-28 · Jackpot, NVNTSB CHI77FA060Accident · 1 fatalClosedPiper PA-23 · Plano, ILNTSB ANC77FA062Accident · 1 fatalClosedBrittnorman BN-2H · Ruby, AKNTSB OAK77FA042Accident · 2 fatalClosedBeech 95-B55 · Eureka, CANTSB NYC77FA072Accident · 1 fatalClosedPiper PA-31 · Cheektowaga, NYNTSB SEA77FYE29Accident · 1 fatalClosedTaylor B8M · Shelton, WANTSB OAK77FA041Accident · 1 fatalClosedPiper PA-28 · Truckee, CANTSB DEN77FTC19Accident · 2 fatalClosedDouglas DC-3A · Sheridan, WYNTSB DEN77FA048Accident · 2 fatalClosedBellanca 8GCBC · San Mateo, NMNTSB CHI77FEE32Accident · 2 fatalClosedPiper PA-28 · Wadsworth, ILNTSB ANC77FA060Accident · 2 fatalClosedPiper PA-14 · Wasilla, AKNTSB MIA77FA069Accident · 2 fatalClosedPiper PA-32 · Andros Is, Burkina FasoNTSB MIA77FA068Accident · 6 fatalClosedAero Cmdr 680 · Ft Lauderdale, FLNTSB MKC77FA030Accident · 4 fatalClosedPiper PA-22 · Bunker, MONTSB MIA77FA067Accident · 2 fatalClosedBellanca 7KCAB · Elberta, ALNTSB IAD77DA053Accident · 1 fatalClosedGrum Amer AA-1 · Vine Grove, KYNTSB CHI77FA059Accident · 1 fatalClosedCessna 150M · Peoria, ILNTSB LAX77FA058Accident · 2 fatalClosedCessna 150J · Silverado, CANTSB DEN77FA047Accident · 1 fatalClosedCessna TU206C · Vaughn, NMNTSB OAK77FVD43Accident · 1 fatalClosedCallair A-9B · Stockton, CANTSB LAX77FA057Accident · 1 fatalClosedBell 47G-5A · Maricopa, AZNTSB IAD77FA051Accident · 1 fatalClosedGrum Amer AA5-A · Warrenton, VANTSB CHI77FA058Accident · 1 fatalClosedPiper PA-28 · Clayton, ILNTSB ANC77FA055Accident · 1 fatalClosedPiper PA-28 · Tyonek, AKNTSB SEA77FYA28Accident · 1 fatalClosedHughes 369HS · American Falls, IDNTSB NYC77FA071Accident · 1 fatalClosedPiper PA-28 · Ocean City, NJNTSB NYC77FA070Accident · 3 fatalClosedPiper PA-28R · Hingham, MANTSB LAX77FUQ39Accident · 1 fatalClosedThorp T-18 · Van Nuys, CANTSB CHI77FET22Accident · 1 fatalClosedPiper PA-28 · Huntington, INNTSB OAK77FA040Accident · 1 fatalClosedCessna 421A · San Rafael, CA