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 OAK77FA014Accident · 1 fatalClosedPiper PA-28 · Kelseyville, CAJan 24, 1977 · N43032 · DestroyedNTSB DEN77FA022Accident · 2 fatalClosedCessna 172 · Moab, UTJan 24, 1977 · N4171F · DestroyedNTSB LAX77FUM13Accident · 1 fatalClosedLuscombe 8D · Calipatria, CAJan 23, 1977 · N28407 · DestroyedNTSB CHI77FA025Accident · 2 fatalClosedPiper PA-22 · Romeoville, ILJan 23, 1977 · N4904Z · DestroyedNTSB LAX77FA026Accident · 1 fatalClosedBeech 35-C33 · Prescott, AZJan 21, 1977 · N6006F · DestroyedNTSB LAX77FA024Accident · 2 fatalClosedMooney M20F · Wilcox, AZJan 21, 1977 · N6874V · DestroyedNTSB DEN77FA021Accident · 1 fatalClosedBellanca 17-30 · Acomita, NMJan 21, 1977 · N7352V · DestroyedNTSB MIA77FLA15Accident · 1 fatalClosedCessna 150L · Bunnell, FLJan 20, 1977 · N68056 · DestroyedNTSB OAK77FA013Accident · 2 fatalClosedBeech C45H · Sonoma, CAJan 16, 1977 · N94972 · DestroyedNTSB NYC77FA028Accident · 1 fatalClosedPiper J3C65 · Duanesburg, NYJan 15, 1977 · N87955 · Substantial damageNTSB FTW77FA031Accident · 2 fatalClosedGlobe GC-1B · El Paso, TXJan 15, 1977 · N80566 · DestroyedNTSB FTW77FA030Accident · 2 fatalClosedCessna 185D · Jennings, LAJan 15, 1977 · N1507F · DestroyedNTSB SEA77FA012Accident · 3 fatalClosedBeech C35 · Mckenna, WAJan 14, 1977 · N859M · DestroyedNTSB UNK77X0102Accident · 5 fatalClosedDouglas DC-8 · Anchorage, AKJan 13, 1977 · JA8054 · DestroyedNTSB DEN77FTE15Accident · 2 fatalClosedStits SA-11A · Longmont, COJan 13, 1977 · N3274 · Substantial damageNTSB LAX77FA023Accident · 1 fatalClosedCessna 140 · Riverside, CAJan 12, 1977 · N2155V · 2 aircraft · DestroyedNTSB FTW77FA029Accident · 4 fatalClosedBeech 95-B55 · Pampa, TXJan 12, 1977 · N179W · DestroyedNTSB MIA77DA019Accident · 1 fatalClosedPiper PA-23 · Caribbean Sea (Atlantic Ocean)Jan 10, 1977 · N5002Y · DestroyedNTSB OAK77FA010Accident · 2 fatalClosedPiper PA-28R · Lemoore, CAJan 9, 1977 · N441S · DestroyedNTSB LAX77FA022Accident · 2 fatalClosedCessna 150L · Altadena, CAJan 9, 1977 · N1227Q · DestroyedNTSB CHI77FA023Accident · 1 fatalClosedBeech K35 · Delaware Twp, INJan 9, 1977 · N6098E · DestroyedNTSB OAK77FA011Accident · 2 fatalClosedCessna 310 · Fremont, CAJan 8, 1977 · N5321A · DestroyedNTSB LAX77FA021Accident · 2 fatalClosedPiper PA-32R · Benson, AZJan 8, 1977 · N1049H · DestroyedNTSB MKC77FA011Accident · 4 fatalClosedMitsubishi MU-2B · Rochester, MNJan 7, 1977 · N854Q · DestroyedNTSB LAX77AA019Accident · 4 fatalClosedLear Jet 24B · Palm Springs, CAJan 6, 1977 · N12MK · DestroyedNTSB FTW77FA028Accident · 1 fatalClosedBolkow BO105C · Morgan City, LAJan 6, 1977 · N200BB · Substantial damageNTSB CHI77FA022Accident · 2 fatalClosedLear Jet 23 · Flint, MIJan 6, 1977 · N332PC · DestroyedNTSB MIA77FA023Accident · 1 fatalClosedCessna 172 · Wiggins, MSJan 3, 1977 · N12771 · DestroyedNTSB FTW77FA027Accident · 2 fatalClosedCessna 150J · Patterson, LAJan 3, 1977 · N51148 · DestroyedNTSB DEN77FA017Accident · 1 fatalClosedCessna 182 · Pagosa Springs, COJan 3, 1977 · N86292 · DestroyedNTSB CHI77FA021Accident · 2 fatalClosedCessna 310J · Rockford, ILJan 3, 1977 · N3100L · DestroyedNTSB ANC77FA019Accident · 1 fatalClosedPiper PA-18 · Kaktovik, AKJan 2, 1977 · N7199Z · Substantial damageNTSB SEA77FA011Accident · 1 fatalClosedBeech V35B · Auburn, WADec 31, 1976 · N84BB · DestroyedNTSB OAK77FVA12Accident · 1 fatalClosedBoeing A75N1 · Oakdale, CADec 31, 1976 · N53039 · DestroyedNTSB LAX77FA018Accident · 4 fatalClosedBeech 95-B55 · Barstow, CADec 31, 1976 · N4635S · DestroyedNTSB DEN77FA016Accident · 3 fatalClosedCessna 182P · Santa Rosa, NMDec 31, 1976 · N8338M · DestroyedNTSB FTW77FA026Accident · 2 fatalClosedPiccard AX-6 · Jersey Village, TXDec 30, 1976 · N53DP · DestroyedNTSB CHI77FA020Accident · 2 fatalClosedCessna 411 · Mccomb Twp, MIDec 29, 1976 · N411EF · DestroyedNTSB MKC77FA010Accident · 1 fatalClosedCessna 210L · Fenton, MODec 28, 1976 · N2148S · DestroyedNTSB MIA77FA021Accident · 2 fatalClosedCessna 172N · Chiefland, FLDec 28, 1976 · N73840 · DestroyedNTSB MIA77DA022Accident · 6 fatalClosedPiper PA-23 · Missing AircraftDec 28, 1976 · N4573P · DestroyedNTSB NYC77FHM07Accident · 1 fatalClosedBeech M35 · Flanders, NJDec 26, 1976 · N9573R · Substantial damageNTSB LAX77FA016Accident · 1 fatalClosedErco 415-C · Murrieta, CADec 26, 1976 · N87406 · DestroyedNTSB DEN77FA014Accident · 2 fatalClosedBellanca 7GCBC · Clovis, NMDec 26, 1976 · N86942 · DestroyedNTSB MKC77FA009Accident · 2 fatalClosedPiper PA-28R · Kadoka, SDDec 25, 1976 · N2943R · DestroyedNTSB MIA77FA020Accident · 3 fatalClosedBeech B95A · Panacea, FLDec 25, 1976 · N22RL · DestroyedNTSB CHI77FA018Accident · 3 fatalClosedPiper PA-28 · Columbia City, INDec 25, 1976 · N1510J · DestroyedNTSB FTW77FA024Accident · 1 fatalClosedBeech :50 · Mcallen, TXDec 23, 1976 · N30AM · DestroyedNTSB CHI77FA017Accident · 1 fatalClosedPiper PA-23 · North Royalton, OHDec 23, 1976 · N2264P · DestroyedNTSB OAK77FA009Accident · 1 fatalClosedCessna 172M · Empire, NVDec 22, 1976 · N12364 · Destroyed