Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 SEA80FYE10Accident · Minor injuriesClosedHughes 369D · Mt.Vernon, WADec 22, 1979 · N8303F · Substantial damage NTSB SEA80FA047Accident · 4 fatalClosedPiper PA-24 · White Pass, WADec 11, 1979 · N6171P · Destroyed NTSB SEA80FA013Accident · 1 fatalClosedCessna T210M · Pasco, WADec 8, 1979 · N732QJ · Destroyed NTSB SEA80FYE09Accident · Serious injuriesClosedCessna 152 · Freeland, WADec 1, 1979 · N48129 · Substantial damage NTSB SEA80FYP05Accident · Minor injuriesClosedCessna 150E · Moses Lake, WANov 26, 1979 · N4098U · Substantial damage NTSB SEA80FA008Accident · 2 fatalClosedNavion A · Kent, WANov 23, 1979 · N4804K · Destroyed NTSB SEA80FA007Accident · 2 fatalClosedCessna T210M · Yakima, WANov 21, 1979 · N321TT · Substantial damage NTSB SEA80IA006Incident · No injuriesClosedBeech 99 · Yakima, WANov 14, 1979 · N8012R · Minor damage NTSB SEA80DYE08Accident · Serious injuriesClosedPiper PA-18 · Lynnwood, WANov 13, 1979 · N4122E · Substantial damage NTSB SEA80DYP03Accident · No injuriesClosedBellanca 7KCAB · College Place, WANov 11, 1979 · N2680Z · Substantial damage NTSB SEA80FYE07Accident · Minor injuriesClosedMaule M-5 · Maple Valley, WANov 9, 1979 · N376X · Destroyed NTSB SEA80DYE06Accident · No injuriesClosedAero Comdr 112A · Vashon Island, WANov 7, 1979 · N1478J · Substantial damage NTSB SEA80DYE05Accident · No injuriesClosedHiller Acft UH-12E · Neah Bay, WAOct 31, 1979 · N87977 · Substantial damage NTSB SEA80DYE03Accident · No injuriesClosedHiller Acft UH-12D · Amanda Park, WAOct 29, 1979 · N62377 · Substantial damage NTSB SEA80DYE02Accident · No injuriesClosedPiper PA-28R · Roche Harbor, WAOct 28, 1979 · N816J · Substantial damage NTSB SEA80DYE04Accident · No injuriesClosedMooney M20C · Everett, WAOct 27, 1979 · N6961U · Substantial damage NTSB SEA80FA004Accident · 2 fatalClosedCessna 177RG · Ephrata, WAOct 18, 1979 · N34948 · Destroyed NTSB SEA80DYP02Accident · No injuriesClosedCessna 150 · Ritzville, WAOct 8, 1979 · N6649T · Substantial damage NTSB SEA80FA001Accident · 1 fatalClosedCessna 150F · Arlington, WAOct 7, 1979 · N3033X · Destroyed NTSB SEA80DYE01Accident · No injuriesClosedCessna 170B · Copalis Beach, WAOct 6, 1979 · N3160A · Substantial damage NTSB SEA79FYM70Accident · No injuriesClosedCessna 150 · Vancouver, WASep 30, 1979 · N60420 · Substantial damage NTSB SEA79DYP43Accident · No injuriesClosedCessna 150L · Yakima, WASep 30, 1979 · N11633 · Substantial damage NTSB SEA79FYM69Accident · Serious injuriesClosedMoots BD-4 · Battle Ground, WASep 27, 1979 · N17127 · Substantial damage NTSB SEA79DYE49Accident · No injuriesClosedCessna R172K · Bellingham, WASep 22, 1979 · N6417K · Substantial damage NTSB SEA79FYP42Accident · No injuriesClosedCessna P337 · Spokane, WASep 21, 1979 · N5JU · Substantial damage NTSB SEA79DYE44Accident · No injuriesClosedCessna 172 · Spanaway, WASep 18, 1979 · N73524 · Substantial damage NTSB SEA79DYM65Accident · No injuriesClosedEnstrom 280C · Vancouver, WASep 17, 1979 · N222NT · Substantial damage NTSB SEA79DYE46Accident · No injuriesClosedCessna 152 · Rochester, WASep 16, 1979 · N68267 · Substantial damage NTSB SEA79DYE45Accident · Minor injuriesClosedHughes 269B · Renton, WASep 15, 1979 · N9355K · Substantial damage NTSB SEA79DYE48Accident · Minor injuriesClosedGrum-Amer AA-5A · Friday Harbor, WASep 14, 1979 · N26832 · Destroyed NTSB SEA79DYE35Accident · No injuriesClosedPiper PA-28 · Lopez Island, WASep 8, 1979 · N75177 · Substantial damage NTSB SEA79FA057Accident · Serious injuriesClosedBeech D35 · Bellingham, WASep 7, 1979 · N249D · Substantial damage NTSB SEA79FA056Accident · Serious injuriesClosedHiller FH1100 · Arlington, WASep 6, 1979 · N377FH · Destroyed NTSB SEA79DYE42Accident · No injuriesClosedGreat Lakes Baby · Arlington, WAAug 31, 1979 · N8850 · Substantial damage NTSB SEA79FA055Accident · No injuriesClosedLear Jet 23 · Othello, WAAug 29, 1979 · N6GJ · Substantial damage NTSB SEA79FYE41Accident · No injuriesClosedCessna A185F · Renton, WAAug 28, 1979 · N9533H · Substantial damage NTSB SEA79FA052Accident · 5 fatalClosedPiper PA-32 · Maple Falls, WAAug 27, 1979 · CG-IMB · Destroyed NTSB SEA79DYE50Accident · Minor injuriesClosedDehavilland Moth · Martha Lake, WAAug 25, 1979 · N8722 · Substantial damage NTSB SEA79DYE47Accident · No injuriesClosedNavion A · Snohomish, WAAug 25, 1979 · N8750H · Substantial damage NTSB SEA79FA051Accident · Minor injuriesClosedMaule M-4 · Vancouver, WAAug 22, 1979 · N40332 · Substantial damage NTSB SEA79FYE43Accident · 1 fatalClosedZipper HH-1 · Everett, WAAug 15, 1979 · N2200Z · Destroyed NTSB SEA79FYP40Accident · No injuriesClosedCessna 172K · Deer Park, WAAug 13, 1979 · N46652 · Substantial damage NTSB SEA79DYE39Accident · Minor injuriesClosedBeech B24R · Burton, WAAug 11, 1979 · N4348W · Substantial damage NTSB SEA79FYE37Accident · No injuriesClosedBellanca 14-13 · Federal Way, WAAug 4, 1979 · N74353 · Destroyed NTSB SEA79FYE36Accident · No injuriesClosedCessna 180 · Auburn, WAAug 4, 1979 · N6014B · Substantial damage NTSB SEA79FYE38Accident · Serious injuriesClosedCessna 172N · Port Angeles, WAAug 3, 1979 · N733LC · Destroyed NTSB SEA79DYM56Accident · No injuriesClosedTailwind W-8 · Goldendale, WAAug 2, 1979 · N1416 · Substantial damage NTSB SEA79DYP39Accident · Minor injuriesClosedTaylorcraft DC-65 · Mead, WAJul 23, 1979 · N57833 · Substantial damage NTSB SEA79FYP37Accident · No injuriesClosedWaco YKS-6 · Pasco, WAJul 22, 1979 · N16512 · Substantial damage NTSB SEA79DYP38Accident · Minor injuriesClosedCessna 188B · Mattawa, WAJul 20, 1979 · N9845G · Substantial damage