Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 SEA67D0228Accident · No injuriesClosedPiper PA-28 · Bellevue, WADec 31, 1966 · N5745W · Substantial damage NTSB SEA67F0245Accident · Serious injuriesClosedCessna 170A · Kalama, WADec 30, 1966 · N9237A · Destroyed NTSB SEA67F0244Accident · Minor injuriesClosedPiper PA-28 · Tacoma, WADec 17, 1966 · N4545R · 2 aircraft · Substantial damage NTSB SEA67A0042Accident · No injuriesClosedHiller UH-12C · Rosalia, WADec 12, 1966 · N5316V · Substantial damage NTSB SEA67D0213Accident · No injuriesClosedCessna 172 · Fri.Harbor, WADec 6, 1966 · N6374E · Substantial damage NTSB SEA67A0041Accident · 1 fatalClosedCessna 150F · Ndavenport, WADec 6, 1966 · N8888S · Destroyed NTSB SEA67D0203Accident · No injuriesClosedPiper PA-23 · Almira, WADec 3, 1966 · N4947P · Substantial damage NTSB SEA67A0040Accident · No injuriesClosedBell 47G-2 · Maple Valley, WADec 1, 1966 · N2865B · Substantial damage NTSB SEA67D0200Accident · Serious injuriesClosedCessna 175 · Kettle Falls, WANov 24, 1966 · CF-SFS · Destroyed NTSB SEA67A0038Accident · 2 fatalClosedCessna 182H · Frances, WANov 23, 1966 · N2047X · Destroyed NTSB SEA67D0201Accident · No injuriesClosedCessna 150 · Colton, WANov 22, 1966 · N8974S · Substantial damage NTSB SEA67A0037Accident · No injuriesClosedAir-Space 18A · Hoquiam, WANov 21, 1966 · N6130S · Substantial damage NTSB SEA67F0205Accident · Serious injuriesClosedCessna 182 · Royal City, WANov 16, 1966 · N2349R · Substantial damage NTSB SEA67D0175Accident · No injuriesClosedCessna 150 · Spokane, WANov 13, 1966 · N8647G · Substantial damage NTSB SEA67D0202Accident · No injuriesClosedCessna 150 · Pasco, WANov 12, 1966 · N3986J · Substantial damage NTSB SEA67D0188Accident · No injuriesClosedStinson L-5B · Yakima, WANov 12, 1966 · N6439C · Destroyed NTSB SEA67D0182Accident · No injuriesClosedCessna 182 · Tonasket, WANov 11, 1966 · N3117Y · Substantial damage NTSB SEA67D0212Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WANov 9, 1966 · N6936W · Substantial damage NTSB SEA67D0174Accident · No injuriesClosedPiper PA-24 · Touchet, WANov 6, 1966 · N5070P · Substantial damage NTSB SEA67F0179Accident · No injuriesClosedBeech G35 · Spokane, WANov 5, 1966 · N4501D · Substantial damage NTSB SEA67D0183Accident · No injuriesClosedPiper PA-16 · College Plce, WAOct 27, 1966 · N5944H · Substantial damage NTSB SEA67D0173Accident · No injuriesClosedMooney M21 · Walla Walla, WAOct 27, 1966 · N6852U · Substantial damage NTSB SEA66D0166Accident · No injuriesClosedPiper PA-25 · Pasco, WAOct 22, 1966 · N6049Z · Substantial damage NTSB SEA67D0211Accident · No injuriesClosedCessna 310J · Everett, WAOct 13, 1966 · N3116L · Destroyed NTSB SEA67A0031Accident · No injuriesClosedBell 47G · Tonasket, WAOct 12, 1966 · N979B · Substantial damage NTSB SEA67D0145Accident · No injuriesClosedPiper PA-18 · Coulee City, WAOct 11, 1966 · N1883P · Substantial damage NTSB SEA67A0032Accident · No injuriesClosedBell 47D1 · Llensburg, WAOct 11, 1966 · N162B · Substantial damage NTSB SEA67D0210Accident · No injuriesClosedCessna 172 · Seattle, WAOct 9, 1966 · N8533B · Substantial damage NTSB SEA67D0209Accident · No injuriesClosedCessna 150 · Bellvue, WAOct 8, 1966 · N4146U · Substantial damage NTSB SEA67D0176Accident · No injuriesClosedPiper PA-32 · College Pl., WAOct 8, 1966 · N3497W · Substantial damage NTSB SEA67A0036Accident · No injuriesClosedBell 47G3B1 · Cle Elum, WAOct 8, 1966 · N8518F · Substantial damage NTSB SEA67D0208Accident · No injuriesClosedPiper PA-24 · Friday Harb., WAOct 2, 1966 · N8974P · Substantial damage NTSB LAX67A0035Accident · 4 fatalClosedBeech A35 · Seattle, WAOct 2, 1966 · N728B · Destroyed NTSB SEA67D0140Accident · No injuriesClosedCessna 182 · Moses Lake, WASep 20, 1966 · N2934F · Substantial damage NTSB SEA67D0160Accident · No injuriesClosedPiper PA-14 · Starbuck, WASep 19, 1966 · N5145H · Substantial damage NTSB SEA67D0149Accident · No injuriesClosedCessna 172 · Puyallup, WASep 19, 1966 · N5757R · Substantial damage NTSB SEA67D0155Accident · No injuriesClosedCessna 172 · Snohomish, WASep 13, 1966 · N5789R · Substantial damage NTSB SEA67D0113Accident · No injuriesClosedCessna 180 · Ellensburg, WASep 13, 1966 · N8214V · Substantial damage NTSB SEA67D0136Accident · No injuriesClosedPiper PA-25 · Quincy, WASep 12, 1966 · N6034Z · Substantial damage NTSB SEA67D0151Accident · No injuriesClosedCessna 175 · Bellevue, WASep 7, 1966 · N7272M · Substantial damage NTSB SEA67A0021Accident · 2 fatalClosedGlobe GC-1B · Woodinville, WASep 7, 1966 · N80785 · Destroyed NTSB SEA67F0109Accident · Minor injuriesClosedCessna 140 · Walla Walla, WASep 4, 1966 · N2222N · Substantial damage NTSB UNK66X0169AccidentClosedBeech G35 · Seattle, WASep 1, 1966 · N45590 · Substantial damage NTSB SEA67D0150Accident · No injuriesClosedAeronca 7AC · Auburn, WASep 1, 1966 · N2004E · Substantial damage NTSB SEA67F0106Accident · No injuriesClosedMooney M20B · Richland, WAAug 28, 1966 · N74545 · Substantial damage NTSB SEA67A0018Accident · No injuriesClosedBensen B8M · Richland, WAAug 27, 1966 · N68682 · Substantial damage NTSB SEA67F0163Accident · No injuriesClosedGlobe GC-1B · Vancouver, WAAug 21, 1966 · N80649 · Substantial damage NTSB SEA67D0153Accident · No injuriesClosedBeech J35 · Fri. Harbor, WAAug 21, 1966 · N3053C · Substantial damage NTSB SEA67D0103Accident · No injuriesClosedMooney M-18 · Easton, WAAug 21, 1966 · N4180 · Substantial damage NTSB SEA67A0016Accident · 2 fatalClosedFairchild M-62C · Bellingham, WAAug 21, 1966 · N58737 · Substantial damage