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 MIA77FLA26Accident · 1 fatalClosedBensen BM-8 · Palatka, FLNTSB MIA77AA054Accident · 4 fatalClosedBellanca 14-13 · Thomaston, GANTSB LAX77FA038Accident · 4 fatalClosedGrum Amer AA5-A · Flagstaff, AZNTSB NYC77FA052Accident · 1 fatalClosedPiper PA-28 · Nashua, NHNTSB OAK77DJA09Accident · 5 fatalClosedCessna 310 · Honolulu, HINTSB NYC77FA038Accident · 1 fatalClosedPiper PA-23 · Weathersfield, CTNTSB IAD77FA034Accident · 3 fatalClosedPiper PA-28 · Glasgow, KYNTSB DEN77FA036Accident · 2 fatalClosedCessna TU206F · Duchesne, UTNTSB MIA77FA052Accident · 4 fatalClosedBeech A36 · Miami, FLNTSB CHI77FEM22Accident · 1 fatalClosedAmer Avco AA1 · East Tawas, MINTSB SEA77FA027Accident · 3 fatalClosedCessna 182P · Port Orchard, WANTSB SEA77FA026Accident · 2 fatalClosedCessna 180 · Newdale, IDNTSB LAX77FA039Accident · 1 fatalClosedHiller UH-12E · Thermal, CANTSB CHI77FA039Accident · 3 fatalClosedNa Rockwell 112 · Hudson, WINTSB NYC77FA049Accident · 4 fatalClosedCessna 195 · Reading, PANTSB IAD77FID16Accident · 1 fatalClosedSchweizer 1-26B · Windsor, VANTSB DEN77FA034Accident · 3 fatalClosedCessna 150 · Boulder, CONTSB CHI77FEM21Accident · 1 fatalClosedCessna 150J · Albion, MINTSB DEN77FA035Accident · 2 fatalClosedCessna 182H · Tooele, UTNTSB ANC77FA038Accident · 2 fatalClosedBellanca 8GCBC · Fairbanks, AKNTSB NYC77FA048Accident · 1 fatalClosedBellanca 17-30A · Jamestown, NYNTSB MIA77FKQ07Accident · 1 fatalClosedBellanca 8GCBC · Edwards, MSNTSB FTW77FPD19Accident · 1 fatalClosedCessna A188B · De Leon, TXNTSB DEN77FA033Accident · 2 fatalClosedAeronca 7AC · Laramie, WYNTSB OAK77FA028Accident · 1 fatalClosedPiper PA28 · Auberry, CANTSB NYC77FA046Accident · 7 fatalClosedMitsubishi MU-2 · Bronx, NYNTSB LAX77FVJ43Accident · 1 fatalClosedStits SA-3A · Bisbee, AZNTSB SEA77FYM25Accident · 1 fatalClosedMooney M20E · Toledo, ORNTSB SEA77FA025Accident · 2 fatalClosedPiper PA-28 · Sekiu, WANTSB DCA77AA015Accident · 62 fatalClosedDouglas DC-9 · New Hope, GANTSB MIA77FA050Accident · 2 fatalClosedBeech C24R · Monroe, GANTSB LAX77FA034Accident · 2 fatalClosedPiper PA-28 · Saugus, CANTSB IAD77FKM13Accident · 1 fatalClosedCessna 150 · Eden, NCNTSB FTW77FPD17Accident · 3 fatalClosedPiper PA-24 · Wichita Falls, TXNTSB DEN77FA032Accident · 4 fatalClosedAvions Mrcl DA-10 · Denver, CONTSB CHI77FA038Accident · 2 fatalClosedBrantly B-2 · Tremont, ILNTSB LAX77FA033Accident · 7 fatalClosedCessna 411A · Spring Valley, CANTSB FTW77FA048Accident · 6 fatalClosedPiper PA-32R · Commerce, TXNTSB CHI77FEI16Accident · 1 fatalClosedSchweizer SGS233 · Liverpool, OHNTSB SEA77FA024Accident · 2 fatalClosedBell 214B-1 · Liberty, WANTSB SEA77FA023Accident · 2 fatalClosedBeech B19 · Ephrata, WANTSB MIA77FA048Accident · 1 fatalClosedCessna 207 · Atlanta, GANTSB CHI77FEG14Accident · 1 fatalClosedKen Rand KR-2 · Xenia, OHNTSB LAX77FA036Accident · 1 fatalClosedBeech E55 · Phoenix, AZNTSB DCA77RA014Accident · 574 fatalClosedBoeing 747 · Tenerife, SPNTSB CHI77FA037Accident · 2 fatalClosedCessna 172M · Iron River, MINTSB IAD77FA032Accident · 4 fatalClosedPiper PA-28 · Powell, TNNTSB FTW77FA047Accident · 3 fatalClosedPiper PA-23 · Mcalester, OKNTSB LAX77FUQ22Accident · 1 fatalClosedCessna 172M · Inyokern, CANTSB LAX77FA031Accident · 4 fatalClosedCessna 172 · Payson, AZ