# NTSB investigations, OR: Emergency descent

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.

## Latest cases

- [NTSB WPR19FA178](https://openairdocs.org/ntsb/WPR19FA178.md): Maule M7-235B · Sunriver, OR · Accident · 1 fatal · Class 2 · Field · Final report · Jun 22, 2019 · N118G · Substantial damage
  > A partial loss of engine power due to the separation of baffling in both mufflers. Contributing to the accident was the pilot's failure to retract the landing gear on the float-equipped airplane before performing a forced landing to the river.
- [NTSB WPR18LA127](https://openairdocs.org/ntsb/WPR18LA127.md): Yakovlev YAK 52 · Hillsboro, OR · Accident · Serious injuries · Limited investigation · Final report · Apr 26, 2018 · N2YK · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was…
- [NTSB WPR15LA106](https://openairdocs.org/ntsb/WPR15LA106.md): Grumman Acft ENG Cor-Schweizer G 164A · Alfalfa, OR · Accident · No injuries · Limited investigation · Final report · Feb 18, 2015 · N4863 · Substantial damage
  > A total loss of engine power after takeoff for reasons that could not be determined, because examination of the engine did not reveal any mechanical anomalies that would have precluded normal operation.
- [NTSB WPR09CA467](https://openairdocs.org/ntsb/WPR09CA467.md): Beech 35-C33 · Tillamook, OR · Accident · No injuries · Data collection · Final report · Sep 27, 2009 · N90LP · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's failure to visually verify that sufficient fuel was on board prior to flight. Contributing to the accident was a malfunctioning fuel gage.
- [NTSB WPR09FA459](https://openairdocs.org/ntsb/WPR09FA459.md): Robinson Helicopter R22 Beta · Forest Grove, OR · Accident · 2 fatal · Field investigation · Final report · Sep 20, 2009 · N956SH · Substantial damage
  > The flight crew’s failure to maintain adequate main rotor speed while maneuvering, which resulted in a main rotor blade stall and an uncontrolled descent into terrain.
- [NTSB WPR09CA375](https://openairdocs.org/ntsb/WPR09CA375.md): Robinson Helicopter R22 Beta · Troutdale, OR · Accident · Minor injuries · Data collection · Final report · Jul 29, 2009 · N7176W · Substantial damage
  > The flight instructor's failure to maintain adequate main rotor RPM.
- [NTSB WPR09CA377](https://openairdocs.org/ntsb/WPR09CA377.md): Robinson Helicopter R22 Beta · Troutdale, OR · Accident · No injuries · Data collection · Final report · Jul 27, 2009 · N8340S · Substantial damage
  > The student pilot's improper use of the collective control and the flight instructor’s delayed reaction to the student pilot’s incorrect control inputs.
- [NTSB SEA06CA125](https://openairdocs.org/ntsb/SEA06CA125.md): Schweizer SGS 2-33A · Hood River, OR · Accident · No injuries · Data collection · Final report · Jun 18, 2006 · N2052T · Substantial damage
  > A loss of lift, which resulted in a forced landing. Trees in the landing area were a contributing factor.
- [NTSB SEA05CA200](https://openairdocs.org/ntsb/SEA05CA200.md): McDonnell Douglas 369E · Medford, OR · Accident · Minor injuries · Data collection · Final report · Sep 24, 2005 · N5207C · Substantial damage
  > In-flight collision with terrain during a precautionary landing. Factors include instrument meteorological conditions and pilot disorientation.
- [NTSB SEA04LA092](https://openairdocs.org/ntsb/SEA04LA092.md): Start & Flug H-101 Salto · Creswell, OR · Accident · Serious injuries · Limited investigation · Final report · May 24, 2004 · N101Q · Substantial damage
  > The pilot's failure to maintain clearance from the terrain while attempting to maneuver the aircraft into the wind during an off-airport landing in an open field. Factors include the pilot's inadequate in flight planning, tailwind conditions during an…
- [NTSB SEA04LA079](https://openairdocs.org/ntsb/SEA04LA079.md): SZD Jantar 42-1 · Wamic, OR · Accident · No injuries · Limited investigation · Final report · May 2, 2004 · N272AS · Substantial damage
  > The glider pilot's inadequate en route planning, which resulted in a forced landing in an area without suitable landing terrain. Factors include no suitable landing terrain in the area where the pilot found it necessary to execute a forced landing, and trees…
- [NTSB SEA65A0044](https://openairdocs.org/ntsb/SEA65A0044.md): Bell 47D1 · Roseburg, OR · Accident · No injuries · Closed · Feb 23, 1965 · N917B · Substantial damage

## 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 = 600)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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