Skip to content

NTSB investigations, 1971, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 SEA72AS027Accident · 1 fatalClosedCessna 150G · Kalama, WADec 31, 1971 · N2257J · Destroyed NTSB SEA72DYG23Accident · No injuriesClosedCessna 182A · Pulman, WADec 23, 1971 · N5948B · Substantial damage NTSB SEA72DVG22Accident · No injuriesClosedLuscombe 8F · Walla Walla, WADec 23, 1971 · N1870B · Substantial damage NTSB SEA72DYG21Accident · Minor injuriesClosedBeech 23 · Pullman, WADec 11, 1971 · N7608R · Substantial damage NTSB SEA72FYG20Accident · No injuriesClosedCessna 172K · Spokane, WANov 14, 1971 · N84034 · Substantial damage NTSB SEA72DYE20Accident · No injuriesClosedCessna 172 · Eastbound, WANov 8, 1971 · N8604B · Substantial damage NTSB SEA72FYE19Accident · 1 fatalClosedKasper BKB · Arlington, WANov 6, 1971 · N2991G · Destroyed NTSB SEA72DYG19Accident · No injuriesClosedCessna 182L · Spokane, WANov 5, 1971 · N42338 · Substantial damage NTSB SEA72FYG18Accident · Serious injuriesClosedPiper PA-32 · College Pl, WAOct 26, 1971 · N5268S · Destroyed NTSB SEA72DYE17Accident · No injuriesClosedPiper PA-22 · San Juan, WAOct 12, 1971 · N3028Z · Substantial damage NTSB SEA72AS016Accident · 1 fatalClosedChampion 7GCBC · North Bend, WAOct 10, 1971 · N5079X · Destroyed NTSB SEA72IS014Incident · No injuriesClosedBoeing 747 · Seattle, WAOct 9, 1971 · N601US · Minor damage NTSB SEA72AS015Accident · 1 fatalClosedChampion 7KCAB · Roche Harbor, WAOct 8, 1971 · N9124L · Destroyed NTSB SEA72DYE16Accident · No injuriesClosedBell 47G2 · Clallam Bay, WAOct 6, 1971 · N5160B · Substantial damage NTSB SEA72FYG15Accident · Serious injuriesClosedCessna A188 · Albion, WASep 23, 1971 · N9772V · Destroyed NTSB SEA72DYG13Accident · No injuriesClosedAero Comdr 600S24 · Pasco, WASep 18, 1971 · N8911Q · Destroyed NTSB SEA72AS013Accident · Minor injuriesClosedHughes 369HS · Shelton, WASep 18, 1971 · N9018F · Substantial damage NTSB SEA72DYE13Accident · No injuriesClosedBeech A35 · Prevost, WASep 9, 1971 · N654B · Substantial damage NTSB SEA72AS010Accident · 4 fatalClosedBellanca 17-30A · Seattle, WASep 9, 1971 · N6701V · Destroyed NTSB SEA72FYG09Accident · Minor injuriesClosedLuscombe 8A · Newport, WASep 5, 1971 · N28443 · Substantial damage NTSB SEA72DYG12Accident · No injuriesClosedCessna 182 · Outlook, WASep 3, 1971 · N2417X · Substantial damage NTSB SEA72AS009Accident · 2 fatalClosedStinson 108-2 · Port Angeles, WASep 3, 1971 · N890D · Destroyed NTSB SEA72IS008Incident · No injuriesClosedBoeing 747 · Seattle, WASep 2, 1971 · N606US · Minor damage NTSB SEA72AS007Accident · 2 fatalClosedCessna 310 · Mazama, WAAug 24, 1971 · N770E · Destroyed NTSB SEA72DYE15Accident · Minor injuriesClosedRyan ST-3KR · Olympia, WAAug 19, 1971 · N53438 · Substantial damage NTSB SEA72DYE11Accident · No injuriesClosedCessna 150 · Bellingham, WAAug 18, 1971 · N23313 · Substantial damage NTSB SEA72DYE10Accident · No injuriesClosedCessna 150 · Edison, WAAug 16, 1971 · N150PW · Substantial damage NTSB SEA72AS006Accident · 2 fatalClosedErco 415-C · Cle Elum, WAAug 14, 1971 · N99265 · Destroyed NTSB SEA72FYG06Accident · 1 fatalClosedPiper PA-25 · Ephrata, WAAug 12, 1971 · N8732L · Destroyed NTSB SEA72FYE06Accident · No injuriesClosedCessna 172 · Renton, WAAug 5, 1971 · N2048Y · Substantial damage NTSB SEA72FYE04Accident · No injuriesClosedJeanies Teenie · Kent, WAAug 1, 1971 · N2457 · Substantial damage NTSB SEA72DYG05Accident · No injuriesClosedHughes 269C · Pullman, WAJul 30, 1971 · N9641F · Destroyed NTSB SEA72DYE05Accident · No injuriesClosedPiper PA-28 · Tacoma, WAJul 21, 1971 · N8813N · Substantial damage NTSB SEA72DYG04Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 20, 1971 · N6034Z · Destroyed NTSB SEA72FYE03Accident · 1 fatalClosedHiller 12E · Skykomish, WAJul 16, 1971 · N9749C · Destroyed NTSB SEA72DYG02Accident · No injuriesClosedCessna A188 · Brownstown, WAJul 16, 1971 · N5501S · Substantial damage NTSB SEA72DYC06Accident · No injuriesClosedCessna 206 · Orchards, WAJul 16, 1971 · N5033U · Substantial damage NTSB SEA72AS002Accident · 1 fatalClosedTaylorcraft BCS12D · Sucia Island, WAJul 16, 1971 · N96216 · Minor damage NTSB SEA72DYG03Accident · No injuriesClosedHughes 269B · Pullman, WAJul 14, 1971 · N9539F · Substantial damage NTSB SEA72FYG01Accident · 1 fatalClosedSnow S2R · Royal City, WAJul 13, 1971 · N8879Q · Destroyed NTSB SEA72FYE02Accident · Minor injuriesClosedCessna 150 · Bellevue, WAJul 3, 1971 · N3139X · Destroyed NTSB SEA72FYE01Accident · No injuriesClosedCessna 150 · Lacey, WAJul 3, 1971 · N6693G · Substantial damage NTSB SEA72AS001Accident · 2 fatalClosedTaylorcraft BC12-D · Riverside, WAJul 3, 1971 · N43846 · Destroyed NTSB SEA71DYG62Accident · No injuriesClosedCessna 182 · Colville, WAJun 27, 1971 · N3106Q · Substantial damage NTSB SEA71FYG60Accident · Minor injuriesClosedBell 47G2 · Moses Lake, WAJun 24, 1971 · N1657 · Destroyed NTSB SEA71FYE38Accident · No injuriesClosedChampion 7ECA · Auburn, WAJun 22, 1971 · N1628G · Substantial damage NTSB SEA71FYE37Accident · Minor injuriesClosedCessna 175 · Kenmore, WAJun 21, 1971 · N7271M · Substantial damage NTSB SEA71DYC45Accident · Minor injuriesClosedBeech A23-24 · Dallesport, WAJun 18, 1971 · N7985L · Substantial damage NTSB SEA71DYG59Accident · No injuriesClosedCallair A-6 · Waterville, WAJun 16, 1971 · N2934G · Substantial damage NTSB SEA71DYG58Accident · No injuriesClosedMaule M-4 · Ephrata, WAJun 14, 1971 · N9862M · Substantial damage