Final NTSB investigations, OR

6 cases where the defining event was Collision with terr/obj (non-CFIT).

Cases per year

20092026
Final NTSB investigations, OR per year, 2009–2026: 6 cases
20091
20101
20201
20211
20231
20251

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 c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
  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 WPR25LA103Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe unmanned aircraft system’s failure to maintain clearance from an obstacle, which resulted in a loss of control and impact with terrain.Feb 21, 2025 · N265PA · Substantial damageNTSB WPR24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · The Dalles, ORThe pilot’s encounter with severe turbulence at night which resulted in an extended downwind and collision with wires during the base turn.Oct 20, 2023 · N6308Q · Substantial damageNTSB WPR21LA252Accident · No injuriesClass 4 · LimitedFinal reportSilverLight AR-1 · Lakeside, ORThe pilot’s inadequate decision to continue the takeoff after sufficient airspeed was not attained and his failure to maintain aircraft control while maneuvering to avoid obstructions, which resulted in a collision with the ground.Jun 29, 2021 · N159WT · Substantial damageNTSB ANC21LA007Accident · 2 fatalClass 3 · LimitedFinal reportCessna 150L · Colton, ORThe pilot’s failure to maintain positive control of the airplane in mountainous terrain during dark night conditions as a result of spatial disorientation which led to a loss of control and subsequent impact with terrain.Nov 16, 2020 · N18666 · DestroyedNTSB WPR10CA470Accident · No injuriesData collectionFinal reportBell 47G · Gaston, ORThe pilot's failure to maintain tail rotor clearance while landing on a transport trailer positioned on an uneven surface.Sep 26, 2010 · N7860S · Substantial damageNTSB WPR09LA426Accident · Minor injuriesLimited investigationFinal reportSix-Chuter American Spirit · Brownsville, ORThe pilot's failure to maintain clearance from power lines.Aug 29, 2009 · N9184F · Substantial damage