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 OAK77FA014Accident · 1 fatalClosedPiper PA-28 · Kelseyville, CANTSB DEN77FA022Accident · 2 fatalClosedCessna 172 · Moab, UTNTSB LAX77FUM13Accident · 1 fatalClosedLuscombe 8D · Calipatria, CANTSB CHI77FA025Accident · 2 fatalClosedPiper PA-22 · Romeoville, ILNTSB LAX77FA026Accident · 1 fatalClosedBeech 35-C33 · Prescott, AZNTSB LAX77FA024Accident · 2 fatalClosedMooney M20F · Wilcox, AZNTSB DEN77FA021Accident · 1 fatalClosedBellanca 17-30 · Acomita, NMNTSB MIA77FLA15Accident · 1 fatalClosedCessna 150L · Bunnell, FLNTSB OAK77FA013Accident · 2 fatalClosedBeech C45H · Sonoma, CANTSB NYC77FA028Accident · 1 fatalClosedPiper J3C65 · Duanesburg, NYNTSB FTW77FA031Accident · 2 fatalClosedGlobe GC-1B · El Paso, TXNTSB FTW77FA030Accident · 2 fatalClosedCessna 185D · Jennings, LANTSB SEA77FA012Accident · 3 fatalClosedBeech C35 · Mckenna, WANTSB UNK77X0102Accident · 5 fatalClosedDouglas DC-8 · Anchorage, AKNTSB DEN77FTE15Accident · 2 fatalClosedStits SA-11A · Longmont, CONTSB LAX77FA023Accident · 1 fatalClosedCessna 140 · Riverside, CANTSB FTW77FA029Accident · 4 fatalClosedBeech 95-B55 · Pampa, TXNTSB MIA77DA019Accident · 1 fatalClosedPiper PA-23 · Caribbean Sea (Atlantic Ocean)NTSB OAK77FA010Accident · 2 fatalClosedPiper PA-28R · Lemoore, CANTSB LAX77FA022Accident · 2 fatalClosedCessna 150L · Altadena, CANTSB CHI77FA023Accident · 1 fatalClosedBeech K35 · Delaware Twp, INNTSB OAK77FA011Accident · 2 fatalClosedCessna 310 · Fremont, CANTSB LAX77FA021Accident · 2 fatalClosedPiper PA-32R · Benson, AZNTSB MKC77FA011Accident · 4 fatalClosedMitsubishi MU-2B · Rochester, MNNTSB LAX77AA019Accident · 4 fatalClosedLear Jet 24B · Palm Springs, CANTSB FTW77FA028Accident · 1 fatalClosedBolkow BO105C · Morgan City, LANTSB CHI77FA022Accident · 2 fatalClosedLear Jet 23 · Flint, MINTSB MIA77FA023Accident · 1 fatalClosedCessna 172 · Wiggins, MSNTSB FTW77FA027Accident · 2 fatalClosedCessna 150J · Patterson, LANTSB DEN77FA017Accident · 1 fatalClosedCessna 182 · Pagosa Springs, CONTSB CHI77FA021Accident · 2 fatalClosedCessna 310J · Rockford, ILNTSB ANC77FA019Accident · 1 fatalClosedPiper PA-18 · Kaktovik, AKNTSB SEA77FA011Accident · 1 fatalClosedBeech V35B · Auburn, WANTSB OAK77FVA12Accident · 1 fatalClosedBoeing A75N1 · Oakdale, CANTSB LAX77FA018Accident · 4 fatalClosedBeech 95-B55 · Barstow, CANTSB DEN77FA016Accident · 3 fatalClosedCessna 182P · Santa Rosa, NMNTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXNTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MINTSB MKC77FA010Accident · 1 fatalClosedCessna 210L · Fenton, MONTSB MIA77FA021Accident · 2 fatalClosedCessna 172N · Chiefland, FLNTSB MIA77DA022Accident · 6 fatalClosedPiper PA-23 · Missing AircraftNTSB NYC77FHM07Accident · 1 fatalClosedBeech M35 · Flanders, NJNTSB LAX77FA016Accident · 1 fatalClosedErco 415-C · Murrieta, CANTSB DEN77FA014Accident · 2 fatalClosedBellanca 7GCBC · Clovis, NMNTSB MKC77FA009Accident · 2 fatalClosedPiper PA-28R · Kadoka, SDNTSB MIA77FA020Accident · 3 fatalClosedBeech B95A · Panacea, FLNTSB CHI77FA018Accident · 3 fatalClosedPiper PA-28 · Columbia City, INNTSB FTW77FA024Accident · 1 fatalClosedBeech :50 · Mcallen, TXNTSB CHI77FA017Accident · 1 fatalClosedPiper PA-23 · North Royalton, OHNTSB OAK77FA009Accident · 1 fatalClosedCessna 172M · Empire, NV