Skip to content

NTSB investigations, 1968, OR

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 SEA69D0181Accident · No injuriesClosedHiller UH-12E · Brightwood, ORDec 21, 1968 · N3820 · Substantial damage NTSB SEA69A0037Accident · 1 fatalClosedCessna TU206A · Troutdale, ORDec 18, 1968 · N29145 · Destroyed NTSB SEA69A0036Accident · 1 fatalClosedAero Comdr 500-B · Imnaha, ORDec 18, 1968 · N5080 · Destroyed NTSB SEA69D0177Accident · No injuriesClosedMooney M20E · Albany, ORDec 8, 1968 · N9336M · Substantial damage NTSB SEA69A0034Accident · 3 fatalClosedPiper PA-28 · Vernonia, ORDec 8, 1968 · N6382R · Destroyed NTSB SEA69D0176Accident · No injuriesClosedCessna 150 · Chemult, ORDec 2, 1968 · N6915S · Substantial damage NTSB OAK69A0030Accident · 1 fatalClosedPiper PA-28 · Durkee, ORNov 10, 1968 · N7273W · Substantial damage NTSB SEA69D0167Accident · No injuriesClosedPiper PA-22 · Cascade Locks, ORNov 9, 1968 · N4512A · Substantial damage NTSB SEA69F0163Accident · No injuriesClosedPiper PA-16 · Oregon City, OROct 27, 1968 · N6855K · Substantial damage NTSB OAK69A0022Accident · 3 fatalClosedMooney M20F · Cotage Grove, OROct 17, 1968 · N78889 · Destroyed NTSB SEA69F0147Accident · No injuriesClosedMooney M-18LA · Mount Angel, OROct 16, 1968 · N4097 · Substantial damage NTSB SEA69I0023Incident · No injuriesClosedPiper PA-31 · Portland, OROct 8, 1968 · N1132 · Minor damage NTSB SEA69D0162Accident · No injuriesClosedCessna 172 · Tillamook, OROct 8, 1968 · N7100T · Substantial damage NTSB SEA69A0022Accident · 2 fatalClosedN.American AT-6C · Veneta, OROct 2, 1968 · N5186V · Destroyed NTSB SEA69D0132Accident · Minor injuriesClosedCessna 172 · Lakeview, ORSep 29, 1968 · N6352E · Substantial damage NTSB SEA69D0160Accident · No injuriesClosedCessna 140 · Mulino, ORSep 27, 1968 · N2497N · Substantial damage NTSB SEA69D0156Accident · No injuriesClosedMooney M18C · Portland, ORSep 20, 1968 · N4094 · Destroyed NTSB SEA69D0169Accident · No injuriesClosedPiper PA-28 · Gov Camp, ORSep 19, 1968 · N6598W · Destroyed NTSB SEA69A0021Accident · 4 fatalClosedNavion A · Sweet Home, ORSep 14, 1968 · N8552H · Destroyed NTSB SEA69F0131Accident · No injuriesClosedCessna 172G · Sublimity, ORSep 7, 1968 · N4121L · Substantial damage NTSB SEA69F0126Accident · Minor injuriesClosedCessna 172G · Canyon City, ORSep 7, 1968 · N5784R · Destroyed NTSB SEA69A0015Accident · 2 fatalClosedPiper PA-28 · Dorena, ORAug 26, 1968 · N5385L · Destroyed NTSB SEA69F0120Accident · Minor injuriesClosedBeech B35 · Hillsboro, ORAug 21, 1968 · N5241C · Substantial damage NTSB SEA69D0119Accident · No injuriesClosedCessna 120 · Waldport, ORAug 16, 1968 · N72560 · Substantial damage NTSB SEA69F0118Accident · No injuriesClosedPiper PA-28 · Winchestr By, ORAug 15, 1968 · N4472J · Substantial damage NTSB SEA69F0143Accident · No injuriesClosedCessna 185 · Portland, ORAug 9, 1968 · N9808X · Substantial damage NTSB SEA69D0110Accident · Minor injuriesClosedPiper PA-22 · Reedsport, ORAug 7, 1968 · N4917Z · Substantial damage NTSB SEA69D0078Accident · Minor injuriesClosedStory Mark 7 · Salem, ORAug 5, 1968 · N1269 · Substantial damage NTSB SEA69F0152Accident · 1 fatalClosedBensen B-8M · Midland, ORJul 27, 1968 · NNONE · Substantial damage NTSB SEA69F0076Accident · No injuriesClosedPiper J5A · Beaverton, ORJul 23, 1968 · N35692 · Substantial damage NTSB SEA69F0102Accident · Serious injuriesClosedCessna 172 · Klamath Falls, ORJul 20, 1968 · N5672T · Destroyed NTSB SEA69D0077Accident · Minor injuriesClosedCessna 172H · Union Creek, ORJul 18, 1968 · N8829Z · Destroyed NTSB SEA69A0004Accident · 1 fatalClosedCessna 170A · Hermiston, ORJul 15, 1968 · N9747A · Destroyed NTSB SEA69F0072Accident · 1 fatalClosedSmith-Mini DSA-1 · Hubbard, ORJul 14, 1968 · N65B · Destroyed NTSB SEA69F0073Accident · Serious injuriesClosedCessna 150 · The Dalles, ORJul 12, 1968 · N22872 · Destroyed NTSB SEA69F0105Accident · Minor injuriesClosedStinson 108-1 · Ten Mile, ORJul 7, 1968 · N8510K · Destroyed NTSB SEA69D0054Accident · No injuriesClosedNo.American P-51 · Medford, ORJul 7, 1968 · N66111 · Destroyed NTSB SEA69A0002Accident · 2 fatalClosedMooney M20F · Cascadia, ORJul 4, 1968 · N9527M · Destroyed NTSB SEA69F0051Accident · Minor injuriesClosedCessna 177 · Sweethome, ORJul 1, 1968 · N3172T · Destroyed NTSB SEA69D0068Accident · No injuriesClosedRepublic RC-3 · The Dalles, ORJun 30, 1968 · N6272K · Substantial damage NTSB SEA69D0042Accident · Minor injuriesClosedCessna 150 · Halfway, ORJun 28, 1968 · N22499 · Substantial damage NTSB SEA69F0007Accident · No injuriesClosedCessna A188 · Adrian, ORJun 26, 1968 · N9771V · No damage NTSB SEA69F0024Accident · No injuriesClosedHughes 269A · Medford, ORJun 23, 1968 · N8711F · Substantial damage NTSB SEA69D0028Accident · No injuriesClosedMooney M20C · Jefferson, ORJun 16, 1968 · N3487X · Substantial damage NTSB SEA69D0027Accident · No injuriesClosedBeech 35-B33 · Albany, ORJun 15, 1968 · N1396Z · Substantial damage NTSB SEA69F0025Accident · No injuriesClosedBrantly B-2 · Albany, ORJun 13, 1968 · N5963X · Substantial damage NTSB SEA69F0064Accident · No injuriesClosedPiper PA-20 · Redmond, ORJun 8, 1968 · N7725K · Substantial damage NTSB SEA69D0050Accident · No injuriesClosedCessna 150 · Springfield, ORMay 31, 1968 · N6716F · Substantial damage NTSB SEA69D0045Accident · No injuriesClosedPiper PA-18 · Carver, ORMay 27, 1968 · N5881D · Substantial damage NTSB SEA69D0058Accident · No injuriesClosedBeech 23 · Eugene, ORMay 23, 1968 · N2329L · Substantial damage