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 FTW78FA052Accident · 1 fatalClosedBeech 35-B33 · Mineral Wells, TXNTSB NYC78FA066Accident · 1 fatalClosedGrum Amer AA1-C · Tamsworth, NHNTSB MKC78FA051Accident · 1 fatalClosedN American SNJ-4 · Gravois Mills, MONTSB CHI78FA045Accident · 3 fatalClosedPiper PA-23 · Belleville, ILNTSB SEA78FA039Accident · 4 fatalClosedPiper PA-28R · Baker, ORNTSB OAK78FA035Accident · 4 fatalClosedCessna 182P · S Lake Tahoe, CANTSB SEA78FA038Accident · 1 fatalClosedNavion A · Ashland, ORNTSB OAK78FVG53Accident · 3 fatalClosedPiper PA-24 · Ruth, CANTSB MKC78FA052Accident · 3 fatalClosedBeech E35 · Potosi, MONTSB MKC78FA050Accident · 2 fatalClosedPiper PA-28 · Columbus, NENTSB MIA78FA098Accident · 1 fatalClosedHughes 269C · Atlanta, GANTSB NYC78FA067Accident · 5 fatalClosedCessna 402 · Pottstown, PANTSB LAX78FUJ70Accident · 1 fatalClosedNord Stampe SV4C · Phoenix, AZNTSB IAD78FA073Accident · 1 fatalClosedPiper PA-23 · Marion, KYNTSB NYC78FA065Accident · 1 fatalClosedCessna 177A · Newfane, NYNTSB CHI78FEI23Accident · 1 fatalClosedPiper PA-28 · South Bass Is, OHNTSB MKC78FCQ27Accident · 3 fatalClosedBeech V35 · Hillsboro, KSNTSB MKC78FA049Accident · 1 fatalClosedCessna 150H · St Louis, MONTSB OAK78FA034Accident · 1 fatalClosedPiper PA-28 · Chicago Park, CANTSB LAX78FA055Accident · 2 fatalClosedBellanca 7GCBC · Santa Paula, CANTSB FTW78FRG51Accident · 1 fatalClosedBellanca 8KCAB · Brady, TXNTSB LAX78FUG34Accident · 2 fatalClosedMustang II · Norco, CANTSB SEA78FYM39Accident · 1 fatalClosedBoeing E75N1 · John Day, ORNTSB UNK78X0126Accident · 1 fatalClosedPiper PA22 · Arramberri, MexicoNTSB IAD78FA072Accident · 1 fatalClosedHughes 269C · Charlotte, NCNTSB LAX78FUQ32Accident · 1 fatalClosedProsch PR-2 · Mojave, CANTSB MKC78FA048Accident · 1 fatalClosedPiper PA-28 · Albert Lea, MNNTSB SEA78FYP31Accident · 1 fatalClosedBriegleb BF12BD · Ephrata, WANTSB OAK78FA033Accident · 1 fatalClosedPiper PA-24 · Dayton, NVNTSB MKC78FA047Accident · 1 fatalClosedCessna 120 · Abilene, KSNTSB DEN78FA050Accident · 4 fatalClosedPiper PA-28 · Silverton, CONTSB SEA78DA037Accident · 4 fatalClosedGrum Amer AA-5A · Kettle Falls, WANTSB NYC78FNA29Accident · 1 fatalClosedSchweizer 233A · Plymouth, MANTSB FTW78FA051Accident · 1 fatalClosedCessna 150 · Mckinney, TXNTSB DEN78FA049Accident · 3 fatalClosedFairchild C-119G · Greybull, WYNTSB DEN78FA044Accident · 1 fatalClosedCessna U206 · Erie, CONTSB SEA78FA036Accident · 1 fatalClosedCessna 182A · Featherville, IDNTSB NYC78FA063Accident · 1 fatalClosedBeech 95 · Waterford, CTNTSB DEN78FA047Accident · 2 fatalClosedBellanca 8KCAB · Green River, WYNTSB SEA78FTI22Accident · 2 fatalClosedPiper PA-18 · Columbia Falls, MTNTSB FTW78FA050Accident · 1 fatalClosedCessna 210L · Mt.Ida, ARNTSB CHI78FEI20Accident · 2 fatalClosedBeech A45 · Newton Falls, OHNTSB CHI78FA044Accident · 1 fatalClosedCessna 206G · East Tawas, MINTSB MKC78FTK20Accident · 1 fatalClosedPiper PA-18 · Naples, SDNTSB DEN78FA046Accident · 4 fatalClosedPiper PA-31T · Lamar, CONTSB MKC78FA046Accident · 1 fatalClosedPiper PA-28 · Omaha, NENTSB MKC78FA045Accident · 2 fatalClosedCessna 170B · Isle, MNNTSB FTW78FPG34Accident · 1 fatalClosedCessna A188B · Lunsford, ARNTSB MKC78FTG09Accident · 1 fatalClosedCessna 188B · Sheyenne, NDNTSB NYC78FA062Accident · 1 fatalClosedCessna 310P · Mattituck, NY