Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 SEA71DVQ16Accident · No injuriesClosedBell 47G-2 · Sixes, ORDec 21, 1970 · N73284 · Substantial damage NTSB SEA71AS030Accident · 2 fatalClosedMooney M20E · Amity, ORDec 20, 1970 · N1983Y · Destroyed NTSB SEA71FWA25Accident · No injuriesClosedCessna 180 · Donald, ORDec 12, 1970 · N2392C · Substantial damage NTSB SEA71FWA24Accident · Serious injuriesClosedPiper PA-22 · Haines, ORNov 28, 1970 · N9184D · Substantial damage NTSB SEA71FVQ15Accident · Serious injuriesClosedPiper PA-28R · Bend, ORNov 22, 1970 · N3729T · Destroyed NTSB SEA71DWA23Accident · Serious injuriesClosedGlobe GC-1B · Pendleton, ORNov 14, 1970 · N2317B · Destroyed NTSB SEA71AS021Accident · 1 fatalClosedPiper PA-28R · Portland, OROct 9, 1970 · N5004S · Destroyed NTSB SEA71DWA21Accident · Minor injuriesClosedHughes 269B · Meacham, OROct 4, 1970 · N9354F · Destroyed NTSB SEA71DVQ08Accident · No injuriesClosedCessna 310J · Merrill, OROct 4, 1970 · N3009L · Substantial damage NTSB SEA71DVQ12Accident · No injuriesClosedCessna 172 · Lakeview, OROct 2, 1970 · N1823Y · Substantial damage NTSB SEA71DWA19Accident · No injuriesClosedErco 415-C · Wallowa, ORSep 27, 1970 · N99196 · Substantial damage NTSB SEA71AS014Accident · 3 fatalClosedBeech A23A · Medford, ORSep 13, 1970 · N2355W · Destroyed NTSB SEA71DWA16Accident · No injuriesClosedCessna 210 · Portland, ORSep 6, 1970 · N2301F · Substantial damage NTSB SEA71DVQ11Accident · Serious injuriesClosedCessna 172H · Ashland, ORSep 5, 1970 · N3783R · Destroyed NTSB SEA71DWA18Accident · Minor injuriesClosedCessna 150 · Gaston, ORAug 31, 1970 · N60306 · Substantial damage NTSB SEA71DVQ10Accident · No injuriesClosedPiper PA-32 · Alvord Ranch, ORAug 31, 1970 · N3221W · Substantial damage NTSB SEA71DVQ09Accident · No injuriesClosedPiper PA-20 · Klamath Flls, ORAug 31, 1970 · N7640K · Substantial damage NTSB SEA71AS011Accident · 1 fatalClosedCessna 172 · Agness, ORAug 26, 1970 · N79511 · Destroyed NTSB SEA71FWA14Accident · No injuriesClosedHelio Acft H-391B · Newberg, ORAug 21, 1970 · N17081 · Substantial damage NTSB SEA71FWA12Accident · 1 fatalClosedBoeing A75 · Hood River, ORAug 21, 1970 · N56628 · Destroyed NTSB SEA71FWA11Accident · Minor injuriesClosedMooney M20A · Grande Ronde, ORAug 14, 1970 · N8386E · Substantial damage NTSB SEA71FWA09Accident · No injuriesClosedBell 47G-4A · Estacada, ORAug 10, 1970 · N7939S · Substantial damage NTSB SEA71FVQ05Accident · No injuriesClosedPiper PA-22 · Junction Cty, ORAug 8, 1970 · N5210Z · Substantial damage NTSB SEA71DVQ06Accident · No injuriesClosedCessna 150 · Christmas V, ORAug 8, 1970 · N4024J · Substantial damage NTSB SEA71DWA10Accident · No injuriesClosedPiper PA-24 · Waldport, ORAug 7, 1970 · N5718P · Substantial damage NTSB SEA71DWD08Accident · No injuriesClosedSchweizer SGS233 · North Plains, ORAug 2, 1970 · N7761S · Substantial damage NTSB SEA71AS007Accident · 2 fatalClosedPiper PA-18 · Mitchell, ORAug 2, 1970 · N7663D · Destroyed NTSB SEA71FVQ04Accident · No injuriesClosedStinson 108-1 · Springfield, ORAug 1, 1970 · N97934 · Substantial damage NTSB SEA71AS005Accident · 2 fatalClosedCessna 150 · Gold Beach, ORJul 31, 1970 · N5878G · Destroyed NTSB SEA71DVQ03Accident · No injuriesClosedConvair PB4Y-2 · Diamond Lake, ORJul 27, 1970 · N3191G · Substantial damage NTSB SEA71FVQ01Accident · Minor injuriesClosedCessna 170 · Redmond, ORJul 17, 1970 · N9571A · Destroyed NTSB SEA71AS002Accident · No injuriesClosedCessna 182A · Glendale, ORJul 14, 1970 · N2018G · Substantial damage NTSB SEA71DXM04Accident · No injuriesClosedCessna 182E · Vale, ORJul 12, 1970 · N9359X · Substantial damage NTSB SEA71DWA05Accident · No injuriesClosedHiller Acft UH-12A · Maupin, ORJul 11, 1970 · N8180H · Substantial damage NTSB SEA71DWA03Accident · No injuriesClosedPiper PA-24 · Cove, ORJul 5, 1970 · N6256P · Substantial damage NTSB SEA71FWA01Accident · Serious injuriesClosedAeronca 7GCB · Hillsboro, ORJul 4, 1970 · N9915Y · Destroyed NTSB SEA71DWA02Accident · Minor injuriesClosedPiper PA-28 · Halfway, ORJul 2, 1970 · N7049R · Substantial damage NTSB SEA70FWA16Accident · No injuriesClosedHughes 269A · St Johns, ORJun 20, 1970 · N8737F · Substantial damage NTSB SEA70FXM19Accident · Serious injuriesClosedPiper PA-25 · Ontario, ORJun 17, 1970 · N7749Z · Destroyed NTSB SEA70AS047Accident · 3 fatalClosedMeyers OTW · Scappoose, ORJun 14, 1970 · N34324 · 2 aircraft · Destroyed NTSB SEA70AS046Accident · 2 fatalClosedCessna 150J · Lacomb, ORJun 8, 1970 · N51325 · Destroyed NTSB OAK70DVG26Accident · No injuriesClosedBoeing A75-N1 · Merrill, ORJun 4, 1970 · N65680 · Destroyed NTSB SEA70FWA15Accident · Minor injuriesClosedHiller Acft UH-12E · Bridgeport, ORJun 2, 1970 · N5387V · Destroyed NTSB SEA70DVQ09Accident · No injuriesClosedPiper PA-32 · Mckenzie Br., ORMay 25, 1970 · N4171R · Substantial damage NTSB SEA70DVQ08Accident · No injuriesClosedCessna 172 · Creswell, ORMay 23, 1970 · N7358A · Substantial damage NTSB SEA70DVQ06Accident · Minor injuriesClosedAeronca 7BCM · Ashland, ORMay 17, 1970 · N8362H · Destroyed NTSB SEA70AS043Accident · 7 fatalClosedBeech E18S · Joseph, ORMay 15, 1970 · N3621B · Destroyed NTSB SEA70AS042Accident · 1 fatalClosedMooney M10 · Wolf Creek, ORMay 11, 1970 · N9505V · Destroyed NTSB SEA70DVQ05Accident · No injuriesClosedBellanca 17-30 · Burns, ORMay 9, 1970 · N7329V · Destroyed NTSB SEA70FVQ04Accident · Minor injuriesClosedPiper PA-25 · Harrisburg, ORMay 7, 1970 · N7635Z · Destroyed