Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 SEA70D0151Accident · No injuriesClosedPiper PA-24 · Mulino, ORDec 31, 1969 · N6373P · Substantial damage NTSB SEA70D0127Accident · Minor injuriesClosedPiper PA-18 · Jordan Vally, ORDec 24, 1969 · N1858P · Substantial damage NTSB SEA70D0149Accident · No injuriesClosedCessna 150 · Cottage Grve, ORDec 22, 1969 · N6708S · Substantial damage NTSB SEA70D0145Accident · No injuriesClosedPiper PA-24 · Enterprise, ORDec 14, 1969 · N7760P · Substantial damage NTSB SEA70D0144Accident · No injuriesClosedAero Comdr 520 · Salem, ORDec 13, 1969 · N2622B · Substantial damage NTSB SEA70F0152Accident · No injuriesClosedCessna 175 · Malin, ORDec 1, 1969 · N7940T · Substantial damage NTSB SEA70A0023Accident · 5 fatalClosedCessna 310B · Miltn-Frewtr, ORDec 1, 1969 · N401T · Destroyed NTSB SEA70D0146Accident · No injuriesClosedCessna 182 · Prairie City, ORNov 26, 1969 · N7257E · Substantial damage NTSB SEA70A0020Accident · 2 fatalClosedPiper PA-22 · Scappoose, ORNov 14, 1969 · N1460A · Destroyed NTSB SEA70F0143Accident · Minor injuriesClosedCessna P206 · Independence, ORNov 10, 1969 · N2535X · Substantial damage NTSB SEA70D0142Accident · No injuriesClosedErcoupe 415C · Hillsboro, ORNov 7, 1969 · N2243H · Substantial damage NTSB SEA70F0140Accident · Serious injuriesClosedPiper PA-18 · Princeton, OROct 20, 1969 · N4372Z · Destroyed NTSB SEA70F0139Accident · Serious injuriesClosedCessna 150 · Millican, OROct 18, 1969 · N7163X · Destroyed NTSB SEA70A0016Accident · 3 fatalClosedPiper PA-24 · Newberg, OROct 17, 1969 · N7315P · Substantial damage NTSB SEA70D0148Accident · No injuriesClosedStinson SR-7C · Troutdale, OROct 12, 1969 · N16106 · Substantial damage NTSB SEA75AS015Accident · 1 fatalClosedBeech A35-33 · Oakridge, OROct 9, 1969 · N916B · Destroyed NTSB SEA70D0134Accident · No injuriesClosedHelio Acft H-391B · Reedsport, OROct 7, 1969 · N6025 · Substantial damage NTSB SEA70D0132Accident · No injuriesClosedCessna 195A · Vernonia, OROct 4, 1969 · N1042D · Destroyed NTSB SEA70F0131Accident · No injuriesClosedMooney M20E · Albany, ORSep 24, 1969 · N3232F · Substantial damage NTSB SEA70D0130Accident · No injuriesClosedCessna 170B · Agnes, ORSep 13, 1969 · N4359B · Substantial damage NTSB SEA70D0147Accident · No injuriesClosedBergfalke II-55 · Aurora, ORSep 7, 1969 · N5924 · Substantial damage NTSB SEA70D0125Accident · No injuriesClosedKaman Acft K-600 · Wolf Creek, ORSep 5, 1969 · N2855J · Destroyed NTSB SEA70F0074Accident · Serious injuriesClosedPiper PA-23 · Haines, ORSep 3, 1969 · N6076Y · Destroyed NTSB SEA70D0123Accident · No injuriesClosedCessna 140 · Roseburg, ORSep 2, 1969 · N76445 · Substantial damage NTSB SEA70F0093Accident · No injuriesClosedBeech A55 · Eugene, ORAug 25, 1969 · N9505Y · Substantial damage NTSB SEA70F0090Accident · Serious injuriesClosedPiper PA-22 · Halsey, ORAug 21, 1969 · N4782Z · Substantial damage NTSB SEA70D0087Accident · No injuriesClosedErco 415C · Canby, ORAug 17, 1969 · N3286H · Substantial damage NTSB SEA70A0010Accident · 1 fatalClosedCessna 140 · Newport, ORAug 14, 1969 · N2225N · Destroyed NTSB SEA70F0052Accident · No injuriesClosedPiper PA-22 · Halfway, ORAug 13, 1969 · N5709D · Substantial damage NTSB SEA70A0009Accident · 1 fatalClosedChampion 7KCAB · Scappoose, ORAug 10, 1969 · N1607G · Destroyed NTSB SEA70F0121Accident · No injuriesClosedPiper PA-28R · Lake O Woods, ORAug 9, 1969 · N7526J · Substantial damage NTSB SEA70D0063Accident · No injuriesClosedPiper PA-28 · Brookings, ORAug 9, 1969 · N9446J · Substantial damage NTSB SEA70A0007Accident · 2 fatalClosedBeech D50E · Sandy, ORAug 2, 1969 · N992T · Destroyed NTSB SEA70D0041Accident · No injuriesClosedWaco UMF · Adrian, ORJul 30, 1969 · N14085 · Destroyed NTSB SEA70D0073Accident · No injuriesClosedPiper PA-30 · Portland, ORJul 28, 1969 · N8125Y · Substantial damage NTSB SEA70D0065Accident · No injuriesClosedTravel Air E4000 · Nyssa, ORJul 28, 1969 · N477N · Substantial damage NTSB SEA70A0005Accident · 1 fatalClosedPiper PA-28 · Astoria, ORJul 27, 1969 · N9751W · Destroyed NTSB SEA70D0051Accident · No injuriesClosedPiper J3C-65 · Eugene, ORJul 25, 1969 · N8358H · Substantial damage NTSB SEA70F0046Accident · Serious injuriesClosedBell 47G3B2 · Albany, ORJul 19, 1969 · N4758R · Destroyed NTSB SEA70D0061Accident · No injuriesClosedCessna 180 · Donald, ORJul 18, 1969 · N2992A · Substantial damage NTSB SEA70F0055Accident · Minor injuriesClosedPiper PA-18 · White City, ORJul 17, 1969 · N7394D · Destroyed NTSB OAK70A0004Accident · 1 fatalClosedCessna 182 · Pendleton, ORJul 17, 1969 · N2193G · Destroyed NTSB SEA70D0060Accident · No injuriesClosedPiper PA-28 · Eugene, ORJul 12, 1969 · N6412W · Substantial damage NTSB SEA70F0118Accident · Minor injuriesClosedPiper PA-28R · Condon, ORJul 5, 1969 · N3940T · Substantial damage NTSB SEA70D0015Accident · No injuriesClosedBell 47G-2 · Ontario, ORJul 4, 1969 · N9963Z · Substantial damage NTSB OAK70A0001Accident · 2 fatalClosedCessna 177 · Astoria, ORJul 4, 1969 · N3372T · Destroyed NTSB SEA70D0006Accident · Minor injuriesClosedPiper PA-25 · Vale, ORJun 14, 1969 · N6512Z · Substantial damage NTSB SEA69A0060Accident · 3 fatalClosedCessna 337C · North Bend, ORJun 5, 1969 · N2665S · Destroyed NTSB SEA70D0009Accident · No injuriesClosedChampion 7EC · Eagle Point, ORJun 2, 1969 · N7547E · Substantial damage NTSB SEA69A0058Accident · 3 fatalClosedPiper PA-28 · Mcknzie Brdg, ORMay 30, 1969 · N7133R · Destroyed