NTSB investigations, 1995, OR

6 cases where the first occurrence was “In flight collision with object”.

Cases per year

19822026
NTSB investigations, 1995, OR per year, 1982–2026: 130 cases
198212
19836
19844
19854
19866
19873
19885
19895
19903
19915
19928
19935
19946
19956
19968
19979
19982
19994
20007
20015
20022
20036
20043
20053
20061
20072

Latest cases

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\") = 1995
    AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
  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 SEA96LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacific City, ORThe pilot's delay in aborting the landing, which resulted in his failure to clear the perimeter fence. Factors relating to the accident were: the tailwind, and the pilot's failure to land at the proper touchdown point.Dec 24, 1995 · N738ME · Substantial damageNTSB SEA95LA191Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Nyssa, ORthe pilot's inadequate ground reconnaissance.Aug 23, 1995 · N146KY · Substantial damageNTSB SEA95LA110Accident · 1 fatalLimited investigationFinal reportGarlick TH-1L · Umpqua, ORThe pilot's failure to maintain clearance with a tree, resulting in a tail rotor blade strike on the tree which disabled the tail rotor. Contributing to the accident was the 150-foot-high rock bluff.Jun 1, 1995 · N27FL · Substantial damageNTSB SEA95LA068Accident · No injuriesLimited investigationFinal reportBell 230 · Portland, ORThe pilot-in-command's failure to maintain clearance from the perimeter fence while landing. A factor was the heliport perimeter fence.Mar 7, 1995 · N230LF · Substantial damageNTSB SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.Feb 18, 1995 · N115EZ · Substantial damageNTSB SEA95LA039Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · La Grande, ORFailure of the pilot to maintain proper altitude/clearance from higher terrain that was located near the airport. Factors related to the accident were: low ceiling, fog, false/incorrect indication of the NDB, failure of other personnel to properly issue a…Jan 21, 1995 · N36PB · Substantial damage