Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 SEA76AS031Accident · 3 fatalClosedCessna R172 · Klamath Falls, ORDec 21, 1975 · N12987 · Destroyed NTSB SEA76FYC26Accident · Minor injuriesClosedHiller Acft UH-12D · Nehalem, ORDec 11, 1975 · N17714 · Destroyed NTSB SEA76FYI12Accident · No injuriesClosedBeech G35 · Bend, ORDec 5, 1975 · N4419D · Destroyed NTSB SEA76AS029Accident · 1 fatalClosedMooney M20C · Mount Hood, ORDec 1, 1975 · N9746M · Destroyed NTSB SEA76DYI11Accident · No injuriesClosedRyan Navion A · Klamath Falls, ORNov 29, 1975 · N91543 · Substantial damage NTSB SEA76AS028Accident · 2 fatalClosedPiper PA-24 · Myrtle Creek, ORNov 29, 1975 · N9451P · Destroyed NTSB SEA76DYC24Accident · No injuriesClosedMaule M4220C · Enterprise, OROct 28, 1975 · N40643 · Substantial damage NTSB SEA76AS023Accident · 2 fatalClosedCessna 150J · Grants Pass, OROct 28, 1975 · N50490 · Destroyed NTSB SEA76DYI10Accident · No injuriesClosedCessna 320F · Riley Junction, OROct 17, 1975 · N6163Q · Substantial damage NTSB SEA7LFYC22Accident · Minor injuriesClosedCessna 170B · Cascade Locks, ORSep 27, 1975 · N2772D · Substantial damage NTSB SEA76DYC21Accident · No injuriesClosedPiper PA-28 · Albany, ORSep 21, 1975 · N41505 · Substantial damage NTSB SEA76FYC20Accident · No injuriesClosedHiller Acft UH-12B · Brownsville, ORSep 20, 1975 · N8108H · Substantial damage NTSB SEA76DYI09Accident · Serious injuriesClosedBell 47J-2A · Roseburg, ORSep 20, 1975 · N2ZH · Substantial damage NTSB SEA76FYC19Accident · No injuriesClosedCessna 150F · Portland, ORSep 11, 1975 · N8352G · Substantial damage NTSB SEA76FYC18Accident · No injuriesClosedCessna 175 · Tillamook, ORSep 8, 1975 · N8097T · Substantial damage NTSB SEA76FYC17Accident · Serious injuriesClosedGrum Amer AA5 · Hillsboro, ORSep 7, 1975 · N9266L · Substantial damage NTSB SEA76FYI07Accident · No injuriesClosedAero Comdr A-9B · Roseburg, ORSep 3, 1975 · N7681V · Destroyed NTSB SEA76DYI06Accident · No injuriesClosedPiper PA-32 · Redmond, ORSep 1, 1975 · N4092R · Substantial damage NTSB SEA76DYC14Accident · No injuriesClosedPiper PA-32 · Enterprise, ORSep 1, 1975 · N3507W · Substantial damage NTSB SEA76DYC12Accident · No injuriesClosedChampion 7GCB · Antelope, ORAug 23, 1975 · N9958Y · Substantial damage NTSB SEA76FYC11Accident · 1 fatalClosedCallair A-9B · Pendleton, ORAug 15, 1975 · N7245V · Destroyed NTSB SEA76DYC10Accident · No injuriesClosedCessna A188B · Jefferson, ORAug 12, 1975 · N9873G · Destroyed NTSB SEA76FYC09Accident · No injuriesClosedPiper PA-28 · Mulino, ORAug 11, 1975 · N9577J · Substantial damage NTSB SEA76DYI05Accident · Minor injuriesClosedCessna 182 · Bonanza, ORAug 8, 1975 · N2541R · Destroyed NTSB SEA7KAS006Accident · 2 fatalClosedCessna 195A · Lincoln City, ORJul 28, 1975 · N1529D · Destroyed NTSB SEA76DYI04Accident · No injuriesClosedPiper PA-32 · Sunriver, ORJul 27, 1975 · N3560W · Substantial damage NTSB SEA76AS007Accident · 1 fatalClosedPiper PA-28 · Sheridan, ORJul 27, 1975 · N9183J · Destroyed NTSB SEA76DYI08Accident · No injuriesClosedBoeing E75 · Klamath Falls, ORJul 23, 1975 · N4769V · Substantial damage NTSB SEA76DYC08Incident · No injuriesClosedMooney M20C · Dalles, ORJul 23, 1975 · N9753M · Minor damage NTSB SEA76DYC07Accident · No injuriesClosedSchweizer SGS233 · North Plains, ORJul 19, 1975 · N5759S · Substantial damage NTSB SEA76DYC06Accident · No injuriesClosedCessna 172 · Sandy, ORJul 19, 1975 · N4320R · Substantial damage NTSB SEA76FYI03Accident · No injuriesClosedAeronca 15AC · Lapine, ORJul 13, 1975 · N1313H · Substantial damage NTSB SEA7LFYC04Accident · No injuriesClosedBoeing E75 · Madras, ORJul 12, 1975 · N147KY · Substantial damage NTSB SEA76FYC03Accident · No injuriesClosedCessna 172 · Seaside, ORJul 11, 1975 · N61542 · Substantial damage NTSB SEA76DYI01Accident · No injuriesClosedCessna 170 · Redmond, ORJul 5, 1975 · N8282A · Destroyed NTSB SEA76FYC02Accident · No injuriesClosedCessna 180 · Molalla, ORJul 4, 1975 · N2468C · Substantial damage NTSB SEA76DYI02Accident · No injuriesClosedCessna 172 · Fields, ORJul 4, 1975 · N3880Q · Substantial damage NTSB SEA76DYC01Accident · No injuriesClosedPiper PA-25 · Baker, ORJul 3, 1975 · N6504Z · Substantial damage NTSB SEA75DYI31Accident · No injuriesClosedPiper PA-20 · Eugene, ORJun 28, 1975 · N7013K · Substantial damage NTSB SEA75DYC46Accident · No injuriesClosedBellanca 14-13 · Astoria, ORJun 27, 1975 · N86726 · Substantial damage NTSB SEA75FYI30Accident · Minor injuriesClosedCessna 180A · Sunriver, ORJun 26, 1975 · N9650B · Destroyed NTSB SEA75AYI28Accident · Serious injuriesClosedBoeing A75N1 · Malin, ORJun 22, 1975 · N53126 · 2 aircraft · No damage NTSB SEA75DYC42Accident · No injuriesClosedHiller Acft UH-12D · Manzanita, ORJun 14, 1975 · N17714 · Substantial damage NTSB SEA75DYC41Accident · No injuriesClosedBeech 35 · Wasco, ORJun 13, 1975 · N3965N · Substantial damage NTSB SEA75AS044Accident · 1 fatalClosedAmer Avco AA1-A · Portland, ORJun 13, 1975 · N9632L · Destroyed NTSB SEA75DYC40Accident · Serious injuriesClosedBell 47G-2A · Corvallis, ORMay 31, 1975 · N5161B · Destroyed NTSB SEA75FYC39Accident · No injuriesClosedPiper J3L-65 · Cornelius, ORMay 28, 1975 · N26841 · Substantial damage NTSB SEA75DYI27Accident · No injuriesClosedCessna 150 · Redmond, ORMay 28, 1975 · N10297 · Substantial damage NTSB SEA75DYI26Accident · No injuriesClosedMooney M20C · Norway, ORMay 28, 1975 · N3445X · Substantial damage NTSB SEA75DYI25Accident · Serious injuriesClosedCessna 210 · Riddle, ORMay 26, 1975 · N2308F · Destroyed