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 FTW78FA023Accident · 2 fatalClosedPiper PA-28 · Rockwall, TXNTSB MIA78FA029Accident · 1 fatalClosedPiper PA-31 · Anniston, ALNTSB IAD78FA030Accident · 1 fatalClosedBeech 55 · Lexington, KYNTSB FTW78FA022Accident · 2 fatalClosedBeech D55 · El Campo, TXNTSB DEN78FA019Accident · 2 fatalClosedPiper PA-24 · Glendevey, CONTSB CHI78FA015Accident · 2 fatalClosedCessna 337G · Marion, ILNTSB SEA78FA017Accident · 1 fatalClosedAero Comdr 500B · Miles City, MTNTSB NYC78FA020Accident · 3 fatalClosedBell 206L · Courtney, PANTSB IAD78DA029Accident · 2 fatalClosedPiper PA-28R · Cape Charles, VANTSB CHI78FA014Accident · 1 fatalClosedBeech BE-35 · Tell City, INNTSB LAX78FA019Accident · 3 fatalClosedPiper PA-22 · Devore, CANTSB IAD78FA028Accident · 5 fatalClosedCessna 421B · Knoxville, TNNTSB FTW78DA024Accident · 1 fatalClosedCessna 177RG · New Orleans, LANTSB MIA78FA028Accident · 3 fatalClosedPiper PA-28 · Clewiston, FLNTSB LAX78FA018Accident · 4 fatalClosedBeech C-23 · Mojave, CANTSB CHI78FA034Accident · 1 fatalClosedPiper PA-28 · Mellen, WINTSB MKC78FA017Accident · 2 fatalClosedCessna 310L · Garden City, KSNTSB IAD78FA027Accident · 2 fatalClosedCessna 182K · Pearisburg, VANTSB ANC78FA009Accident · 3 fatalClosedCessna 180 · Galena, AKNTSB OAK78DA012Accident · 2 fatalClosedPiper PA-28R · Ke-Ahole, HINTSB MIA78FA026Accident · 3 fatalClosedCessna 177 · Albany, GANTSB LAX78FA017Accident · 2 fatalClosedCessna 152 · Ojai, CANTSB SEA78FA016Accident · 1 fatalClosedPiper PA-34 · Wenatchee, WANTSB MKC78FCG12Accident · 1 fatalClosedCessna 177B · Grain Valley, MONTSB FTW78FA021Accident · 2 fatalClosedCessna 152 · Teague, TXNTSB SEA78FA015Accident · 2 fatalClosedGrum Amer AA-5A · Anaconda, MTNTSB NYC78FA018Accident · 3 fatalClosedCessna 180 · Berlin, NHNTSB NYC78FA017Accident · 2 fatalClosedHughes 269B · Quincy, MANTSB MIA78FA024Accident · 4 fatalClosedBeech A24 · Alachua, FLNTSB LAX78FA016Accident · 2 fatalClosedCessna 182A · El Cajon, CANTSB NYC78FA016Accident · 1 fatalClosedPiper PA-28 · Brooklyn, CTNTSB LAX78FA015Accident · 3 fatalClosedGrum Amer AA-5B · Desert Hot Spg, CANTSB MIA78FA022Accident · 2 fatalClosedCessna 172 · Blairsville, GANTSB MIA78DA025Accident · 3 fatalClosedPiper PA-28 · Mayaguez (Atlantic Ocean)NTSB IAD78FA025Accident · 2 fatalClosedCessna 206F · Sylva, NCNTSB MKC78FA016Accident · 2 fatalClosedLuscombe 8E · Gordon, NENTSB MIA78FA020Accident · 2 fatalClosedCessna 150 · Plantation, FLNTSB FTW78DQD08Accident · 1 fatalClosedCessna 177RG · Coyanosa, TXNTSB SEA78FA014Accident · 7 fatalClosedAero Cmdr 520 · Cheshire, ORNTSB NYC78FA019Accident · 1 fatalClosedCessna 404 · Buffalo, NYNTSB FTW78FA019Accident · 2 fatalClosedPiper PA-28R · Giddings, TXNTSB OAK78FA011Accident · 1 fatalClosedCessna 172M · Orland, CANTSB NYC78FA015Accident · 1 fatalClosedBeagle B206 · Greenwich, CTNTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRNTSB ANC78FA005Accident · 2 fatalClosedHiller Acft FH1100 · Anchor Point, AKNTSB OAK78FA010Accident · 1 fatalClosedCessna U206 · Little River, CANTSB FTW78FRA11Accident · 1 fatalClosedLuscombe 8A · Pearland, TXNTSB DCA78AA005Accident · 3 fatalClosedDouglas DC-8F · Kaysville, UTNTSB MIA78AF019Accident · 1 fatalClosedCessna 150 · Dauphin Island, ALNTSB LAX78FA013Accident · 2 fatalClosedPiper PA-30 · Van Nuys, CA