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 CHI78FA012Accident · 1 fatalClosedCessna U206F · Garrettsville, OHNTSB SEA78FA013Accident · 1 fatalClosedCessna 152 · Quincy, WANTSB MKC78FA014Accident · 1 fatalClosedPiper PA-28R · Waukon, IANTSB MIA78DA023Accident · 1 fatalClosedPiper PA-31 · Kingston (Atlantic Ocean)NTSB DEN78FA016Accident · 2 fatalClosedLake LA-4 · Albuquerque, NMNTSB MIA78FA015Accident · 1 fatalClosedPiper PA-18 · Jeffersonville, GANTSB MKC78FA013Accident · 2 fatalClosedPiper PA-34 · Davenport, IANTSB LAX78FA014Accident · 1 fatalClosedBellanca 7ECA · Catalina Islnd, CANTSB LAX78FA006Accident · 2 fatalClosedCessna 150G · Laguna Beach, CANTSB IAD78FA022Accident · 2 fatalClosedPiper PA-28 · Ocracoke, NCNTSB FTW78FA018Accident · 1 fatalClosedCessna 210D · Hot Springs, ARNTSB DCA78AA001Accident · 29 fatalClosedDouglas DC-3 · Evansville, INNTSB NYC78FA013Accident · 2 fatalClosedBeech D95A · Richland, PANTSB OAK78FA008Accident · 1 fatalClosedPiper PA-28 · Watsonville, CANTSB FTW78FA017Accident · 3 fatalClosedPiper PA-24 · Kerrville, TXNTSB IAD78FA020Accident · 1 fatalClosedPiper PA-28R · Elizabethtown, KYNTSB MKC78FA012Accident · 2 fatalClosedPiper PA-28R · Fordland, MONTSB FTW78FA016Accident · 17 fatalClosedS.N.I.A.S. SA330J · Intracstl City, LANTSB DEN78FA013Accident · 3 fatalClosedCessna 182 · Socorro, NMNTSB OAK78FA007Accident · 1 fatalClosedBellanca 7KCAB · Clearlake Oaks, CANTSB IAD78FA019Accident · 2 fatalClosedVarga 2150A · Jessup, MDNTSB FTW78FA015Accident · 3 fatalClosedCessna 310 · Wharton, TXNTSB SEA78FYP05Accident · 1 fatalClosedBeech A35 · W.Richland, WANTSB NYC78FA012Accident · 2 fatalClosedTaylorcraft BC12-D · Mercer, MENTSB IAD78FA018Accident · 2 fatalClosedCessna 172H · Dickson, TNNTSB FTW78FA014Accident · 1 fatalClosedPiper PA-28 · Langley, OKNTSB LAX78FA011Accident · 4 fatalClosedCessna 177B · Tucson, AZNTSB SEA78FA018Accident · 1 fatalClosedCessna 320E · Steptoe, WANTSB MKC78FA011Accident · 1 fatalClosedBeech C33 · Canton, SDNTSB IAD78FA017Accident · 2 fatalClosedCessna 172H · Cades Cove, TNNTSB NYC78FA011Accident · 1 fatalClosedCessna 206 · Taunton, MANTSB MKC78FA010Accident · 2 fatalClosedPiper PA-28 · Huron, SDNTSB IAD78FA016Accident · 1 fatalClosedPiper PA-23 · Reston, VANTSB SEA78FA011Accident · 2 fatalClosedPiper PA-32 · Pocatello, IDNTSB MKC78FA009Accident · 1 fatalClosedCessna 182M · Hill City, SDNTSB MIA78FA017Accident · 1 fatalClosedPiper PA-28 · Lakeport, FLNTSB IAD78FA015Accident · 2 fatalClosedBeech 58 · Pinehurst, NCNTSB MKC78FA008Accident · 2 fatalClosedBellanca 8KCAB · Inwood, IANTSB SEA78FA010Accident · 2 fatalClosedCessna 210E · Moscow, IDNTSB FTW78FRJ08Accident · 1 fatalClosedPiper J-3 · Farmerville, LANTSB DEN78FA010Accident · 1 fatalClosedCessna 414 · Aspen, CONTSB OAK78FA006Accident · 4 fatalClosedPiper PA-28 · Independence, CANTSB LAX78FA009Accident · 2 fatalClosedMooney M20B · Tucson, AZNTSB DEN78FA011Accident · 2 fatalClosedCessna 175 · Leadville, CONTSB DEN78FA008Accident · 1 fatalClosedPiper PA-28 · Carlsbad, NMNTSB IAD78FA014Accident · 6 fatalClosedPiper PA-31T · Beckley, WVNTSB NYC78FA010Accident · 1 fatalClosedPiper PA-34 · Reedsville, NYNTSB NYC78FA009Accident · 1 fatalClosedPiper PA-28R · North Wales, PANTSB IAD78FA013Accident · 1 fatalClosedCessna 182 · Richmond, VANTSB LAX78FA008Accident · 2 fatalClosedBell 47J-2 · Burbank, CA