Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 SEA72DYA22Accident · No injuriesClosedAeronca 11AC · Brogan, ORDec 25, 1971 · N3175E · Substantial damage NTSB SEA72AS025Accident · 1 fatalClosedPiper PA-22 · Portland, ORDec 19, 1971 · N3535Z · Destroyed NTSB SEA72FYC25Accident · No injuriesClosedCessna 150 · Forest Grove, ORDec 18, 1971 · N7011S · Substantial damage NTSB SEA72AS028Accident · 3 fatalClosedCessna T337D · Vale, ORDec 13, 1971 · N86371 · Destroyed NTSB SEA72AS022Accident · 6 fatalClosedBeech C35 · Astoria, ORNov 25, 1971 · N1944D · Destroyed NTSB SEA72FYC24Accident · Minor injuriesClosedPiper PA-20 · Washougal, ORNov 20, 1971 · N7630K · Destroyed NTSB SEA72AS020Accident · 4 fatalClosedPiper PA-23 · Grants Pass, ORNov 17, 1971 · N1156P · Destroyed NTSB SEA72DYC23Accident · No injuriesClosedCessna 175 · Condon, ORNov 13, 1971 · N7095M · Substantial damage NTSB SEA72DYC22Accident · No injuriesClosedBeech A-23A · Troutdale, ORNov 13, 1971 · N3692Q · Substantial damage NTSB SEA72AS018Accident · 2 fatalClosedCessna P206 · Durkee, ORNov 1, 1971 · N2531X · Destroyed NTSB SEA72FYC21Accident · No injuriesClosedDruin Turb D-31 · Corvallis, OROct 20, 1971 · N7193 · Substantial damage NTSB SEA72AS017Accident · 2 fatalClosedMooney M20F · Azalea, OROct 11, 1971 · N6432Q · Destroyed NTSB SEA72DYC20Accident · No injuriesClosedPiper PA-22 · Oregon City, OROct 9, 1971 · N7323D · Substantial damage NTSB SEA72DYI09Accident · Minor injuriesClosedStearman PT-17 · Glide, ORSep 16, 1971 · N4769V · Destroyed NTSB SEA72AS012Accident · 4 fatalClosedMooney M20C · Lacomb, ORSep 12, 1971 · N3431X · Destroyed NTSB SEA72FYC18Accident · No injuriesClosedPiper PA-28 · Portland, ORSep 4, 1971 · N7603W · Substantial damage NTSB SEA72DYC19Accident · No injuriesClosedPiper PA-12 · Kimberley, ORAug 27, 1971 · N3480M · Substantial damage NTSB SEA72FYI08Accident · Serious injuriesClosedCessna 150G · Paisley, ORAug 26, 1971 · N3837J · Destroyed NTSB SEA72FYC17Accident · No injuriesClosedPiper PA-22 · Portland, ORAug 19, 1971 · N5037Z · Substantial damage NTSB SEA72DYI07Accident · No injuriesClosedPiper PA-24 · Bend, ORAug 19, 1971 · N6651P · Substantial damage NTSB SEA72DYC16Accident · No injuriesClosedMaule M-4 · Lagrande, ORAug 18, 1971 · N2077U · Substantial damage NTSB SEA72DYA09Accident · No injuriesClosedLuscombe 8A · Jordan Vally, ORAug 18, 1971 · N72019 · Substantial damage NTSB SEA72DYI06Accident · Minor injuriesClosedBell 47G3B · Selma, ORAug 13, 1971 · N73241 · Substantial damage NTSB SEA72FYI05Accident · No injuriesClosedBeech B23 · Bend, ORAug 11, 1971 · N7603R · Substantial damage NTSB SEA72FYI04Accident · No injuriesClosedKaman HUK-1 · Central Pt, ORAug 7, 1971 · N9847 · Substantial damage NTSB SEA72FYC15Accident · No injuriesClosedCessna A188 · St.Johns, ORAug 2, 1971 · N8073V · Substantial damage NTSB SEA72AS005Accident · 2 fatalClosedCallair A-9 · Nyssa, ORAug 2, 1971 · N3558G · 2 aircraft · Destroyed NTSB SEA72DYI03Accident · No injuriesClosedCessna 172 · Lakeview, ORAug 1, 1971 · N8904B · Substantial damage NTSB SEA72FYC14Accident · 1 fatalClosedBell 47-G3B · Mt Vernon, ORJul 31, 1971 · N4079G · Destroyed NTSB SEA72FYC12Accident · 1 fatalClosedCallair A-9 · Hermiston, ORJul 29, 1971 · N375MC · 2 aircraft · Minor damage NTSB SEA72FYC11Accident · No injuriesClosedCessna 150 · Albany, ORJul 27, 1971 · N3625J · Substantial damage NTSB SEA72AS004Accident · No injuriesClosedDouglas DC-3C · Redmond, ORJul 26, 1971 · N51041 · Substantial damage NTSB SEA72DYC09Accident · No injuriesClosedChampion 7FC · Sandy, ORJul 25, 1971 · N9051B · Substantial damage NTSB SEA72DYC08Accident · No injuriesClosedBell 47G3B1 · Legrande, ORJul 20, 1971 · N1324X · Destroyed NTSB SEA72DYC07Accident · No injuriesClosedStinson 108-1 · Salem, ORJul 18, 1971 · N9023K · Substantial damage NTSB SEA72DYC05Accident · No injuriesClosedPiper J3C-65 · Beaverton, ORJul 5, 1971 · N33551 · Substantial damage NTSB SEA72FYC02Accident · Serious injuriesClosedBeech 23 · Seaside, ORJul 3, 1971 · N8707M · Destroyed NTSB SEA72DYC04Accident · No injuriesClosedPiper J-3 · Dayton, ORJul 3, 1971 · N11CJ · Substantial damage NTSB SEA72DYC03Accident · No injuriesClosedMooney M20C · Culver, ORJul 3, 1971 · N6666U · Substantial damage NTSB SEA72DYC01Accident · Minor injuriesClosedCessna A185E · John Day, ORJul 1, 1971 · N4740Q · Destroyed NTSB SEA71DYC47Accident · No injuriesClosedCessna 172F · Lostine, ORJun 30, 1971 · N8303U · Destroyed NTSB SEA71FYC46Accident · Minor injuriesClosedCessna 172G · Mt.Hood, ORJun 20, 1971 · N1165F · Substantial damage NTSB SEA71FYI26Accident · Serious injuriesClosedPitts S1C · Creswell, ORJun 19, 1971 · N75E · Substantial damage NTSB SEA71AS047Accident · 5 fatalClosedPiper PA-32 · Meacham, ORJun 14, 1971 · N4070W · Destroyed NTSB SEA71FYC43Accident · No injuriesClosedCessna 182B · Enterprise, ORJun 12, 1971 · N2513G · Substantial damage NTSB SEA71FYC42Accident · 1 fatalClosedHiller UH12A · Brooks, ORJun 11, 1971 · N8178H · Destroyed NTSB SEA71DYA34Accident · Minor injuriesClosedPiper PA-25 · Arock, ORJun 6, 1971 · N7302Z · Destroyed NTSB SEA71AS046Accident · 3 fatalClosedPiper PA-28 · Clatskanie, ORJun 2, 1971 · N3968R · Destroyed NTSB SEA71FYC41Accident · No injuriesClosedHughes 269A · Wilsonville, ORMay 29, 1971 · N8850F · Substantial damage NTSB SEA71AS045Accident · 1 fatalClosedPiper PA-22 · Springfield, ORMay 23, 1971 · N2129A · Destroyed