# NTSB investigations, OR: Enroute

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 14 · 695 cases

## Latest cases

- [NTSB WPR26FA068](https://openairdocs.org/ntsb/WPR26FA068.md): Beech K35 · Summer Lake, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Dec 23, 2025 · N9540R · Substantial damage
  > On December 23, 2025, about 0841 Pacific standard time, a Beech K35, N9540R, was substantially damaged when it was involved in an accident near Summer Lake, Oregon. The pilot was fatally injured. The airplane was being operated as a Title 14 Code of Federal…
- [NTSB WPR25LA267](https://openairdocs.org/ntsb/WPR25LA267.md): David Ullman Jabirwatt · Albany, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 18, 2025 · N824DW · Substantial damage
  > On August 18, 2025, about 1300 Pacific daylight time, an experimental amateur-built Jabirwatt, N824DW, was substantially damaged when it was involved in an accident near Albany, Oregon. The pilot was not injured. The airplane was operated as a Title 14 Code…
- [NTSB WPR25LA054](https://openairdocs.org/ntsb/WPR25LA054.md): Cessna 150L · Glen Avon, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 4, 2024 · N5330Q · Substantial damage
  > On December 4, 2024, about 1420 Pacific standard time, a Cessna 150L, N5330Q, sustained substantial damage when it was involved in an accident near Glen Avon, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…
- [NTSB WPR25LA024](https://openairdocs.org/ntsb/WPR25LA024.md): Hayden ED RV10 · Beaver Marsh, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 19, 2024 · N929EH · Substantial damage
  > On October 19, 2024, about 1400 Pacific daylight time, an experimental amateur built Vans RV-10, N929EH, was substantially damaged when it was involved in an accident near Beaver Creek, Oregon. The pilot was not injured. The airplane was operated as a Title…
- [NTSB WPR24LA302](https://openairdocs.org/ntsb/WPR24LA302.md): Amazon.Com Services MK30 · Pendleton, OR · Accident · No injuries · Class 4 · Limited · Final report · Sep 6, 2024 · N213PA · 2 aircraft · Destroyed
  > The operator’s failure to maintain separation between two drones during dual simulated engine out recoveries, which resulted in a midair collision.
- [NTSB WPR24LA300](https://openairdocs.org/ntsb/WPR24LA300.md): Pacific Aerospace 750XL · Mulino, OR · Accident · No injuries · Class 4 · Limited · Final report · Aug 31, 2024 · N902ST · Substantial damage
  > The skydiver’s unintentional parachute deployment and subsequent entanglement with the airplane’s horizontal stabilizer.
- [NTSB WPR24LA294](https://openairdocs.org/ntsb/WPR24LA294.md): Luscombe 8 · Bend, OR · Accident · No injuries · Class 4 · Limited · Final report · Aug 30, 2024 · N71899 · Substantial damage
  > A failure of the left fuel valve, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB WPR24FA105](https://openairdocs.org/ntsb/WPR24FA105.md): Piper PA-32-260 · Madras, OR · Accident · 2 fatal · Class 3 · Field · Final report · Mar 10, 2024 · N3264W · Destroyed
  > The pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with turbulence and structural icing conditions, loss of control, and subsequent impact with terrain.
- [NTSB DCA24MA063](https://openairdocs.org/ntsb/DCA24MA063.md): Boeing 737-9 · Portland, OR · Accident · Minor injuries · Class 1 · Major · Final report · Jan 6, 2024 · N704AL · Substantial damage
  > the in-flight separation of the left mid exit door (MED) plug due to Boeing Commercial Airplanes’ failure to provide adequate training, guidance, and oversight necessary to ensure that manufacturing personnel could consistently and correctly comply with its…
- [NTSB WPR23LA303](https://openairdocs.org/ntsb/WPR23LA303.md): Aldinger Albert John Cozy Mark III · McDermitt, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 3, 2023 · N964AL · Substantial damage
  > The pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR23LA309](https://openairdocs.org/ntsb/WPR23LA309.md): Cessna 150M · Dune City, OR · Accident · No injuries · Class 4 · Limited · Final report · Jul 28, 2023 · N66165 · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, and impact with terrain.
- [NTSB WPR23LA267](https://openairdocs.org/ntsb/WPR23LA267.md): Piper PA-22-160 · Coquille Bay, OR · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 8, 2023 · N9507D · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with terrain.
- [NTSB WPR23LA184](https://openairdocs.org/ntsb/WPR23LA184.md): Rans S-21 · Creswell, OR · Accident · No injuries · Class 3 · Limited · Final report · May 10, 2023 · N468MM · Substantial damage
  > A total loss of engine power caused by fatigue cracking and fracture of the crankshaft due to severe wear of the bearings.
- [NTSB WPR23FA141](https://openairdocs.org/ntsb/WPR23FA141.md): Cirrus Design SR22 · Oxbow, OR · Accident · 2 fatal · Class 3 · Field · Final report · Apr 2, 2023 · N424SW · Destroyed
  > The pilot’s continued visual flight into instrument meteorological conditions, resulting in airframe ice accretion and a subsequent loss of airplane control.
- [NTSB WPR23LA115](https://openairdocs.org/ntsb/WPR23LA115.md): Aircraft Mfg & Development CH 2000 · Mulino, OR · Accident · No injuries · Class 4 · Limited · Final report · Feb 25, 2023 · N8500Z · Substantial damage
  > The pilot’s inadequate fuel planning which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR22FA354](https://openairdocs.org/ntsb/WPR22FA354.md): Piper PA-28-140 · Sisters, OR · Accident · 1 fatal · Class 3 · Field · Final report · Sep 22, 2022 · N7063R · Destroyed
  > The non-instrument-rated pilot’s flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s degraded judgement due to fatigue.
- [NTSB WPR22LA193](https://openairdocs.org/ntsb/WPR22LA193.md): Vans RV-8 · Galice, OR · Accident · No injuries · Class 3 · Limited · Final report · May 31, 2022 · N298DM · Substantial damage
  > The in-flight failure of the crankshaft gear’s alignment dowel as a result of the retaining bolt not being installed, which lead to a total loss of engine power.
- [NTSB WPR22LA019](https://openairdocs.org/ntsb/WPR22LA019.md): Lancair ES · Fall Creek, OR · Accident · No injuries · Class 3 · Limited · Final report · Oct 15, 2021 · N511ZZ · Substantial damage
  > Total loss of engine power due to fatigue failure of the camshaft gear.
- [NTSB WPR21LA292](https://openairdocs.org/ntsb/WPR21LA292.md): Cessna 180K · Mt. Hood, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 24, 2021 · N8884 · Substantial damage
  > The total loss of engine power while in cruise flight for reasons that could not be determined based on available evidence. Contributing to the accident was the presentation of an abandoned airport as available for use in the Federal Aviation Administration…
- [NTSB WPR21LA094](https://openairdocs.org/ntsb/WPR21LA094.md): Randy Wayne Maloney M1 · Eagle Point, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 21, 2021 · N322TR · Destroyed
  > A partial loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB WPR21LA082](https://openairdocs.org/ntsb/WPR21LA082.md): Cessna 560 · Warm Springs, OR · Accident · 1 fatal · Class 3 · Limited · Final report · Jan 9, 2021 · N3RB · Destroyed
  > A loss of airplane control due to pilot incapacitation for reasons that could not be determined.
- [NTSB ANC21LA007](https://openairdocs.org/ntsb/ANC21LA007.md): Cessna 150L · Colton, OR · Accident · 2 fatal · Class 3 · Limited · Final report · Nov 16, 2020 · N18666 · Destroyed
  > The 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.
- [NTSB WPR20LA155](https://openairdocs.org/ntsb/WPR20LA155.md): CSP Leasing Cavalon · Roseburg, OR · Accident · 1 fatal · Class 3 · Limited · Final report · May 28, 2020 · N477AG · Destroyed
  > A substantially unweighted rotor system for reasons that could not be determined, which resulted in contact between the main rotor blade and the gyrocopter’s keel tube and a loss of control and impact with terrain.
- [NTSB WPR20LA097](https://openairdocs.org/ntsb/WPR20LA097.md): Cessna 170 · Baker City, OR · Accident · No injuries · Class 3 · Limited · Final report · Feb 27, 2020 · N5478C · Substantial damage
  > The failure of the No. 2 connecting rod bearing as a result of oil starvation due to a contaminated oil filter screen.
- [NTSB WPR19LA265](https://openairdocs.org/ntsb/WPR19LA265.md): Beech 35 · Gresham, OR · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 24, 2019 · N5277C · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of the instructor’s inadequate in-flight fuel management.
- [NTSB WPR19FA256](https://openairdocs.org/ntsb/WPR19FA256.md): Piper PA32 · La Grande, OR · Accident · 1 fatal · Class 3 · Field · Final report · Sep 8, 2019 · N6300Z · Destroyed
  > The pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.
- [NTSB WPR19LA189](https://openairdocs.org/ntsb/WPR19LA189.md): Vans RV14 · Aumsville, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 16, 2019 · N365EM · Destroyed
  > An inflight fire that originated in the engine compartment for reasons that could not be determined based on available evidence.
- [NTSB ANC19LA032](https://openairdocs.org/ntsb/ANC19LA032.md): Cessna 172 · Newport, OR · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 8, 2019 · N9919V · Substantial damage
  > The pilot's improper verification of the fuel quantity during the preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB WPR19LA097](https://openairdocs.org/ntsb/WPR19LA097.md): MD Helicopter 369 · Newberg, OR · Accident · No injuries · Class 3 · Limited · Final report · Mar 17, 2019 · N119T · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB WPR18LA111](https://openairdocs.org/ntsb/WPR18LA111.md): Pflugradt Kitfox · Clatskanie, OR · Accident · No injuries · Limited investigation · Final report · Mar 20, 2018 · N925DP · Substantial damage
  > A partial loss of engine power due to an improperly secured throttle cable set screw.
- [NTSB GAA18CA172](https://openairdocs.org/ntsb/GAA18CA172.md): Lithuanian Factory Of LAK 12 · Sunriver, OR · Accident · No injuries · Data collection · Final report · Mar 20, 2018 · N63010 · Substantial damage
  > The glider pilot's inadequate flight planning, which resulted in an off-airport landing.
- [NTSB WPR18FA001](https://openairdocs.org/ntsb/WPR18FA001.md): Cirrus Design SR22 · Klamath Falls, OR · Accident · 2 fatal · Field investigation · Final report · Oct 1, 2017 · N6083D · Destroyed
  > The noninstrument rated pilot's decision to depart on a cross-country flight with en route weather conditions forecasted to be less than visual meteorological conditions and then to continue flight into instrument meteorological conditions, which resulted in…
- [NTSB WPR17LA147](https://openairdocs.org/ntsb/WPR17LA147.md): Cessna 180 · Baker City, OR · Accident · No injuries · Limited investigation · Final report · Jul 9, 2017 · N4683B · Substantial damage
  > The loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning.
- [NTSB GAA17CA373](https://openairdocs.org/ntsb/GAA17CA373.md): Cessna 172 · Roseburg, OR · Accident · No injuries · Data collection · Final report · Jun 25, 2017 · N79938 · Substantial damage
  > An in-flight collision with a bird during the approach.
- [NTSB GAA17CA331](https://openairdocs.org/ntsb/GAA17CA331.md): Piper PA25 · Hood River, OR · Accident · Minor injuries · Data collection · Final report · Jun 11, 2017 · N8578L · Substantial damage
  > The pilot's failure to visually check the fuel level prior to takeoff and subsequent mismanagement of the available fuel supply during numerous glider tow flights.
- [NTSB WPR17LA082](https://openairdocs.org/ntsb/WPR17LA082.md): OTT 601XL-B · The Dalles, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 2017 · N610TT · Substantial damage
  > A partial loss of engine power due to the reverse bending fatigue failure of the propeller hub bolts, which resulted from the bolts not fitting tightly into the propeller hub holes. Also causal was the pilot's decision to use improper bolts for this type of…
- [NTSB WPR17FA052](https://openairdocs.org/ntsb/WPR17FA052.md): Piper PA 28-236 · Port Orford, OR · Accident · 1 fatal · Field investigation · Final report · Jan 13, 2017 · N81839 · Substantial damage
  > The pilot's loss of vision during cruise flight, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to fly with a known medical condition.
- [NTSB GAA16CA317](https://openairdocs.org/ntsb/GAA16CA317.md): Ryan Navion · McMinnville, OR · Accident · Minor injuries · Data collection · Final report · Jun 13, 2016 · N4171K · Substantial damage
  > The pilot's failure to replace the oil filler cap following the preflight inspection, which resulted in a loss of engine oil and engine power, an emergency landing, and impact with terrain.
- [NTSB WPR16LA081](https://openairdocs.org/ntsb/WPR16LA081.md): Mcdonnell Douglas Helicopter 600N · Ashland, OR · Accident · No injuries · Limited investigation · Final report · Feb 5, 2016 · N745BW · Substantial damage
  > Fatigue cracking of a main rotor blade for reasons that could not be determined based on the available information.
- [NTSB WPR16LA060](https://openairdocs.org/ntsb/WPR16LA060.md): Piper PA46 · Burns, OR · Accident · No injuries · Limited investigation · Final report · Jan 31, 2016 · N777PG · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of an anomaly that would have precluded normal operation. Contributing to the accident was a preexisting landing gear anomaly that…
- [NTSB WPR15LA228](https://openairdocs.org/ntsb/WPR15LA228.md): Hudson Zodiac CH 601 XLB · Hubbard, OR · Accident · No injuries · Limited investigation · Final report · Aug 2, 2015 · N234S · Substantial damage
  > A severe propeller vibration due to the pilot's improper installation of the propeller spacer assembly, which necessitated an engine shutdown, an off-airport landing, and a collision with a sprinkler system.
- [NTSB WPR15LA155](https://openairdocs.org/ntsb/WPR15LA155.md): Cessna 140 · Crescent Lake, OR · Accident · Minor injuries · Limited investigation · Final report · May 1, 2015 · N2514N · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inability to restart the engine for reasons that could not be determined because postaccident examination…
- [NTSB WPR15FA152](https://openairdocs.org/ntsb/WPR15FA152.md): Piper PA 28-140 · Mt Tom, OR · Accident · 1 fatal · Field investigation · Final report · Apr 22, 2015 · N1729J · Destroyed
  > The noncertificated pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation leading to the pilot's loss of control of the airplane and subsequent collision with mountainous terrain.
- [NTSB WPR15LA137](https://openairdocs.org/ntsb/WPR15LA137.md): Piper PA 46-310P · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Mar 1, 2015 · N9133G · Substantial damage
  > A loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR15LA032](https://openairdocs.org/ntsb/WPR15LA032.md): Cessna T210M · Jacksonville, OR · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2014 · N1593M · Substantial damage
  > A loss of engine power during cruise flight due to the failure of the No. 6 connecting rod, which resulted from oil starvation.
- [NTSB WPR15LA008](https://openairdocs.org/ntsb/WPR15LA008.md): Piper PA 28-180 · Bend, OR · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 2014 · N32150 · Substantial damage
  > A partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat after takeoff and during the climb.
- [NTSB WPR14FA218](https://openairdocs.org/ntsb/WPR14FA218.md): Nebert Vans RV-10 · Toledo, OR · Accident · 2 fatal · Field investigation · Final report · May 31, 2014 · N62DN · Substantial damage
  > A total loss of engine power due to fuel starvation because of a blocked fuel line that resulted from the pilot’s improper maintenance practices and the pilot’s subsequent failure to maintain adequate airspeed while attempting a forced landing, which led to…
- [NTSB WPR14LA055](https://openairdocs.org/ntsb/WPR14LA055.md): Richard S Duncan Avid Flyer · Lakeside, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2013 · N1445P · Substantial damage
  > The pilot/owner’s failure to comply with the engine manufacturer’s maintenance guidance, which resulted in the total loss of engine power due to the fracture failure of the plastic drive gear for the engine lubricating oil pump.
- [NTSB WPR14CA052](https://openairdocs.org/ntsb/WPR14CA052.md): Bell 206B · Milo, OR · Accident · Serious injuries · Data collection · Final report · Oct 28, 2013 · N16673 · Substantial damage
  > The pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.
- [NTSB WPR13LA396](https://openairdocs.org/ntsb/WPR13LA396.md): Flight Design Ctsw · Sisters, OR · Accident · No injuries · Limited investigation · Final report · Sep 2, 2013 · N102HA · Substantial damage
  > The pilot's inadequate preflight fuel planning and poor decision-making, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the lack of documentation describing the limitations of the airplane’s fuel…

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.