Skip to content

NTSB investigations, 1975, WA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 SEA76AS032Accident · 4 fatalClosedPiper PA-24 · Palmer, WADec 26, 1975 · N7288P · Destroyed NTSB SEA76IS033Incident · No injuriesClosedBeech 99 · Seattle, WADec 24, 1975 · N408SA · No damage NTSB SEA76DYG26Accident · No injuriesClosedCessna 140 · Quincy, WADec 22, 1975 · N89908 · Substantial damage NTSB SEA76DYG27Accident · No injuriesClosedCessna 210 · Wilbur, WADec 18, 1975 · N9634T · Substantial damage NTSB SEA76FYE22Accident · Serious injuriesClosedCessna 172 · Lummi Island, WADec 14, 1975 · N9613Q · Substantial damage NTSB SEA76DYC25Accident · No injuriesClosedCessna 150 · Vancouver, WANov 25, 1975 · N7719E · Substantial damage NTSB SEA76DYG28Accident · No injuriesClosedCessna 182 · Curlew, WANov 22, 1975 · N3343Y · Substantial damage NTSB SEA76DYC23Accident · No injuriesClosedAmer Avco AA1-A · Goldendale, WANov 19, 1975 · N6368L · Substantial damage NTSB SEA76AS027Accident · 1 fatalClosedBeech 19A · Port Orchard, WANov 19, 1975 · N5085T · Destroyed NTSB SEA76FYE21Accident · Serious injuriesClosedPiper PA-22 · Lummi Island, WANov 18, 1975 · N8155D · Substantial damage NTSB SEA76DYG23Accident · No injuriesClosedCessna 150 · Brewster, WANov 10, 1975 · N6329S · Substantial damage NTSB SEA76AS026Accident · 1 fatalClosedPiper J3C-65 · Carbonado, WANov 9, 1975 · N6899H · Destroyed NTSB SEA76FYE21Accident · Serious injuriesClosedAmer Avco AA1-B · Oak Harbor, WANov 8, 1975 · N9687L · Substantial damage NTSB SEA76AS021Accident · Serious injuriesClosedDouglas DC-10 · Seattle, WAOct 16, 1975 · N1815U · No damage NTSB SEA76AS020Accident · 2 fatalClosedPiper PA-24 · Woodland, WAOct 14, 1975 · N6680P · Destroyed NTSB SEA7LFYE18Accident · Serious injuriesClosedLake LA-4 · Alderwood Mnr, WAOct 11, 1975 · N2011L · Destroyed NTSB SEA76AS019Accident · 1 fatalClosedPiper PA-28 · Snoqualme Pass, WAOct 11, 1975 · N5858U · Destroyed NTSB SEA76DYE19Accident · No injuriesClosedCessna 172 · Elma, WAOct 10, 1975 · N5274R · Substantial damage NTSB SEA76FYG17Accident · Serious injuriesClosedBeech 19A · Quincy, WAOct 6, 1975 · N6062N · Substantial damage NTSB SEA76DYG20Accident · No injuriesClosedCessna 172B · Deer Park, WAOct 5, 1975 · N7748X · Substantial damage NTSB SEA76FYE17Accident · 1 fatalClosedMini Cab Hawk · Maple Valley, WASep 30, 1975 · N27421 · Destroyed NTSB SEA76FYG16Accident · No injuriesClosedGlobe GC-1B · Kennewick, WASep 28, 1975 · N3390K · Substantial damage NTSB SEA76DYG21Accident · No injuriesClosedCessna 206 · Pasco, WASep 18, 1975 · N2102F · Substantial damage NTSB SEA76AS017Accident · 1 fatalClosedCessna 150L · Kalama, WASep 18, 1975 · N16187 · Substantial damage NTSB SEA7LDYE16Accident · No injuriesClosedHiller Acft UH-12E · Randle, WASep 15, 1975 · N102EH · Destroyed NTSB SEA76DYG14Accident · No injuriesClosedPiper PA-24 · Richland, WASep 14, 1975 · N5829P · Substantial damage NTSB SEA76DYG13Accident · No injuriesClosedPiper PA-25 · Odessa, WASep 7, 1975 · N7491Z · Substantial damage NTSB SEA76DYG15Accident · No injuriesClosedBell 47G5 · Basin City, WASep 6, 1975 · N1420 · Substantial damage NTSB SEA76DYE15Accident · No injuriesClosedAmer Avco AA1 · Hoquiam, WASep 6, 1975 · N6146L · Substantial damage NTSB SEA76DYG12Accident · No injuriesClosedCessna 188 · Monitor, WASep 5, 1975 · N9083G · Substantial damage NTSB SEA76DYE14Accident · No injuriesClosedHiller Acft UH-12E · Randle, WASep 5, 1975 · N5344V · Destroyed NTSB SEA76DYC16Accident · No injuriesClosedCessna 150 · Kelso, WASep 5, 1975 · N18661 · Substantial damage NTSB SEA76FYE13Accident · No injuriesClosedDehavilland DHC-3 · Auburn, WASep 4, 1975 · N567AA · Substantial damage NTSB SEA76DYC15Accident · No injuriesClosedCessna 150 · Battleground, WASep 3, 1975 · N51053 · Substantial damage NTSB SEA76AB016Accident · 1 fatalClosedCessna 150K · Vancouver, WASep 2, 1975 · N5716G · Destroyed NTSB SEA76AS015Accident · 1 fatalClosedCessna 210 · Bellevue, WAAug 28, 1975 · N7478E · Destroyed NTSB SEA76FYE12Accident · Serious injuriesClosedCessna 205 · Spanaway, WAAug 27, 1975 · N8298Z · Substantial damage NTSB SEA76FYC14Accident · No injuriesClosedLuscombe 8A · Vancouver, WAAug 26, 1975 · N2267K · Substantial damage NTSB SEA76DYG09Accident · No injuriesClosedCessna 150 · Ellensburg, WAAug 26, 1975 · N3270J · Substantial damage NTSB SEA76AS014Accident · 2 fatalClosedCessna 182A · Cyrstal Mtn, WAAug 25, 1975 · N4783D · Destroyed NTSB SEA76AS013Accident · 1 fatalClosedBellanca 14-13 · Snoqualmie Pss, WAAug 24, 1975 · N74265 · Destroyed NTSB SEA76AS012Accident · 2 fatalClosedCessna 182P · Brinnon, WAAug 21, 1975 · N21022 · Destroyed NTSB SEA76DYE11Accident · No injuriesClosedSchleicher ASW-15 · Packwood, WAAug 17, 1975 · N15FZ · Destroyed NTSB LAX76AL012Accident · 1 fatalClosedPiper PA-18 · Tacoma, WAAug 17, 1975 · N4270Z · Destroyed NTSB SEA76DYE09Accident · No injuriesClosedDehavilland DHC-2 · Kent, WAAug 14, 1975 · N5162G · Substantial damage NTSB SEA76DYE10Accident · No injuriesClosedHiller Acft UH-12E · Forks, WAAug 13, 1975 · N2HL · Substantial damage NTSB SEA76DYG08Accident · No injuriesClosedCessna 177 · Quincy, WAAug 11, 1975 · N177JM · Destroyed NTSB SEA76DYE07Accident · No injuriesClosedChampion 7GCAA · Vashon Island, WAAug 10, 1975 · N6326N · Substantial damage NTSB SEA76AS010Accident · 4 fatalClosedBeech G35 · Bellingham, WAAug 10, 1975 · N4500D · Destroyed NTSB SEA76DYG11Accident · No injuriesClosedCessna 175 · Nason Creek, WAAug 9, 1975 · N6555E · Substantial damage