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 CHI78FA012Accident · 1 fatalClosedCessna U206F · Garrettsville, OHDec 17, 1977 · N1045V · DestroyedNTSB SEA78FA013Accident · 1 fatalClosedCessna 152 · Quincy, WADec 16, 1977 · N757TC · DestroyedNTSB MKC78FA014Accident · 1 fatalClosedPiper PA-28R · Waukon, IADec 16, 1977 · N44988 · DestroyedNTSB MIA78DA023Accident · 1 fatalClosedPiper PA-31 · Kingston (Atlantic Ocean)Dec 16, 1977 · N483LC · DestroyedNTSB DEN78FA016Accident · 2 fatalClosedLake LA-4 · Albuquerque, NMDec 16, 1977 · N6011V · DestroyedNTSB MIA78FA015Accident · 1 fatalClosedPiper PA-18 · Jeffersonville, GADec 15, 1977 · N4890P · DestroyedNTSB MKC78FA013Accident · 2 fatalClosedPiper PA-34 · Davenport, IADec 14, 1977 · N1634H · DestroyedNTSB LAX78FA014Accident · 1 fatalClosedBellanca 7ECA · Catalina Islnd, CADec 14, 1977 · N5233X · DestroyedNTSB LAX78FA006Accident · 2 fatalClosedCessna 150G · Laguna Beach, CADec 14, 1977 · N8312J · DestroyedNTSB IAD78FA022Accident · 2 fatalClosedPiper PA-28 · Ocracoke, NCDec 14, 1977 · N7285W · DestroyedNTSB FTW78FA018Accident · 1 fatalClosedCessna 210D · Hot Springs, ARDec 13, 1977 · TI-AIC · DestroyedNTSB DCA78AA001Accident · 29 fatalClosedDouglas DC-3 · Evansville, INDec 13, 1977 · N51071 · DestroyedNTSB NYC78FA013Accident · 2 fatalClosedBeech D95A · Richland, PADec 12, 1977 · N1199T · Substantial damageNTSB OAK78FA008Accident · 1 fatalClosedPiper PA-28 · Watsonville, CADec 11, 1977 · N475FL · DestroyedNTSB FTW78FA017Accident · 3 fatalClosedPiper PA-24 · Kerrville, TXDec 11, 1977 · N7126P · DestroyedNTSB IAD78FA020Accident · 1 fatalClosedPiper PA-28R · Elizabethtown, KYDec 10, 1977 · N9406N · DestroyedNTSB MKC78FA012Accident · 2 fatalClosedPiper PA-28R · Fordland, MODec 8, 1977 · N38775 · DestroyedNTSB FTW78FA016Accident · 17 fatalClosedS.N.I.A.S. SA330J · Intracstl City, LADec 8, 1977 · N4730S · DestroyedNTSB DEN78FA013Accident · 3 fatalClosedCessna 182 · Socorro, NMDec 8, 1977 · N6488A · DestroyedNTSB OAK78FA007Accident · 1 fatalClosedBellanca 7KCAB · Clearlake Oaks, CADec 5, 1977 · N7908S · DestroyedNTSB IAD78FA019Accident · 2 fatalClosedVarga 2150A · Jessup, MDDec 5, 1977 · N4612V · DestroyedNTSB FTW78FA015Accident · 3 fatalClosedCessna 310 · Wharton, TXDec 5, 1977 · N3000D · DestroyedNTSB SEA78FYP05Accident · 1 fatalClosedBeech A35 · W.Richland, WADec 4, 1977 · N8687A · Substantial damageNTSB NYC78FA012Accident · 2 fatalClosedTaylorcraft BC12-D · Mercer, MEDec 4, 1977 · N6607N · DestroyedNTSB IAD78FA018Accident · 2 fatalClosedCessna 172H · Dickson, TNDec 4, 1977 · N75923 · DestroyedNTSB FTW78FA014Accident · 1 fatalClosedPiper PA-28 · Langley, OKDec 4, 1977 · N41737 · DestroyedNTSB LAX78FA011Accident · 4 fatalClosedCessna 177B · Tucson, AZDec 3, 1977 · N34100 · 2 aircraft · DestroyedNTSB SEA78FA018Accident · 1 fatalClosedCessna 320E · Steptoe, WADec 1, 1977 · N3431Q · DestroyedNTSB MKC78FA011Accident · 1 fatalClosedBeech C33 · Canton, SDDec 1, 1977 · N9435S · DestroyedNTSB IAD78FA017Accident · 2 fatalClosedCessna 172H · Cades Cove, TNDec 1, 1977 · N8821Z · DestroyedNTSB NYC78FA011Accident · 1 fatalClosedCessna 206 · Taunton, MANov 30, 1977 · N2119F · DestroyedNTSB MKC78FA010Accident · 2 fatalClosedPiper PA-28 · Huron, SDNov 30, 1977 · N5288T · DestroyedNTSB IAD78FA016Accident · 1 fatalClosedPiper PA-23 · Reston, VANov 30, 1977 · N6241Y · DestroyedNTSB SEA78FA011Accident · 2 fatalClosedPiper PA-32 · Pocatello, IDNov 29, 1977 · N41861 · Substantial damageNTSB MKC78FA009Accident · 1 fatalClosedCessna 182M · Hill City, SDNov 29, 1977 · N71026 · DestroyedNTSB MIA78FA017Accident · 1 fatalClosedPiper PA-28 · Lakeport, FLNov 29, 1977 · N5374W · DestroyedNTSB IAD78FA015Accident · 2 fatalClosedBeech 58 · Pinehurst, NCNov 29, 1977 · N4461S · DestroyedNTSB MKC78FA008Accident · 2 fatalClosedBellanca 8KCAB · Inwood, IANov 28, 1977 · N12PG · DestroyedNTSB SEA78FA010Accident · 2 fatalClosedCessna 210E · Moscow, IDNov 27, 1977 · N2369F · DestroyedNTSB FTW78FRJ08Accident · 1 fatalClosedPiper J-3 · Farmerville, LANov 27, 1977 · N88338 · DestroyedNTSB DEN78FA010Accident · 1 fatalClosedCessna 414 · Aspen, CONov 27, 1977 · N1682T · DestroyedNTSB OAK78FA006Accident · 4 fatalClosedPiper PA-28 · Independence, CANov 26, 1977 · N3972R · DestroyedNTSB LAX78FA009Accident · 2 fatalClosedMooney M20B · Tucson, AZNov 26, 1977 · N74771 · DestroyedNTSB DEN78FA011Accident · 2 fatalClosedCessna 175 · Leadville, CONov 25, 1977 · N9413B · DestroyedNTSB DEN78FA008Accident · 1 fatalClosedPiper PA-28 · Carlsbad, NMNov 25, 1977 · N2665T · Substantial damageNTSB IAD78FA014Accident · 6 fatalClosedPiper PA-31T · Beckley, WVNov 24, 1977 · N801HD · DestroyedNTSB NYC78FA010Accident · 1 fatalClosedPiper PA-34 · Reedsville, NYNov 23, 1977 · N777TD · DestroyedNTSB NYC78FA009Accident · 1 fatalClosedPiper PA-28R · North Wales, PANov 23, 1977 · N1018L · DestroyedNTSB IAD78FA013Accident · 1 fatalClosedCessna 182 · Richmond, VANov 23, 1977 · N2686R · DestroyedNTSB LAX78FA008Accident · 2 fatalClosedBell 47J-2 · Burbank, CANov 22, 1977 · N8442E · Destroyed