Skip to content

NTSB investigations, 1965, 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, 1965, 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") = 1965 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\") = 1965
    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") = 1965
  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 SEA66A0039Accident · 1 fatalClosedCessna 170B · Pendleton, ORDec 30, 1965 · N2382D · Substantial damage NTSB SEA66A0040Accident · 4 fatalClosedPiper PA-30 · Ironside, ORDec 29, 1965 · N7675Y · Destroyed NTSB SEA66F0194Accident · Minor injuriesClosedStinson 108-1 · Springfield, ORDec 28, 1965 · N8641K · Substantial damage NTSB SEA66A0038Accident · Minor injuriesClosedSikorsky S-55 · Seaside, ORDec 22, 1965 · N73893 · Destroyed NTSB SEA66D0187Accident · No injuriesClosedPiper PA-22 · Eugene, ORDec 11, 1965 · N6956D · Substantial damage NTSB SEA66F0204Accident · No injuriesClosedPiper PA-22 · Scio, ORDec 10, 1965 · N9312D · Substantial damage NTSB SEA66A0036Accident · No injuriesClosedAir & Space 18A · Oakland, ORDec 8, 1965 · N6101S · Substantial damage NTSB SEA66D0186Accident · No injuriesClosedCessna 140 · Beaverton, ORDec 4, 1965 · N3701V · Substantial damage NTSB SEA66F0167Accident · No injuriesClosedCessna 150 · Mcminnville, ORNov 19, 1965 · N3091J · Substantial damage NTSB SEA66D0177Accident · No injuriesClosedBeechcraft B35 · Warrenton, ORNov 5, 1965 · N5032C · Substantial damage NTSB SEA66F0164Accident · Minor injuriesClosedCessna 172F · Springfield, ORNov 4, 1965 · N8467U · Substantial damage NTSB SEA66F0153Accident · Serious injuriesClosedCessna 195B · Imnaha, OROct 31, 1965 · N3090B · Destroyed NTSB SEA66F0154Accident · Serious injuriesClosedCessna 172 · Hermiston, OROct 26, 1965 · N3706S · Substantial damage NTSB SEA66F0174Accident · No injuriesClosedBeechcraft E35 · Adel, OROct 24, 1965 · N7328B · Destroyed NTSB SEA66F0165Accident · No injuriesClosedCessna 140A · Mulino, OROct 23, 1965 · N9695A · Substantial damage NTSB SEA66D0146Accident · Minor injuriesClosedCessna 175A · Wheeler, OROct 11, 1965 · N6760E · Substantial damage NTSB SEA66F0173Accident · Minor injuriesClosedBeechcraft M23 · Parkrose, OROct 10, 1965 · N8787M · Substantial damage NTSB SEA66A0020Accident · 2 fatalClosedConvair PBY-6A · Klamathfalls, OROct 4, 1965 · N6455C · Destroyed NTSB SEA66D0147Accident · Minor injuriesClosedPiper PA-22 · Ione, OROct 2, 1965 · N2924Z · Substantial damage NTSB SEA66D0160Accident · No injuriesClosedCessna 170 · Monument, OROct 1, 1965 · N3903V · Substantial damage NTSB SEA66D0144Accident · No injuriesClosedPiper PA-18 · Malin, ORSep 24, 1965 · N3568P · Substantial damage NTSB SEA66A0023Accident · No injuriesClosedHughes 269B · Enterprise, ORSep 23, 1965 · N9426F · Substantial damage NTSB SEA66F0143Accident · No injuriesClosedPiper PA-22 · Culver, ORSep 16, 1965 · N1892P · Substantial damage NTSB SEA66D0129Accident · Minor injuriesClosedCessna 172 · Condon, ORSep 15, 1965 · N8872U · Substantial damage NTSB SEA66F0133Accident · Minor injuriesClosedPiper PA-30 · Hillsboro, ORSep 14, 1965 · N246NW · Destroyed NTSB SEA66F0125Accident · No injuriesClosedPiper PA-16 · Salem, ORSep 12, 1965 · N5995H · Substantial damage NTSB SEA66F0124Accident · Serious injuriesClosedEcessna 120 · Mckenzie Brge, ORSep 5, 1965 · N3139N · Destroyed NTSB SEA66F0118Accident · No injuriesClosedCessna 182 · Baker, ORSep 4, 1965 · N5335B · Substantial damage NTSB SEA66F0120Accident · Serious injuriesClosedPiper PA-22 · Beavercreek, ORAug 31, 1965 · N4769Z · Destroyed NTSB SEA66F0121Accident · No injuriesClosedAeronca 7AC · Springfield, ORAug 29, 1965 · N1838E · Substantial damage NTSB SEA66A0018Accident · 2 fatalClosedCessna 182 · Prineville, ORAug 27, 1965 · N2905Y · Destroyed NTSB SEA66F0116Accident · No injuriesClosedCessna 180 · Prairie City, ORAug 22, 1965 · N2956C · Destroyed NTSB SEA66F0112Accident · Minor injuriesClosedPiper PA-22 · Beaver Creek, ORAug 21, 1965 · N3935P · Substantial damage NTSB SEA66A0013Accident · No injuriesClosedHiller UH12E · Crowley, ORAug 16, 1965 · N5341V · Substantial damage NTSB SEA66A0015Accident · No injuriesClosedHughes 269A · Delake, ORAug 15, 1965 · N8762F · Substantial damage NTSB SEA66D0111Accident · No injuriesClosedWaco YKS-7 · Klamath Falls, ORAug 12, 1965 · N19376 · Substantial damage NTSB SEA66A0011Accident · No injuriesClosedCurtiss C-46A · Salem, ORAug 12, 1965 · N7769B · Substantial damage NTSB SEA66D0113Accident · No injuriesClosedPiper PA-28 · Aurora, ORAug 6, 1965 · N5805W · Substantial damage NTSB SEA66F0108Accident · Minor injuriesClosedMooney M20C · Troutdale, ORAug 5, 1965 · N78942 · Substantial damage NTSB SEA66F0107Accident · No injuriesClosedBeechcraft C-45G · Cave Junctn, ORJul 26, 1965 · N248GB · Substantial damage NTSB SEA66D0106Accident · Minor injuriesClosedWaco UPF-7 · Ashland, ORJul 21, 1965 · N32023 · Destroyed NTSB SEA66F0075Accident · No injuriesClosedCessna 180 · Medford, ORJul 14, 1965 · N9352C · Substantial damage NTSB SEA66F0083Accident · No injuriesClosedCessna 150E · Halsey, ORJul 11, 1965 · N2508J · Substantial damage NTSB SEA66F0073Accident · No injuriesClosedAeronca 7ECA · Eugene, ORJul 10, 1965 · N11093 · Substantial damage NTSB SEA66F0097Accident · No injuriesClosedMooney M20A · Roseburg, ORJul 3, 1965 · N8114E · Substantial damage NTSB SEA66F0087Accident · Serious injuriesClosedPiper PA-18A · Mosier, ORJun 23, 1965 · N3792P · Destroyed NTSB SEA66F0051Accident · No injuriesClosedCessna 182 · Grants Pass, ORJun 22, 1965 · N5856B · Substantial damage NTSB SEA66F0050Accident · No injuriesClosedBoeing A75N1 · Merrill, ORJun 19, 1965 · N63702 · Destroyed NTSB SEA66F0042Accident · No injuriesClosedCessna 170B · Hood River, ORJun 19, 1965 · CF-RQU · Substantial damage NTSB SEA66F0062Accident · No injuriesClosedCallair A-6 · Lakeview, ORJun 13, 1965 · N2907G · Substantial damage