Skip to content

NTSB investigations, 1981, WA

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1981, WA per year, 1963–2026: 4,814 cases
1963	1
1964	110
1965	131
1966	140
1967	159
1968	125
1969	116
1970	118
1971	86
1972	107
1973	104
1974	109
1975	129
1976	117
1977	104
1978	118
1979	118
1980	107
1981	102
1982	95
1983	101
1984	89
1985	73
1986	100
1987	79
1988	80
1989	76
1990	78
1991	94
1992	79
1993	69
1994	67
1995	73
1996	65
1997	62
1998	67
1999	68
2000	67
2001	66
2002	66
2003	74
2004	75
2005	59
2006	49
2007	53
2008	58
2009	58
2010	51
2011	58
2012	54
2013	37
2014	47
2015	36
2016	32
2017	39
2018	47
2019	37
2020	28
2021	41
2022	35
2023	36
2024	29
2025	37
2026	29

Where

Latest cases

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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.

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'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB SEA82FA014Accident · 1 fatalClosedCessna 402C · Pullman, WADec 28, 1981 · N2749N · Destroyed NTSB LAX82FA030Accident · 2 fatalClosedCessna 150 · Kelso, WADec 19, 1981 · N6043K · Destroyed NTSB SEA82IA009Incident · No injuriesClosedCessna 207 · Belfair, WADec 2, 1981 · N1733U · Minor damage NTSB SEA82DYP06Accident · No injuriesClosedCessna 172G · Mattawa, WADec 2, 1981 · N5757R · Substantial damage NTSB SEA82IA008Incident · No injuriesClosedPiper PA-31 · Seattle, WANov 30, 1981 · N3533P · No damage NTSB SEA82FA007Accident · 4 fatalClosedPiper PA-28 · Longview, WANov 29, 1981 · N54440 · Destroyed NTSB SEA82DYE03Accident · No injuriesClosedLuscombe 8A · Friday Harbor, WANov 29, 1981 · N45651 · Substantial damage NTSB SEA82FA011Accident · 2 fatalClosedCessna 150G · Renton, WANov 26, 1981 · N4737X · Destroyed NTSB SEA82IA004Incident · No injuriesClosedBeech 200 · Seattle, WANov 19, 1981 · N3875F · Minor damage NTSB SEA82DYE01Accident · No injuriesClosedEnstrom 280C · Burke Island, WANov 13, 1981 · N555BT · Substantial damage NTSB SEA82FYP03Accident · No injuriesClosedRobinson R22 · Rosalia, WANov 5, 1981 · N9072N · Substantial damage NTSB SEA82DYP04Accident · Minor injuriesClosedPiper PA-28 · George, WANov 5, 1981 · N8873N · Destroyed NTSB SEA82DYE02Accident · No injuriesClosedCessna 182 · Everett, WANov 2, 1981 · N42043 · Substantial damage NTSB SEA82FA001Accident · 1 fatalClosedChampion 7GCAA · Goldendale, WAOct 17, 1981 · N9606S · Destroyed NTSB SEA82DYP01Accident · Minor injuriesClosedBellanca 7ECA · Wapato, WAOct 11, 1981 · N2696Z · Substantial damage NTSB SEA81FYP39Accident · No injuriesClosedPiper PA-28R · Republic, WAOct 11, 1981 · N8906C · Substantial damage NTSB SEA81FA057Accident · 3 fatalClosedCessna 210A · Woodland, WASep 20, 1981 · N6653X · Destroyed NTSB SEA81DYP42Accident · No injuriesClosedBoeing A75N1 · Orondo, WASep 17, 1981 · N56929 · Substantial damage NTSB SEA81DYP40Accident · No injuriesClosedEagle DW-1 · Chelan, WASep 16, 1981 · N8802E · Substantial damage NTSB SEA81FA055Accident · 4 fatalClosedCessna 320D · Republic, WASep 11, 1981 · N111NT · Destroyed NTSB SEA81DYE37Accident · No injuriesClosedCessna 172 · Bremerton, WASep 8, 1981 · N2946E · Substantial damage NTSB SEA81DYP38Accident · No injuriesClosedCessna 150 · Sunnyside, WASep 4, 1981 · N3800V · Substantial damage NTSB SEA81DYM41Accident · No injuriesClosedBeech B23 · Orchards, WASep 4, 1981 · N2362Z · Substantial damage NTSB SEA81FA054Accident · 3 fatalClosedBeech C24R · Snoqualmie Ps, WAAug 29, 1981 · N6016S · Destroyed NTSB SEA81DYP37Accident · No injuriesClosedHughes 369D · Leavenworth, WAAug 26, 1981 · N58306 · Substantial damage NTSB SEA81DYE38Accident · No injuriesClosedCessna 172A · Port Townsend, WAAug 25, 1981 · N7438X · Substantial damage NTSB SEA81DYP36Accident · Serious injuriesClosedCessna P210N · College Place, WAAug 18, 1981 · N4931K · Substantial damage NTSB SEA81FYP35Accident · No injuriesClosedNavion · Spangle, WAAug 16, 1981 · N91104 · Substantial damage NTSB SEA81FYP34Accident · No injuriesClosedBoeing E75 · Omak, WAAug 14, 1981 · N68462 · Substantial damage NTSB SEA81DYP33Accident · No injuriesClosedCessna 150L · Waitsburg, WAAug 13, 1981 · N21916 · Substantial damage NTSB LAX81FA116Accident · 1 fatalClosedGrum Amer AA-5B · Vancouver, WAAug 13, 1981 · N1565R · Destroyed NTSB SEA81DA052Accident · No injuriesClosedPiper PA-34 · Wenatchee, WAAug 10, 1981 · N666HL · Substantial damage NTSB SEA81FA051Accident · 2 fatalClosedRyan Acft ST-3KR · Shelton, WAAug 8, 1981 · N56005 · Destroyed NTSB SEA81FA050Accident · 2 fatalClosedSikorsky S-58B · Bellevue, WAAug 7, 1981 · N4247 · Destroyed NTSB SEA81FYM34Accident · Minor injuriesClosedCessna 170B · Vancouver, WAAug 6, 1981 · N3123A · Substantial damage NTSB SEA81FYP31Accident · No injuriesClosedBoeing A75N1 · Wenatchee, WAAug 3, 1981 · N49323 · Substantial damage NTSB SEA81FA049Accident · 2 fatalClosedCessna 182A · Kingston, WAJul 28, 1981 · N4794D · Destroyed NTSB SEA81FYE36Accident · No injuriesClosedPietenpol GN-2 · Friday Harbor, WAJul 26, 1981 · N6210 · Substantial damage NTSB SEA81DYP30Accident · Minor injuriesClosedPiper PA-22 · Coulee City, WAJul 25, 1981 · N2287A · Substantial damage NTSB SEA81FYP28Accident · Minor injuriesClosedEnstrom F-28C · Rice, WAJul 21, 1981 · N5689M · Destroyed NTSB SEA81DYP27Accident · Minor injuriesClosedPiper PA-36 · Moses Lake, WAJul 17, 1981 · N57611 · Destroyed NTSB SEA81DYE35Accident · No injuriesClosedPiper PA-28 · Bellingham, WAJul 17, 1981 · N6497R · Destroyed NTSB SEA81FA046Accident · No injuriesClosedBeech V35B · Sequim, WAJul 16, 1981 · N2052D · Substantial damage NTSB SEA81DYP26Accident · Minor injuriesClosedBell 47G-2A · Moses Lake, WAJul 9, 1981 · N73997 · Destroyed NTSB SEA81DYP25Accident · No injuriesClosedCessna 180 · Walla Walla, WAJul 3, 1981 · N7828K · Substantial damage NTSB SEA81DYE33Accident · No injuriesClosedCessna 310D · Rochester, WAJun 29, 1981 · N6759T · Substantial damage NTSB SEA81DYE32Accident · No injuriesClosedCessna 152 · Seattle, WAJun 29, 1981 · N6136B · Substantial damage NTSB SEA81DYP24Accident · Serious injuriesClosedAero Comdr S2R · Wallula, WAJun 24, 1981 · N8802Q · Destroyed NTSB SEA81DYE34Accident · No injuriesClosedSchweizer SGS233 · Issaquah, WAJun 24, 1981 · N2828H · Substantial damage NTSB SEA81FYP23Accident · Minor injuriesClosedPiper PA-28R · Sunnyside, WAJun 22, 1981 · N3790M · Substantial damage