OpenAirDocs.org

NTSB investigations, NM

231 cases where the phase of flight was Maneuvering.

Cases per year

19642026

Where

Open the map

Latest cases

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\" = 'NM' 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 WPR25FA020Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Las Cruces, NMThe pilot’s entry into an aerobatic maneuver at an altitude that was insufficient to complete a successful recovery, which resulted in an accelerated stall and impact with terrain.Oct 20, 2024 · N512DW · DestroyedNTSB WPR23FA138Accident · 1 fatalClass 3 · FieldFinal reportAerotrike Cobra · Santa Teresa, NMThe pilot’s exceedance of the aircraft’s critical angle of attack, which resulted in an aerodynamic stall.Apr 1, 2023 · UNREG · DestroyedNTSB WPR22LA168Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Folsom, NMThe pilot’s failure to maintain airspeed and rotor rpm which resulted in a hard landing.Apr 28, 2022 · N41339 · Substantial damageNTSB WPR22FA148Accident · 1 fatalClass 3 · FieldFinal reportTaylorcraft BL-65 · Counselor, NMA loss of control while maneuvering at a high-density altitude in gusty wind conditions.Apr 9, 2022 · N24345 · Substantial damageNTSB WPR22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Lanark, NMThe pilot’s loss of control of the airplane after the inadvertent unlocking and opening of the canopy for reasons that could not be determined based on available evidence.Mar 25, 2022 · N823MM · Substantial damageNTSB WPR22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Hachita, NMThe pilot’s failure to adequately monitor the environment during a low level operation, which resulted in collision with vegetation.Dec 3, 2021 · N7116L · Substantial damageNTSB WPR22FA043Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Carlsbad, NMThe pilot's failure to maintain separation from an FM tower guy wire while on an aerial survey flight.Nov 19, 2021 · N91AZ · Substantial damageNTSB WPR22FA011Accident · 1 fatalClass 3 · FieldFinal reportCessna 175 · Reserve, NMThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot’s reduced forward visibility due to the sun.Oct 15, 2021 · N7584M · Substantial damageNTSB WPR21LA310Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Fort Sumner, NMThe pilot's failure to maintain adequate clearance from a windmill while maneuvering during an aerial application flight.Jul 30, 2021 · N9197F · DestroyedNTSB ANC19FA018Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, NMThe pilot's loss of airplane control due to his failure to maintain appropriate control inputs and airspeed after shutting down an engine because of a progressive failure of the pressure relief valve in the fuel pump, which resulted in variable fuel pressure…May 5, 2019 · N102SN · Substantial damageNTSB CEN19LA067Accident · No injuriesLimited investigationFinal reportBell 47G · Belen, NMThe pilot's failure to maintain adequate main rotor speed while the helicopter was in an out-of-ground effect hover.Jan 11, 2019 · N3755Z · Substantial damageNTSB CEN18FA262Accident · 1 fatalField investigationFinal reportSchempp-Hirth Flugzeugbau Ventus 3F · Moriarty, NMThe pilot's exceedance of the glider's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall and subsequent impact with terrain.Jul 10, 2018 · N753R · Substantial damageNTSB CEN18LA226Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Arrey, NMThe pilot's failure to maintain clearance from a hillside during an agricultural application flight while facing the sun.Jun 15, 2018 · N6672Q · Substantial damageNTSB CEN18FA009Accident · 2 fatalField investigationFinal reportCessna 182H · Las Cruces, NMControlled flight into terrain in dark night conditions.Oct 13, 2017 · N8338S · Substantial damageNTSB GAA17CA360Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Portales, NMThe pilot's decision to fly the airplane under transmission lines while maneuvering at low altitude in high-density altitude conditions, which resulted in subsequent collision with terrain.Jun 22, 2017 · N700LA · DestroyedNTSB CEN17LA216Accident · No injuriesLimited investigationFinal reportWilliam D Telfair/Zia Z Telfai Excalibur · Albuquerque, NMThe loss of pitch control due to the overload failure of the control rod.Jun 4, 2017 · N78DZ · Substantial damageNTSB CEN15LA359Accident · Serious injuriesLimited investigationFinal reportAeros Aeros 2 · Albuquerque, NMThe ultralight airplane’s encounter with a downdraft in mountainous terrain, which resulted in a descent into trees.Aug 8, 2015 · N5982V · Substantial damageNTSB GAA15CA171Accident · No injuriesData collectionFinal reportWeatherly 620B · Hatch, NMThe pilot failed to maintain obstacle clearance, and the airplane struck a transmission line wire during aerial application operations.Jul 9, 2015 · N2034P · Substantial damageNTSB CEN15FA255Accident · 2 fatalField investigationFinal reportCub Crafters CC18-180 · Raton, NMThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Jun 5, 2015 · N162WR · Substantial damageNTSB CEN15CA218Accident · Minor injuriesData collectionFinal reportSchmidt Donald L GS1 Glastar · Moriarty, NMThe inadvertent encounter with a microburst while maneuvering near mountainous terrain, which resulted in a off airport landing and impact with terrain.May 2, 2015 · N993S · Substantial damageNTSB CEN14CA164Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Ruidoso, NMThe pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance.Mar 19, 2014 · N3398M · Substantial damageNTSB CEN13TA535Accident · Minor injuriesFinal reportBell 206L-3 · Amistad, NMThe pilot's failure to arrest the descent following an abrupt maneuver to avoid birds, which resulted in an impact with terrain.Sep 7, 2013 · N721LL · Substantial damageNTSB CEN13FA517Accident · 3 fatalField investigationFinal reportRobinson R44 II · Caballo, NMThe pilot’s failure to see and avoid power lines while maneuvering near the ground because dust stirred up by the rotor wash obscured his visibility.Aug 31, 2013 · N3156U · Substantial damageNTSB CEN13LA507Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Clayton, NMThe pilot's loss of vertical control after the helicopter encountered a gusty tailwind while maneuvering at a low altitude and near the helicopter's maximum gross weight.Aug 26, 2013 · N744KA · Substantial damageNTSB CEN13LA464Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Santa Teresa, NMThe pilot’s failure to maintain clearance from a tree at the completion of an agricultural spray run. Contributing to the accident was the pilot’s decision to accept a high level of risk to spray a small field bordered by multiple obstacles and his fatigue…Aug 6, 2013 · N3789E · Substantial damageNTSB CEN13CA336Accident · Minor injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Corona, NMThe pilot's failure to maintain aircraft control while ridge-soaring in gusty wind conditions.Jun 2, 2013 · N62TW · Substantial damageNTSB CEN13CA019Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Portales, NMThe pilot’s failure to maintain clearance from power lines during an aerial application flight.Oct 17, 2012 · N598LA · Substantial damageNTSB CEN12LA427Accident · Serious injuriesLimited investigationFinal reportMurray Richard F Aircam BY Lockwood · Taos, NMThe pilot's decision to fly in gusty wind conditions at low altitude over mountainous terrain contrary to guidance in the airplane flight manual and subsequent loss of airplane control due to wind and turbulence.Jul 7, 2012 · N984AT · Substantial damageNTSB CEN12FA291Accident · 1 fatalField investigationFinal reportBeech V35B · Las Vegas, NMThe pilot’s loss of airplane control for reasons that could not be determined because postaccident examination revealed no evidence of preimpact anomalies that would have precluded normal operation.May 11, 2012 · N645EP · Substantial damageNTSB CEN12LA289Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Grants, NMThe loss of engine power due to an excessively rich fuel mixture that occurred during operations at idle power settings at a high density altitude. Contributing to the accident was the flight instructor’s poor decision-making in choosing to practice an…May 10, 2012 · N7523S · Substantial damageNTSB CEN12FA174Accident · 2 fatalField investigationFinal reportHemp Timothy Legacy 2000 · Belen, NMThe pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…Mar 1, 2012 · N273TE · DestroyedNTSB CEN12FA090Accident · 2 fatalField investigationFinal reportCessna 182R · Mescalero, NMThe pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.Nov 26, 2011 · N9408X · Substantial damageNTSB CEN11FA652Accident · 2 fatalField investigationFinal reportConcannon Milton Radial ROC · Socorro, NMThe pilot's failure to maintain adequate airspeed during the visual approach to the runway, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s lack of experience in the airplane make and model and the possible sedating…Sep 19, 2011 · N91TX · Substantial damageNTSB CEN11CA326Accident · No injuriesData collectionFinal reportGetten Marvin T Quickie Q2 · Albuquerque, NMThe pilot's loss of elevator control, due to control stick's counter-weight binding with the airplane's header tank.May 6, 2011 · N314JF · Substantial damageNTSB CEN11TA064Accident · Minor injuriesFinal reportPartenavia P.68 · Anthony, NMThe pilot's decision to conduct a low-level flight in mountainous terrain in an area where downdrafts were prevalent, resulting in the inadvertent loss of control and the collision with the terrain.Nov 10, 2010 · N44956 · DestroyedNTSB CEN10CA395Accident · No injuriesData collectionFinal reportBell OH-58A · Roswell, NMThe pilot's failure to maintain clearance from transmission wires.Jul 10, 2010 · N415NS · Substantial damageNTSB CEN10CA010Accident · Serious injuriesData collectionFinal reportAerostar International RX-7 · Albuquerque, NMThe pilot’s failure to maintain adequate clearance from a known obstacle and the pilot’s failure to maintain control of the balloon during the sudden climb following the ejection of the passenger.Oct 5, 2009 · N9126K · Minor damageNTSB CEN09PA348Accident · 2 fatalClass 1Final reportAgusta A109E · Santa Fe, NMThe pilot's decision to take off from a remote, mountainous landing site in dark (moonless) night, windy, instrument meteorological conditions. Contributing to the accident were an organizational culture that prioritized mission execution over aviation safety…Jun 10, 2009 · N606SP · DestroyedNTSB CEN09LA345Accident · Serious injuriesLimited investigationFinal reportCurtiss Moses Aerolite · Los Lunas, NMA loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement.Jun 9, 2009 · N43598 · Substantial damageNTSB CEN09LA170Accident · No injuriesLimited investigationFinal reportBeech B35 · La Luz, NMA loss of engine power due to fuel starvation as a result of a blockage in the right fuel tank vent.Feb 21, 2009 · N8799A · Substantial damageNTSB CEN09FA043Accident · 1 fatalField investigationFinal reportCessna 175 · Mt. Dora, NMThe pilot's failure to maintain clearance from rising terrain for undetermined reasons.Oct 29, 2008 · N175JG · DestroyedNTSB CEN09LA009Accident · 1 fatalLimited investigationFinal reportSproul 72K-TET · Rio Rancho, NMThe pilot's failure to maintain clearance from the power lines and the failure of either pilot to take any corrective action to avoid the collision.Oct 10, 2008 · N72KX · DestroyedNTSB DEN08LA040Accident · 1 fatalLimited investigationFinal reportGarniss Stol 701 · Mesilla, NMThe pilot's failure to maintain aircraft control during an intentional low altitude maneuver due to impairment, resulting in the in-flight collision with terrain.Dec 15, 2007 · N45500 · DestroyedNTSB DEN07LA167Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Silver City, NMThe student pilot's failure to maintain control of the helicopter resulting in his settling with power and subsequent impact with terrain. A factor contributing to the accident was the trees.Sep 29, 2007 · N74557 · Substantial damageNTSB DEN07LA145Accident · 1 fatalLimited investigationFinal reportAdams Airborne Australia O · Taos, NMThe pilot's intentional low altitude flight in a confined area and an inadvertent stall/spin. Contributing factors in this accident were the blind/box canyon and the aircraft's low airspeed.Aug 26, 2007 · N7068U · DestroyedNTSB DEN07FA136Accident · 2 fatalField investigationFinal reportZlin Aviation s.r.o. Savage · Mosquero, NMThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall. Contributing to the accident was the conflicting airspeed information provided by the manufacturer, the incorrect airspeed indicator markings, and the high density…Aug 15, 2007 · N808GS · Substantial damageNTSB DEN07MA134Accident · 5 fatalMajor investigationFinal reportBeech E90B · Ruidoso, NMFailure to maintain clearance from terrain due to spatial disorientation.Aug 6, 2007 · N369CD · DestroyedNTSB DEN07FA071Accident · 1 fatalField investigationFinal reportBeech A23A · Holman, NMThe pilot's failure to maintain a safe altitude and clearance, and his improper inflight planning/decision to postpone initiating a climbing turn to avoid obstructions.Mar 13, 2007 · N4761J · DestroyedNTSB DEN07LA020Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502A · Deming, NMThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain. A contributing factor was the low airspeed.Nov 6, 2006 · N1541T · DestroyedNTSB DEN07CA009Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Hope, NMthe pilot's failure to maintain aircraft control. Contributing factors in this accident included the sudden wind shift and high density altitude, resulting in the helicopter settling with power, and the high vegetation.Oct 15, 2006 · N75262 · Substantial damage