Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 SEA69F0165Accident · No injuriesClosedHughes 269A · Renton, WADec 28, 1968 · N8780F · Substantial damage NTSB SEA69D0155Accident · No injuriesClosedPiper PA-28 · Spokane, WADec 15, 1968 · N8283W · Substantial damage NTSB SEA69D0180Accident · No injuriesClosedStinson 108 · Vancouver, WADec 8, 1968 · N97887 · Substantial damage NTSB SEA69D0166Accident · No injuriesClosedCessna 150 · Gig Harbor, WADec 8, 1968 · N8846G · Substantial damage NTSB SEA69D0149Accident · No injuriesClosedCessna 210D · Spangle, WADec 7, 1968 · N3743Y · Substantial damage NTSB SEA69D0164Accident · Minor injuriesClosedPiper PA-28 · Duvall, WADec 6, 1968 · N9347W · Destroyed NTSB SEA69F0173Accident · Minor injuriesClosedBeech D18S · Seattle, WADec 5, 1968 · CF-RQL · Destroyed NTSB SEA69D0151Accident · Minor injuriesClosedCessna 182F · Marshall, WANov 27, 1968 · N5567B · Substantial damage NTSB SEA69D0146Accident · No injuriesClosedPiper PA-28 · Almira, WANov 24, 1968 · N7501J · Substantial damage NTSB SEA69A0031Accident · 1 fatalClosedCessna 150J · Ralston, WANov 24, 1968 · N50598 · Destroyed NTSB SEA69A0028Accident · 1 fatalClosedCessna 150H · Spirit Lake, WANov 10, 1968 · N22166 · Destroyed NTSB SEA69A0027Accident · 2 fatalClosedPiper PA-16 · Pine City, WANov 10, 1968 · N6804K · Substantial damage NTSB SEA69A0026Accident · 2 fatalClosedStinson 108 · Vancouver, WANov 10, 1968 · N422C · Destroyed NTSB SEA69D0136Accident · No injuriesClosedCessna 150 · Long Beach, WANov 6, 1968 · N6470T · Substantial damage NTSB SEA69F0133Accident · No injuriesClosedBeech C-17B · Arlington, WANov 3, 1968 · N17074 · Substantial damage NTSB SEA69F0129Accident · No injuriesClosedHughes 269A · Renton, WAOct 29, 1968 · N8772F · Destroyed NTSB SEA69D0137Accident · No injuriesClosedStinson 108-3 · Seattle, WAOct 26, 1968 · N6283M · Substantial damage NTSB SEA69D0144Accident · No injuriesClosedCessna 206 · Bellevue, WAOct 24, 1968 · 8R-GDF · 2 aircraft · Substantial damage NTSB SEA69F0140Accident · No injuriesClosedBell 206 · Seattle, WAOct 20, 1968 · N4046G · Substantial damage NTSB SEA69F0159Accident · Minor injuriesClosedBoeing A75N1 · Sprague, WAOct 16, 1968 · N56919 · Substantial damage NTSB SEA69F0130Accident · Minor injuriesClosedTaylorcraft A · Bellevue, WAOct 10, 1968 · N19647 · Substantial damage NTSB SEA69D0115Accident · Serious injuriesClosedBell 47G-4 · Eltopia, WASep 30, 1968 · N6786D · Substantial damage NTSB SEA69D0124Accident · No injuriesClosedCessna 150 · Ephrata, WASep 29, 1968 · N7183F · Substantial damage NTSB SEA69D0117Accident · No injuriesClosedBeech S35 · Malott, WASep 28, 1968 · N8802M · Substantial damage NTSB SEA69D0128Accident · No injuriesClosedPiper PA-28 · Spanaway, WASep 24, 1968 · N9265W · Substantial damage NTSB SEA69D0114Accident · No injuriesClosedSchleicher KA6CR · Dallesport, WASep 15, 1968 · N8521 · Destroyed NTSB SEA69D0111Accident · No injuriesClosedCessna 150 · Pullman, WASep 12, 1968 · N7286S · Substantial damage NTSB SEA69A0019Accident · 2 fatalClosedPiper PA-18 · Sunnyside, WASep 5, 1968 · N2889P · Destroyed NTSB SEA69D0100Accident · No injuriesClosedPiper PA-25 · Othello, WASep 3, 1968 · N7610Z · Substantial damage NTSB SEA69D0095Accident · No injuriesClosedAeronca 7AC · Tekoa, WASep 2, 1968 · N2218E · Substantial damage NTSB SEA69D0091Accident · Minor injuriesClosedJoesten J-1 · Puyallup, WASep 2, 1968 · N68653 · Destroyed NTSB SEA69A0018Accident · 2 fatalClosedCessna 140 · Snoqualmie P, WASep 1, 1968 · N76588 · Destroyed NTSB SEA69F0109Accident · No injuriesClosedPiper PA-14 · Silverdale, WAAug 30, 1968 · N4296H · Substantial damage NTSB SEA69D0099Accident · No injuriesClosedCessna 150 · Friday Harbr, WAAug 30, 1968 · N6720F · Substantial damage NTSB SEA69D0096Accident · No injuriesClosedCessna A188 · Sunnyside, WAAug 29, 1968 · N8019V · Substantial damage NTSB SEA69A0017Accident · 2 fatalClosedCessna 172 · Lopez, WAAug 28, 1968 · N2520Y · Destroyed NTSB SEA69A0016Accident · 2 fatalClosedErco 415-D · Packwood, WAAug 26, 1968 · N2505H · Destroyed NTSB SEA69D0087Accident · No injuriesClosedPiper PA-24 · Colville, WAAug 23, 1968 · N9256P · Substantial damage NTSB SEA69F0086Accident · 1 fatalClosedGrumman G-164 · Walla Walla, WAAug 19, 1968 · N650U · Destroyed NTSB SEA69A0013Accident · 5 fatalClosedPiper PA-32 · Skamania, WAAug 15, 1968 · N4006R · Destroyed NTSB SEA69A0011Accident · 1 fatalClosedPiper PA-18A · Hartline, WAAug 10, 1968 · N2262A · Destroyed NTSB SEA69D0070Accident · No injuriesClosedCessna 150 · Kent, WAAug 9, 1968 · N3530L · Substantial damage NTSB SEA69D0062Accident · No injuriesClosedStinson 108-1 · Warden, WAAug 6, 1968 · N9105K · Substantial damage NTSB SEA69F0075Accident · Serious injuriesClosedSchweizer SGS123 · East Wenatch, WAJul 28, 1968 · N10366 · Substantial damage NTSB SEA69D0061Accident · No injuriesClosedPiper PA-25 · Warden, WAJul 28, 1968 · N7415Z · Substantial damage NTSB SEA69D0063Accident · No injuriesClosedCessna 172 · Yakima, WAJul 27, 1968 · N4134F · Substantial damage NTSB SEA69A0009Accident · 3 fatalClosedCessna T-50 · Ellensburg, WAJul 27, 1968 · N50615 · Destroyed NTSB SEA69F0049Accident · Minor injuriesClosedCessna 188 · Sunnyside, WAJul 25, 1968 · N8024V · Substantial damage NTSB SEA69F0047Accident · No injuriesClosedPiper PA-24 · Spokane, WAJul 23, 1968 · N6817P · Substantial damage NTSB SEA69A0007Accident · 1 fatalClosedCommonwlth 9000 · Vancouver, WAJul 21, 1968 · N18008 · Destroyed