Skip to content

NTSB investigations, 1977, OR

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

19622026

NTSB investigations, 1977, OR per year, 1962–2026: 3,390 cases
1962	1
1964	74
1965	88
1966	121
1967	121
1968	84
1969	80
1970	68
1971	77
1972	75
1973	84
1974	71
1975	77
1976	81
1977	95
1978	88
1979	90
1980	76
1981	75
1982	82
1983	65
1984	70
1985	56
1986	51
1987	40
1988	41
1989	45
1990	49
1991	51
1992	48
1993	39
1994	46
1995	56
1996	60
1997	56
1998	40
1999	43
2000	56
2001	47
2002	39
2003	48
2004	40
2005	54
2006	38
2007	47
2008	40
2009	31
2010	40
2011	31
2012	35
2013	31
2014	18
2015	29
2016	23
2017	27
2018	31
2019	42
2020	23
2021	36
2022	24
2023	23
2024	30
2025	20
2026	23

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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 SEA78DYM13Accident · No injuriesClosedPiper PA-28R · Aurora, ORDec 26, 1977 · N4936J · 2 aircraft · Minor damage NTSB SEA78DYK05Accident · No injuriesClosedPiper PA-28 · Agness, ORDec 23, 1977 · N56759 · Substantial damage NTSB SEA78FA014Accident · 7 fatalClosedAero Cmdr 520 · Cheshire, ORDec 22, 1977 · C-GHUN · Destroyed NTSB SEA78DYK04Accident · Minor injuriesClosedHiller Acft FH1100 · Walton, ORDec 22, 1977 · N92484 · Destroyed NTSB SEA78FYM12Accident · Minor injuriesClosedBeech A23 · Newberg, ORDec 21, 1977 · N14311 · Substantial damage NTSB SEA78DYM11Accident · No injuriesClosedCessna 152 · Dayton, ORDec 18, 1977 · N757JM · Substantial damage NTSB SEA78DYK03Accident · Serious injuriesClosedHiller Acft UH12E · Port Orford, ORDec 7, 1977 · N116HA · Destroyed NTSB SEA78DYK02Accident · No injuriesClosedCessna T210 · Redmond, ORNov 23, 1977 · N94001 · Substantial damage NTSB SEA78FYM09Accident · No injuriesClosedCessna 210E · Boardman, ORNov 11, 1977 · N4956U · Substantial damage NTSB SEA78FYM08Accident · Serious injuriesClosedCessna 172M · Forest Grove, ORNov 11, 1977 · N64084 · Destroyed NTSB SEA78FYM07Accident · Minor injuriesClosedHiller Acft UH-12E · Amity, ORNov 7, 1977 · N6ZH · Destroyed NTSB SEA78FA007Accident · 1 fatalClosedPiper PA-28 · Gales Creek, ORNov 4, 1977 · N2710Q · Destroyed NTSB SEA78FYM06Accident · Serious injuriesClosedHiller Acft UH-12E · Depoe Bay, ORNov 3, 1977 · N9786C · Substantial damage NTSB SEA78FA005Accident · 2 fatalClosedPiper PA-32 · Troutdale, OROct 26, 1977 · N1230W · Destroyed NTSB SEA78DYM05Accident · No injuriesClosedCessna TU206 · Gates, OROct 22, 1977 · N5458Q · Substantial damage NTSB SEA78DYK01Accident · No injuriesClosedPiper PA-32R · Klamath Falls, OROct 22, 1977 · N812PC · Substantial damage NTSB SEA78FYM04Accident · Minor injuriesClosedErco 415-C · Scappoose, OROct 5, 1977 · N2645H · Substantial damage NTSB SEA78FYM03Accident · No injuriesClosedEnstrom 280C · Aloha, OROct 5, 1977 · N111EE · Substantial damage NTSB SEA78FA006Accident · 2 fatalClosedCessna 182J · Umpqua, OROct 5, 1977 · N3383F · Destroyed NTSB SEA78FYM02Accident · Minor injuriesClosedBell 47G3B1 · Alsea, OROct 2, 1977 · N1199W · Substantial damage NTSB SEA77FA056Accident · 1 fatalClosedCessna 206 · Cove, ORSep 28, 1977 · N35904 · Destroyed NTSB SEA77DYK24Accident · Minor injuriesClosedCessna 150 · Ashland, ORSep 23, 1977 · N2646J · Substantial damage NTSB SEA77FA054Accident · 1 fatalClosedCessna 180 · Ashland, ORSep 21, 1977 · N9999N · Destroyed NTSB SEA77DYK23Accident · No injuriesClosedBeech C45H · Medford, ORSep 11, 1977 · N600UW · Substantial damage NTSB SEA77DYM62Accident · Minor injuriesClosedPiper PA-22 · The Dalles, ORSep 6, 1977 · N4841A · Substantial damage NTSB SEA77DYK22Accident · No injuriesClosedCessna 150L · Tenmile, ORAug 31, 1977 · N17067 · Substantial damage NTSB SEA77DYM61Accident · No injuriesClosedBellanca 8GCBC · Baker, ORAug 27, 1977 · N86714 · Substantial damage NTSB SEA77FA048Accident · 3 fatalClosedCessna 195A · Elgin, ORAug 18, 1977 · N4304V · Destroyed NTSB SEA77DYM57Accident · No injuriesClosedBeech C-18S · Sheridan, ORAug 14, 1977 · N4758N · Substantial damage NTSB SEA77DYK21Accident · No injuriesClosedPiper PA-28 · Riley, ORAug 13, 1977 · N7078W · Substantial damage NTSB SEA77FA047Accident · 1 fatalClosedAerostar 601P · Burns, ORAug 12, 1977 · N9578Q · Destroyed NTSB SEA77DA046Accident · Minor injuriesClosedCessna 210L · Klamath Falls, ORAug 3, 1977 · N92PF · Substantial damage NTSB SEA77DYM60Accident · No injuriesClosedBeech B35 · Dallas, ORJul 31, 1977 · N5066C · Substantial damage NTSB SEA77DYM55Accident · Minor injuriesClosedLuscombe 8A · The Dalles, ORJul 30, 1977 · N2712K · Destroyed NTSB SEA77DYM54Accident · No injuriesClosedCessna 320E · Yamhill, ORJul 30, 1977 · N3492Q · Substantial damage NTSB SEA77DYM56Accident · No injuriesClosedCessna 182 · John Day, ORJul 28, 1977 · N6176B · Substantial damage NTSB SEA77DYM50Accident · No injuriesClosedCessna 140 · Rufus, ORJul 28, 1977 · N89388 · Destroyed NTSB SEA77FYM49Accident · No injuriesClosedPiper PA-24 · Silverton, ORJul 25, 1977 · N5457P · Substantial damage NTSB SEA77FYM53Accident · No injuriesClosedSchweizer 2-33A · North Plains, ORJul 23, 1977 · N5759S · Substantial damage NTSB SEA77DYM48Accident · No injuriesClosedBuffum Mini Coupe · Willsonville, ORJul 23, 1977 · N75MB · Substantial damage NTSB SEA77DYM52Accident · No injuriesClosedHiller Acft UH-12C · Albany, ORJul 22, 1977 · N10321 · Substantial damage NTSB SEA77DYK19Accident · No injuriesClosedBlanik L-13 · Sisters, ORJul 22, 1977 · N90846 · Substantial damage NTSB SEA77DYM47Accident · No injuriesClosedPiper PA-28 · Wakonda Beach, ORJul 21, 1977 · N33346 · Substantial damage NTSB SEA77FYA31Accident · Serious injuriesClosedCallair A9B · Adrian, ORJul 19, 1977 · N7764V · Destroyed NTSB SEA77DYM45Accident · No injuriesClosedCessna 172 · Madras, ORJul 12, 1977 · N6414E · Substantial damage NTSB SEA77DYM51Accident · No injuriesClosedCessna 150 · Dallas, ORJul 11, 1977 · N22499 · Substantial damage NTSB SEA77DYA29Accident · No injuriesClosedCessna 188A · Ontario, ORJul 11, 1977 · N8088V · Destroyed NTSB SEA77DYK18Accident · Minor injuriesClosedM-Saulnier MS893E · Fields, ORJul 9, 1977 · N101GT · Substantial damage NTSB SEA77DYM46Accident · No injuriesClosedPiper PA-18 · Hermiston, ORJul 7, 1977 · N40523 · Substantial damage NTSB SEA77DYK17Accident · No injuriesClosedRyan ST-3KR · Ashland, ORJul 4, 1977 · N2860D · Substantial damage