Skip to content

NTSB investigations, 1974, OR

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1974, OR per year, 1962–2026: 3,393 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	26

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") = 1974 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\") = 1974
    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") = 1974
  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 SEA75AS024Accident · 1 fatalClosedCessna 120 · Wasco, ORDec 19, 1974 · N2124V · Destroyed NTSB SEA75FYC26Accident · No injuriesClosedBellanca 17-30 · Portland, ORDec 8, 1974 · N4876V · Substantial damage NTSB SEA75KYI18Accident · Serious injuriesClosedPiper PA-31P · North Bend, ORDec 6, 1974 · N104RE · Substantial damage NTSB SEA75FYC13Accident · 1 fatalClosedMullan SA-11A · Mcminnville, ORDec 1, 1974 · N3304 · Destroyed NTSB SEA75FYI17Accident · No injuriesClosedCessna 150 · North Bend, ORNov 23, 1974 · N6960G · Substantial damage NTSB SEA75DYI16Accident · Minor injuriesClosedMidget MM-1 · Creswell, ORNov 20, 1974 · N3070 · Substantial damage NTSB SEA75DYC12Accident · No injuriesClosedCessna 182A · Oregon City, ORNov 15, 1974 · N4787D · Substantial damage NTSB SEA75FYI15Accident · 1 fatalClosedBensen B8ME · Eugene, OROct 26, 1974 · N3306 · Destroyed NTSB SEA75DYC20Accident · No injuriesClosedCessna 150 · St Paul, OROct 19, 1974 · N23015 · Substantial damage NTSB SEA75DYC19Accident · Minor injuriesClosedBeech E35 · Lagrande, OROct 10, 1974 · N3212C · Substantial damage NTSB SEA75DYI14Accident · Minor injuriesClosedBeech 19 · Burns, OROct 6, 1974 · N1960W · Substantial damage NTSB SEA75DYI13Accident · Minor injuriesClosedPiper PA-28 · Medford, OROct 4, 1974 · N1798T · Destroyed NTSB SEA75DYC18Accident · No injuriesClosedCessna 177 · Kent, OROct 4, 1974 · N1851Q · Substantial damage NTSB SEA75DYI12Accident · No injuriesClosedCessna 182 · Bend, ORSep 28, 1974 · N8599T · Substantial damage NTSB SEA75DYC17Accident · Minor injuriesClosedPiper PA-18A · Friend, ORSep 26, 1974 · N1456C · Substantial damage NTSB SEA75FYI10Accident · No injuriesClosedBoeing A75N1 · Wilbur, ORSep 22, 1974 · N4825V · Destroyed NTSB SEA75DYI09Accident · Minor injuriesClosedCessna 177RG · Medford, ORSep 17, 1974 · N2066Q · Substantial damage NTSB SEA75AYI11Accident · No injuriesClosedCessna 172 · Eugene, ORSep 17, 1974 · N20981 · Substantial damage NTSB SEA75DYI08Accident · Minor injuriesClosedPiper J5A · Bend, ORSep 2, 1974 · N38862 · Substantial damage NTSB SEA75AS011Accident · 2 fatalClosedPiper PA-12 · Medford, ORAug 30, 1974 · N3020M · Destroyed NTSB SEA75FYC14Accident · No injuriesClosedCessna 182H · Oregon City, ORAug 29, 1974 · N8321S · Substantial damage NTSB SEA75DYI07Accident · Minor injuriesClosedPiper PA-28 · Crescent Lk, ORAug 27, 1974 · N5571F · Substantial damage NTSB SEA75DYI06Accident · No injuriesClosedBensen B-8M · Eugene, ORAug 17, 1974 · N3306 · Substantial damage NTSB SEA75DVC15Accident · No injuriesClosedPiper PA-32 · Condon, ORAug 17, 1974 · N3623W · Substantial damage NTSB SEA75FYC10Accident · Serious injuriesClosedCessna T206 · Pendleton, ORAug 14, 1974 · N2516X · Destroyed NTSB SEA75FYI04Accident · Serious injuriesClosedBeech 36 · Klamath Fls, ORAug 12, 1974 · N7703R · Substantial damage NTSB SEA75FYC08Accident · No injuriesClosedPiper PA-28 · Aurora, ORAug 8, 1974 · N5023T · Substantial damage NTSB SEA75DYC06Accident · No injuriesClosedPiper PA-28 · Ukiah, ORAug 6, 1974 · N3088T · Substantial damage NTSB SEA75DYI05Accident · No injuriesClosedLuscombe 8A · Medford, ORAug 2, 1974 · N1151B · Substantial damage NTSB SEA75DYI03Accident · Serious injuriesClosedCessna 180H · Roseburg, ORJul 31, 1974 · N2736X · Substantial damage NTSB SEA75FYI02Accident · No injuriesClosedPiper PA-32 · Bend, ORJul 29, 1974 · N4232R · Substantial damage NTSB SEA75FYC05Accident · No injuriesClosedFly Baby 1 · Hubbard, ORJul 20, 1974 · N4604 · Substantial damage NTSB SEA75FYC04Accident · No injuriesClosedGrumman G-44 · Sandy, ORJul 16, 1974 · N708C · Substantial damage NTSB SEA75FYC03Accident · No injuriesClosedHiller Acft UH-12E · Dayton, ORJul 16, 1974 · N104HA · Substantial damage NTSB SEA75DYC02Accident · No injuriesClosedVertol 107 · Estacada, ORJul 11, 1974 · N6676D · No damage NTSB SEA75DYI01Accident · No injuriesClosedBell 47G · Midland, ORJul 7, 1974 · N957B · Destroyed NTSB SEA75DYC01Accident · No injuriesClosedAmer Avco AA1-A · Sandy, ORJul 3, 1974 · N6368L · Substantial damage NTSB SEA74FYI13Accident · Serious injuriesClosedStearman A75N1 · Klamath Flls, ORJun 28, 1974 · N53399 · Substantial damage NTSB SEA74AS051Accident · 1 fatalClosedCessna 182P · Zigzag, ORJun 25, 1974 · N21018 · Destroyed NTSB SEA74DYC62Accident · No injuriesClosedPiper PA-32 · Pacific City, ORJun 23, 1974 · N4429T · Substantial damage NTSB SEA74DYC60Accident · No injuriesClosedMooney M10 · Lebanon, ORJun 23, 1974 · N9515V · Substantial damage NTSB SEA74FYC61Accident · Serious injuriesClosedJohnson Chris · Mcminnville, ORJun 21, 1974 · N7192 · Destroyed NTSB SEA74DYI12Accident · No injuriesClosedPiper PA-28 · Sunriver, ORJun 8, 1974 · N4758T · Substantial damage NTSB SEA74DYA43Accident · No injuriesClosedCessna 188 · Nyssa, ORJun 8, 1974 · N9867U · Substantial damage NTSB SEA74FYC56Accident · 1 fatalClosedMay Flybaby 1 · Salem, ORMay 27, 1974 · N93003 · Destroyed NTSB SEA74FYC55Accident · No injuriesClosedBeech D18S · Mcminnville, ORMay 26, 1974 · N104J · Substantial damage NTSB SEA74DYC54Accident · Minor injuriesClosedBell 47G-3B · North Powder, ORMay 24, 1974 · N73940 · Substantial damage NTSB SEA74FYC53Accident · Serious injuriesClosedBellanca 17-30A · Hillsboro, ORMay 22, 1974 · N8290R · Destroyed NTSB SEA74DYC50Accident · No injuriesClosedPiper PA-28 · Mulino, ORMay 15, 1974 · N15285 · Substantial damage NTSB SEA74DYC48Accident · Minor injuriesClosedPiper PA-18 · Echo, ORMay 9, 1974 · N3965Z · Substantial damage