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 MIA78FA051Accident · 2 fatalClosedCessna 172M · Griffing, GANTSB MIA78FA050Accident · 2 fatalClosedCessna 310I · Laurel, MSNTSB ANC78FA022Accident · 1 fatalClosedPiper PA-20 · Trading Bay, AKNTSB OAK78DA021Accident · 1 fatalClosedCessna 150 · Eureka, CANTSB MIA78FA049Accident · 1 fatalClosedPiper PA-28 · Bishopville, SCNTSB DEN78FA030Accident · 1 fatalClosedCessna 320 · Gallup, NMNTSB OAK78FA020Accident · 4 fatalClosedCessna 411 · Chilcoot, CANTSB MIA78FA048Accident · 2 fatalClosedPiper PA-30 · Waco, GANTSB DEN78FA029Accident · 4 fatalClosedBeech 95-C55 · Durango, CONTSB OAK78FJY01Accident · 2 fatalClosedCessna 337F · Agana, GUNTSB DCA78AA008Accident · 2 fatalClosedDouglas DC-10 · Los Angeles, CANTSB LAX78FA031Accident · 7 fatalClosedAero Comdr 500A · Solvang, CANTSB IAD78FA045Accident · 1 fatalClosedPiper PA-32 · Myersville, MDNTSB DEN78FA027Accident · 6 fatalClosedBeech A90 · Big Piney, WYNTSB ANC78FA023Accident · 3 fatalClosedEvangel 4500 · Merrill Pass, AKNTSB LAX78FA030Accident · 4 fatalClosedPiper PA-28 · Santa Susana, CANTSB SEA78FYP14Accident · 1 fatalClosedCessna 185 · Naches, WANTSB FTW78FA030Accident · 1 fatalClosedCessna 150M · Denton, TXNTSB DEN78FA028Accident · 2 fatalClosedBeech 35-B33 · Walden, CONTSB DEN78FA026Accident · 5 fatalClosedCessna 206 · Yoder, CONTSB SEA78FA020Accident · 7 fatalClosedPiper PA-32R · Oak Harbor, WANTSB MIA78FA046Accident · 1 fatalClosedMooney M20F · Ft.Lauderdale (Atlantic Ocean)NTSB LAX78FA029Accident · 6 fatalClosedCessna T2101 · Bakersfield, CANTSB LAX78FA028Accident · 1 fatalClosedPiper PA-28 · Wasco, CANTSB IAD78FA044Accident · 2 fatalClosedSiai-Marche SF260 · Charlotte, NCNTSB FTW78FA029Accident · 4 fatalClosedCessna 172N · Lubbock, TXNTSB DEN78FA025Accident · 2 fatalClosedBeech 35 · Ogden, UTNTSB OAK78FA017Accident · 4 fatalClosedMooney M20C · Morgan Hill, CANTSB DEN78FA024Accident · 6 fatalClosedAero Comdr 560A · Glenrock, WYNTSB OAK78FVG21Accident · 1 fatalClosedBreezy Stokie · Lincoln, CANTSB OAK78FA018Accident · 4 fatalClosedBeech 58 · Genoa Peak, NVNTSB MIA78FA044Accident · 1 fatalClosedBeech A45 · Moultrie, GANTSB MIA78DA045Accident · 4 fatalClosedPiper PA-28 · Jekyll Island, GANTSB IAD78FA043Accident · 2 fatalClosedPiper PA-22 · Camden, TNNTSB FTW78FA028Accident · 2 fatalClosedPiper PA-31 · Searcy, ARNTSB DEN78FTE30Accident · 1 fatalClosedCessna 150G · Ft Garland, CONTSB MIA78FA043Accident · 2 fatalClosedBeech V35B · Myrtle Beach, SCNTSB FTW78FA027Accident · 1 fatalClosedCessna 340 · Amarillo, TXNTSB CHI78FA023Accident · 1 fatalClosedTaylorcraft BC12D · Lowell, MINTSB MIA78FA041Accident · 1 fatalClosedCessna 150F · Jefferson, GANTSB IAD78FA041Accident · 4 fatalClosedAero Cmdr 680FL · Morrisville, NCNTSB UNK78X0106Accident · 5 fatalClosedMitsubishi MU2 · Neiva, ColombiaNTSB OAK78FVG19Accident · 1 fatalClosedCessna 150 · Vacaville, CANTSB NYC78FNC14Accident · 2 fatalClosedCessna 150K · Dexter, MENTSB LAX78FA027Accident · 2 fatalClosedPiper PA-30 · Glen Ivy, CANTSB LAX78FA026Accident · 3 fatalClosedGrum Amer AA-5A · Fontana, CANTSB MIA78FA040Accident · 2 fatalClosedBeech D18S · Clewiston, FLNTSB FTW78FA026Accident · 2 fatalClosedCessna 177RG · Wimberley, TXNTSB OAK78FA016Accident · 1 fatalClosedBeech 35 · Napa, CANTSB NYC78FA027Accident · 1 fatalClosedPiper PA-32R · Danbury, CT