NTSB investigations, OR

482 cases where the phase of flight was Maneuvering.

Cases, newest first

Query with SQL
duckdb -csv -c "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"

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 SEA04LA139Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Nyssa, ORThe failure (fracture) of the number four cylinder head during an aerial application run. Factors include the soft crop-covered terrain.Jul 23, 2004 · N7220 · Substantial damageNTSB SEA04FA133Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Ontario, ORThe pilot's failure to maintain airspeed resulting in an aerodynamic stall while maneuvering for an approach to land.Jul 15, 2004 · N4439P · Substantial damageNTSB SEA04LA114Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Medford, ORThe pilot's failure to maintain clearance from a tree while maneuvering. Trees were a factor.Jun 23, 2004 · N73909 · Substantial damageNTSB SEA04LA082Accident · 1 fatalLimited investigationFinal reportKaman K-1200 · West Fork, ORThe pilot's failure to maintain adequate clearance with trees during logging operations. Contributing factors were the trees, mountainous (steeply sloped) terrain, and the pilot's decision to conduct operations in this terrain with a 200 foot long line.May 12, 2004 · N162KA · Substantial damageNTSB SEA04FA060Accident · 3 fatalField investigationFinal reportCessna 182Q · Santiam Junc., ORThe pilot's failure to maintain adequate airspeed which resulted in a stall while attempting a low-level crossing of a ridge from the leeward to the windward side. Factors include low-level maneuvering, strong gusty winds, and downdrafts.Mar 29, 2004 · N96719 · Substantial damageNTSB SEA04LA036Accident · No injuriesLimited investigationFinal reportBell 206B · Turner, ORThe pilot's inadequate preflight inspection which failed to detect contaminated fuel. A collapsed fuel screen was a contributing factor.Jan 26, 2004 · N92CA · Substantial damageNTSB SEA04LA026Accident · 1 fatalLimited investigationFinal reportUpright RV-7A · McMinnville, ORThe pilot's failure to maintain aircraft control. Cloudy weather, continued flight into adverse weather, inadequate preflight planning and mountainous terrain were factors.Dec 11, 2003 · N29CV · DestroyedNTSB SEA04LA024Accident · 1 fatalLimited investigationFinal reportShear Titan Tornado · Brooks, ORThe failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.Dec 2, 2003 · N183T · Substantial damageNTSB SEA04LA018Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Monmouth, ORFatigue failure of a tail rotor blade during hover operations.Nov 18, 2003 · N7825S · Substantial damageNTSB SEA04FA009Accident · 1 fatalField investigationFinal reportBeech A36 · Seaside, ORThe pilot's failure to maintain clearance from objects while maneuvering. High winds, gusts and rain were factors.Oct 20, 2003 · N136SB · DestroyedNTSB SEA04FA006Accident · 2 fatalField investigationFinal reportCessna 340A · Scappoose, ORThe pilot's failure to maintain airspeed while maneuvering. An inadvertent stall, the pilot's failure to follow engine operation procedures and engine detonation were factors.Oct 18, 2003 · N340P · DestroyedNTSB SEA04LA005Accident · 2 fatalLimited investigationFinal reportBell 206B · Swisshome, ORThe pilot's failure to maintain clearance from power lines while maneuvering. The power line, mountainous terrain with high obstructions (thick trees and underbrush) and the operators failure to maintain a "hazard map" as indicated in their procedures manual…Oct 14, 2003 · N86W · Substantial damageNTSB SEA03LA189Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Diamond, ORLoss of engine power for undetermined reasons during hover.Sep 12, 2003 · N48020 · Substantial damageNTSB SEA03LA160Accident · Minor injuriesLimited investigationFinal reportHughes 269C-1 · Scappoose, ORThe helicopter encountering a ground resonance condition following a failure to maintain hovering flight. Contributing factors to the accident included the pilot's failure to maintain rotor RPM and the high pressure state of the landing gear shock absorbing…Jul 29, 2003 · N61442 · Substantial damageNTSB SEA03LA125Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · La Grande, ORThe cross threading and separation of the clutch assembly while maneuvering which resulted in a loss of engine power followed by a hard landing. An inadequate maintenance overhaul was a factor.Jul 4, 2003 · N37799 · DestroyedNTSB SEA02FA097Accident · No injuriesField investigationFinal reportLewis Nieuport 11 · Independence, ORThe partial loss of engine power in maneuvering flight due to the rotation of the ignition distributor as a result of a failure to tighten the distributor positioning clamp after the last engine timing adjustment. Factors include an inadequate maintenance…Jun 9, 2002 · N132DC · Substantial damageNTSB SEA02LA039Accident · 1 fatalLimited investigationFinal reportBitton/Sport Flight Talon · Boring, ORLoss of control for undetermined reasons.Feb 10, 2002 · UNREG · Substantial damageNTSB SEA01FA167Accident · 3 fatalField investigationFinal reportBeech 58 · Ashland, ORThe pilot's failure to maintain clearance from the terrain after inadvertently entering an area of instrument meteorological conditions (IMC) during a visual flight rules (VFR) flight. Factors include mountainous/hilly terrain and low ceilings in the area…Sep 5, 2001 · N18414 · DestroyedNTSB SEA01LA144Accident · No injuriesLimited investigationFinal reportHutton KR-2 · Roseburg, ORA total loss of power for undetermined reasons and the pilot's misjudgment of distance and speed while maneuvering to a forced landing at a nearby airport. Contributing factors were the 8 knot tailwind and the fence which the aircraft impacted when it over…Jul 25, 2001 · N4GJ · Substantial damageNTSB SEA01LA118Accident · No injuriesLimited investigationFinal reportHughes 369D · Canby, ORFuel starvation as a result of a collapsed fuel nozzle filter screen. Contamination that blocked the fuel nozzle screen and water contamination were factors.Jun 11, 2001 · N69PE · Substantial damageNTSB SEA01LA029Accident · No injuriesLimited investigationFinal reportKaman K-1200 · Prineville, ORThe pilot's failure to adequately compensate for wind conditions.Dec 10, 2000 · N317KA · Substantial damageNTSB SEA00LA186Accident · 1 fatalLimited investigationFinal reportde Havilland DH-100 MK.6 · Ontario, ORThe pilot's failure to maintain adequate airspeed during low-altitude maneuvering flight, resulting in an accelerated stall and spin. A factor was the pilot's intentional low-altitude maneuvering flight.Sep 23, 2000 · N152RD · DestroyedNTSB SEA00LA158Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235 · Paulina, ORThe pilot's failure to maintain an airspeed above stalling speed (Vs), which resulted in a stall/mush into the terrain. Factors include mountainous/hilly terrain, tall trees, a high density altitude, and the pilot's diverted attention as he attempted to keep…Aug 13, 2000 · N6269M · Substantial damageNTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.Jul 21, 2000 · N731GR · Substantial damageNTSB SEA00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Haines, ORThe pilot's failure to correctly judge his rate of descent and his failure to initiate his level off soon enough to keep the helicopter from impacting the terrain. Factors include hilly terrain near the edge of the field he was spraying.Jul 4, 2000 · N30DP · Substantial damageNTSB SEA00LA107Accident · 1 fatalLimited investigationFinal reportHaessler Cosmo Phase II · Banks, ORThe pilot's improper installation, i.e., reversed connection, of the rudder control cables resulting in reverse rudder operation and a subsequent stall/spin. A contributing factor was the pilot's intentional design change/addition of a rudder to the aircraft.Jun 17, 2000 · N9022F · DestroyedNTSB SEA00LA097Accident · No injuriesLimited investigationFinal reportBell 212 · Eugene, ORInadequate quality control by the manufacturer during the manufacturing process, which led to the total failure of a fastener, and the separation of the tail rotor blade balance weight. An adhesive debond between the adhesive and the surface was a factor.Jun 3, 2000 · CFHDY · Substantial damageNTSB SEA00LA051Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Odell, ORThe pilot's failure to maintain sufficient altitude over, or clearance with, a tree. Factors contributing to the occurrence of the accident were the tree and sharply rising terrain. A factor contributing to the severity of the accident was a post-crash fuel…Mar 13, 2000 · N9040V · DestroyedNTSB SEA00FA030Accident · 1 fatalField investigationFinal reportCessna 140A · Harper, ORThe pilot-in-command's failure to maintain terrain clearance. Factors include meteorological conditions obscuring the pilot's visibility and incapacitation due to illegal substances.Dec 11, 1999 · N5347C · Substantial damageNTSB SEA00LA028Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Salem, ORFailure of the pilot to maintain ground clearance, resulting in the long-line snagging and then striking the tail rotor.Dec 3, 1999 · N11KV · Substantial damageNTSB SEA00LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Malheur City, ORThe pilot's excessive descent rate during an attempted precautionary landing. Factors include the pilot's intentional operation of his aircraft with a known electrical system deficiency, a malfunction of the electrical system while in flight, the pilot's…Nov 13, 1999 · N82553 · DestroyedNTSB SEA00FA014Accident · 1 fatalField investigationFinal reportEnstrom F28C · Pendleton, ORFailure to maintain clearance from the runway surface while maneuvering at low altitude, and inadequate remedial action after the tail rotor struck the surface.Nov 2, 1999 · N635H · DestroyedNTSB SEA99LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hillsboro, ORLoss of engine power due to fuel contamination.Sep 9, 1999 · N4065P · Substantial damageNTSB SEA99FA168Accident · 1 fatalField investigationFinal reportSchweizer 269C · Westport, ORThe pilot's failure to maintain clearance from terrain. Factors include low clouds and visibility and near-night light conditions.Aug 8, 1999 · N383T · DestroyedNTSB SEA99LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Jordan Valley, ORThe pilot's inadvertent stall/mush of the aircraft while attempting a forced landing due to partial power loss of the engine. Factors include carburetor icing conditions and the pilot's improper use of carburetor heat.Jul 25, 1999 · N3992P · Substantial damageNTSB SEA99GA085Accident · 2 fatalFinal reportCessna 182R · Enterprise, ORThe pilot's failure to maintain aircraft control while maneuvering in a canyon, and the mentor's failure to take adequate remedial action. Factors included box canyon terrain and high density altitude conditions.Jun 13, 1999 · N9458H · DestroyedNTSB SEA99FA027Accident · 4 fatalField investigationFinal reportBeech 58P · Yamhill, ORThe pilot's failure to maintain clearance from hilly terrain while maneuvering below a low ceiling. Factors include a dark night, a low ceiling, fog, and hilly terrain.Jan 7, 1999 · N700LF · DestroyedNTSB SEA99LA005Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Scappoose, ORAircraft control was not maintained. Inadequate remedial action is a factor.Oct 22, 1998 · N474BC · Substantial damageNTSB SEA98GA159Accident · No injuriesFinal reportBell 212 · Juntura, ORThe pilot-in-command's failure to maintain proper clearance between the long line cable and hell hole structure resulting in airframe contact and binding of the cable. This resulted in separation/disabling of the fuel control solenoid and a subsequent…Aug 8, 1998 · N291B · Substantial damageNTSB SEA98FA109Accident · No injuriesField investigationFinal reportNolley BD-5T · Corvallis, ORThe introduction of a fuel containing an ethanol additive into fuel tanks sloshed/sealed with a compound incompatible with alcohols, resulting in debonding of the compound from the fuel tank walls, leading to partial blockage of an in-line fuel filter, and a…Jun 21, 1998 · N50TX · Substantial damageNTSB SEA98FA055Accident · No injuriesField investigationFinal reportEnstrom F28F · Baker, ORFatigue failure of the steel tubing pylon structure. Factors include inadequate inspection by maintenance personnel of damage after a previous accident.Mar 30, 1998 · N171HH · Substantial damageNTSB SEA98LA033Accident · 2 fatalLimited investigationFinal reportSherman Executive · Stayton, ORMain rotor strike and separation of the tail boom for undetermined reasons.Jan 31, 1998 · N50499 · DestroyedNTSB SEA98LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · John Day, ORa loss of engine power for undetermined reasons.Dec 6, 1997 · N171HH · Substantial damageNTSB SEA98LA013Accident · No injuriesLimited investigationFinal reportBell 206B · Forest Grove, ORExcessive deceleration of the helicopter by the pilot-in-command, resulting in an in-flight main rotor blade strike on the helicopter's external load line and subsequent main rotor separation. Downhill terrain which led to a descending approach to the pickup…Nov 8, 1997 · N101LF · DestroyedNTSB SEA97LA212Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Oakridge, ORThe first pilot's decision to perform a low altitude maneuver, and his subsequent failure to maintain altitude and clearance from trees during a low altitude maneuver.Sep 18, 1997 · N8509 · DestroyedNTSB SEA97FA178Accident · 2 fatalField investigationFinal reportCessna 172M · Clackamas, ORThe pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…Jul 28, 1997 · N80222 · Substantial damageNTSB SEA97LA171Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Yamhill, ORLoss of engine power for undetermined reasons.Jul 20, 1997 · N1105B · Substantial damageNTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…Jun 20, 1997 · N168RW · DestroyedNTSB SEA97LA142Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-400 · Weston, ORThe pilot's failure to attain a proper descent rate during the forced landing. Factors include: the pilot's failure to use an 'engine start' checklist, failure to turn the ignition switch to the 'on' position, failure to use the landing checklist, failure to…Jun 14, 1997 · N321V · Substantial damageNTSB SEA97LA117Accident · 1 fatalLimited investigationFinal reportHiller UH-12E · Miltonfreewater, ORThe main rotor blade separated due to fatigue. Factors were: an Airworthiness Directive was not properly performed, and inadequate inspection of the main rotor blades.May 21, 1997 · N3005J · Substantial damage