Skip to content

NTSB investigations, 1978, OR

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 SEA79DYK04Accident · No injuriesClosedCessna 152 · Burns, ORDec 28, 1978 · N45989 · Substantial damage NTSB DCA79AA005Accident · 10 fatalClosedDouglas DC-8 · Portland, ORDec 28, 1978 · N8082U · Destroyed NTSB SEA79FYM08Accident · No injuriesClosedHiller Acft Soloy · Lacomb, ORDec 22, 1978 · N172ET · Substantial damage NTSB SEA79DYM09Accident · No injuriesClosedHiller Acft Soloy · Toledo, ORDec 15, 1978 · N147HA · Substantial damage NTSB SEA79FYM07Accident · Serious injuriesClosedCessna 414 · Baker, ORDec 11, 1978 · N41075 · Substantial damage NTSB SEA79FA017Accident · 1 fatalClosedCessna 150K · Astoria, ORDec 10, 1978 · N8339M · Destroyed NTSB SEA79FA016Accident · 1 fatalClosedPiper PA-14 · Eugene, ORDec 1, 1978 · N5013W · Destroyed NTSB SEA79FA014Accident · 2 fatalClosedBellanca 17-30 · Medford, ORNov 19, 1978 · N7320V · Destroyed NTSB SEA79FYK03Accident · Serious injuriesClosedCessna 210 · Triangle Lake, ORNov 13, 1978 · N5733J · Substantial damage NTSB SEA79FYM06Accident · No injuriesClosedHiller Acft UH-12E · Salem, ORNov 9, 1978 · N6ZH · Substantial damage NTSB SEA79FA012Accident · 1 fatalClosedCessna 177B · Kimberly, ORNov 9, 1978 · N11606 · Destroyed NTSB SEA79FA011Accident · 3 fatalClosedCessna 185 · Joseph, ORNov 5, 1978 · N80169 · Destroyed NTSB SEA79DYM04Accident · No injuriesClosedSoloy UH12E · Molalla, ORNov 2, 1978 · N5381V · Substantial damage NTSB SEA79DYM05Accident · No injuriesClosedCessna 172 · Portland, ORNov 1, 1978 · N737BZ · Substantial damage NTSB SEA79FA010Accident · 3 fatalClosedPiper PA-20 · Joseph, OROct 28, 1978 · N2411A · Destroyed NTSB SEA79DYK02Accident · Minor injuriesClosedCessna 182P · Silver Lake, OROct 25, 1978 · N9942E · Substantial damage NTSB SEA79FYA04Accident · Serious injuriesClosedCessna 182A · Jamieson, OROct 22, 1978 · N6034B · Substantial damage NTSB SEA79DYM03Accident · No injuriesClosedCessna 180 · Sumpter, OROct 22, 1978 · N6571A · Substantial damage NTSB SEA79FYM02Accident · No injuriesClosedGrum Amer AA5-A · Hillsboro, OROct 21, 1978 · N9721U · Substantial damage NTSB SEA79DYK01Accident · Serious injuriesClosedPiper PA-28 · Sun River, OROct 8, 1978 · N98054 · Substantial damage NTSB SEA79FYM01Accident · No injuriesClosedHiller Acft UH-12E · Falls City, OROct 2, 1978 · N90476 · Substantial damage NTSB SEA78FYM53Accident · No injuriesClosedBellanca 7ECA · Hillsboro, ORSep 30, 1978 · N4183Y · Substantial damage NTSB SEA78FYM52Accident · Minor injuriesClosedPiper PA-28 · Hillsboro, ORSep 30, 1978 · N5795F · Substantial damage NTSB SEA78DYK25Accident · Minor injuriesClosedPiper PA-31 · Sun River, ORSep 30, 1978 · N27279 · Substantial damage NTSB SEA78FYK24Accident · 1 fatalClosedCallair B-1A · Glide, ORSep 20, 1978 · N7269V · Substantial damage NTSB SEA78FYM51Accident · Minor injuriesClosedCessna 182 · Oregon City, ORSep 18, 1978 · N4854D · Substantial damage NTSB SEA78FYK23Accident · Minor injuriesClosedHome Built KR-2 · North Bend, ORSep 14, 1978 · N57JC · Substantial damage NTSB SEA78FA065Accident · 1 fatalClosedPiper PA-28 · Rainier, ORSep 14, 1978 · N5877U · Destroyed NTSB SEA78DYK22Accident · No injuriesClosedPiper PA-28 · Sun River, ORSep 12, 1978 · N43990 · Substantial damage NTSB SEA78FYK21Accident · No injuriesClosedCessna 182B · Azalea, ORSep 9, 1978 · N2465G · Substantial damage NTSB SEA78FA063Accident · 4 fatalClosedPiper PA-28 · Sisters, ORSep 7, 1978 · N39499 · Destroyed NTSB SEA78FYM50Accident · 1 fatalClosedMini Coupe Buffum · Independence, ORAug 30, 1978 · N75MB · Destroyed NTSB SEA78FA058Accident · 2 fatalClosedBeech C35 · Redmond, ORAug 19, 1978 · N668D · Destroyed NTSB SEA78FA056Accident · 2 fatalClosedCessna 172XP · Eugene, ORAug 15, 1978 · N736XU · Destroyed NTSB SEA79FYM48Accident · Serious injuriesClosedHughes 369D · Cascadia, ORAug 14, 1978 · N8600F · Destroyed NTSB SEA78FA055Accident · 3 fatalClosedAero Comdr 100 · Bly, ORAug 11, 1978 · N4179X · Destroyed NTSB SEA78FYM47Accident · Serious injuriesClosedCessna 180H · Enterprise, ORAug 5, 1978 · N3475Y · Substantial damage NTSB SEA78FYM46Accident · No injuriesClosedCessna R182 · Troutdale, ORAug 3, 1978 · N4105C · Substantial damage NTSB SEA78DYA18Accident · No injuriesClosedHiller Acft UH-12E · Adrian, ORJul 20, 1978 · N67696 · Destroyed NTSB SEA78DYK20Accident · No injuriesClosedBeech 35 · Crescent Lake, ORJul 15, 1978 · N3943N · Substantial damage NTSB SEA78FYM45Accident · No injuriesClosedStinson 108-3 · The Dalles, ORJul 9, 1978 · N4050C · Substantial damage NTSB SEA78DYM44Accident · Serious injuriesClosedMaule M5220C · Enterprise, ORJul 8, 1978 · N62014 · Substantial damage NTSB SEA78FYM42Accident · Serious injuriesClosedBellanca 17-30 · Toledo, ORJul 6, 1978 · N8814V · Substantial damage NTSB SEA78DYK19Accident · No injuriesClosedCessna 170 · Bandon, ORJul 2, 1978 · N4135V · Substantial damage NTSB SEA78FYM41Accident · Serious injuriesClosedPiper PA-22 · Grand Ronde, ORJun 29, 1978 · N5941D · Substantial damage NTSB SEA78DYM37Accident · No injuriesClosedCessna 188A · Enterprise, ORJun 28, 1978 · N5633J · Substantial damage NTSB SEA78FA039Accident · 4 fatalClosedPiper PA-28R · Baker, ORJun 24, 1978 · N40048 · Destroyed NTSB SEA78FA038Accident · 1 fatalClosedNavion A · Ashland, ORJun 23, 1978 · N91504 · Destroyed NTSB SEA78FYM40Accident · Serious injuriesClosedPiper PA-36 · Carlton, ORJun 21, 1978 · N41324 · Destroyed NTSB SEA78FYM38Accident · No injuriesClosedPiper PA-22 · Newberg, ORJun 17, 1978 · N3651P · Substantial damage