NTSB investigations, 1980, WA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year

19632026
NTSB investigations, 1980, WA per year, 1963–2026: 4,814 cases
19631
1964110
1965131
1966140
1967159
1968125
1969116
1970118
197186
1972107
1973104
1974109
1975129
1976117
1977104
1978118
1979118
1980107
1981102
198295
1983101
198489
198573
1986100
198779
198880
198976
199078
199194
199279
199369
199467
199573
199665
199762
199867
199968
200067
200166
200266
200374
200475
200559
200649
200753
200858
200958
201051
201158
201254
201337
201447
201536
201632
201739
201847
201937
202028
202141
202235
202336
202429
202537
202629

Latest cases

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 year(c.\"eventDate\") = 1980
    AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
  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 SEA81DYE09Accident · No injuriesClosedBakeng Duce · Issaquah, WADec 28, 1980 · N54BM · Substantial damageNTSB SEA81FYM12Accident · Serious injuriesClosedCessna 172N · Yacolt, WADec 25, 1980 · N738FS · Substantial damageNTSB SEA81FA012Accident · 2 fatalClosedPiper PA-34 · Stevenson, WADec 21, 1980 · N114PH · DestroyedNTSB SEA81FYM11Accident · No injuriesClosedCessna 182P · Orchards, WADec 9, 1980 · N21413 · Substantial damageNTSB SEA81FA013Accident · 1 fatalClosedCessna 210 · Royal City, WADec 3, 1980 · N6508X · DestroyedNTSB LAX81FA020Accident · 2 fatalClosedCessna 320C · Marysville, WANov 30, 1980 · N9RT · DestroyedNTSB SEA81FA009Accident · 6 fatalClosedBeech 58TC · Ellensburg, WANov 27, 1980 · N24AC · DestroyedNTSB SEA81DYP04Accident · No injuriesClosedHughes 269B · Ephrata, WANov 23, 1980 · N9477F · Substantial damageNTSB SEA81IA007Incident · No injuriesClosedCessna 310G · Walla Walla, WANov 20, 1980 · N2905R · Minor damageNTSB SEA81DYE08Accident · No injuriesClosedHiller Acft UH-12E · Forks, WANov 19, 1980 · N542HA · Substantial damageNTSB SEA81DYE06Accident · No injuriesClosedCessna 172 · Diamond Point, WANov 16, 1980 · N6477D · Substantial damageNTSB SEA81FA004Accident · 3 fatalClosedNavion A · Yakima, WANov 15, 1980 · N8553H · DestroyedNTSB SEA81DYE07Accident · No injuriesClosedCessna 185 · Port Townsend, WANov 15, 1980 · N70037 · Substantial damageNTSB SEA81DYE05Accident · No injuriesClosedCessna 180 · Forks, WANov 11, 1980 · N4724U · Substantial damageNTSB SEA81FA058Accident · 4 fatalClosedCessna 172M · Quinault, WANov 8, 1980 · N61614 · DestroyedNTSB SEA81FYE04Accident · No injuriesClosedCessna 210P · Everett, WAOct 23, 1980 · N731HV · Substantial damageNTSB SEA81DYP02Accident · No injuriesClosedPiper PA-28R · Almira, WAOct 12, 1980 · N4527J · Substantial damageNTSB SEA81FYE03Accident · No injuriesClosedCessna 185 · Seattle, WAOct 9, 1980 · N70438 · Substantial damageNTSB SEA81DYM06Accident · No injuriesClosedBell 206L-1 · Cougar, WAOct 8, 1980 · N2756N · Substantial damageNTSB SEA81FYP01Accident · Serious injuriesClosedPiper PA-22 · Waterville, WAOct 6, 1980 · N7710D · Substantial damageNTSB SEA81DYM08Accident · No injuriesClosedCessna 140 · Vancouver, WAOct 6, 1980 · N72778 · Substantial damageNTSB SEA81FYE02Accident · Serious injuriesClosedChampion 8KCAB · Lester, WAOct 5, 1980 · N33MJ · Substantial damageNTSB SEA81FYM01Accident · 1 fatalClosedWalker Mini · Trout Lake, WAOct 2, 1980 · N249KY · DestroyedNTSB SEA80FYP42Accident · No injuriesClosedBensen B-8M · Quincy, WASep 29, 1980 · NONE · Substantial damageNTSB SEA80FYP40Accident · Minor injuriesClosedGulf-Schwzr G-164B · Ritzville, WASep 22, 1980 · N8093K · DestroyedNTSB SEA80DYP41Accident · No injuriesClosedPiper PA-18 · Colfax, WASep 19, 1980 · N40523 · Substantial damageNTSB SEA80DYM62Accident · No injuriesClosedCessna 182P · Goldendale, WASep 18, 1980 · N1498M · Substantial damageNTSB SEA80FA049Accident · 4 fatalClosedCessna 177RG · Lopez, WASep 16, 1980 · N7514V · DestroyedNTSB SEA80FYP39Accident · No injuriesClosedCessna 182B · Buena, WASep 15, 1980 · N2761G · Substantial damageNTSB SEA81FYP38Accident · Serious injuriesClosedHughes 369D · Newport, WASep 12, 1980 · N1090L · Substantial damageNTSB SEA80FA045Accident · 4 fatalClosedCessna 182Q · Skykomish, WAAug 30, 1980 · N759ZZ · DestroyedNTSB SEA80FYP36Accident · No injuriesClosedPiper PA-38 · Stratford, WAAug 28, 1980 · N6320A · Substantial damageNTSB SEA80FYM57Accident · No injuriesClosedCessna 182C · Orchards, WAAug 24, 1980 · N8800T · Substantial damageNTSB SEA80FYP34Accident · No injuriesClosedBell 47G-2 · Sunnyside, WAAug 23, 1980 · N73284 · Substantial damageNTSB SEA80FYP33Accident · No injuriesClosedCessna T210N · Walla Walla, WAAug 21, 1980 · N7372C · Substantial damageNTSB SEA80FA041Accident · No injuriesClosedCessna R172K · Renton, WAAug 11, 1980 · N736UN · Substantial damageNTSB SEA80FYE50Accident · Minor injuriesClosedCessna 182A · Issaquah, WAAug 9, 1980 · N3890D · Substantial damageNTSB SEA80DYE53Accident · No injuriesClosedCessna 177B · Olympia, WAAug 6, 1980 · N13310 · Substantial damageNTSB SEA80DYE49Accident · No injuriesClosedAeronca 7AC · Kent, WAAug 3, 1980 · N3011E · Substantial damageNTSB SEA80DYE48Accident · No injuriesClosedBeech C24R · Roche Harbor, WAJul 31, 1980 · N23843 · Substantial damageNTSB SEA80DYE45Accident · No injuriesClosedPiper PA-28 · Forks, WAJul 30, 1980 · N38376 · Substantial damageNTSB SEA80DYE47Accident · 2 fatalClosedCoot B · Kelso, WAJul 26, 1980 · N7141 · DestroyedNTSB SEA80FYE42Accident · Serious injuriesClosedBeech A36TC · Seattle, WAJul 21, 1980 · N66811 · DestroyedNTSB SEA80FYP29Accident · No injuriesClosedCessna TU206F · Sunnyside, WAJul 20, 1980 · N7470Q · Substantial damageNTSB SEA80FYE43Accident · Minor injuriesClosedPiper PA-28 · Gardner, WAJul 20, 1980 · N3576B · DestroyedNTSB SEA80FYP28Accident · Minor injuriesClosedTexas Hel OH-13H · Moses Lake, WAJul 19, 1980 · N51855 · Substantial damageNTSB SEA80DYE44Accident · No injuriesClosedBeech A23 · Morton, WAJul 18, 1980 · N1466L · DestroyedNTSB SEA80FA037Accident · 2 fatalClosedCessna 170A · Clinton, WAJul 17, 1980 · N1713D · 2 aircraft · DestroyedNTSB SEA80FYP27Accident · Serious injuriesClosedCessna 177RG · Ione, WAJul 16, 1980 · N1891Q · Substantial damageNTSB SEA80DYP30Accident · No injuriesClosedCessna 152 · Spokane, WAJul 6, 1980 · N89310 · Substantial damage