Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 SEA70F0136Accident · Serious injuriesClosedCessna 185 · North Bend, WADec 23, 1969 · N4519F · Substantial damage NTSB SEA70F0137Accident · Serious injuriesClosedPiper PA-28 · Bremerton, WADec 15, 1969 · N98296 · Substantial damage NTSB SEA70F0129Accident · Serious injuriesClosedCessna 150H · Spokane, WADec 15, 1969 · N22640 · Destroyed NTSB SEA70D0150Accident · No injuriesClosedAmerican AA-1 · Vancouver, WADec 14, 1969 · N5763L · Substantial damage NTSB SEA70I0024Incident · No injuriesClosedBoeing 747 · Renton, WADec 13, 1969 · N732PA · Minor damage NTSB SEA70F0138Accident · Minor injuriesClosedCessna 172 · Port Townsnd, WADec 10, 1969 · N8692U · Destroyed NTSB SEA70D0115Accident · No injuriesClosedAeronca 15AC · Mead, WANov 21, 1969 · N1458H · Substantial damage NTSB SEA70I0021Incident · No injuriesClosedFairchild F-27A · Pullman, WANov 17, 1969 · N755L · Minor damage NTSB SEA70A0022Accident · 1 fatalClosedCessna 150F · Cougar, WANov 17, 1969 · N8879G · Destroyed NTSB SEA70D0112Accident · No injuriesClosedCessna 180 · Seattle, WANov 15, 1969 · N7699A · Substantial damage NTSB SEA70D0116Accident · Minor injuriesClosedStinson 108-1 · Ellensburg, WANov 10, 1969 · N97963 · Destroyed NTSB SEA79FA059Accident · 1 fatalClosedCessna 140 · Lester, WANov 2, 1969 · N2050N · Destroyed NTSB SEA70F0119Accident · 2 fatalClosedBell 47G-2 · Loomis, WAOct 31, 1969 · N2803B · Destroyed NTSB SEA70F0110Accident · Minor injuriesClosedCessna 180 · Mountlake Tr, WAOct 27, 1969 · N1772C · Destroyed NTSB SEA70F0105Accident · No injuriesClosedCessna 172 · Auburn, WAOct 25, 1969 · N6064R · Substantial damage NTSB SEA70D0109Accident · No injuriesClosedMonocoupe 110 · Monroe, WAOct 19, 1969 · N18642 · Substantial damage NTSB SEA70D0102Accident · No injuriesClosedCessna 210E · Wenatchee, WAOct 18, 1969 · N4969U · Substantial damage NTSB SEA70A0015Accident · 1 fatalClosedErco 415-D · Issaquah, WAOct 12, 1969 · N2137H · Destroyed NTSB SEA70F0097Accident · Minor injuriesClosedKaman HUK-1 · Enumclaw, WAOct 4, 1969 · N11012 · Substantial damage NTSB SEA70D0133Accident · No injuriesClosedSchemp SHK-1 · Easton, WAOct 4, 1969 · N1582 · Substantial damage NTSB SEA70D0128Accident · No injuriesClosedChampion 7GCAA · Easton, WAOct 4, 1969 · N9528S · Substantial damage NTSB SEA70D0099Accident · No injuriesClosedCessna U206 · Sunnyside, WAOct 3, 1969 · N2191F · Substantial damage NTSB SEA70F0108Accident · 1 fatalClosedCessna A185E · Kent, WAOct 2, 1969 · N2726J · Destroyed NTSB SEA70F0106Accident · Minor injuriesClosedCessna 150 · Takoma, WASep 24, 1969 · N3538J · Substantial damage NTSB SEA70A0013Accident · 1 fatalClosedPiper PA-30 · Tacoma, WASep 22, 1969 · N8504Y · Destroyed NTSB SEA70A0012Accident · 2 fatalClosedCessna 177A · Spokane, WASep 21, 1969 · N30397 · Destroyed NTSB SEA70D0108Accident · No injuriesClosedCessna 170 · Alderwod Mnr, WASep 19, 1969 · N2534V · Substantial damage NTSB SEA70D0087Accident · No injuriesClosedCessna T-50 · Everett, WASep 14, 1969 · N1261N · Substantial damage NTSB SEA70D0085Accident · No injuriesClosedLuscombe 8A · Snohomish, WASep 7, 1969 · N28436 · Substantial damage NTSB SEA70D0100Accident · No injuriesClosedCessna 150 · Waterville, WASep 5, 1969 · N60886 · Substantial damage NTSB SEA70D0083Accident · No injuriesClosedCessna 150H · Colfax, WASep 1, 1969 · N6585S · Substantial damage NTSB SEA70F0122Accident · No injuriesClosedAlon A-2 · Vancouver, WAAug 31, 1969 · N5632F · Substantial damage NTSB SEA70F0075Accident · No injuriesClosedPiper PA-28 · Lester, WAAug 30, 1969 · N2839R · Substantial damage NTSB SEA70F0054Accident · No injuriesClosedCessna 140 · Everett, WAAug 30, 1969 · N89183 · Substantial damage NTSB SEA70F0070Accident · Minor injuriesClosedStinson 10A · Oroville, WAAug 24, 1969 · CF-WCJ · Substantial damage NTSB SEA70F0089Accident · Minor injuriesClosedBullock Curtis · Spokane, WAAug 23, 1969 · N5704N · Substantial damage NTSB SEA70D0086Accident · No injuriesClosedCessna 150 · Tacoma, WAAug 21, 1969 · N6533F · Substantial damage NTSB SEA70D0084Accident · Minor injuriesClosedCallair A-3 · Goldendale, WAAug 18, 1969 · N2911V · Substantial damage NTSB SEA70D0040Accident · No injuriesClosedTaylorcraft BC-65 · Colville, WAAug 17, 1969 · N21223 · Substantial damage NTSB SEA70D0098Accident · No injuriesClosedCessna 170B · Monroe, WAAug 16, 1969 · N4463B · Substantial damage NTSB SEA70D0067Accident · No injuriesClosedCessna 172 · Electric Cty, WAAug 14, 1969 · N5741A · Substantial damage NTSB SEA70D0096Accident · Minor injuriesClosedCessna 150 · Sultan, WAAug 11, 1969 · N3052S · Destroyed NTSB SEA70D0064Accident · No injuriesClosedPiper PA-25 · Othello, WAAug 10, 1969 · N4359Y · Substantial damage NTSB SEA70F0077Accident · Serious injuriesClosedPuss Moth 80A · Tekoa, WAAug 3, 1969 · N223EC · Substantial damage NTSB SEA70D0053Accident · No injuriesClosedHughes 269B · Castle Mt, WAJul 28, 1969 · N9432F · Substantial damage NTSB SEA70D0095Accident · No injuriesClosedBoeing A75N1 · Granger, WAJul 26, 1969 · N53098 · Substantial damage NTSB SEA70F0050Accident · No injuriesClosedBeech A35 · Seattle, WAJul 22, 1969 · N3940 · Substantial damage NTSB SEA70D0035Accident · No injuriesClosedGrumman G-164 · Walla Walla, WAJul 18, 1969 · N747Y · Substantial damage NTSB SEA70A0002Accident · 2 fatalClosedGlobe GC-1B · Winlock, WAJul 10, 1969 · N78155 · Destroyed NTSB SEA70D0025Accident · No injuriesClosedErco 415-C · Puyallup, WAJul 5, 1969 · N2741H · Substantial damage