Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 SEA78FA016Accident · 1 fatalClosedPiper PA-34 · Wenatchee, WADec 30, 1977 · N7089C · Destroyed NTSB SEA78FA013Accident · 1 fatalClosedCessna 152 · Quincy, WADec 16, 1977 · N757TC · Destroyed NTSB SEA78DYP06Accident · No injuriesClosedCessna 172 · Pasco, WADec 15, 1977 · N9021H · Substantial damage NTSB SEA78FYE04Accident · No injuriesClosedCessna 185F · Seattle, WADec 6, 1977 · N1022F · Substantial damage NTSB SEA78FYP05Accident · 1 fatalClosedBeech A35 · W.Richland, WADec 4, 1977 · N8687A · Substantial damage NTSB SEA78FA018Accident · 1 fatalClosedCessna 320E · Steptoe, WADec 1, 1977 · N3431Q · Destroyed NTSB SEA78FYE03Accident · No injuriesClosedPiper PA-18 · Bellevue, WANov 26, 1977 · N2LB · Substantial damage NTSB SEA78IA009Incident · No injuriesClosedBoeing 727 · Seattle, WANov 17, 1977 · N316AS · Minor damage NTSB SEA78FYM10Accident · Serious injuriesClosedCessna T337B · Vancouver, WANov 14, 1977 · N2351S · Destroyed NTSB SEA78FA008Accident · 4 fatalClosedCessna 172M · Newport, WANov 13, 1977 · C-GSKO · Destroyed NTSB SEA78FYE02Accident · Minor injuriesClosedHughes 369C · Morton, WANov 10, 1977 · N9174F · Destroyed NTSB SEA78FYE01Accident · Serious injuriesClosedAerosport Quail · Spanaway, WANov 3, 1977 · N9229Z · Substantial damage NTSB SEA78DYP04Accident · No injuriesClosedCessna 172D · Sunnyside, WANov 1, 1977 · N2388U · Substantial damage NTSB SEA77FA004Accident · 4 fatalClosedN.American Navion · Yakima, WAOct 23, 1977 · N91580 · Destroyed NTSB SEA78DYP03Accident · No injuriesClosedHughes 369D · Spokane, WAOct 12, 1977 · N8601F · Substantial damage NTSB SEA78DYP02Accident · No injuriesClosedCons-Vultee L-13 · Wenatchee, WAOct 11, 1977 · N4659V · Substantial damage NTSB SEA78FA003Accident · 3 fatalClosedPiper PA-31P · Vancouver, WAOct 8, 1977 · N117HC · Destroyed NTSB SEA78FA001Accident · 7 fatalClosedDehavilland DHC-2 · Stevens Pass, WAOct 1, 1977 · N64391 · Destroyed NTSB SEA78DYP01Accident · No injuriesClosedCessna 206 · Priest Rpd Dam, WAOct 1, 1977 · N72160 · Substantial damage NTSB SEA77FA055Accident · 2 fatalClosedPiper PA-28 · Reardan, WASep 30, 1977 · N8342W · Destroyed NTSB SEA77FYE36Accident · Serious injuriesClosedCessna 180 · Auburn, WASep 24, 1977 · N4581B · Substantial damage NTSB SEA77FYP45Accident · Minor injuriesClosedPiper PA-25 · Pasco, WASep 21, 1977 · N4566Y · Destroyed NTSB SEA77FA053Accident · 1 fatalClosedCessna 150L · Clarkston, WASep 17, 1977 · N6578G · Destroyed NTSB SEA77DYP47Accident · Minor injuriesClosedAero Comdr S2R · Touchet, WASep 17, 1977 · N5045X · Destroyed NTSB SEA77FA052Accident · 3 fatalClosedCessna 172K · Skykomish, WASep 16, 1977 · N78597 · Destroyed NTSB SEA77FA051Accident · 2 fatalClosedCessna 182L · Bellevue, WASep 9, 1977 · N3466R · Destroyed NTSB SEA77DYP46Accident · No injuriesClosedCessna 182 · Walla Walla, WASep 8, 1977 · N5141D · Substantial damage NTSB SEA77FYP43Accident · Serious injuriesClosedPiper PA-28R · Cle Elum, WASep 5, 1977 · N5303T · Substantial damage NTSB SEA77FA050Accident · 1 fatalClosedGrum Amer AA1C · Othello, WASep 4, 1977 · N9558U · Destroyed NTSB SEA77DYP42Accident · No injuriesClosedCessna 170B · Connell, WAAug 29, 1977 · N2731D · Substantial damage NTSB SEA77FYE34Accident · Serious injuriesClosedAnderson Kgfshr · Lakewood Ctr, WAAug 28, 1977 · N8DE · Substantial damage NTSB SEA77DYE35Accident · No injuriesClosedCessna 172 · Ilwaco, WAAug 27, 1977 · N6931X · Substantial damage NTSB SEA77DYP41Accident · No injuriesClosedCessna 150M · Moses Lake, WAAug 26, 1977 · N66063 · Substantial damage NTSB SEA77FYM59Accident · 1 fatalClosedPitts MR1 · Vancouver, WAAug 21, 1977 · N30059 · Destroyed NTSB SEA77FA049Accident · 4 fatalClosedCessna 185 · Hansville, WAAug 21, 1977 · N1738R · Destroyed NTSB SEA77DYE33Accident · Serious injuriesClosedLambert 201 · Silverdale, WAAug 21, 1977 · CF-AAT · Substantial damage NTSB SEA77DYM58Accident · Minor injuriesClosedCessna 172K · Orchard, WAAug 19, 1977 · N79931 · Substantial damage NTSB SEA77DYP40Accident · No injuriesClosedGrumman G-164B · Quincy, WAAug 15, 1977 · N48423 · Substantial damage NTSB SEA77FYP38Accident · Serious injuriesClosedBushby Midg Mustng · Plain, WAAug 13, 1977 · N73T · Substantial damage NTSB SEA77FYP39Accident · Serious injuriesClosedNaval Fcty N3N-3 · Prescott, WAAug 11, 1977 · N45261 · Destroyed NTSB SEA77DYP36Accident · No injuriesClosedCessna 150H · Nespelem, WAAug 6, 1977 · N8863R · Substantial damage NTSB SEA77DYE31Accident · No injuriesClosedPiper PA-28 · Bellevue, WAAug 5, 1977 · N9155W · Substantial damage NTSB SEA77DYP35Accident · No injuriesClosedCessna 188 · Connell, WAAug 3, 1977 · N72414 · Substantial damage NTSB SEA77FYP34Accident · Serious injuriesClosedPiper PA-28 · Mattawa, WAAug 1, 1977 · N9507J · Substantial damage NTSB SEA77DYP26Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 28, 1977 · N8850L · Substantial damage NTSB SEA77DYP33Accident · No injuriesClosedAero Comdr 600S2R · Othello, WAJul 27, 1977 · N1500R · Substantial damage NTSB SEA77FA042Accident · 1 fatalClosedKr-2 · Arlington, WAJul 24, 1977 · N43TS · Destroyed NTSB SEA77DYK20Accident · No injuriesClosedEnstrom F28C · Medford, WAJul 22, 1977 · N51727 · Substantial damage NTSB SEA77FYE29Accident · 1 fatalClosedTaylor B8M · Shelton, WAJul 19, 1977 · N65360 · Destroyed NTSB SEA77DYE30Accident · Minor injuriesClosedWulle VP2 · Ferndale, WAJul 18, 1977 · N5596 · Destroyed