# NTSB investigations, OR: Maneuvering

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 10 · 482 cases

## Latest cases

- [NTSB WPR26LA352](https://openairdocs.org/ntsb/WPR26LA352.md): Beech B95 · Newport, OR · Accident · 1 fatal · Class 4 · Limited · Investigation open · Sep 21, 2026 · N529RB
- [NTSB WPR26FA320](https://openairdocs.org/ntsb/WPR26FA320.md): Mooney M20C · Mount Hood, OR · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 31, 2026 · N2783W · Substantial damage
  > On August 31, 2026, about 1131 Pacific daylight time, a Mooney M20C, N2783W, was destroyed when it was involved in an accident near Hood River, Oregon. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR26LA312](https://openairdocs.org/ntsb/WPR26LA312.md): Schweizer G-164B · Olene, OR · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 20, 2026 · N7501Q · Destroyed
  > On August 20, 2026, about 9:32 Pacific daylight time, a Schweizer Aircraft Corp., G-164B, N7501Q, was destroyed when it was involved in an accident near Orlene, Oregon. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26FA289](https://openairdocs.org/ntsb/WPR26FA289.md): Cirrus Design SR22T · Bend, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 5, 2026 · N625LK · Substantial damage
  > On August 4, 2026, at about 1845 Pacific daylight time, a Cirrus Design Corporation SR22T airplane, N625LK, was substantially damaged when it was involved in an accident near Bend, Oregon. The pilot was fatally injured. The airplane was operated as Title 14…
- [NTSB WPR25LA034](https://openairdocs.org/ntsb/WPR25LA034.md): Robinson Helicopter R44 II · Durkee, OR · Accident · No injuries · Class 3 · Limited · Final report · Nov 7, 2024 · N4361R · Substantial damage
  > The pilot's inadequate performance planning, which resulted in insufficient engine power to transition into an out-of-ground-effect hover at a high gross weight.
- [NTSB WPR25LA010](https://openairdocs.org/ntsb/WPR25LA010.md): Enstrom Helicopter 280C · Vale, OR · Accident · No injuries · Class 4 · Limited · Final report · Oct 9, 2024 · N646H · Substantial damage
  > The pilot’s failure to maintain engine and rotor rpm during takeoff, that resulted in a hard landing.
- [NTSB WPR24FA255](https://openairdocs.org/ntsb/WPR24FA255.md): Air Tractor AT-802A · Izee, OR · Accident · 1 fatal · Class 3 · Field · Final report · Jul 26, 2024 · N805DG · Substantial damage
  > The pilot’s controlled flight into terrain while maneuvering through an area of low visibility due to wildfire smoke and haze.
- [NTSB WPR24FA104](https://openairdocs.org/ntsb/WPR24FA104.md): Kolb Firestar KXP · Cave Junction, OR · Accident · 1 fatal · Class 3 · Field · Final report · Mar 7, 2024 · N4443G · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's use of potentially impairing substances with bipolar disorder, which resulted in a decreased…
- [NTSB WPR24LA036](https://openairdocs.org/ntsb/WPR24LA036.md): Bell OH-58A · Estacada, OR · Accident · No injuries · Class 4 · Limited · Final report · Nov 15, 2023 · N103WC · Substantial damage
  > The pilot’s failure to maintain helicopter control during an external load operation, which resulted in the helicopter’s main rotor blades impacting the tail boom.
- [NTSB WPR24FA004](https://openairdocs.org/ntsb/WPR24FA004.md): Piper PA-44-180 · Newberg, OR · Accident · 2 fatal · Class 3 · Field · Final report · Oct 4, 2023 · N8360K · Substantial damage
  > The pilot receiving instruction’s failure to maintain control of the airplane and the flight instructor’s inadequate supervision of the flight, which resulted in a stall/spin from which they were unable to recover.
- [NTSB WPR23LA255](https://openairdocs.org/ntsb/WPR23LA255.md): Avia Stroitel AC-5M · North Plains, OR · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 5, 2023 · N40233 · Substantial damage
  > The pilot’s failure to maintain control of the motor glider, which resulted in an inflight overstress separation of the right wing during a high-speed, high-wing-load spiral dive recovery. Contributing to the accident was the inadequately manufactured wing…
- [NTSB WPR23LA097](https://openairdocs.org/ntsb/WPR23LA097.md): Kaman Aerospace K-1200 · Sweet Home, OR · Accident · No injuries · Class 3 · Limited · Final report · Jan 24, 2023 · N202WM · Substantial damage
  > Improper installation of the hardware retaining the adjustment screw in the N2 topping governor lever and roller assembly, which resulted in a partial loss of engine power.
- [NTSB WPR22LA364](https://openairdocs.org/ntsb/WPR22LA364.md): Schleicher ASW-20 · Hood River, OR · Accident · No injuries · Class 4 · Limited · Final report · Sep 29, 2022 · N220CW · Substantial damage
  > The pilot’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.
- [NTSB WPR22FA312](https://openairdocs.org/ntsb/WPR22FA312.md): Jackson Dennis RV-8 · Scio, OR · Accident · 2 fatal · Class 3 · Field · Final report · Aug 21, 2022 · N184DJ · Substantial damage
  > The pilot’s decision to perform a low-altitude aerobatic maneuver and his improper execution of the maneuver, which resulted in impact with terrain.
- [NTSB WPR22LA045](https://openairdocs.org/ntsb/WPR22LA045.md): Elvin Jack R JR Rotorway Exec 162F · Scio, OR · Accident · No injuries · Class 4 · Limited · Final report · Nov 22, 2021 · N102LD · Substantial damage
  > The pilot’s improper maintenance on the tail rotor assembly, which resulted in the loss of control and roll over.
- [NTSB WPR21LA338](https://openairdocs.org/ntsb/WPR21LA338.md): Bell 206L-3 · Tillamook, OR · Accident · No injuries · Class 4 · Limited · Final report · Sep 8, 2021 · N6516K · Substantial damage
  > The pilot's failure to maintain clearance from a powerline during a low reconnaissance, with sun glare.
- [NTSB WPR21LA333](https://openairdocs.org/ntsb/WPR21LA333.md): Bell Helicopter Textron 206L-1 · Glide, OR · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 27, 2021 · N303AE · Substantial damage
  > The pilot’s failure to maintain clearance from a tree during an aerial application.
- [NTSB WPR21FA265](https://openairdocs.org/ntsb/WPR21FA265.md): North Wing Mustang · Albany, OR · Accident · 2 fatal · Class 3 · Field · Final report · Jul 10, 2021 · UNREG · Substantial damage
  > The noncertificated pilot’s loss of aircraft control after a low-level turn with a bank angle that exceeded the manufacturer’s operating limitations.
- [NTSB WPR21LA061](https://openairdocs.org/ntsb/WPR21LA061.md): Cessna 172 · Arch Cape, OR · Accident · 1 fatal · Class 4 · Limited · Final report · Nov 9, 2020 · N1444V · Destroyed
  > The pilot’s descent into the ocean for reasons that could not be determined.
- [NTSB WPR21LA008](https://openairdocs.org/ntsb/WPR21LA008.md): Cessna 180 · Princeton, OR · Accident · No injuries · Class 3 · Limited · Final report · Oct 2, 2020 · N8678X · Substantial damage
  > The pilot’s failure to enrichen the mixture, which resulted in a partial loss of engine power.
- [NTSB WPR20LA224](https://openairdocs.org/ntsb/WPR20LA224.md): Hiller UH 12D · Mehama, OR · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 17, 2020 · N2297W · Destroyed
  > An in-flight separation of a tail rotor blade due to fatigue cracking and overstress, which resulted in a loss of directional control and subsequent ground impact.
- [NTSB WPR20FA016](https://openairdocs.org/ntsb/WPR20FA016.md): Enstrom 280F · Jordan Valley, OR · Accident · 1 fatal · Class 3 · Field · Final report · Oct 25, 2019 · N280F · Substantial damage
  > A partial loss of engine power due to a worn engine air induction hose, and a subsequent uncontrolled descent into terrain. Contributing to the accident was the failure of maintenance personnel to adequately inspect the hose, and the pilot’s decision to fly…
- [NTSB WPR19LA217](https://openairdocs.org/ntsb/WPR19LA217.md): Cessna 206 · Prospect, OR · Accident · No injuries · Class 3 · Limited · Final report · Aug 10, 2019 · N5152U · Substantial damage
  > The failure of the counterweight retainer pin plate which resulted in a total loss of engine power.
- [NTSB WPR19FA159](https://openairdocs.org/ntsb/WPR19FA159.md): Titan Titan II · Summerville, OR · Accident · 1 fatal · Class 3 · Field · Final report · Jun 5, 2019 · N4362V · Destroyed
  > The noncertificated pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall/spin and impact with terrain.
- [NTSB WPR19FA143](https://openairdocs.org/ntsb/WPR19FA143.md): Top Dog TopDog Ultralight · Creswell, OR · Accident · 1 fatal · Class 3 · Field · Final report · May 12, 2019 · UNREG · Substantial damage
  > The non-certificated pilot's loss of control while maneuvering. Contributing to the accident was his lack of training in the aircraft and his impairment from illicit drugs.
- [NTSB WPR19LA122](https://openairdocs.org/ntsb/WPR19LA122.md): Bell 206 · Oakridge, OR · Accident · No injuries · Class 3 · Limited · Final report · Apr 26, 2019 · N206JH · Substantial damage
  > A total loss of engine power following the failure of a 3rd stage turbine blade due to low- and high-cycle fatigue.
- [NTSB WPR19FA116](https://openairdocs.org/ntsb/WPR19FA116.md): Vans RV8 · Brookings, OR · Accident · 2 fatal · Class 3 · Field · Final report · Apr 18, 2019 · N791PF · Substantial damage
  > The pilot’s failure to maintain aircraft control during an aggressive maneuver that resulted in a nose down collision with terrain.
- [NTSB WPR19FA077](https://openairdocs.org/ntsb/WPR19FA077.md): Rockwell 112 · Mt Hood, OR · Accident · 1 fatal · Class 2 · Field · Final report · Jan 25, 2019 · N1332J · Destroyed
  > The pilot's decision to fly the airplane in close proximity to mountainous terrain in an area of mountain wave activity that exceeded the performance capabilities of the airplane. Contributing to the accident was the pilot's degraded decision making and…
- [NTSB WPR19LA071](https://openairdocs.org/ntsb/WPR19LA071.md): Bell 206 · Ashland, OR · Accident · 1 fatal · Class 3 · Limited · Final report · Jan 23, 2019 · N8227J · Substantial damage
  > The pilot's decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and spatial disorientation leading to a loss of control.
- [NTSB WPR18TA238](https://openairdocs.org/ntsb/WPR18TA238.md): Rans S14 · Brownsville, OR · Accident · Serious injuries · Class 3 · Final report · Aug 20, 2018 · N140JL · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, loss of control, and impact with terrain.
- [NTSB GAA18CA383](https://openairdocs.org/ntsb/GAA18CA383.md): Grumman Acft ENG Cor-Schweizer G 164 · Malin, OR · Accident · No injuries · Data collection · Final report · Jun 27, 2018 · N151QC · Substantial damage
  > The pilot’s misjudgment of the approach and his subsequent exceedance of the airplane’s critical angle of attack during an agricultural application flight, which resulted in an aerodynamic stall and collision with power lines.
- [NTSB WPR18LA130](https://openairdocs.org/ntsb/WPR18LA130.md): Robinson Helicopter R22 Beta · Portland, OR · Accident · Serious injuries · Class 3 · Limited · Final report · May 2, 2018 · N7526S · Substantial damage
  > A hard landing for reasons that could not be determined based on the available information.
- [NTSB GAA18CA145](https://openairdocs.org/ntsb/GAA18CA145.md): Piper PA28R · Milton-Freewater, OR · Accident · No injuries · Data collection · Final report · Feb 28, 2018 · N323MQ · Substantial damage
  > The pilot receiving instruction’s and flight instructor’s improper decision to enter a canyon surrounded by steep rising terrain and their subsequent failure to maintain clearance from terrain while maneuvering at a low altitude.
- [NTSB WPR17FA085](https://openairdocs.org/ntsb/WPR17FA085.md): Piper PA 46-310P · Harrisburg, OR · Accident · 4 fatal · Field investigation · Final report · Apr 7, 2017 · N123SB · Destroyed
  > An encounter with a downburst during an instrument approach, which resulted in a loss of control at low altitude. Contributing to the accident was the air traffic controller's failure to solicit and disseminate pilot reports from arriving and departing…
- [NTSB WPR16FA169](https://openairdocs.org/ntsb/WPR16FA169.md): Boeing A75N1(PT17) · Madras, OR · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2016 · N999PP · Destroyed
  > The pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver. Contributing to the accident was a high density altitude and the pilot's failure to plan/adequately compensate for high density altitude conditions.
- [NTSB GAA16CA213](https://openairdocs.org/ntsb/GAA16CA213.md): Robinson Helicopter R22 · Troutdale, OR · Accident · Minor injuries · Data collection · Final report · May 4, 2016 · N227SH · Substantial damage
  > The flight instructor's failure to monitor outside the helicopter during hover flight, which resulted in a collision with terrain and rollover.
- [NTSB WPR16FA087](https://openairdocs.org/ntsb/WPR16FA087.md): North American AT 6A · Astoria, OR · Accident · 2 fatal · Field investigation · Final report · Mar 23, 2016 · N7055D · Destroyed
  > The pilot's loss of aircraft control during a low-altitude ash dispersal maneuver. Contributing to the accident was his degraded performance due to his medical conditions.
- [NTSB GAA16LA100](https://openairdocs.org/ntsb/GAA16LA100.md): Enstrom F-28 · Ritter Butte, OR · Accident · Serious injuries · Limited investigation · Final report · Jan 13, 2016 · N756H · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain.
- [NTSB WPR16LA020](https://openairdocs.org/ntsb/WPR16LA020.md): Bell 206B · Dallas, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2015 · N22743 · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR15LA261](https://openairdocs.org/ntsb/WPR15LA261.md): Schweizer 269C · Forest Grove, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 2015 · N290R · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR15LA248](https://openairdocs.org/ntsb/WPR15LA248.md): Sikorsky S 61A · Ironside, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 2015 · N1043T · Substantial damage
  > A loss of power to the No. 2 engine due to the failure of the accessory gearbox drivetrain. Also causal was the pilot’s inability to release the external longline due to the use of a safety wire across the coupling of the quick-disconnect mechanism, which…
- [NTSB WPR15LA178](https://openairdocs.org/ntsb/WPR15LA178.md): Garlick Helicopters UH 1H · Cove, OR · Accident · No injuries · Limited investigation · Final report · May 31, 2015 · N462CC · Substantial damage
  > The failure of the engine-to-transmission drive shaft coupling assembly due to a fatigue fracture of one of its attachment bolts, which resulted in a loss of power to the main rotor.
- [NTSB WPR15FA161](https://openairdocs.org/ntsb/WPR15FA161.md): Bellanca 7GCBC · Juntura, OR · Accident · 1 fatal · Field investigation · Final report · May 14, 2015 · N5042P · Substantial damage
  > The pilot's failure to see and avoid power lines while intentionally maneuvering at low altitude for the aerial observation flight.
- [NTSB WPR14CA280](https://openairdocs.org/ntsb/WPR14CA280.md): Bell 47G · Gaston, OR · Accident · No injuries · Data collection · Final report · Jul 3, 2014 · N684PC · Substantial damage
  > The pilot's inability to maintain control of the helicopter as a result of a hydraulic hose becoming entangled around the right skid.
- [NTSB WPR14FA244](https://openairdocs.org/ntsb/WPR14FA244.md): Grumman American Avn. AA 5B · Florence, OR · Accident · 2 fatal · Field investigation · Final report · Jun 15, 2014 · N28718 · Destroyed
  > The noninstrument-rated pilot’s visual flight into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.
- [NTSB WPR14LA160](https://openairdocs.org/ntsb/WPR14LA160.md): Agustawestland AW109SP · Astoria, OR · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 2014 · N361CR · No damage
  > The decision by the ship pilot and the helicopter crew to lower the ship pilot to a location on the ship that did not provide the helicopter pilot with an adequate view of the ship. Contributing to the accident was the inadequate pre-mission coordination…
- [NTSB WPR14FA037](https://openairdocs.org/ntsb/WPR14FA037.md): Musick Lancair 235 · McMinnville, OR · Accident · 1 fatal · Field investigation · Final report · Oct 28, 2013 · N25DM · Substantial damage
  > The pilot's failure to maintain airplane control while intentionally performing maneuvers in an effort to troubleshoot a landing gear malfunction.
- [NTSB WPR13FA411](https://openairdocs.org/ntsb/WPR13FA411.md): Bell UH 1B · Detroit, OR · Accident · 1 fatal · Field investigation · Final report · Sep 16, 2013 · N204UH · Substantial damage
  > The fatigue failure of the upper two tailboom attachment points, which resulted in the tailboom separating from the fuselage during logging operations. Contributing to the accident was poor maintenance throughout the helicopter’s operational life.
- [NTSB WPR13FA400](https://openairdocs.org/ntsb/WPR13FA400.md): Cantrell LW Challenger II SP · Prineville, OR · Accident · 1 fatal · Field investigation · Final report · Sep 8, 2013 · N65VG · Substantial damage
  > The in-flight failure of the left elevator control torque tube. Contributing to the accident was the improper assembly of the elevator control torque tubes.
- [NTSB WPR13GA374](https://openairdocs.org/ntsb/WPR13GA374.md): Mcdonnell Douglas Helicopter 369E · Burns, OR · Accident · No injuries · Final report · Aug 12, 2013 · N62PJ · Substantial damage
  > The total loss of engine power during cruise flight due to the separation of one of the 4th-stage turbine wheel blades due to low-cycle fatigue cracking that had progressed to high-cycle fatigue cracking, which ultimately led to the overload failure of the…

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?state=OR&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?state=OR

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.