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 DEN77FA053Accident · 2 fatalClosedMaule M4 · Estes Park, CONTSB OAK77DA053Accident · 1 fatalClosedCessna 210 · Missing AircraftNTSB NYC77FA081Accident · 1 fatalClosedAeronca 7AC · Ottsville, PANTSB MIA77FKJ69Accident · 1 fatalClosedPiper PA-18 · Vincent, ALNTSB FTW77FPG77Accident · 1 fatalClosedWeatherly 201B · Cornerstone, ARNTSB MKC77FA033Accident · 3 fatalClosedCessna 172D · St.Louis, MONTSB NYC77FA079Accident · 1 fatalClosedBellanca 14-19 · Lemoyne, PANTSB MIA77FA080Accident · 3 fatalClosedBeech 65-80 · Vancleave, MSNTSB MIA77FA079Accident · 1 fatalClosedCessna 150 · Ft.Lauderdale, FLNTSB IAD77FA060Accident · 1 fatalClosedAero Comdr A-9 · Petersburg, VANTSB CHI77FA065Accident · 3 fatalClosedCessna 402A · Yates City, ILNTSB ANC77FA073Accident · 2 fatalClosedPiper PA-18 · Merrill Pass, AKNTSB SEA77FA047Accident · 1 fatalClosedAerostar 601P · Burns, ORNTSB IAD77FA059Accident · 4 fatalClosedBeech 58 · Parkersburg, WVNTSB NYC77FA078Accident · 2 fatalClosedBeagle B.206S · Westport, CTNTSB IAD77FA058Accident · 1 fatalClosedGrum Amer AA1-B · Unity, MDNTSB FTW77FA067Accident · 1 fatalClosedCessna 182P · Austin, TXNTSB DEN77FA052Accident · 4 fatalClosedCessna U206 · Engle, NMNTSB DEN77FA051Accident · 2 fatalClosedMooney M20E · Albuquerque, NMNTSB ANC77FA072Accident · 6 fatalClosedBeech H18 · Wrangell, AKNTSB MKC77FER75Accident · 1 fatalClosedWendt WH-1 · Lakeville, MNNTSB FTW77FRJ16Accident · 1 fatalClosedGrumman G-164A · Waterproof, LANTSB OAK77FA047Accident · 2 fatalClosedCessna 120 · San Ramon, CANTSB MIA77FA076Accident · 2 fatalClosedChampion 7ECA · Greenville, SCNTSB LAX77FUJ78Accident · 3 fatalClosedBellanca 14-13 · Mesa, AZNTSB LAX77FA063Accident · 2 fatalClosedCessna 172M · Big Bear City, CANTSB CHI77FA064Accident · 4 fatalClosedPiper PA-28R · De Witt, ILNTSB OAK77FA056Accident · 2 fatalClosedCessna 172M · Carmel Valley, CANTSB OAK77FA046Accident · 2 fatalClosedBeech A36 · Crescent City, CANTSB NYC77FHJ33Accident · 1 fatalClosedChampion 7GCAA · Shirley, NYNTSB MIA77FLA44Accident · 1 fatalClosedBellanca 17-30A · Jacksonville, FLNTSB FTW77FPA24Accident · 1 fatalClosedGersbach Sdwndr · Hebron, TXNTSB CHI77FA063Accident · 3 fatalClosedAero Comdr 720 · Wausau, WINTSB ANC77FA067Accident · 1 fatalClosedDehavilland DHC-3 · Bettles, AKNTSB MIA77FA074Accident · 1 fatalClosedCessna 182D · Cusseta, GANTSB ANC77FA069Accident · 1 fatalClosedPiper PA-12 · Solo Creek, AKNTSB NYC77FNC43Accident · 1 fatalClosedBellanca 7GCBC · Ft Fairfield, MENTSB NYC77FA077Accident · 1 fatalClosedPiper PA-23 · No Atlantic Ocean (Atlantic Ocean)NTSB MIA77FA073Accident · 1 fatalClosedBellanca 7GCBC · Leland, MSNTSB IAD77FA055Accident · 1 fatalClosedBoeing A75N-1 · Union City, TNNTSB FTW77FA065Accident · 1 fatalClosedPiper PA-28 · Wichita Falls, TXNTSB LAX77FA060Accident · 2 fatalClosedBell 206B · Encino, CANTSB CHI77FET31Accident · 2 fatalClosedTurner T-40A · Valparaiso, INNTSB CHI77FA062Accident · 1 fatalClosedBellanca 7ACA · Oshkosh, WINTSB OAK77FA045Accident · 1 fatalClosedCessna 182P · Reno, NVNTSB NYC77FA075Accident · 1 fatalClosedCessna 172 · Mayfield, NYNTSB ANC77FA065Accident · 5 fatalClosedBeech E90 · Sitka, AKNTSB NYC77FHA31Accident · 1 fatalClosedBeech 35H · Avoca, PANTSB CHI77FA061Accident · 1 fatalClosedCessna 172F · Grand Rapids, MINTSB CHI77EEP48Accident · 1 fatalClosedBellanca 14-13 · Prairie Du Chn, WI