NTSB investigations, 1968, OR

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.

Cases, newest first

Query with SQL
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.

NTSB SEA69D0002Accident · No injuriesClosedCessna 182 · Pendleton, ORMay 21, 1968 · N3474R · Substantial damageNTSB SEA69F0022Accident · Minor injuriesClosedPiper PA-18 · Lowell, ORMay 10, 1968 · N9073D · Substantial damageNTSB SEA69D0056Accident · No injuriesClosedBeech A23A · Grants Pass, ORMay 8, 1968 · N2355W · Substantial damageNTSB SEA69F0019Accident · Minor injuriesClosedPiper PA-28 · Paisley, ORApr 30, 1968 · N8925J · DestroyedNTSB SEA69D0020Accident · No injuriesClosedCessna 177 · Canby, ORApr 22, 1968 · N3460T · Substantial damageNTSB SEA68D0311Accident · No injuriesClosedHughes 269B · Tigard, ORApr 20, 1968 · N9477F · Substantial damageNTSB SEA69F0009Accident · Serious injuriesClosedPiper PA-22 · Springfield, ORApr 19, 1968 · N9302D · Substantial damageNTSB SEA68F0331Accident · 1 fatalClosedCessna A188 · The Dalles, ORApr 17, 1968 · N8015V · DestroyedNTSB SEA68F0299Accident · No injuriesClosedPiper PA-22 · Hood River, ORApr 17, 1968 · N610A · Substantial damageNTSB SEA69F0089Accident · Minor injuriesClosedPiper PA-30 · Silver Lake, ORApr 16, 1968 · N7234Y · DestroyedNTSB SEA68D0282Accident · No injuriesClosedPiper PA-24 · Vale, ORApr 14, 1968 · N8852P · Substantial damageNTSB SEA68F0290Accident · No injuriesClosedCessna 172 · Bend, ORApr 7, 1968 · N7831X · Substantial damageNTSB SEA68D0305Accident · No injuriesClosedPiper PA-22 · Spray, ORApr 6, 1968 · N9672D · Substantial damageNTSB SEA68A0063Accident · 3 fatalClosedMooney M20B · Bend, ORApr 4, 1968 · N74561 · DestroyedNTSB SEA68D0307Accident · No injuriesClosedCessna 182 · Baker, ORApr 3, 1968 · N2709G · DestroyedNTSB SEA68F0289Accident · Serious injuriesClosedHiller UH-12E · Newport, ORApr 2, 1968 · N9757C · DestroyedNTSB SEA69F0010Accident · No injuriesClosedStearman PT-13 · Condon, ORMar 30, 1968 · N49377 · Substantial damageNTSB SEA69D0044Accident · No injuriesClosedCessna 172 · Ashland, ORMar 29, 1968 · N1718F · Substantial damageNTSB SEA68D0279Accident · No injuriesClosedCessna 172 · Mulino, ORMar 17, 1968 · N4197L · Substantial damageNTSB SEA68D0288Accident · No injuriesClosedPiper PA-28 · Millican, ORMar 16, 1968 · N6475W · Substantial damageNTSB SEA68D0280Accident · No injuriesClosedCulver LFA · Eugene, ORMar 16, 1968 · N41722 · Substantial damageNTSB SEA68D0285Accident · No injuriesClosedCessna 150 · Florence, ORMar 14, 1968 · N7112F · Substantial damageNTSB SEA68F0278Accident · Minor injuriesClosedCessna 150 · Dillard, ORMar 11, 1968 · N3099S · Substantial damageNTSB SEA68A0058Accident · 1 fatalClosedCessna 172G · Troutdale, ORMar 11, 1968 · N3898L · DestroyedNTSB SEA68D0271Accident · No injuriesClosedCessna 140 · Beaver Creek, ORMar 3, 1968 · N76167 · Substantial damageNTSB SEA68F0266Accident · No injuriesClosedPiper PA-22 · Crescent Lk, ORFeb 29, 1968 · N7021D · Substantial damageNTSB SEA68F0267Accident · No injuriesClosedPiper PA-22 · Gleneden Bch, ORFeb 27, 1968 · N8862C · DestroyedNTSB SEA68D0276Accident · No injuriesClosedLuscombe 8E · Progress, ORFeb 26, 1968 · N1284K · Substantial damageNTSB SEA68F0261Accident · No injuriesClosedCessna 182 · Springfield, ORFeb 11, 1968 · N2993Y · Substantial damageNTSB SEA68A0051Accident · 3 fatalClosedBeech B95 · Wilsonville, ORFeb 11, 1968 · N9657R · DestroyedNTSB SEA68F0256Accident · Serious injuriesClosedAeronca 65-CA · Ashland, ORJan 27, 1968 · N39353 · DestroyedNTSB SEA68F0272Accident · Minor injuriesClosedBeech E35 · Parkdale, ORJan 24, 1968 · N3525B · DestroyedNTSB SEA68A0048Accident · 1 fatalClosedPiper PA-24 · Medical Spgs, ORJan 15, 1968 · N7435P · DestroyedNTSB SEA68F0245Accident · No injuriesClosedCessna A188 · Central Pont, ORJan 6, 1968 · N9734V · Destroyed