Fatal NTSB investigations, 1981, WA

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 per year

19642026
Fatal NTSB investigations, 1981, WA per year, 1964–2026: 839 cases
196420
196513
196615
196713
196825
196920
197025
197117
197219
197316
197426
197523
197617
197730
197830
197922
198020
198123
198213
198324
198412
198521
198621
198713
198813
198918
199018
199118
199220
199310
199411
199517
199613
199710
199814
199912
20005
200110
20025
200312
200416
20058
20069
200712
200812
20095
20107
20117
20125
20131
20148
20159
20162
20174
20188
20198
20204
20214
20226
20234
20247
20255
20264

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\") = 1981
    AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    AND 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 SEA82FA014Accident · 1 fatalClosedCessna 402C · Pullman, WADec 28, 1981 · N2749N · DestroyedNTSB LAX82FA030Accident · 2 fatalClosedCessna 150 · Kelso, WADec 19, 1981 · N6043K · DestroyedNTSB SEA82FA007Accident · 4 fatalClosedPiper PA-28 · Longview, WANov 29, 1981 · N54440 · DestroyedNTSB SEA82FA011Accident · 2 fatalClosedCessna 150G · Renton, WANov 26, 1981 · N4737X · DestroyedNTSB SEA82FA001Accident · 1 fatalClosedChampion 7GCAA · Goldendale, WAOct 17, 1981 · N9606S · DestroyedNTSB SEA81FA057Accident · 3 fatalClosedCessna 210A · Woodland, WASep 20, 1981 · N6653X · DestroyedNTSB SEA81FA055Accident · 4 fatalClosedCessna 320D · Republic, WASep 11, 1981 · N111NT · DestroyedNTSB SEA81FA054Accident · 3 fatalClosedBeech C24R · Snoqualmie Ps, WAAug 29, 1981 · N6016S · DestroyedNTSB LAX81FA116Accident · 1 fatalClosedGrum Amer AA-5B · Vancouver, WAAug 13, 1981 · N1565R · DestroyedNTSB SEA81FA051Accident · 2 fatalClosedRyan Acft ST-3KR · Shelton, WAAug 8, 1981 · N56005 · DestroyedNTSB SEA81FA050Accident · 2 fatalClosedSikorsky S-58B · Bellevue, WAAug 7, 1981 · N4247 · DestroyedNTSB SEA81FA049Accident · 2 fatalClosedCessna 182A · Kingston, WAJul 28, 1981 · N4794D · DestroyedNTSB SEA81FA035Accident · 2 fatalClosedBell 47G-4A · Aberdeen, WAMay 19, 1981 · N9457 · DestroyedNTSB SEA81FA034Accident · 1 fatalClosedBeech 35 · Maple Valley, WAMay 8, 1981 · N3024V · DestroyedNTSB SEA81FA031Accident · 2 fatalClosedPiper PA-28 · Washougal, WAApr 22, 1981 · C-GNVX · DestroyedNTSB SEA81AA030Accident · 1 fatalClosedCessna 172N · Gorst, WAApr 21, 1981 · N2411E · DestroyedNTSB SEA81FA026Accident · 1 fatalClosedMuir RV-3 · Renton, WAMar 28, 1981 · N84763 · DestroyedNTSB SEA81FA025Accident · 1 fatalClosedSchweizer SGS126 · Arlington, WAMar 21, 1981 · N9866E · DestroyedNTSB SEA81FA020Accident · 2 fatalClosedCessna 182P · Everett, WAMar 3, 1981 · N21002 · DestroyedNTSB SEA81FA019Accident · 1 fatalClosedPiper PA-28 · Seattle, WAFeb 25, 1981 · N2258Q · DestroyedNTSB SEA81FA018Accident · 2 fatalClosedPiper PA-28 · Port Angles, WAJan 28, 1981 · N3062D · DestroyedNTSB SEA81FA017Accident · 2 fatalClosedCessna 150F · Puyallup, WAJan 23, 1981 · N6942F · DestroyedNTSB DCA81AA006Accident · 7 fatalClosedBeech 99A · Spokane, WAJan 20, 1981 · N390CA · Destroyed