Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 SEA74DYC30Accident · No injuriesClosedPiper PA-28 · Mocalla, ORDec 30, 1973 · N55620 · Substantial damage NTSB SEA74DYC29Accident · No injuriesClosedCessna 172L · La Grande, ORDec 19, 1973 · N7251Q · Substantial damage NTSB SEA74DYC31Accident · Minor injuriesClosedCallair A-5T · Siletz, ORDec 8, 1973 · N6030C · Substantial damage NTSB SEA74FYC27Accident · No injuriesClosedNavion G · Salem, ORDec 5, 1973 · N2453T · Substantial damage NTSB SEA74DYC26Accident · No injuriesClosedCessna 140 · Portland, ORDec 1, 1973 · N76006 · Substantial damage NTSB SEA74DYI09Accident · No injuriesClosedCessna 177 · North Bend, ORNov 18, 1973 · N2289Y · Substantial damage NTSB SEA74DYC24Accident · No injuriesClosedPiper PA-22 · Mosier, ORNov 17, 1973 · N5912Z · Substantial damage NTSB SEA74DYC25Accident · Serious injuriesClosedCessna 150L · Salem, ORNov 10, 1973 · N18153 · Destroyed NTSB SEA74DYC23Accident · No injuriesClosedCessna 180 · Cascade Lock, ORNov 4, 1973 · N4515B · Substantial damage NTSB SEA74FYC22Accident · No injuriesClosedPiper PA-36 · Newberg, OROct 30, 1973 · N56148 · Substantial damage NTSB SEA74FYI07Accident · Serious injuriesClosedCessna 177 · Grants Pass, OROct 28, 1973 · N34601 · Substantial damage NTSB SEA74DYC21Accident · No injuriesClosedCessna 140 · Astoria, OROct 8, 1973 · N3086N · Substantial damage NTSB SEA74DYC19Accident · Minor injuriesClosedPiper PA-28 · Colton, ORSep 30, 1973 · N2479T · Substantial damage NTSB SEA74FVC18Accident · No injuriesClosedPiper PA-28 · Salem, ORSep 26, 1973 · N5239T · Substantial damage NTSB SEA74AS016Accident · 3 fatalClosedCessna 172L · Chiloquin, ORSep 16, 1973 · N2855Q · Destroyed NTSB SEA74DYC17Accident · No injuriesClosedCessna 310H · Imnaha, ORSep 15, 1973 · N1091Q · Substantial damage NTSB SEA74DYC16Accident · Minor injuriesClosedCessna 170A · Imnaha, ORSep 15, 1973 · N9211A · Substantial damage NTSB SEA74FYC05Accident · No injuriesClosedPiper PA-28 · Yamhill, ORSep 13, 1973 · N7655J · Substantial damage NTSB SEA74FYC14Accident · No injuriesClosedBeech A23 · La Grande, ORSep 10, 1973 · N4783J · Destroyed NTSB SEA74DYC15Accident · No injuriesClosedMcculloch J-2 · Redmond, ORSep 9, 1973 · N4327G · Substantial damage NTSB SEA74AS012Accident · 3 fatalClosedPiper PA-28 · Oakridge, ORSep 3, 1973 · N4576T · Destroyed NTSB SEA74DYC13CaseClosedCessna 177 · Dallas, ORSep 1, 1973 · N34591 NTSB SEA74FYC12Accident · No injuriesClosedBeech A35 · Salem, ORAug 26, 1973 · N707B · Substantial damage NTSB SEA74AS010Accident · 1 fatalClosedCessna 150L · Pendleton, ORAug 26, 1973 · N5316Q · Destroyed NTSB SEA74AS011Accident · 2 fatalClosedPiper PA-28 · Oakridge, ORAug 21, 1973 · N6344W · Destroyed NTSB SEA74AS008Accident · 2 fatalClosedLuscombe T-8F · Cottage Grov, ORAug 21, 1973 · N2139B · Destroyed NTSB SEA74FYC06Accident · Serious injuriesClosedCessna 150L · Granite, ORAug 20, 1973 · N10865 · Substantial damage NTSB SEA74DYC11Accident · No injuriesClosedPiper PA-20 · Aurora, ORAug 18, 1973 · N1018F · Substantial damage NTSB SEA74DYC10Accident · No injuriesClosedMooney M20B · Hillsboro, ORAug 13, 1973 · N74796 · Substantial damage NTSB SEA74FYC09Accident · No injuriesClosedCessna 150 · Baker, ORAug 12, 1973 · N4827X · Substantial damage NTSB SEA74FYC07Accident · No injuriesClosedMooney M20H · Silverton, ORAug 4, 1973 · N6570B · Substantial damage NTSB SEA74FYA06Accident · No injuriesClosedErco 415-C · Jordan Vly, ORAug 1, 1973 · N2129H · Substantial damage NTSB SEA74FYC04Accident · No injuriesClosedPiper PA-28R · Yamhill, ORJul 29, 1973 · N3961T · Substantial damage NTSB SEA74FYI06Accident · No injuriesClosedCessna 140 · Klamath Fals, ORJul 28, 1973 · N72166 · Substantial damage NTSB SEA74AS005Accident · 2 fatalClosedCessna 177 · Prospect, ORJul 28, 1973 · N29472 · Destroyed NTSB SEA74AS004Accident · 2 fatalClosedCessna 175C · Pacific City, ORJul 24, 1973 · N8318T · Destroyed NTSB SEA74DYI03Accident · Minor injuriesClosedFlybaby · Bandon, ORJul 21, 1973 · N1432 · Substantial damage NTSB SEA74DYI02Accident · No injuriesClosedCessna 150J · Rogue River, ORJul 20, 1973 · N50566 · Substantial damage NTSB SEA74DYA04Accident · Serious injuriesClosedPiper PA-28 · Ironside, ORJul 20, 1973 · N7259W · Substantial damage NTSB SEA74FYI05Accident · Minor injuriesClosedBoeing PT-17 · Malin, ORJul 19, 1973 · N56941 · Substantial damage NTSB SEA74AS001Accident · 1 fatalClosedPiper PA-18 · Metolius, ORJul 15, 1973 · N1758P · Destroyed NTSB SEA74DYI01Accident · No injuriesClosedHiller FH1100 · Cave Jctn, ORJul 9, 1973 · N427FH · Substantial damage NTSB SEA74FYC01Accident · Serious injuriesClosedStory MK-7 · Monmouth, ORJul 1, 1973 · N1269 · Substantial damage NTSB SEA73AS040Accident · 3 fatalClosedPiper PA-28R · Eugene, ORJun 25, 1973 · N3841T · Destroyed NTSB SEA74DYC02Accident · No injuriesClosedCessna 310 · Hillsboro, ORJun 24, 1973 · N2661C · Substantial damage NTSB SEA73DYC39Accident · Minor injuriesClosedCessna 150G · Brightwood, ORJun 23, 1973 · N84685 · Destroyed NTSB SEA74DYI04Accident · No injuriesClosedPiper PA-25 · Burns, ORJun 22, 1973 · N7374Z · Substantial damage NTSB SEA73FYC38Accident · No injuriesClosedCessna 210D · Lagrande, ORJun 22, 1973 · N3823Y · Substantial damage NTSB SEA73FYC37Accident · Serious injuriesClosedBell 47G-3B · Warm Springs, ORJun 21, 1973 · N1324X · Destroyed NTSB SEA73AS037Accident · 2 fatalClosedAeronca O-58B · Riddle, ORJun 21, 1973 · N48661 · Destroyed