Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 SEA73AS017Accident · 2 fatalClosedPiper PA-22 · Portland, ORDec 31, 1972 · N2730P · Destroyed NTSB SEA73FYC15Accident · No injuriesClosedPiper PA-24 · Gervais, ORDec 25, 1972 · N6496P · Substantial damage NTSB SEA73DYC14Accident · No injuriesClosedCessna 170B · Wallowa, ORDec 9, 1972 · N8365A · Substantial damage NTSB SEA73FYC13Accident · No injuriesClosedPiper PA-28 · Newberg, ORDec 4, 1972 · N5046T · Substantial damage NTSB SEA73DYI08Accident · Minor injuriesClosedPiper PA-28 · Klamath Fall, ORDec 2, 1972 · N1223T · Substantial damage NTSB SEA73AS015Accident · 3 fatalClosedPiper PA-28 · Bend, ORNov 26, 1972 · N4447J · Substantial damage NTSB SEA73DYI07Accident · No injuriesClosedLuscombe 8A · Coos Bay, ORNov 17, 1972 · N45493 · Substantial damage NTSB OAK73AP011Accident · 1 fatalClosedPiper PA-28 · Baker, ORNov 16, 1972 · N5365L · Destroyed NTSB SEA73DYC12Accident · No injuriesClosedPiper PA-28 · Grand Ronde, ORNov 11, 1972 · N9526J · Substantial damage NTSB SEA73FYC11Accident · No injuriesClosedErcoupe 415-CD · North Plains, OROct 7, 1972 · N3340H · Substantial damage NTSB SEA73DYI05Accident · No injuriesClosedAero Comdr 100 · Burns, OROct 7, 1972 · N4115X · Substantial damage NTSB SEA73ASO08Accident · 1 fatalClosedCessna 150G · Portland, OROct 4, 1972 · N8320J · Destroyed NTSB SEA73DYI04Accident · No injuriesClosedPiper PA-25 · Glide, ORSep 19, 1972 · N7134Z · Substantial damage NTSB SEA73FYC10Accident · No injuriesClosedPiper PA-28 · Portland, ORSep 18, 1972 · N8490R · Substantial damage NTSB SEA73DYC09Accident · No injuriesClosedCessna 120 · Mltn-Frewatr, ORSep 16, 1972 · N2999N · Substantial damage NTSB SEA73AS006Accident · Minor injuriesClosedTaylorcraft BC1265 · Grants Pass, ORSep 10, 1972 · N29719 · Minor damage NTSB SEA73FYC08Accident · Serious injuriesClosedHughes 269A · Portland, ORSep 9, 1972 · N8752F · Destroyed NTSB SEA73FYA10Accident · No injuriesClosedPiper PA-25 · Ontario, ORSep 8, 1972 · N6887Z · Substantial damage NTSB SEA73FYC04Accident · No injuriesClosedPiper PA-22 · Mcminville, ORSep 4, 1972 · N6157D · Substantial damage NTSB SEA73FYI05Accident · 1 fatalClosedKaman H-43A · Jacksonville, ORSep 3, 1972 · N2853J · Destroyed NTSB SEA73FYC07Accident · 1 fatalClosedCallair A-9 · Pendleton, ORAug 25, 1972 · N7201V · Destroyed NTSB SEA73DY103Accident · No injuriesClosedBrantly B-2 · Roseburg, ORAug 23, 1972 · N5955X · Substantial damage NTSB SEA73AS004Accident · 1 fatalClosedPiper PA-28R · Bandon, ORAug 16, 1972 · N7504J · Destroyed NTSB SEA73DYC05Accident · No injuriesClosedBell 206A · John Day, ORAug 10, 1972 · N209D · Substantial damage NTSB SEA73FYI02Accident · Minor injuriesClosedPiper PA-28 · Roseburg, ORAug 3, 1972 · N1721T · Substantial damage NTSB SEA73FYC03Accident · Minor injuriesClosedCessna 210J · Condon, ORJul 29, 1972 · N3318S · Substantial damage NTSB SEA73AS002Accident · 1 fatalClosedPiper PA-28 · Klamath Fall, ORJul 21, 1972 · N7165R · Destroyed NTSB SEA73FVC01Accident · No injuriesClosedCessna 170B · Halfway, ORJul 15, 1972 · N2757C · Destroyed NTSB SEA72FYI01Accident · Minor injuriesClosedCessna 172L · Medford, ORJul 1, 1972 · N7010Q · Substantial damage NTSB SEA72DYA43Accident · Minor injuriesClosedAero Comdr 600S2R · Ontario, ORJun 30, 1972 · N1782S · Substantial damage NTSB SEA72FYC49Accident · Serious injuriesClosedCallair A-9 · Harrisburg, ORJun 26, 1972 · N3588G · Substantial damage NTSB SEA72AS055Accident · 1 fatalClosedPiper PA-22 · Springfield, ORJun 22, 1972 · N3556A · Destroyed NTSB SEA72DYA40Accident · Minor injuriesClosedPiper PA-25 · Ontario, ORJun 19, 1972 · N7275Z · Destroyed NTSB SEA72FYI23Accident · Serious injuriesClosedBoeing A75N1 · Lakeview, ORJun 13, 1972 · N48568 · Destroyed NTSB SEA72FYC47Accident · 1 fatalClosedBoeing A75 · Salem, ORJun 7, 1972 · N56236 · Substantial damage NTSB SEA72FYC46Accident · Serious injuriesClosedBellanca 1419-2 · Hermiston, ORJun 7, 1972 · N7698B · Destroyed NTSB SEA72DYC48Accident · No injuriesClosedCessna 210 · Unity, ORJun 7, 1972 · N2221R · Substantial damage NTSB SEA72FYA37Accident · Serious injuriesClosedPiper PA-25 · Nyssa, ORJun 6, 1972 · N6512Z · Destroyed NTSB SEA72AS051Accident · 3 fatalClosedPiper PA-22 · Sunriver, ORMay 29, 1972 · N4411A · Destroyed NTSB SEA72FVC44Accident · Minor injuriesClosedMooney M20E · Corvallis, ORMay 28, 1972 · N1243X · Destroyed NTSB SEA72DVC43Accident · No injuriesClosedPiper PA-24 · Lyons, ORMay 18, 1972 · N5719P · Substantial damage NTSB SEA72FYC41Accident · Serious injuriesClosedInterstate S-1A · Cascade Lock, ORMay 14, 1972 · N37216 · Destroyed NTSB SEA72DYA34Accident · No injuriesClosedCessna 172H · Ontario, ORMay 13, 1972 · N2626L · 2 aircraft · Substantial damage NTSB SEA72FYI22Accident · No injuriesClosedCessna 172 · Klamath Flls, ORMay 11, 1972 · N84271 · Substantial damage NTSB SEA72FYC40Accident · No injuriesClosedPiper PA-12 · Oregon City, ORMay 5, 1972 · N2954M · Substantial damage NTSB SEA72FYC39Accident · No injuriesClosedMooney M20F · Tigard, ORMay 3, 1972 · N9590M · Substantial damage NTSB SEA72DYI20Accident · Minor injuriesClosedCessna 140 · Bend, ORApr 29, 1972 · N73079 · Substantial damage NTSB SEA72DYC37Accident · No injuriesClosedPiper PA-28 · Hillsboro, ORApr 26, 1972 · N1683J · Substantial damage NTSB SEA72DYA31Accident · No injuriesClosedBoeing A75 · Harper, ORApr 26, 1972 · N56236 · Substantial damage NTSB SEA72DYI21Accident · Minor injuriesClosedCessna 172K · North Bend, ORApr 25, 1972 · N84196 · Destroyed