Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 SEA80DYM11Accident · No injuriesClosedCessna 177RG · Hood River, ORDec 25, 1979 · N2185Q · Substantial damage NTSB SEA80DYM10Accident · No injuriesClosedAerospatle SA315B · Mill City, ORDec 17, 1979 · N55963 · Substantial damage NTSB SEA80FYM09Accident · Serious injuriesClosedCessna 150G · Aloha, ORDec 10, 1979 · N4825X · Substantial damage NTSB SEA80FYM07Accident · No injuriesClosedBeech 36 · Hillsboro, ORNov 30, 1979 · N7605N · Substantial damage NTSB SEA80FA009Accident · 2 fatalClosedMooney M20C · Grass Valley, ORNov 28, 1979 · N7090V · Destroyed NTSB SEA80FYM06Accident · Minor injuriesClosedCessna 152 · Newberg, ORNov 23, 1979 · N67500 · Substantial damage NTSB SEA80FA005Accident · 3 fatalClosedCessna T310R · Salem, ORNov 12, 1979 · N1316G · Destroyed NTSB SEA80FYM04Accident · No injuriesClosedBell 206A · Amity, ORNov 7, 1979 · N6212N · Substantial damage NTSB SEA80DYM02Accident · No injuriesClosedCessna TU206F · Elgin, ORNov 1, 1979 · N196BC · Substantial damage NTSB SEA80FYM01Accident · No injuriesClosedPiper PA-38 · Troutdale, OROct 24, 1979 · N2340D · Substantial damage NTSB SEA80DYK02Accident · No injuriesClosedCessna 310 · Brookings, OROct 20, 1979 · N4591L · Substantial damage NTSB SEA80DYK01Accident · No injuriesClosedCessna TU206 · Klamath Falls, OROct 12, 1979 · N1204Q · Substantial damage NTSB SEA79FYM67Accident · No injuriesClosedAeronca 7AC · Tigard, ORSep 23, 1979 · N1787E · Substantial damage NTSB SEA79FYM68Accident · No injuriesClosedCessna 172N · Clatskanie, ORSep 22, 1979 · N7335B · Substantial damage NTSB SEA79FYK32Accident · No injuriesClosedBeech P35 · Sunriver, ORSep 21, 1979 · N1752G · Substantial damage NTSB SEA79DYM66Accident · Minor injuriesClosedCessna 182P · Condon, ORSep 14, 1979 · N4677K · Substantial damage NTSB SEA79AA058Accident · 12 fatalClosedDouglas DC-7C · Klamath Falls, ORSep 14, 1979 · N4SW · Destroyed NTSB SEA79FYK31Accident · Minor injuriesClosedM.B.B. BO-209 · Grants Pass, ORSep 12, 1979 · N209AD · Substantial damage NTSB SEA79FYK29Accident · Minor injuriesClosedCessna 150F · Cottage Grove, ORSep 9, 1979 · N8937S · Substantial damage NTSB SEA79DYK30Accident · No injuriesClosedCessna 150 · Eugene, ORSep 8, 1979 · N7091F · Substantial damage NTSB SEA79FYK28Accident · No injuriesClosedCessna 152 · Creswell, ORSep 7, 1979 · N89487 · Substantial damage NTSB SEA79FA054Accident · 3 fatalClosedMooney M20C · Newberg, ORSep 1, 1979 · N9753M · Destroyed NTSB SEA79FA053Accident · 4 fatalClosedPiper PA-28 · Paisley, ORSep 1, 1979 · N2818N · Destroyed NTSB SEA79FYK27Accident · Serious injuriesClosedCessna 177RG · Redmond, ORAug 31, 1979 · N1882Q · Destroyed NTSB SEA79DYM63Accident · No injuriesClosedGrum-Amer AA-5B · Condon, ORAug 29, 1979 · N74472 · Substantial damage NTSB SEA79FYK24Accident · No injuriesClosedCessna A185F · Eugene, ORAug 25, 1979 · N93086 · Substantial damage NTSB SEA79DYM61Accident · No injuriesClosedCessna 305A · Sandy, ORAug 22, 1979 · N5305G · Substantial damage NTSB SEA79FYA23Accident · No injuriesClosedPiper PA-25 · Adrian, ORAug 21, 1979 · N6721Z · Substantial damage NTSB SEA79DYK23Accident · No injuriesClosedGrum Amer AA-5 · Medford, ORAug 20, 1979 · N6046L · Substantial damage NTSB SEA79DYM59Accident · No injuriesClosedMaule M4220C · Bates, ORAug 19, 1979 · N40307 · Substantial damage NTSB SEA79FYM58Accident · No injuriesClosedPiper PA-18 · Heppner, ORAug 18, 1979 · N3765Z · Substantial damage NTSB SEA79FYM57Accident · Serious injuriesClosedAero Comdr S-2R · Hermiston, ORAug 16, 1979 · N4945X · Substantial damage NTSB SEA79FYK21Accident · Serious injuriesClosedMaule M5-235 · Plush, ORAug 15, 1979 · N56291 · Destroyed NTSB SEA79DYK26Accident · No injuriesClosedCessna 150 · Burns, ORAug 3, 1979 · N61030 · Substantial damage NTSB SEA79DYM55Accident · Minor injuriesClosedHiller Acft UH-12E · Warm Spgs Res, ORJul 28, 1979 · N6ZH · Destroyed NTSB SEA80FYM54Accident · Minor injuriesClosedHughes 369D · Bay City, ORJul 25, 1979 · N58184 · Substantial damage NTSB SEA79DYK20Accident · No injuriesClosedPiper PA-28 · White City, ORJul 25, 1979 · N6844W · Substantial damage NTSB SEA79DYM53Accident · No injuriesClosedCessna 150 · Pilot Rock, ORJul 24, 1979 · N51192 · Substantial damage NTSB SEA79FYA20Accident · No injuriesClosedCessna 188 · Nyssa, ORJul 22, 1979 · N9499R · Destroyed NTSB SEA79FYM52Accident · Serious injuriesClosedCessna 150 · Sisters, ORJul 21, 1979 · N51321 · Substantial damage NTSB SEA79FYM51Accident · Minor injuriesClosedBell 47G · Embler, ORJul 18, 1979 · N6356X · Substantial damage NTSB SEA79DYK19Accident · No injuriesClosedCessna 305A · Creswell, ORJul 18, 1979 · N5311G · Substantial damage NTSB SEA79DYM50Accident · No injuriesClosedBeech A36 · Troutdale, ORJul 13, 1979 · N24158 · Substantial damage NTSB SEA79FYM48Accident · No injuriesClosedGrumman G-164A · Hermiston, ORJul 11, 1979 · N5340 · Substantial damage NTSB SEA79FYM47Accident · Minor injuriesClosedPiper J-3 · Clatskanie, ORJul 8, 1979 · N38790 · Substantial damage NTSB SEA79FYM45Accident · No injuriesClosedPiper PA-24 · Salem, ORJul 1, 1979 · N6651P · Substantial damage NTSB SEA79DYM44Accident · Minor injuriesClosedCessna 185 · Madras, ORJun 24, 1979 · N4710Q · Substantial damage NTSB SEA79DYM42Accident · Minor injuriesClosedCessna 172 · Baker, ORJun 19, 1979 · N733QW · Substantial damage NTSB SEA79DYK17Accident · No injuriesClosedStinson 108-3 · Malin, ORJun 19, 1979 · N6813M · Substantial damage NTSB SEA79FYM41Accident · No injuriesClosedCessna 182 · Wilsonville, ORJun 18, 1979 · N4952D · Substantial damage