Skip to content

NTSB investigations, 1978, 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 SEA83FA064Accident · 2 fatalClosedPiper PA-28 · North Bend, WADec 23, 1978 · N95172 · Destroyed NTSB SEA79DYE08Accident · Minor injuriesClosedAmer Avco AA1-C · Everett, WADec 6, 1978 · N9711U · Substantial damage NTSB SEA79FYE07Accident · Minor injuriesClosedCessna 150 · Issaquah, WADec 3, 1978 · N12MM · Destroyed NTSB SEA79DYP06Accident · No injuriesClosedCessna 180 · Connell, WADec 3, 1978 · N7616K · Substantial damage NTSB SEA79FYP04Accident · 1 fatalClosedCessna R172K · Dayton, WADec 1, 1978 · N736TH · Destroyed NTSB SEA79FYE06Accident · No injuriesClosedPiper PA-28 · Bremerton, WANov 24, 1978 · N8402C · Substantial damage NTSB SEA79FA013Accident · Minor injuriesClosedPiper PA-28 · Bellingham, WANov 16, 1978 · N47226 · Destroyed NTSB SEA79FYP03Accident · Serious injuriesClosedCessna 150A · Easton, WANov 15, 1978 · N7195X · Substantial damage NTSB SEA79DYE05Accident · No injuriesClosedCessna 172 · Orcas Island, WANov 13, 1978 · N734VX · Substantial damage NTSB SEA79DYE03Accident · No injuriesClosedEvans VP-1 · Yelm, WANov 12, 1978 · N6949 · Substantial damage NTSB SEA79FYE04Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WANov 10, 1978 · N4036Q · Substantial damage NTSB SEA79FA009Accident · 3 fatalClosedCessna P210 · Toutle, WANov 2, 1978 · N3686P · Destroyed NTSB SEA79FYE02Accident · Minor injuriesClosedCessna 150 · Port Townsend, WAOct 23, 1978 · N21913 · Substantial damage NTSB SEA79FA006Accident · 4 fatalClosedGrum Amer AA-5B · Roche Harbor, WAOct 21, 1978 · N28924 · Destroyed NTSB SEA79FA005Accident · 5 fatalClosedRolladn SCH LS-1-F · Ephrata, WAOct 21, 1978 · N61MP · 2 aircraft · Destroyed NTSB SEA79FA001Accident · 2 fatalClosedCessna 150H · Omak, WAOct 6, 1978 · N22421 · Destroyed NTSB SEA78DYE40Accident · No injuriesClosedCessna 172M · Eatonville, WASep 29, 1978 · N70405 · Substantial damage NTSB SEA78DYE39Accident · Minor injuriesClosedCessna 172 · Seattle, WASep 29, 1978 · N75561 · Substantial damage NTSB SEA78DYE38Accident · Minor injuriesClosedGR Lakes 2T-1A2 · Everett, WASep 26, 1978 · N3580L · Substantial damage NTSB SEA78DYE37Accident · Minor injuriesClosedHiller Acft UH-12E · Amanda Park, WASep 25, 1978 · N94519 · Destroyed NTSB SEA78FYE36Accident · No injuriesClosedStinson 108-3 · Neah Bay, WASep 18, 1978 · N4100C · Destroyed NTSB SEA78DYP51Accident · Minor injuriesClosedBellanca 7GCBC · Palouse, WASep 15, 1978 · N68508 · Destroyed NTSB SEA78DYP52Accident · No injuriesClosedHiller Acft UH-12E · Moses Lake, WASep 9, 1978 · N48121 · Substantial damage NTSB SEA78FA061Accident · 2 fatalClosedPiper J3 · Lynden, WASep 4, 1978 · N6391H · Destroyed NTSB SEA78DYP53Accident · No injuriesClosedCessna 172 · Ephrata, WASep 2, 1978 · N7409X · Substantial damage NTSB SEA78FYP50Accident · Minor injuriesClosedCessna T210M · Spokane, WASep 1, 1978 · N761CM · Substantial damage NTSB SEA78FYM49Accident · Serious injuriesClosedLake LA-4 · Goldendale, WAAug 27, 1978 · N1061L · Destroyed NTSB SEA78FA059Accident · Minor injuriesClosedBeech B99 · Pullman, WAAug 24, 1978 · N8012R · Substantial damage NTSB SEA78FYE34Accident · Minor injuriesClosedCessna 210 · Bainbridge Isl, WAAug 18, 1978 · N3810P · Destroyed NTSB SEA78DYE33Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WAAug 14, 1978 · N8845N · Substantial damage NTSB SEA78DYE35Accident · No injuriesClosedLet-Np-K L-13 · Issaquah, WAAug 13, 1978 · N9244Z · Substantial damage NTSB SEA78FA053Accident · 1 fatalClosedStinson 108E · Enumclaw, WAAug 10, 1978 · N4122C · Destroyed NTSB SEA78FYP48Accident · No injuriesClosedWeatherly 201C · Wilbur, WAAug 9, 1978 · N9197W · Destroyed NTSB SEA78FA052Accident · No injuriesClosedBell 47G3B1 · Snoqualmie Fls, WAAug 7, 1978 · N1182W · Destroyed NTSB SEA78DYP46Accident · No injuriesClosedCessna 188 · Connell, WAAug 7, 1978 · N91498 · Substantial damage NTSB SEA78FA051Accident · 1 fatalClosedCessna 337F · Ocean Shores, WAAug 3, 1978 · N1843M · Substantial damage NTSB SEA78FA050Accident · 1 fatalClosedCessna 150F · Lynden, WAJul 30, 1978 · N6735F · Destroyed NTSB SEA78DYP43Accident · No injuriesClosedGrumman G-164B · Ellensburg, WAJul 29, 1978 · N48432 · Substantial damage NTSB UNK78X0129Accident · 1 fatalClosedEnstrom 280C · Lester, WAJul 28, 1978 · N530H · Destroyed NTSB SEA78DYP42Accident · No injuriesClosedCessna 172 · Chewelah, WAJul 28, 1978 · N84679 · Substantial damage NTSB SEA78DYE31Accident · No injuriesClosedNa Rockwell 112TCA · Aberdeen, WAJul 26, 1978 · N112R · Destroyed NTSB SEA78DYE32Accident · No injuriesClosedCessna 185 · Oak Harbor, WAJul 23, 1978 · N94237 · Substantial damage NTSB SEA78FYP41Accident · No injuriesClosedCessna 170B · Spokane, WAJul 22, 1978 · N1695D · Substantial damage NTSB SEA78DYP44Accident · No injuriesClosedHiller Acft UH-12E · Mesa, WAJul 21, 1978 · N99575 · Substantial damage NTSB SEA78DYE29Accident · Minor injuriesClosedHughes 269B · Snoqualamie, WAJul 15, 1978 · N9449F · Substantial damage NTSB SEA78FA045Accident · 1 fatalClosedHiller FH1100 · Clearlake, WAJul 14, 1978 · N99024 · Destroyed NTSB SEA78FA044Accident · 1 fatalClosedBeech B24R · Vashon, WAJul 11, 1978 · N6591R · Destroyed NTSB SEA78FA043Accident · Minor injuriesClosedCessna 207 · Olga, WAJul 11, 1978 · N91041 · Destroyed NTSB SEA78DYP39Accident · No injuriesClosedPiper PA-18 · Withrow, WAJul 11, 1978 · N7369D · Substantial damage NTSB SEA78DYM43Accident · No injuriesClosedCessna 150 · Vancouver, WAJul 9, 1978 · N9256U · Substantial damage