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 MIA78FA073Accident · 2 fatalClosedBellanca 7ECA · Columbus, GAApr 28, 1978 · N1874G · DestroyedNTSB UNK78X0117Accident · 10 fatalClosedCessna 402 · Upola, AntarcticaApr 27, 1978 · N35P · DestroyedNTSB MIA78DA074Accident · 1 fatalClosedTed Smith 601 · Missing AircraftApr 27, 1978 · N555BU · DestroyedNTSB FTW78FA043Accident · 2 fatalClosedAero Comdr 1121A · Flatwoods, LAApr 27, 1978 · N250UA · DestroyedNTSB MIA78FA072Accident · 2 fatalClosedBeech N35 · Kennesaw, GAApr 26, 1978 · N9495Y · DestroyedNTSB LAX78FA044Accident · 2 fatalClosedBeech 76 · Ramoma, CAApr 25, 1978 · N176LD · DestroyedNTSB CHI78FA036Accident · 2 fatalClosedBellanca 7KCAB · Rockford, ILApr 24, 1978 · N41680 · DestroyedNTSB FTW78FPG26Accident · 1 fatalClosedBensen B8-MG · Carlisle, ARApr 23, 1978 · N26083 · DestroyedNTSB CHI78FA035Accident · 9 fatalClosedPiper PA-31 · Arlington, INApr 23, 1978 · N49MC · DestroyedNTSB NYC78FA044Accident · 2 fatalClosedRockwell 114 · Roscoe, NYApr 22, 1978 · C-GQGL · DestroyedNTSB MIA78FA070Accident · 3 fatalClosedPiper PA-28 · Atlanta, GAApr 22, 1978 · N5361L · DestroyedNTSB MIA78FA069Accident · 1 fatalClosedCessna 172 · Benoit, MSApr 22, 1978 · N2304U · DestroyedNTSB CHI78FA033Accident · 1 fatalClosedSchleicher ASK-13 · Adrian, MIApr 22, 1978 · N3AS · 2 aircraft · DestroyedNTSB OAK78FA027Accident · 4 fatalClosedCessna 310R · Lake Tahoe, CAApr 20, 1978 · N3502G · DestroyedNTSB ANC78FA030Accident · 2 fatalClosedDehavilland DHC-2 · Cordova, AKApr 18, 1978 · N4747S · DestroyedNTSB OAK78FA326Accident · 1 fatalClosedPiper PA-28 · Santa Rosa, CAApr 17, 1978 · N2203Q · DestroyedNTSB MKC78FA033Accident · 2 fatalClosedBeech A24R · Mandan, NDApr 17, 1978 · N8051R · DestroyedNTSB MKC78FA032Accident · 1 fatalClosedPiper PA-23 · St Cloud, MNApr 17, 1978 · N799Y · DestroyedNTSB MKC78FA031Accident · 1 fatalClosedBeech A23-24 · Wichita, KSApr 16, 1978 · N7934L · DestroyedNTSB ANC78FA028Accident · 2 fatalClosedBell 206B · Lonely, AKApr 16, 1978 · N49757 · DestroyedNTSB SEA78FYP23Accident · 1 fatalClosedCallair A-9 · Springdale, WAApr 15, 1978 · N3601G · DestroyedNTSB LAX78FA043Accident · 1 fatalClosedPiper PA-23 · Trabuco Canyon, CAApr 15, 1978 · N5641Y · DestroyedNTSB LAX78FA042Accident · 2 fatalClosedCessna 152 · Chatsworth, CAApr 15, 1978 · N24257 · DestroyedNTSB ANC78DA031Accident · 3 fatalClosedCessna 170B · Missing AircraftApr 15, 1978 · N3540C · DestroyedNTSB LAX78FA041Accident · 1 fatalClosedPiper PA-23 · Mesa, AZApr 13, 1978 · N62845 · DestroyedNTSB FTW78FAQ41Accident · 1 fatalClosedCessna 180J · New Orleans, LAApr 13, 1978 · N42210 · DestroyedNTSB SEA78FA025Accident · 1 fatalClosedCessna 150L · Junction City, ORApr 11, 1978 · N10627 · DestroyedNTSB MIA78FA065Accident · 2 fatalClosedBellanca 17-30A · Gulfport, MSApr 11, 1978 · N39817 · DestroyedNTSB MIA78FA064Accident · 2 fatalClosedPiper PA-30 · Destin, FLApr 9, 1978 · N7250Y · DestroyedNTSB IAD78FA058Accident · 1 fatalClosedPiper PA-28 · Edenton, NCApr 9, 1978 · N8726W · DestroyedNTSB SEA78FA026Accident · 2 fatalClosedCessna 152 · Chehalis, WAApr 8, 1978 · N7147Z · DestroyedNTSB MIA78FA063Accident · 1 fatalClosedPiper PA-28 · St.Petersburg, FLApr 8, 1978 · N4731F · DestroyedNTSB DEN78FA036Accident · 1 fatalClosedCessna TP206C · Angle, UTApr 8, 1978 · N8697Z · DestroyedNTSB NYC78FA040Accident · 2 fatalClosedPiper PA-30 · Montpelier, VTApr 7, 1978 · N8559Y · DestroyedNTSB MIA78FA062Accident · 2 fatalClosedCessna 172 · Miles City, FLApr 7, 1978 · N6886A · DestroyedNTSB FTW78FA040Accident · 1 fatalClosedCessna 182P · Ferriday, LAApr 7, 1978 · N52317 · DestroyedNTSB DEN78FA035Accident · 1 fatalClosedPiper PA-38 · Park City, UTApr 7, 1978 · N9360T · DestroyedNTSB CHI78FEV25Accident · 1 fatalClosedBell 47-G · Clinton, ILApr 7, 1978 · N3574 · DestroyedNTSB MIA78FA060Accident · 1 fatalClosedAero Comdr 680F · Fellsmere, FLApr 5, 1978 · N2998C · DestroyedNTSB MIA78FA060Accident · 2 fatalClosedGrumman G-21 · St Thomas, VIApr 5, 1978 · N877A · DestroyedNTSB MIA78DA082Accident · 2 fatalClosedCessna T210 · Great Inagua, Burkina FasoApr 5, 1978 · N761EM · DestroyedNTSB FTW78FA038Accident · 3 fatalClosedBell 212 · Galveston, TXApr 4, 1978 · N140AL · DestroyedNTSB UNK78X0113Accident · 5 fatalClosedNa Rockwell 560 · Nassau, Burkina FasoApr 3, 1978 · N343P · DestroyedNTSB FTW78FA037Accident · 1 fatalClosedCessna 172D · West Helena, ARApr 2, 1978 · N2049Y · DestroyedNTSB ANC78FA027Accident · 2 fatalClosedDornier DO-28D · Bethel, AKApr 2, 1978 · N21AS · DestroyedNTSB MIA78FA057Accident · 1 fatalClosedCessna 337F · No Name Key, FLMar 31, 1978 · N1773M · DestroyedNTSB IAD78FA056Accident · 5 fatalClosedAero Comdr 500B · Salisbury, MDMar 31, 1978 · N313UT · DestroyedNTSB LAX78FA039Accident · 4 fatalClosedBeech 95-B55 · Bear Valy Sprg, CAMar 30, 1978 · N718X · DestroyedNTSB LAX78FA038Accident · 1 fatalClosedCessna 140 · Buckeye, AZMar 27, 1978 · N90119 · DestroyedNTSB OAK78FA025Accident · 1 fatalClosedCessna 182F · Half Moon Bay, CAMar 26, 1978 · N3108U · Destroyed