Skip to content

NTSB investigations, 1974, WA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 SEA75AS028Accident · 4 fatalClosedBrittnorman BN-2A · Riverton Hts, WADec 26, 1974 · N66HA · Destroyed NTSB SEA75FYC22Accident · No injuriesClosedCessna 182M · Vancouver, WADec 16, 1974 · N91916 · Substantial damage NTSB SEA75DYE25Accident · No injuriesClosedCessna 170B · Sinclair Isl, WANov 30, 1974 · N1877C · Substantial damage NTSB SEA75AS023Accident · 4 fatalClosedCessna 150L · Mt Vernon, WANov 29, 1974 · N11383 · 2 aircraft · Destroyed NTSB SEA75DYC21Accident · No injuriesClosedAmer Avco AA5 · Vancouver, WANov 9, 1974 · N6027L · Substantial damage NTSB SEA75FYE24Accident · 1 fatalClosedBell 205-A1 · Marblemount, WANov 4, 1974 · N59436 · Destroyed NTSB SEA75AS022Accident · 1 fatalClosedBell 47G-2 · Kingston, WANov 4, 1974 · N5160B · Destroyed NTSB SEA75FYG11Accident · No injuriesClosedCessna 172 · Richland, WANov 2, 1974 · N7143T · Substantial damage NTSB SEA75DYG13Accident · No injuriesClosedPiper PA-31 · Moses Lake, WANov 2, 1974 · N7700L · Substantial damage NTSB SEA75FYE23Accident · No injuriesClosedCessna 172 · Seattle, WAOct 31, 1974 · N3763L · Substantial damage NTSB SEA75AS019Accident · 2 fatalClosedCessna 182E · Prosser, WAOct 28, 1974 · N9224X · Destroyed NTSB SEA75AS018Accident · 1 fatalClosedWren 182 · Aberdeen, WAOct 27, 1974 · N2427X · Destroyed NTSB SEA75DYE22Accident · No injuriesClosedCessna 172 · Lummi Island, WAOct 26, 1974 · N3942L · Substantial damage NTSB SEA75IS017Incident · 1 fatalClosedDouglas DC-8 · Seattle, WAOct 21, 1974 · OYKTE · No damage NTSB SEA75OYE21Accident · No injuriesClosedCessna 177 · Alderwd Manr, WAOct 18, 1974 · N34555 · Substantial damage NTSB SEA75AS014Accident · 1 fatalClosedCessna 310B · Kent, WAOct 1, 1974 · N5414A · Destroyed NTSB SEA75FYE19Accident · Serious injuriesClosedCessna 150 · Snohomish, WASep 28, 1974 · N4481U · Substantial damage NTSB SEA75DYE18Accident · No injuriesClosedFairchild 24 · Oak Harbor, WASep 22, 1974 · N81204 · Substantial damage NTSB SEA75FVE17Accident · No injuriesClosedPiper PA-28 · Stuart Islnd, WASep 12, 1974 · N98113 · Substantial damage NTSB SEA75DYG12Accident · No injuriesClosedBell 47G-2 · Ruff, WASep 11, 1974 · N3794G · Substantial damage NTSB SEA75AS013Accident · 1 fatalClosedChampion 7ECA · Seattle, WASep 9, 1974 · N5235X · No damage NTSB SEA75DYE15Accident · No injuriesClosedChampion 7ECA · Center Islnd, WAAug 28, 1974 · N2582F · Substantial damage NTSB SEA75FYG10Accident · Serious injuriesClosedBell 47G-2 · Quincy, WAAug 27, 1974 · N6717D · Destroyed NTSB SEA75DYG09Accident · No injuriesClosedPiper PA-23 · Richland, WAAug 25, 1974 · N3173P · Substantial damage NTSB SEA75DYE14Accident · No injuriesClosedBoeing E75N1 · Toledo, WAAug 25, 1974 · N5051V · Substantial damage NTSB SEA75DYE13Accident · Serious injuriesClosedCessna 150 · Lynden, WAAug 24, 1974 · N8671S · Destroyed NTSB SEA75AS010Accident · Serious injuriesClosedCessna 150 · Vancouver, WAAug 24, 1974 · N1445Q · 2 aircraft · Destroyed NTSB SEA75DYG08Accident · No injuriesClosedPiper PA-28R · Othello, WAAug 19, 1974 · N3079R · Substantial damage NTSB SEA75FYC11Accident · Serious injuriesClosedRyan ST3KR · Goldendale, WAAug 18, 1974 · N58651 · Destroyed NTSB SEA75DYE16Accident · No injuriesClosedMooney M20A · Shelton, WAAug 18, 1974 · N8390E · Substantial damage NTSB SEA75AS009Accident · 2 fatalClosedPiper PA-22 · Kent, WAAug 17, 1974 · N6199D · Destroyed NTSB SEA75DYG07Accident · No injuriesClosedBell 47G-2 · Royal City, WAAug 14, 1974 · N6717D · Substantial damage NTSB SEA75DYC09Accident · Serious injuriesClosedBell 205A-1 · Cook, WAAug 14, 1974 · N4763R · Substantial damage NTSB SEA75DYE09Accident · Minor injuriesClosedBeech M35 · Westport, WAAug 13, 1974 · N9535R · Substantial damage NTSB SEA75DYE10Accident · Serious injuriesClosedCessna 150 · Fort Lewis, WAAug 12, 1974 · N11632 · No damage NTSB SEA75FYE11Accident · Serious injuriesClosedBell 47G-2A · Mercer Isl, WAAug 11, 1974 · N88AR · Destroyed NTSB SEA75AS008Accident · 1 fatalClosedPiper PA-32 · Toledo, WAAug 10, 1974 · N4126W · Destroyed NTSB SEA75DYE08Accident · Minor injuriesClosedErco 415-C · Port Townsnd, WAAug 6, 1974 · N3013H · Destroyed NTSB SEA75DYE07Accident · Serious injuriesClosedPiper PA-28 · Eatonville, WAAug 5, 1974 · N2171R · Substantial damage NTSB SEA75AS007Accident · 1 fatalClosedNavion B · Stevenson, WAAug 1, 1974 · N5149K · Substantial damage NTSB SEA75FYE05Accident · Minor injuriesClosedCessna 140A · Stanwood, WAJul 20, 1974 · N9448A · Destroyed NTSB SEA75DYG04Accident · No injuriesClosedCessna 150 · Selah, WAJul 20, 1974 · N6822F · Destroyed NTSB SEA75FYE04Accident · 1 fatalClosedSorrell JA3-80 · Arlington, WAJul 19, 1974 · N68654 · Destroyed NTSB SEA75DYG05Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 18, 1974 · N8803L · Substantial damage NTSB SEA75DYG03Accident · Minor injuriesClosedBell 47G-2 · Wapato, WAJul 18, 1974 · N7891B · Destroyed NTSB SEA75AS004Accident · 2 fatalClosedCessna 172H · Snoqualme Ps, WAJul 18, 1974 · N1669F · Destroyed NTSB SEA75FYE03Accident · Minor injuriesClosedCessna 150F · Buckley, WAJul 16, 1974 · N7777F · Destroyed NTSB SEA75FYG02Accident · Minor injuriesClosedBellanca 8KCAB · Deer Park, WAJul 14, 1974 · N33MJ · Destroyed NTSB SEA75AS003Accident · 1 fatalClosedCessna 180C · Tacoma, WAJul 12, 1974 · N9321T · Destroyed NTSB SEA75AS002Accident · 4 fatalClosedBeech D95A · Anacortes, WAJul 11, 1974 · N8888V · Destroyed