Skip to content

NTSB investigations, 1976, WA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 SEA77FA011Accident · 1 fatalClosedBeech V35B · Auburn, WADec 31, 1976 · N84BB · Destroyed NTSB SEA77DYE06Accident · No injuriesClosedPiper PA-34 · Verlot, WADec 27, 1976 · N33589 · Destroyed NTSB SEA77FYC11Accident · No injuriesClosedCessna 310B · Orchards, WADec 19, 1976 · N5455A · Substantial damage NTSB SEA77FA010Accident · Serious injuriesClosedCessna TU206C · Battle Ground, WADec 17, 1976 · N21NW · Destroyed NTSB SEA77FA009Accident · No injuriesClosedHiller Acft FH1100 · Renton, WADec 17, 1976 · N8678 · Substantial damage NTSB SEA77FYP14Accident · No injuriesClosedCessna 172K · Mead, WADec 11, 1976 · N7089G · Substantial damage NTSB SEA77FYP12Accident · No injuriesClosedAmer Avco AA-1 · Spokane, WADec 9, 1976 · N5799L · Substantial damage NTSB SEA77DYP13Accident · Minor injuriesClosedCessna 150E · Spangle, WADec 8, 1976 · N6286T · Substantial damage NTSB SEA77DYE04Accident · Minor injuriesClosedHiller Acft UH-12E · Neilton, WADec 1, 1976 · N93479 · Destroyed NTSB SEA77DYE05Accident · Minor injuriesClosedSchweizer SGS126 · Issaquah, WANov 28, 1976 · N65952 · Substantial damage NTSB SEA77DYG10Accident · No injuriesClosedWaco UPF-7 · Spokane, WANov 20, 1976 · N29926 · Substantial damage NTSB SEA77FYG11Accident · Serious injuriesClosedHiller Acft UH-12E · Ephrata, WANov 19, 1976 · N5380V · Destroyed NTSB SEA77FYG09Accident · Serious injuriesClosedNaval Fcty N3N-3 · College Place, WANov 16, 1976 · N44707 · Substantial damage NTSB SEA77FYG08Accident · No injuriesClosedMooney M20F · Palouse, WANov 11, 1976 · N9379M · Substantial damage NTSB SEA77DYE03Accident · No injuriesClosedCessna 170 · Spanaway, WANov 6, 1976 · N2620V · Substantial damage NTSB SEA77FYE01Accident · No injuriesClosedCessna 172 · Lummi Island, WANov 5, 1976 · N84647 · Substantial damage NTSB SEA77DYG06Accident · No injuriesClosedPiper PA-28 · Richland, WAOct 29, 1976 · N32735 · Substantial damage NTSB SEA77DYG07Accident · No injuriesClosedTaylorcraft BL-12 · Wilson Creek, WAOct 26, 1976 · N29875 · Substantial damage NTSB SEA77DYG02Accident · No injuriesClosedCessna 185F · Yakima, WAOct 17, 1976 · N1453F · Substantial damage NTSB SEA77DA001Accident · 1 fatalClosedAeronca 11AC · Medical Lake, WAOct 8, 1976 · N9053E · Destroyed NTSB SEA77DYE02Accident · Minor injuriesClosedHiller Acft UH-12E · Brinnon, WAOct 4, 1976 · N2HL · Substantial damage NTSB SEA77FYG05Accident · No injuriesClosedBeech C35 · Colville, WASep 28, 1976 · N8SU · Destroyed NTSB SEA77DYE64Accident · No injuriesClosedCessna 150M · Lynden, WASep 26, 1976 · C-FOOB · Substantial damage NTSB SEA76AS079Accident · 4 fatalClosedPiper PA-34 · Kent, WASep 25, 1976 · N15867 · Destroyed NTSB SEA76FYE63Accident · Serious injuriesClosedBellanca 17-31 · Bremerton, WASep 21, 1976 · N7387V · Substantial damage NTSB SEA76FYC70Accident · No injuriesClosedHiller Acft UH-12D · Carson, WASep 20, 1976 · N62245 · Substantial damage NTSB SEA76FYE61Accident · Serious injuriesClosedKasper Bekan · Issaquah, WASep 19, 1976 · N1853 · Destroyed NTSB SEA76DYE62Accident · No injuriesClosedSchweizer SGS233 · Monroe, WASep 18, 1976 · N5728S · Substantial damage NTSB SEA76FYE59Accident · Minor injuriesClosedBeech A35 · Port Townsend, WASep 15, 1976 · N670D · Substantial damage NTSB SEA76DYG74Accident · No injuriesClosedBell 47G-3B · Cashmere, WASep 15, 1976 · N6712D · Substantial damage NTSB SEA77DYG03Accident · No injuriesClosedCessna 172M · Benge, WASep 9, 1976 · N12772 · Substantial damage NTSB SEA76DYE65Accident · Serious injuriesClosedHiller Acft UH-12E · Humptulips, WASep 7, 1976 · N48001 · Substantial damage NTSB SEA76AS074Accident · 5 fatalClosedCessna TU206F · Spokane, WAAug 31, 1976 · N92JD · Destroyed NTSB SEA76DYE58Accident · No injuriesClosedCessna 175 · Oak Harbor, WAAug 30, 1976 · N7468M · Substantial damage NTSB SEA76A5071Accident · 1 fatalClosedAero Comdr 680FP · Fall City, WAAug 27, 1976 · N680FP · Destroyed NTSB SEA76DYE55Accident · No injuriesClosedBeech B35 · Olympia, WAAug 26, 1976 · N5206C · Substantial damage NTSB SEA76AS061Accident · 1 fatalClosedPiper PA-28 · No.Bonneville, WAAug 24, 1976 · N9154J · Destroyed NTSB SEA76DYG72Accident · No injuriesClosedCessna 205 · Metaline Falls, WAAug 21, 1976 · N8204Z · Substantial damage NTSB SEA76DYE54Accident · Minor injuriesClosedCessna 177 · Eliza Island, WAAug 21, 1976 · N29426 · Substantial damage NTSB SEA76FYE60Accident · No injuriesClosedGrum Amer AA5 · Allyn, WAAug 14, 1976 · N6958L · Substantial damage NTSB SEA76DYE53Accident · No injuriesClosedBeech 23 · Blakely Island, WAAug 11, 1976 · N2389J · Substantial damage NTSB SEA76DYC66Accident · No injuriesClosedBell 47G3B2 · Vancouver, WAAug 11, 1976 · N7092J · Destroyed NTSB SEA76AS070Accident · 4 fatalClosedCessna 172N · Enumclaw, WAAug 11, 1976 · N20083 · Destroyed NTSB SEA76DYG73Accident · Minor injuriesClosedHiller Acft UH-12E · Kennewick, WAAug 10, 1976 · N7411N · Substantial damage NTSB SEA76AS068Accident · 1 fatalClosedNavion A · Snoqulmie Pass, WAAug 4, 1976 · N313L · Destroyed NTSB SEA76DYG68Accident · No injuriesClosedAero Comdr 600S2R · Othello, WAAug 2, 1976 · N4966X · Substantial damage NTSB SEA77DYE56Accident · No injuriesClosedCessna 150 · Eastsound, WAAug 1, 1976 · N60194 · Destroyed NTSB SEA76FYE50Accident · Minor injuriesClosedCessna 150 · Bellevue, WAJul 31, 1976 · N6837G · Destroyed NTSB SEA76DYE51Accident · No injuriesClosedCessna 172L · Raymond, WAJul 30, 1976 · N19768 · Substantial damage NTSB SEA76DYE49Accident · No injuriesClosedCessna 170A · Toledo, WAJul 24, 1976 · N9702A · Substantial damage