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 MKC77FA016Accident · 2 fatalClosedBellanca 8KCAB · Valparaiso, NEFeb 26, 1977 · N53980 · DestroyedNTSB MKC77FA015Accident · 6 fatalClosedBeech D50E · Springfield, MOFeb 26, 1977 · N9950R · DestroyedNTSB DEN77FA027Accident · 3 fatalClosedCessna U206D · Hanna, UTFeb 26, 1977 · N72308 · DestroyedNTSB DEN77FA026Accident · 2 fatalClosedPiper PA-24 · Broomfield, COFeb 26, 1977 · N7237P · DestroyedNTSB FTW77FA038Accident · 1 fatalClosedCessna 150 · Center, TXFeb 25, 1977 · N5669E · DestroyedNTSB OAK77FA021Accident · 1 fatalClosedPiper PA-24 · Elko, NVFeb 24, 1977 · N8478P · DestroyedNTSB NYC77FA033Accident · 1 fatalClosedMooney M20F · Johnstown, PAFeb 24, 1977 · N3991N · DestroyedNTSB DCA77AA012Accident · 8 fatalClosedPiper PA-31T · Bressler, PAFeb 24, 1977 · N631PT · DestroyedNTSB MIA77FA035Accident · 1 fatalClosedEnstrom 280C · Ft.Meade, FLFeb 23, 1977 · N345RA · DestroyedNTSB FTW77FA037Accident · 5 fatalClosedPiper PA-31 · Springdale, ARFeb 22, 1977 · N9145Y · DestroyedNTSB LAX77FA028Accident · 4 fatalClosedBeech K35 · Big Bear City, CAFeb 21, 1977 · N5315E · DestroyedNTSB MIA77FA033Accident · 1 fatalClosedPiper PA-28 · Tampa, FLFeb 20, 1977 · N180SP · DestroyedNTSB CHI77FA030Accident · 1 fatalClosedCessna 150J · Carleton, MIFeb 20, 1977 · N51226 · DestroyedNTSB OAK77FA019Accident · 1 fatalClosedBoeing B75N1 · Jean, NVFeb 19, 1977 · N65543 · DestroyedNTSB FTW77FRG27Accident · 1 fatalClosedBeech D18S · Mc Allen, TXFeb 19, 1977 · N762D · DestroyedNTSB CHI77FA029Accident · 2 fatalClosedAeronca 7AC · St Paris, OHFeb 19, 1977 · N1085E · DestroyedNTSB IAD77FA025Accident · 1 fatalClosedCessna 150M · Burlington, NCFeb 18, 1977 · N3969V · DestroyedNTSB ANC77FA031Accident · 2 fatalClosedStinson 108-2 · Merrill Pass, AKFeb 18, 1977 · N97274 · Substantial damageNTSB MKC77FA014Accident · 1 fatalClosedBeech S-35 · Sioux City, IAFeb 17, 1977 · N5694K · DestroyedNTSB MIA77FA031Accident · 1 fatalClosedBell 206-A · Jayuya, PRFeb 17, 1977 · N4046G · DestroyedNTSB IAD77FA024Accident · 1 fatalClosedPiper PA-28 · New Castle, VAFeb 17, 1977 · N9225J · DestroyedNTSB DEN77FA025Accident · 2 fatalClosedCessna 150C · Reserve, NMFeb 17, 1977 · N7880Z · DestroyedNTSB OAK77FA018Accident · 1 fatalClosedTaylorcraft BC12D1 · Las Vegas, NVFeb 16, 1977 · N44152 · Substantial damageNTSB DEN77FAO24Accident · 2 fatalClosedMooney M20F · Franktown, COFeb 15, 1977 · N9601M · DestroyedNTSB MIA77FA030Accident · 2 fatalClosedGrum Amer AA1B · St Petersburg, FLFeb 14, 1977 · N8851L · DestroyedNTSB FTW77FA036Accident · 2 fatalClosedCessna 150H · Mer Rouge, LAFeb 14, 1977 · N23494 · DestroyedNTSB IAD77DA022Accident · 1 fatalClosedPiper PA-18 · Louisville, KYFeb 13, 1977 · N128T · DestroyedNTSB SEA77FA019Accident · 1 fatalClosedPiper PA-28R · Port Orchard, WAFeb 12, 1977 · N1529X · Substantial damageNTSB IAD77FA021Accident · 1 fatalClosedCessna 182 · Lively, VAFeb 12, 1977 · N9961T · DestroyedNTSB FTW77FA035Accident · 3 fatalClosedPiper PA-28 · Baton Rouge, LAFeb 12, 1977 · N4493T · DestroyedNTSB CHI77FA028Accident · 4 fatalClosedPiper PA-32 · Sugar Grove, ILFeb 12, 1977 · N31CA · DestroyedNTSB MKC77FA013Accident · 6 fatalClosedPiper PA-31 · Anthony, KSFeb 11, 1977 · N59838 · DestroyedNTSB MIA77FA029Accident · 2 fatalClosedBeech B19 · Pensacola Bch, FLFeb 11, 1977 · N1925W · DestroyedNTSB SEA77FA018Accident · 3 fatalClosedPiper PA-28 · Carey, IDFeb 10, 1977 · N937CC · DestroyedNTSB LAX77FA027Accident · 2 fatalClosedStinson JR.S. · Aztec, AZFeb 6, 1977 · N10886 · DestroyedNTSB OAK77FA016Accident · 1 fatalClosedPiper PA-22 · Clearlake Oaks, CAFeb 5, 1977 · N9015D · DestroyedNTSB NYC77FA030Accident · 1 fatalClosedCessna 150L · Smithfield, RIFeb 4, 1977 · N6756G · DestroyedNTSB LAX77FA035Accident · 1 fatalClosedCessna 182H · Tuscon, AZFeb 3, 1977 · N1840X · DestroyedNTSB FTW77FA033Accident · 2 fatalClosedSwearingen SA266T · Beckmam, TXFeb 3, 1977 · N34SM · DestroyedNTSB CHI77FA026Accident · 1 fatalClosedBeech 58 · Necedah, WIFeb 3, 1977 · N177HC · DestroyedNTSB SEA77FA017Accident · 1 fatalClosedPiper PA-23 · Moro, ORFeb 2, 1977 · N484G · DestroyedNTSB LAX77FUJ27Accident · 1 fatalClosedBoeing A75N1 · Parker, AZFeb 1, 1977 · N4758V · DestroyedNTSB ANC77FA024Accident · 1 fatalClosedChase YC122C · Anchorage, AKJan 31, 1977 · N5904V · DestroyedNTSB IAD77FA019Accident · 3 fatalClosedPiper PA30 · Dyersburg, TNJan 29, 1977 · N8719Y · DestroyedNTSB IAD77FA018Accident · 2 fatalClosedCessna 177RG · Chattanooga, TNJan 29, 1977 · N7506V · DestroyedNTSB SEA77FA015Accident · 1 fatalClosedPiper PA-32R · Olympia, WAJan 27, 1977 · N6638F · DestroyedNTSB OAK77DVD12Accident · 1 fatalClosedPiper PA-28 · Pacific Ocean (Pacific Ocean)Jan 27, 1977 · N56049 · DestroyedNTSB MIA77FA026Accident · 2 fatalClosedCessna 411 · Ft Myers, FLJan 25, 1977 · N99JM · DestroyedNTSB DEN77FA023Accident · 3 fatalClosedBellanca 17-30A · San Mateo, NMJan 25, 1977 · N99BB · DestroyedNTSB SEA77FA014Accident · 3 fatalClosedCessna 172M · Forks, WAJan 24, 1977 · N73478 · Destroyed