Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 SEA68F0233Accident · No injuriesClosedCessna 182C · Springfield, ORDec 16, 1967 · N8900T · Substantial damage NTSB SEA68F0220Accident · No injuriesClosedCessna 170B · Prineville, ORNov 14, 1967 · N2732D · Substantial damage NTSB SEA68D0229Accident · No injuriesClosedCessna 182 · Forest Grove, ORNov 8, 1967 · N5700B · Substantial damage NTSB SEA68D0214Accident · No injuriesClosedLuscombe 8E · Ridgefield, ORNov 6, 1967 · N2543K · Substantial damage NTSB SEA68F0239Accident · Minor injuriesClosedCessna 140 · Newberg, ORNov 5, 1967 · N81034N · Destroyed NTSB SEA68A0040Accident · 2 fatalClosedStinson 108-2 · Tigard, ORNov 5, 1967 · N963D · Substantial damage NTSB SEA68D0198Accident · No injuriesClosedStinson 108 · Enterprise, ORNov 4, 1967 · N97408 · Substantial damage NTSB SEA68A0041Accident · 1 fatalClosedHughes 269B · Imnaha, ORNov 2, 1967 · N9426F · Destroyed NTSB SEA68A0037Accident · 1 fatalClosedCessna 180 · Roseburg, OROct 30, 1967 · N2478C · Destroyed NTSB SEA68A0036Accident · Minor injuriesClosedCessna U206 · Glendale, OROct 21, 1967 · N3484L · Destroyed NTSB SEA68A0035Accident · 1 fatalClosedCessna 182B · Colton, OROct 21, 1967 · N7118E · Destroyed NTSB SEA68D0215Accident · No injuriesClosedPiper J3C-65 · Bonanza, OROct 19, 1967 · N6832H · Substantial damage NTSB SEA68F0228Accident · No injuriesClosedCessna 172 · Yamhill, OROct 16, 1967 · N1621F · Substantial damage NTSB SEA68F0206Accident · No injuriesClosedCessna 172 · Newberg, OROct 11, 1967 · N3843R · Substantial damage NTSB SEA68D0202Accident · No injuriesClosedCessna 172 · Vernonia, OROct 7, 1967 · N7642X · Substantial damage NTSB SEA68D0219Accident · Minor injuriesClosedTaylorcraft BL-12 · Sandy, ORSep 26, 1967 · N34036 · Destroyed NTSB SEA68D0193Accident · No injuriesClosedTravel Air C-4000 · Camas Valley, ORSep 20, 1967 · N379M · Substantial damage NTSB SEA68D0207Accident · No injuriesClosedPiper PA-28 · Albany, ORSep 19, 1967 · N7349W · Substantial damage NTSB SEA68F0173Incident · Minor injuriesClosedBeech A23 · Woodburn, ORSep 18, 1967 · CF-VVH · Destroyed NTSB SEA68D0204Accident · No injuriesClosedCessna 150 · Independence, ORSep 17, 1967 · N3097J · Substantial damage NTSB SEA68A0027Accident · 1 fatalClosedCessna 172 · Portland, ORSep 16, 1967 · N5907A · Destroyed NTSB SEA68D0216Accident · No injuriesClosedPiper PA-24 · Bandon, ORSep 14, 1967 · N8899P · Destroyed NTSB SEA68D0192Accident · No injuriesClosedGlobe GC-1B · Warrenton, ORSep 12, 1967 · N2384B · Substantial damage NTSB SEA68D0190Accident · No injuriesClosedBeech 65 · Warrenton, ORSep 9, 1967 · N831Q · Substantial damage NTSB SEA68F0131Accident · Serious injuriesClosedChampion 7KCAB · North Bend, ORSep 6, 1967 · N2728G · Substantial damage NTSB SEA68D0161Accident · No injuriesClosedPiper PA-28 · Lapine, ORSep 4, 1967 · N7154R · Substantial damage NTSB SEA68A0024Accident · 1 fatalClosedAero Comdr 680 · Portland, ORSep 4, 1967 · N6809S · No damage NTSB SEA68F0231Accident · No injuriesClosedPiper PA-28 · Salem, ORSep 3, 1967 · N6049W · Substantial damage NTSB SEA68D0188Accident · No injuriesClosedCessna 175 · Medford, ORSep 3, 1967 · N7277M · Substantial damage NTSB SEA68D0091Accident · Minor injuriesClosedPiper PA-18 · Imnaha, ORSep 2, 1967 · N7533K · Destroyed NTSB SEA68A0022Accident · Serious injuriesClosedEnstrom F-28 · Santiam Jct, ORSep 2, 1967 · N192E · Destroyed NTSB SEA68F0200Accident · Serious injuriesClosedCessna 210 · Gold Beach, ORSep 1, 1967 · N9461T · Substantial damage NTSB SEA68D0184Accident · No injuriesClosedMooney M20C · Salem, ORSep 1, 1967 · N9336M · Substantial damage NTSB SEA68F0182Accident · No injuriesClosedBellanca 14-13 · Aurora, ORAug 28, 1967 · N74325 · Substantial damage NTSB SEA68D0179Accident · No injuriesClosedCessna 150G · Wasco, ORAug 27, 1967 · N3292J · Substantial damage NTSB SEA68F0126Accident · No injuriesClosedCessna 185 · Pendleton, ORAug 25, 1967 · N9931X · Substantial damage NTSB SEA68F0130Accident · No injuriesClosedBeech A23 · Portland, ORAug 23, 1967 · N2374W · Substantial damage NTSB SEA68D0171Accident · No injuriesClosedCessna 150G · North Bend, ORAug 23, 1967 · N4024J · Substantial damage NTSB SEA68A0019Accident · 3 fatalClosedMooney M20F · Albany, ORAug 20, 1967 · N2979L · Destroyed NTSB SEA68F0169Accident · No injuriesClosedCessna 182J · Halsey, ORAug 19, 1967 · N3084F · Substantial damage NTSB SEA68D0189Accident · Minor injuriesClosedPiper PA-22 · Aurora, ORAug 18, 1967 · N4546A · Substantial damage NTSB SEA68D0172Accident · No injuriesClosedPiper PA-24 · Klamath Fall, ORAug 17, 1967 · N6097P · Substantial damage NTSB SEA68F0170Accident · No injuriesClosedErco 415-C · Crabtree, ORAug 16, 1967 · N99785 · Substantial damage NTSB SEA68D0167Accident · Serious injuriesClosedPiper PA-22 · Creswell, ORAug 15, 1967 · N7153D · No damage NTSB SEA68F0106Accident · No injuriesClosedCessna 172 · Pendleton, ORAug 12, 1967 · N6091R · Substantial damage NTSB SEA68D0168Accident · No injuriesClosedCessna 310 · Aurora, ORAug 12, 1967 · N1110Q · Substantial damage NTSB SEA68D0195Accident · No injuriesClosedMaule M-4 · Scappoose, ORAug 8, 1967 · N4132C · Substantial damage NTSB SEA68D0102Accident · No injuriesClosedCessna 172 · Gates, ORAug 7, 1967 · N3739F · Substantial damage NTSB SEA68D0099Accident · No injuriesClosedGrumman G-21A · Sandy, ORAug 5, 1967 · N640 · Substantial damage NTSB SEA68F0205Accident · No injuriesClosedPiper PA-24 · Coos Bay, ORAug 3, 1967 · N5994P · Substantial damage