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 DEN78FA023Accident · 1 fatalClosedPiper PA-24 · Pojoaque, NMFeb 10, 1978 · N6000D · Substantial damageNTSB DCA78AA007Accident · 17 fatalClosedBeech 99 · Richland, WAFeb 10, 1978 · N199EA · DestroyedNTSB MIA78FA039Accident · 1 fatalClosedCessna 310 · St Petersburg, FLFeb 9, 1978 · N1272 · DestroyedNTSB SEA78FA019Accident · 4 fatalClosedBeech 35 · Cascade Locks, ORFeb 7, 1978 · N3087V · DestroyedNTSB NYC78FFJ13Accident · 1 fatalClosedCessna 150 · Auburn, NYFeb 7, 1978 · N714NV · DestroyedNTSB MKC78FA022Accident · 1 fatalClosedBeech D95A · Amidon, NDFeb 7, 1978 · N88GS · DestroyedNTSB LAX78FA025Accident · 2 fatalClosedPiper PA-24 · Rowland Heigts, CAFeb 6, 1978 · N6390P · DestroyedNTSB IAD78FA038Accident · 1 fatalClosedCessna 402B · Greensboro, NCFeb 6, 1978 · N69284 · DestroyedNTSB DEN78FA022Accident · 1 fatalClosedTaylorcraft BC12D · Albuquerque, NMFeb 5, 1978 · N43021 · Substantial damageNTSB ANC78FA018Accident · 5 fatalClosedCessna 320D · Wrangell, AKFeb 5, 1978 · N234M · DestroyedNTSB CHI79FA019Accident · 1 fatalClosedCessna 150M · Big Bay Denoc, MIFeb 4, 1978 · C-GYEF · DestroyedNTSB LAX78FA024Accident · 1 fatalClosedCessna 182A · Los Angeles, CAFeb 3, 1978 · N2210G · 2 aircraft · Substantial damageNTSB OAK78DVW08Accident · 1 fatalClosedPiper PA-28 · Pahrump, NVFeb 2, 1978 · N44517 · DestroyedNTSB MIA78FA037Accident · 1 fatalClosedCessna 402B · Tuscaloosa, ALFeb 1, 1978 · N8210Q · DestroyedNTSB CHI78FA018Accident · 1 fatalClosedCessna 152 · Ypsilanti, MIJan 31, 1978 · N757PQ · DestroyedNTSB OAK78FA015Accident · 1 fatalClosedCessna 182 · Turlock, CAJan 29, 1978 · N5472B · DestroyedNTSB MIA78FLD21Accident · 1 fatalClosedHolt PDQ2 · Arcadia, FLJan 29, 1978 · N30CH · DestroyedNTSB DEN78FTM11Accident · 1 fatalClosedTurner T-40 · Ogden, UTJan 29, 1978 · N862HC · DestroyedNTSB ANC78FA016Accident · 3 fatalClosedCessna 170-A · Anchorage, AKJan 28, 1978 · N5476C · Substantial damageNTSB IAD78DA042Accident · 1 fatalClosedStinson 108 · Ocean City, MDJan 27, 1978 · N8980K · DestroyedNTSB LAX78FA023Accident · 1 fatalClosedHarvard MK4 · St Johns, AZJan 26, 1978 · N10908 · 2 aircraft · Minor damageNTSB SEA78FYP08Accident · 1 fatalClosedCessna 182Q · Colfax, WAJan 25, 1978 · N735ML · DestroyedNTSB MIA78FA035Accident · 3 fatalClosedPiper PA-28 · New Prt Richey, FLJan 25, 1978 · N9386W · DestroyedNTSB FTW78FA025Accident · 1 fatalClosedBell 206B · Palacids, TXJan 25, 1978 · N90024 · DestroyedNTSB NYC78FA023Accident · 2 fatalClosedAerostar 601P · Dubois, PAJan 24, 1978 · N1BE · DestroyedNTSB MKC78FCJ08Accident · 3 fatalClosedCessna 177 · Hayes Center, NEJan 22, 1978 · N3415T · DestroyedNTSB LAX78FA022Accident · 2 fatalClosedCessna 150L · Lucerne Valley, CAJan 22, 1978 · N11497 · DestroyedNTSB DEN78FA021Accident · 4 fatalClosedCessna 177B · Salt Lake City, UTJan 22, 1978 · N18133 · Substantial damageNTSB MKC78FA021Accident · 2 fatalClosedChampion 7EC · Marmarth, NDJan 21, 1978 · N8931R · DestroyedNTSB CHI78FEM08Accident · 1 fatalClosedCessna 150 · Millersburg, MIJan 21, 1978 · N8284U · DestroyedNTSB SEA78FYK07Accident · 1 fatalClosedPiper PA-25 · Christmas Vly, ORJan 20, 1978 · N6559L · DestroyedNTSB SEA78FYK06Accident · 1 fatalClosedHiller UH-12E · Reedsport, ORJan 20, 1978 · N65149 · Minor damageNTSB MIA78FA034Accident · 1 fatalClosedAmer Avco AA1-A · Ormond Beach, FLJan 20, 1978 · N6331L · DestroyedNTSB ANC78FA012Accident · 1 fatalClosedBrittnorman BN-2A · Toksook Bay, AKJan 20, 1978 · N869JA · DestroyedNTSB DEN78FA020Accident · 3 fatalClosedDehavilland DHC-6 · Pueblo, COJan 18, 1978 · N982FL · DestroyedNTSB NYC78FA025Accident · 1 fatalClosedCessna 150 · Missing AircraftJan 16, 1978 · N19031 · DestroyedNTSB LAX78FA021Accident · 1 fatalClosedPiper PA-32 · Kernville, CAJan 16, 1978 · N3350W · DestroyedNTSB SEA78FA018Accident · 6 fatalClosedPiper PA-23 · Medford, ORJan 15, 1978 · N5675Y · DestroyedNTSB MKC78FA020Accident · 3 fatalClosedPiper PA-22 · Tama, IAJan 15, 1978 · N6819B · DestroyedNTSB NYC78FA024Accident · 1 fatalClosedTemco GC1B · Newport, RIJan 14, 1978 · N2406B · DestroyedNTSB OAK78FA013Accident · 1 fatalClosedCessna T210L · Bishop, CAJan 10, 1978 · N30053 · DestroyedNTSB MIA78FA031Accident · 5 fatalClosedBeech B-90 · Yazoo City, MSJan 10, 1978 · N388MC · DestroyedNTSB IAD78FA031Accident · 2 fatalClosedBell 47J · Chesapeake, VAJan 10, 1978 · N6771D · DestroyedNTSB OAK78FA014Accident · 1 fatalClosedLake LA-4 · Hawthorne, NVJan 9, 1978 · N6678L · DestroyedNTSB NYC78FA022Accident · 2 fatalClosedCessna 210K · Ithaca, NYJan 9, 1978 · N8230M · Substantial damageNTSB MIA78FA030Accident · 4 fatalClosedBeech B-58P · Tylertown, MSJan 8, 1978 · N7264R · DestroyedNTSB NYC78FA021Accident · 1 fatalClosedBeech H50 · Pottstown, PAJan 7, 1978 · N5581 · Substantial damageNTSB MIA78FA042Accident · 1 fatalClosedBeech C23 · Eatonton, GAJan 7, 1978 · N9BW · DestroyedNTSB LAX78FUQ10Accident · 1 fatalClosedCessna 150 · Pacoima, CAJan 7, 1978 · N66667 · No damageNTSB LAX78FA020Accident · 2 fatalClosedCessna 182F · Sells, AZJan 7, 1978 · N3117U · Destroyed