Skip to content

NTSB investigations, 1976, 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, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 SEA77FYC12Accident · No injuriesClosedCessna TU206D · Farmington, ORDec 30, 1976 · N72160 · Substantial damage NTSB SEA77FYI03Accident · Minor injuriesClosedGrum Amer AA1-B · Medford, ORNov 30, 1976 · N9699L · Substantial damage NTSB SEA77DYI02Accident · Minor injuriesClosedAeronca 7AC · Bandon, ORNov 26, 1976 · N82041 · Substantial damage NTSB SEA77FA007Accident · 4 fatalClosedPiper PA-28R · Kimberly, ORNov 25, 1976 · N15634 · Destroyed NTSB SEA77DYC08Accident · No injuriesClosedLuscombe 8A · Mitchell, ORNov 25, 1976 · CF-VEX · Substantial damage NTSB SEA77FYC07Accident · No injuriesClosedCessna 150 · Sheridan, ORNov 18, 1976 · N3998U · Substantial damage NTSB SEA77DYC06Accident · No injuriesClosedCessna 172F · Baker, ORNov 14, 1976 · N8787U · Substantial damage NTSB SEA77FA005Accident · 2 fatalClosedCessna 172 · Pendleton, ORNov 9, 1976 · N5789A · Destroyed NTSB SEA77DYC09Accident · Minor injuriesClosedCessna 150 · Cornelius, ORNov 7, 1976 · N60855 · Substantial damage NTSB SEA77FYC05Accident · Minor injuriesClosedPiper PA-28 · Mulino, ORNov 6, 1976 · N95310 · Substantial damage NTSB SEA77FYC04Accident · No injuriesClosedFunk B85C · Portland, ORNov 4, 1976 · N77705 · Substantial damage NTSB SEA77DYC03Accident · Serious injuriesClosedPiper PA-24 · Oregon City, OROct 31, 1976 · N5090P · Substantial damage NTSB SEA77DYC02Accident · No injuriesClosedPiper PA-32 · Condon, OROct 12, 1976 · N8631N · Substantial damage NTSB SEA77DYC01Accident · No injuriesClosedCessna 150 · Lebanon, OROct 10, 1976 · N150FW · Substantial damage NTSB SEA77FA002Accident · 1 fatalClosedGlobe GC-1B · Hood River, OROct 9, 1976 · N80915 · Destroyed NTSB SEA77DYI01Accident · No injuriesClosedCessna 120 · Crane, OROct 2, 1976 · N77407 · Substantial damage NTSB SEA76FYC71Accident · No injuriesClosedCessna 320E · Hillsboro, ORSep 30, 1976 · N3472Q · Substantial damage NTSB SEA76FYI24Accident · Minor injuriesClosedPiper J-3 · Salt Crk Falls, ORSep 19, 1976 · N8360H · Substantial damage NTSB SEA76AS076Accident · 2 fatalClosedUniversal GC-1B · Mckenzie Brdg, ORSep 8, 1976 · N80826 · Destroyed NTSB SEA76DYC68Accident · No injuriesClosedTaylorcraft BC12-D · Oregon City, ORSep 6, 1976 · N5071M · Substantial damage NTSB SEA76DYIIOAccident · No injuriesClosedCessna 150 · Roseburg, ORSep 2, 1976 · N11758 · Substantial damage NTSB SEA76DYC69Accident · No injuriesClosedChampion 7ECA · Wallowa, ORSep 2, 1976 · N11063 · Substantial damage NTSB SEA76FYC67Accident · No injuriesClosedBeech 35 · Gervais, ORAug 25, 1976 · N3203V · Substantial damage NTSB SEA76AS069Accident · 1 fatalClosedMooney M20C · Portland, ORAug 11, 1976 · N9116V · Destroyed NTSB SEA76DYC65Accident · No injuriesClosedPiper PA-24 · Madras, ORJul 19, 1976 · N7610P · Substantial damage NTSB SEA76FYC64Accident · No injuriesClosedBeech D55 · Hillsboro, ORJul 12, 1976 · N73681 · Substantial damage NTSB SEA76DYI22Accident · No injuriesClosedPiper PA-23 · Lakeview, ORJul 12, 1976 · N3154P · Substantial damage NTSB SEA76DYI20Accident · No injuriesClosedStearman PT-17 · Frenchelenn, ORJul 11, 1976 · N9182Z · Substantial damage NTSB SEA76FYC62Accident · Serious injuriesClosedCessna 172M · Albany, ORJul 5, 1976 · N1381U · Substantial damage NTSB SEA76FYC61Accident · Serious injuriesClosedFairchild 24W-46 · Oregon City, ORJul 5, 1976 · N77602 · Substantial damage NTSB SEA76FYC63Accident · Minor injuriesClosedPietenpol S.A.M. · Albany, ORJul 2, 1976 · N5748 · Substantial damage NTSB SEA76AS058Accident · 1 fatalClosedHughes 369HS · Tygh Valley, ORJun 28, 1976 · N9123F · Destroyed NTSB SEA76AS057Accident · 1 fatalClosedCessna 150L · Clatskanie, ORJun 28, 1976 · N19310 · Destroyed NTSB SEA76DYC59Accident · Serious injuriesClosedCessna 150M · Brightwood, ORJun 27, 1976 · N45611 · Destroyed NTSB SEA76FYI21Accident · No injuriesClosedAeronca 65C · Elmira, ORJun 26, 1976 · N22116 · Substantial damage NTSB SEA76FYC60Accident · No injuriesClosedCessna 150L · Oregon City, ORJun 25, 1976 · N10297 · Substantial damage NTSB SEA76AS056Accident · 4 fatalClosedCessna 170 · Medford, ORJun 20, 1976 · N3945V · Destroyed NTSB SEA76DYI19Accident · Minor injuriesClosedPiper J-3 · Central Point, ORJun 19, 1976 · N40618 · Substantial damage NTSB SEA76DYC58Accident · Serious injuriesClosedBell 47G-4A · Lostine, ORJun 15, 1976 · N7945S · Destroyed NTSB SEA76FYC57Accident · Minor injuriesClosedCessna A188A · Moiser, ORJun 14, 1976 · N9965G · Substantial damage NTSB SEA76FYC56Accident · No injuriesClosedBeers-Baird AMFS14 · Carver, ORJun 13, 1976 · N75LB · Substantial damage NTSB SEA76DYC55Accident · No injuriesClosedCessna T210L · Mcminnville, ORJun 12, 1976 · N29176 · Substantial damage NTSB SEA76AS053Accident · 1 fatalClosedCessna 182P · Klamath Falls, ORJun 4, 1976 · N7466Q · No damage NTSB SEA76DYI18Accident · No injuriesClosedPiper PA-32 · Bend, ORJun 3, 1976 · N15326 · Substantial damage NTSB SEA76FYI17Accident · Serious injuriesClosedAmer Avco AA1 · Ashland, ORMay 31, 1976 · N6156L · Destroyed NTSB SEA76FYC54Accident · Serious injuriesClosedPiper PA-25 · Rickreall, ORMay 26, 1976 · N7436Z · Substantial damage NTSB SEA76FYC53Accident · No injuriesClosedCessna 172 · Aurora, ORMay 24, 1976 · N5375R · Substantial damage NTSB SEA76FYC51Accident · No injuriesClosedPiper PA-28 · Aurora, ORMay 18, 1976 · N4292T · Substantial damage NTSB SEA76FYC49Accident · Minor injuriesClosedEnstrom F-28A · Prairie City, ORMay 17, 1976 · N530H · Substantial damage NTSB SEA76FYC52Accident · No injuriesClosedMaule M4210C · Aurora, ORMay 16, 1976 · N984OM · Substantial damage