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 FTW78FQG22Accident · 1 fatalClosedSnow S-2R · Friona, TXNTSB DEN78FA034Accident · 6 fatalClosedCessna 411 · Santa Fe, NMNTSB MIA78DA080Accident · 2 fatalClosedAero Comdr 680 · Missing AircraftNTSB CHI78FA031Accident · 3 fatalClosedBeech H18 · Centreville, ILNTSB OAK78FA024Accident · 2 fatalClosedCessna 150M · Carson City, NVNTSB NYC78FA036Accident · 1 fatalClosedBeech G35 · Philadelphia, PANTSB MIA77FA055Accident · 1 fatalClosedBensen B-8M · Homestead, FLNTSB FTW78FA035Accident · 2 fatalClosedBell 47G-4A · Morgan City, LANTSB LAX78FA037Accident · 6 fatalClosedCessna T207A · Riverside, CANTSB OAK78FA023Accident · 2 fatalClosedGrumman AA-5A · Red Bluff, CANTSB NYC78FA035Accident · 4 fatalClosedBeech S35 · Carrabassett, MENTSB NYC78FA034Accident · 5 fatalClosedBeech B95A · Onchiota, NYNTSB MKC78FA029Accident · 2 fatalClosedCessna 172 · Leawood, KSNTSB FTW78FA034Accident · 2 fatalClosedBeech 65-90 · Houston, TXNTSB SEA78FA023Accident · 4 fatalClosedPiper PA-28 · Milton Frwtr, ORNTSB IAD78FA051Accident · 3 fatalClosedPiper PA-28 · Wilmington, DENTSB DEN78FTC17Accident · 1 fatalClosedCessna 172 · Alta, WYNTSB UNK78X0110Accident · 2 fatalClosedBeech 65 · Angmagslk, GreenlandNTSB IAD78FA052Accident · 2 fatalClosedCessna 172E · Leitchfield, KYNTSB IAD78FA049Accident · 4 fatalClosedCessna 177 · Maryville, TNNTSB CHI78FEV22Accident · 1 fatalClosedHughes 500D · Ellisville, ILNTSB CHI78FA029Accident · 1 fatalClosedGrum Amer AA5-B · Sandusky, OHNTSB SEA78FA022Accident · 3 fatalClosedCessna 172 · Lynden, WANTSB MIA78FA054Accident · 1 fatalClosedPiper PA-31 · Leesburg, FLNTSB NYC78FA033Accident · 2 fatalClosedPiper PA-28 · Sandgate, VTNTSB MKC78FA028Accident · 4 fatalClosedPiper PA-32R · Belfield, NDNTSB FTW78FA032Accident · 1 fatalClosedBell 47G · Eola, TXNTSB MIA78FA053Accident · 1 fatalClosedLake LA-4 · Pierson, FLNTSB DEN78FA033Accident · 1 fatalClosedCessna 152 · Parker, CONTSB CHI79FA028Accident · 1 fatalClosedPiper PA-32R · Rock Falls, ILNTSB CHI78FA027Accident · 2 fatalClosedBeech D18 · Whitelake, MINTSB ANC78FA025Accident · 1 fatalClosedPiper PA-12 · Kotzebue, AKNTSB SEA78FYE12Accident · 1 fatalClosedBerg Sprite SW1 · Lakewood, WANTSB NYC78FA032Accident · 1 fatalClosedPiper PA-23 · Connellsville, PANTSB MKC78FA027Accident · 1 fatalClosedPiper PA-22 · Rapid City, SDNTSB LAX78FA035Accident · 2 fatalClosedPiper PA-28 · Frazier Park, CANTSB LAX78FA034Accident · 3 fatalClosedCessna 182P · Benson, AZNTSB CHI78FA025Accident · 3 fatalClosedCessna T210M · Beecher, ILNTSB SEA78FA021Accident · 1 fatalClosedPiper PA-28 · Springdale, WANTSB LAX78FUQ19Accident · 1 fatalClosedAmateur Baby L · Pacoima, CANTSB LAX78FA038Accident · 1 fatalClosedCessna 150L · Huntington Bch, CANTSB LAX78FA036Accident · 2 fatalClosedPiper PA-28 · Mormon Lake, AZNTSB FTW78FA033Accident · 4 fatalClosedPiper PA-28 · Hiwasse, ARNTSB OAK78FA022Accident · 5 fatalClosedCessna 210L · Mammoth Lakes, CANTSB IAD78FA050Accident · 2 fatalClosedPiper PA-28 · Melfa, VANTSB DEN78FAO32Accident · 5 fatalClosedCessna T210L · Woodland Park, CONTSB DEN78FA031Accident · 3 fatalClosedBeech S35 · Aurora, CONTSB ANC78FA024Accident · 1 fatalClosedBellanca 7GCBC · Anchorage, AKNTSB MKC78FA026Accident · 2 fatalClosedCessna 172 · Memphis, MONTSB IAD78FA048Accident · 3 fatalClosedAero Comdr 681 · Greenup, KY