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 MKC78FA067Accident · 2 fatalClosedPiper PA-28 · St George, MNNTSB MIA78FA120Accident · 2 fatalClosedGrum-Amer AA1A · Toa Baja, PRNTSB IAD78FA099Accident · 2 fatalClosedPiper PA-28R · Bolton, NCNTSB IAD78FA098Accident · 2 fatalClosedCessna 210L · Hot Springs, VANTSB DEN78FA065Accident · 6 fatalClosedMitsubishi MU-2J · Raton, NMNTSB ANC78FA067Accident · 12 fatalClosedGrumman G-21A · Laboucher BayNTSB OAK78FA044Accident · 1 fatalClosedCessna 182Q · Eureka, CANTSB OAK78FVD54Accident · 1 fatalClosedGrumman TS-2A · Laytonville, CANTSB NYC78FA082Accident · 1 fatalClosedCessna 150L · Prospect Harbr, MENTSB MKC78FA066Accident · 2 fatalClosedCessna 172N · Blaine, MNNTSB LAX78FA067Accident · 2 fatalClosedGarcia HS A-2 · Rnch Cucamonga, CANTSB IAD78FA097Accident · 4 fatalClosedCessna 195 · Whitesburg, KYNTSB CHI78FA060Accident · 2 fatalClosedWooddell Pusher · Fort Wayne, INNTSB SEA78FA058Accident · 2 fatalClosedBeech C35 · Redmond, ORNTSB MIA78FA116Accident · 2 fatalClosedPiper J3C · Homestead, FLNTSB FTW78FPG78Accident · 1 fatalClosedPiper PA-25 · Sherrill, ARNTSB UNK78X0132Accident · 1 fatalClosedBell 205A · Dennison, CanadaNTSB SEA78FA057Accident · 6 fatalClosedCessna 320 · Anaconda, MTNTSB OAK78FA043Accident · 1 fatalClosedBellanca 8KCAB · Caruthers, CANTSB MKC78FA065Accident · 3 fatalClosedBell 47-G2 · Branson, MONTSB CHI78FEP61Accident · 2 fatalClosedBeech C23 · Portage, WINTSB FTW78FA069Accident · 2 fatalClosedAeronca 7AC · Haslet, TXNTSB SEA78FA056Accident · 2 fatalClosedCessna 172XP · Eugene, ORNTSB SEA78AM001Accident · 2 fatalClosedPiper PA-28 · Missing AircraftNTSB NYC78FA081Accident · 1 fatalClosedCessna 177 · Chatham, MANTSB DEN78FA060Accident · 2 fatalClosedPiper PA-28 · Edgerton, WYNTSB CHI78FEX31Accident · 1 fatalClosedCessna 172 · Evansville, INNTSB IAD78FA094Accident · 4 fatalClosedPiper PA-28 · Hemlock, WVNTSB FTW78FA067Accident · 2 fatalClosedCessna 150K · De Queen, ARNTSB FTW78FA066Accident · 1 fatalClosedBolkow BO-105 · Cameron, LANTSB DEN78FA059Accident · 6 fatalClosedBeech 55 · Fairfield, UTNTSB CHI78FEP47Accident · 1 fatalClosedChampion 7ECA · Howard, WINTSB CHI78FA059Accident · 2 fatalClosedMooney M20C · Valparaiso, INNTSB ANC78FA065Accident · 1 fatalClosedBeech 95-B55 · Wittier, AKNTSB MKC78FA064Accident · 1 fatalClosedGreat Lakes 2T-1A · Mason City, IANTSB MKC78FA063Accident · 3 fatalClosedCessna 177 · Plainville, KSNTSB MKC78FA062Accident · 4 fatalClosedPiper PA-28 · Brighton, MONTSB MIA79FLA34Accident · 1 fatalClosedBell 47G2 · Omega, GANTSB DEN78FA057Accident · 5 fatalClosedPiper PA-28 · Silverplume, CONTSB CHI78FA058Accident · 1 fatalClosedPiper PA-28 · Bedford, INNTSB SEA78FYA21Accident · 1 fatalClosedAir Tractor AT-300 · Idaho Falls, IDNTSB SEA78FA055Accident · 3 fatalClosedAero Comdr 100 · Bly, ORNTSB SEA78FA054Accident · 1 fatalClosedCessna T206 · Challis, IDNTSB SEA78FA053Accident · 1 fatalClosedStinson 108E · Enumclaw, WANTSB IAD78FA114Accident · 1 fatalClosedBellanca 8KCAB · Princeton, KYNTSB IAD78FA092Accident · 1 fatalClosedPiper J-3 · White Marsh, MDNTSB DEN78FA056Accident · 3 fatalClosedPiper PA-24 · Carrizozo, NMNTSB MIA78DA112Accident · 1 fatalClosedSchemp Nimbus · Mt Groghan, SCNTSB IAD78FA090Accident · 1 fatalClosedPiper PA-22 · Westminister, MDNTSB ANC78FA066Accident · 2 fatalClosedPiper PA-22 · Chandalar Lake, AK