Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 SEA68D0237Accident · No injuriesClosedCessna 182 · Wenatchee, WADec 19, 1967 · N2846R · Substantial damage NTSB SEA68A0043Accident · No injuriesClosedPiper PA-24 · Seattle, WADec 10, 1967 · N6091P · Substantial damage NTSB SEA68D0223Accident · No injuriesClosedCessna 180 · Prosser, WADec 8, 1967 · N172AA · Substantial damage NTSB SEA68F0217Accident · No injuriesClosedPiper PA-22 · Electric Cty, WADec 4, 1967 · N3446A · Substantial damage NTSB SEA68D0232Accident · No injuriesClosedPiper PA-22 · Oak Harbor, WADec 3, 1967 · N5017Z · Substantial damage NTSB SEA68D0222Accident · Minor injuriesClosedCessna 140 · Davenport, WADec 1, 1967 · N72232 · Substantial damage NTSB FTW68A0054Accident · 4 fatalClosedCessna 170A · Van Horn, WANov 26, 1967 · N81K · Destroyed NTSB SEA68D0225Accident · No injuriesClosedCessna 150 · Renton, WANov 22, 1967 · N6849F · 2 aircraft · Substantial damage NTSB SEA68F0224Accident · Minor injuriesClosedCessna 172 · Castle Rock, WANov 12, 1967 · N7045T · Substantial damage NTSB SEA68D0230Accident · No injuriesClosedPiper PA-28 · Carson, WANov 9, 1967 · N8652W · Substantial damage NTSB SEA68F0212Accident · No injuriesClosedPiper PA-24 · Ocean Shores, WANov 4, 1967 · N6116P · 2 aircraft · Substantial damage NTSB SEA68F0201Accident · No injuriesClosedStinson 10A · Kettle Falls, WANov 4, 1967 · N32298 · Substantial damage NTSB SEA68F0196Accident · No injuriesClosedLuscombe 8A · Renton, WANov 2, 1967 · N28425 · Substantial damage NTSB SEA68F0226Accident · No injuriesClosedMooney M20C · Kelso, WANov 1, 1967 · N9338M · Substantial damage NTSB SEA68D0197Accident · No injuriesClosedMooney M20E · Starbuck, WAOct 26, 1967 · N6852U · Substantial damage NTSB SEA68A0034Accident · No injuriesClosedCessna 337A · Ocean Shores, WAOct 13, 1967 · N5326S · Substantial damage NTSB SEA68A0033Accident · No injuriesClosedBell 47G3B1 · Snoqualmie P, WAOct 11, 1967 · N1321X · Substantial damage NTSB SEA68F0175Accident · No injuriesClosedCamair 480 · Georgetown, WAOct 8, 1967 · N234 · Substantial damage NTSB SEA68A0031Accident · 3 fatalClosedCessna 180 · Snoqualmie P, WAOct 3, 1967 · N9185C · Destroyed NTSB SEA68A0030Accident · No injuriesClosedCessna 206 · Decatur, WAOct 1, 1967 · N8041Z · Substantial damage NTSB SEA68D0148Accident · No injuriesClosedCessna 140 · Seattle, WASep 29, 1967 · N76441 · Substantial damage NTSB SEA68A0029Accident · 2 fatalClosedCessna T-210F · Gardiner, WASep 29, 1967 · CF-UDD · Destroyed NTSB SEA68D0141Accident · No injuriesClosedPiper PA-28 · Yakima, WASep 28, 1967 · N4338J · Substantial damage NTSB SEA68F0149Accident · Minor injuriesClosedPiper J-3 · Kent, WASep 27, 1967 · N6899H · Substantial damage NTSB SEA68F0116Accident · Minor injuriesClosedErco 415-C · Pt.Townsend, WASep 26, 1967 · N99181 · Substantial damage NTSB SEA68F0164Accident · Minor injuriesClosedBeech C35 · Forks, WASep 19, 1967 · N773D · Substantial damage NTSB SEA68D0158Accident · No injuriesClosedBoeing B75 · Yakima, WASep 18, 1967 · N1145N · 2 aircraft · Minor damage NTSB SEA68F0227Accident · Serious injuriesClosedCessna 180 · Orchards, WASep 17, 1967 · N1793C · Destroyed NTSB SEA68D0137Accident · Minor injuriesClosedErco 415-C · Easton, WASep 17, 1967 · N3905H · Substantial damage NTSB SEA68F0123Accident · Minor injuriesClosedBeech C35 · Cle Elum, WASep 10, 1967 · N5927C · Substantial damage NTSB SEA68A0025Accident · 2 fatalClosedCessna 180H · Ilwaco, WASep 8, 1967 · N2787X · Destroyed NTSB SEA68F0160Accident · Serious injuriesClosedCessna 172 · Skykomish, WASep 5, 1967 · N8244U · Destroyed NTSB SEA68D0176Accident · No injuriesClosedPiper PA-24 · Auburn, WASep 4, 1967 · N5727P · Destroyed NTSB SEA68D0153Accident · Minor injuriesClosedStinson 108-2 · Bellingham, WASep 4, 1967 · CF-JGU · Substantial damage NTSB SEA68A0023Accident · 1 fatalClosedLuscombe 8A · Olympia, WASep 3, 1967 · N71865 · Destroyed NTSB SEA68F0177Accident · No injuriesClosedMooney M20C · Port Angeles, WAAug 29, 1967 · N5771Q · Substantial damage NTSB SEA68F0092Accident · No injuriesClosedBeech J35 · Spokane, WAAug 29, 1967 · N3053C · Substantial damage NTSB SEA68D0128Accident · No injuriesClosedCessna 175 · Walla Walla, WAAug 28, 1967 · N6918E · Substantial damage NTSB SEA68D0105Accident · No injuriesClosedLuscombe 8A · Deer Park, WAAug 28, 1967 · N28833 · Substantial damage NTSB SEA68D0181Accident · No injuriesClosedCessna 150 · Vancouver, WAAug 27, 1967 · N7904Z · Substantial damage NTSB SEA68D0147Accident · No injuriesClosedCessna 172 · Snohomish, WAAug 27, 1967 · N5674A · Substantial damage NTSB SEA68D0150Accident · Minor injuriesClosedCessna 182 · Goldbar, WAAug 25, 1967 · N2654G · Substantial damage NTSB SEA68F0151Accident · No injuriesClosedCessna 172 · Tumwater, WAAug 19, 1967 · N7027T · Destroyed NTSB SEA68D0174Accident · No injuriesClosedWren 460 · Seattle, WAAug 18, 1967 · N2427X · Substantial damage NTSB SEA68A0018Accident · No injuriesClosedCessna 180H · Clinton, WAAug 17, 1967 · N7901V · Substantial damage NTSB SEA68D0136Accident · No injuriesClosedPiper PA-23 · Georgetown, WAAug 15, 1967 · N4893P · Substantial damage NTSB SEA68F0152Accident · No injuriesClosedBoeing 247-D · Seattle, WAAug 14, 1967 · N13347 · Substantial damage NTSB SEA68F0161Accident · Serious injuriesClosedWaco UKC · Monroe, WAAug 11, 1967 · N16967 · Substantial damage NTSB SEA68D0135Accident · No injuriesClosedCessna 150 · Everett, WAAug 11, 1967 · N6511F · Substantial damage NTSB SEA68A0014Accident · 2 fatalClosedPiper PA-11 · Dayton, WAAug 10, 1967 · N78736 · Destroyed