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.

NTSB FTW78FA052Accident · 1 fatalClosedBeech 35-B33 · Mineral Wells, TXJun 27, 1978 · N5724K · DestroyedNTSB NYC78FA066Accident · 1 fatalClosedGrum Amer AA1-C · Tamsworth, NHJun 25, 1978 · N9544U · DestroyedNTSB MKC78FA051Accident · 1 fatalClosedN American SNJ-4 · Gravois Mills, MOJun 25, 1978 · N9589C · DestroyedNTSB CHI78FA045Accident · 3 fatalClosedPiper PA-23 · Belleville, ILJun 25, 1978 · N3284P · DestroyedNTSB SEA78FA039Accident · 4 fatalClosedPiper PA-28R · Baker, ORJun 24, 1978 · N40048 · DestroyedNTSB OAK78FA035Accident · 4 fatalClosedCessna 182P · S Lake Tahoe, CAJun 24, 1978 · N8257M · DestroyedNTSB SEA78FA038Accident · 1 fatalClosedNavion A · Ashland, ORJun 23, 1978 · N91504 · DestroyedNTSB OAK78FVG53Accident · 3 fatalClosedPiper PA-24 · Ruth, CAJun 23, 1978 · N7335P · DestroyedNTSB MKC78FA052Accident · 3 fatalClosedBeech E35 · Potosi, MOJun 23, 1978 · N13AV · DestroyedNTSB MKC78FA050Accident · 2 fatalClosedPiper PA-28 · Columbus, NEJun 23, 1978 · N8993W · DestroyedNTSB MIA78FA098Accident · 1 fatalClosedHughes 269C · Atlanta, GAJun 23, 1978 · N9584F · DestroyedNTSB NYC78FA067Accident · 5 fatalClosedCessna 402 · Pottstown, PAJun 22, 1978 · N8283F · DestroyedNTSB LAX78FUJ70Accident · 1 fatalClosedNord Stampe SV4C · Phoenix, AZJun 22, 1978 · N10707 · DestroyedNTSB IAD78FA073Accident · 1 fatalClosedPiper PA-23 · Marion, KYJun 22, 1978 · N5421Y · DestroyedNTSB NYC78FA065Accident · 1 fatalClosedCessna 177A · Newfane, NYJun 21, 1978 · N30475 · Substantial damageNTSB CHI78FEI23Accident · 1 fatalClosedPiper PA-28 · South Bass Is, OHJun 21, 1978 · N5570W · DestroyedNTSB MKC78FCQ27Accident · 3 fatalClosedBeech V35 · Hillsboro, KSJun 20, 1978 · N9576Q · DestroyedNTSB MKC78FA049Accident · 1 fatalClosedCessna 150H · St Louis, MOJun 19, 1978 · N50374 · DestroyedNTSB OAK78FA034Accident · 1 fatalClosedPiper PA-28 · Chicago Park, CAJun 18, 1978 · N7075W · DestroyedNTSB LAX78FA055Accident · 2 fatalClosedBellanca 7GCBC · Santa Paula, CAJun 18, 1978 · N68535 · DestroyedNTSB FTW78FRG51Accident · 1 fatalClosedBellanca 8KCAB · Brady, TXJun 18, 1978 · N5541K · DestroyedNTSB LAX78FUG34Accident · 2 fatalClosedMustang II · Norco, CAJun 17, 1978 · N5SH · DestroyedNTSB SEA78FYM39Accident · 1 fatalClosedBoeing E75N1 · John Day, ORJun 16, 1978 · N4769V · DestroyedNTSB UNK78X0126Accident · 1 fatalClosedPiper PA22 · Arramberri, MexicoJun 15, 1978 · N9014D · DestroyedNTSB IAD78FA072Accident · 1 fatalClosedHughes 269C · Charlotte, NCJun 15, 1978 · N8658F · DestroyedNTSB LAX78FUQ32Accident · 1 fatalClosedProsch PR-2 · Mojave, CAJun 14, 1978 · N14EP · DestroyedNTSB MKC78FA048Accident · 1 fatalClosedPiper PA-28 · Albert Lea, MNJun 13, 1978 · N40891 · DestroyedNTSB SEA78FYP31Accident · 1 fatalClosedBriegleb BF12BD · Ephrata, WAJun 11, 1978 · N5010 · DestroyedNTSB OAK78FA033Accident · 1 fatalClosedPiper PA-24 · Dayton, NVJun 11, 1978 · N6025P · DestroyedNTSB MKC78FA047Accident · 1 fatalClosedCessna 120 · Abilene, KSJun 11, 1978 · N1959V · DestroyedNTSB DEN78FA050Accident · 4 fatalClosedPiper PA-28 · Silverton, COJun 11, 1978 · N9669J · DestroyedNTSB SEA78DA037Accident · 4 fatalClosedGrum Amer AA-5A · Kettle Falls, WAJun 10, 1978 · C-GMWC · DestroyedNTSB NYC78FNA29Accident · 1 fatalClosedSchweizer 233A · Plymouth, MAJun 10, 1978 · N17958 · Substantial damageNTSB FTW78FA051Accident · 1 fatalClosedCessna 150 · Mckinney, TXJun 10, 1978 · N63577 · DestroyedNTSB DEN78FA049Accident · 3 fatalClosedFairchild C-119G · Greybull, WYJun 10, 1978 · N3560 · Substantial damageNTSB DEN78FA044Accident · 1 fatalClosedCessna U206 · Erie, COJun 10, 1978 · N2189F · DestroyedNTSB SEA78FA036Accident · 1 fatalClosedCessna 182A · Featherville, IDJun 9, 1978 · N2719G · DestroyedNTSB NYC78FA063Accident · 1 fatalClosedBeech 95 · Waterford, CTJun 8, 1978 · N2714Y · Substantial damageNTSB DEN78FA047Accident · 2 fatalClosedBellanca 8KCAB · Green River, WYJun 8, 1978 · N777DW · Substantial damageNTSB SEA78FTI22Accident · 2 fatalClosedPiper PA-18 · Columbia Falls, MTJun 7, 1978 · N3473Z · Substantial damageNTSB FTW78FA050Accident · 1 fatalClosedCessna 210L · Mt.Ida, ARJun 7, 1978 · N732HY · DestroyedNTSB CHI78FEI20Accident · 2 fatalClosedBeech A45 · Newton Falls, OHJun 6, 1978 · N10155 · DestroyedNTSB CHI78FA044Accident · 1 fatalClosedCessna 206G · East Tawas, MIJun 6, 1978 · N8194G · DestroyedNTSB MKC78FTK20Accident · 1 fatalClosedPiper PA-18 · Naples, SDJun 5, 1978 · N2799P · Substantial damageNTSB DEN78FA046Accident · 4 fatalClosedPiper PA-31T · Lamar, COJun 5, 1978 · N176CC · DestroyedNTSB MKC78FA046Accident · 1 fatalClosedPiper PA-28 · Omaha, NEJun 4, 1978 · N1790H · DestroyedNTSB MKC78FA045Accident · 2 fatalClosedCessna 170B · Isle, MNJun 4, 1978 · N4602C · DestroyedNTSB FTW78FPG34Accident · 1 fatalClosedCessna A188B · Lunsford, ARJun 4, 1978 · N91233 · DestroyedNTSB MKC78FTG09Accident · 1 fatalClosedCessna 188B · Sheyenne, NDJun 3, 1978 · N84677 · DestroyedNTSB NYC78FA062Accident · 1 fatalClosedCessna 310P · Mattituck, NYJun 2, 1978 · N5849M · Destroyed