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 MIA78FA073Accident · 2 fatalClosedBellanca 7ECA · Columbus, GANTSB UNK78X0117Accident · 10 fatalClosedCessna 402 · Upola, AntarcticaNTSB MIA78DA074Accident · 1 fatalClosedTed Smith 601 · Missing AircraftNTSB FTW78FA043Accident · 2 fatalClosedAero Comdr 1121A · Flatwoods, LANTSB MIA78FA072Accident · 2 fatalClosedBeech N35 · Kennesaw, GANTSB LAX78FA044Accident · 2 fatalClosedBeech 76 · Ramoma, CANTSB CHI78FA036Accident · 2 fatalClosedBellanca 7KCAB · Rockford, ILNTSB FTW78FPG26Accident · 1 fatalClosedBensen B8-MG · Carlisle, ARNTSB CHI78FA035Accident · 9 fatalClosedPiper PA-31 · Arlington, INNTSB NYC78FA044Accident · 2 fatalClosedRockwell 114 · Roscoe, NYNTSB MIA78FA070Accident · 3 fatalClosedPiper PA-28 · Atlanta, GANTSB MIA78FA069Accident · 1 fatalClosedCessna 172 · Benoit, MSNTSB CHI78FA033Accident · 1 fatalClosedSchleicher ASK-13 · Adrian, MINTSB OAK78FA027Accident · 4 fatalClosedCessna 310R · Lake Tahoe, CANTSB ANC78FA030Accident · 2 fatalClosedDehavilland DHC-2 · Cordova, AKNTSB OAK78FA326Accident · 1 fatalClosedPiper PA-28 · Santa Rosa, CANTSB MKC78FA033Accident · 2 fatalClosedBeech A24R · Mandan, NDNTSB MKC78FA032Accident · 1 fatalClosedPiper PA-23 · St Cloud, MNNTSB MKC78FA031Accident · 1 fatalClosedBeech A23-24 · Wichita, KSNTSB ANC78FA028Accident · 2 fatalClosedBell 206B · Lonely, AKNTSB SEA78FYP23Accident · 1 fatalClosedCallair A-9 · Springdale, WANTSB LAX78FA043Accident · 1 fatalClosedPiper PA-23 · Trabuco Canyon, CANTSB LAX78FA042Accident · 2 fatalClosedCessna 152 · Chatsworth, CANTSB ANC78DA031Accident · 3 fatalClosedCessna 170B · Missing AircraftNTSB LAX78FA041Accident · 1 fatalClosedPiper PA-23 · Mesa, AZNTSB FTW78FAQ41Accident · 1 fatalClosedCessna 180J · New Orleans, LANTSB SEA78FA025Accident · 1 fatalClosedCessna 150L · Junction City, ORNTSB MIA78FA065Accident · 2 fatalClosedBellanca 17-30A · Gulfport, MSNTSB MIA78FA064Accident · 2 fatalClosedPiper PA-30 · Destin, FLNTSB IAD78FA058Accident · 1 fatalClosedPiper PA-28 · Edenton, NCNTSB SEA78FA026Accident · 2 fatalClosedCessna 152 · Chehalis, WANTSB MIA78FA063Accident · 1 fatalClosedPiper PA-28 · St.Petersburg, FLNTSB DEN78FA036Accident · 1 fatalClosedCessna TP206C · Angle, UTNTSB NYC78FA040Accident · 2 fatalClosedPiper PA-30 · Montpelier, VTNTSB MIA78FA062Accident · 2 fatalClosedCessna 172 · Miles City, FLNTSB FTW78FA040Accident · 1 fatalClosedCessna 182P · Ferriday, LANTSB DEN78FA035Accident · 1 fatalClosedPiper PA-38 · Park City, UTNTSB CHI78FEV25Accident · 1 fatalClosedBell 47-G · Clinton, ILNTSB MIA78FA060Accident · 1 fatalClosedAero Comdr 680F · Fellsmere, FLNTSB MIA78FA060Accident · 2 fatalClosedGrumman G-21 · St Thomas, VINTSB MIA78DA082Accident · 2 fatalClosedCessna T210 · Great Inagua, Burkina FasoNTSB FTW78FA038Accident · 3 fatalClosedBell 212 · Galveston, TXNTSB UNK78X0113Accident · 5 fatalClosedNa Rockwell 560 · Nassau, Burkina FasoNTSB FTW78FA037Accident · 1 fatalClosedCessna 172D · West Helena, ARNTSB ANC78FA027Accident · 2 fatalClosedDornier DO-28D · Bethel, AKNTSB MIA78FA057Accident · 1 fatalClosedCessna 337F · No Name Key, FLNTSB IAD78FA056Accident · 5 fatalClosedAero Comdr 500B · Salisbury, MDNTSB LAX78FA039Accident · 4 fatalClosedBeech 95-B55 · Bear Valy Sprg, CANTSB LAX78FA038Accident · 1 fatalClosedCessna 140 · Buckeye, AZNTSB OAK78FA025Accident · 1 fatalClosedCessna 182F · Half Moon Bay, CA