OpenAirDocs.org

NTSB investigations

18,851 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.\"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 WPR09CA190Accident · Minor injuriesData collectionFinal reportAyres S2R-T34 · Cove, ORThe pilot's failure to maintain adequate clearance from rising terrain while maneuvering.Apr 9, 2009 · N114JP · Substantial damageNTSB CEN09GA242Accident · 1 fatalFinal reportCessna 337 · Pittsville, WIThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall at a low altitude.Apr 8, 2009 · N2489S · No damageNTSB ERA09LA233Accident · 1 fatalLimited investigationFinal reportCurtiss Wright P-40N · Mastic Beach, NYThe pilot's failure to maintain adequate airspeed while performing aerobatics at low altitude.Apr 5, 2009 · N740RB · DestroyedNTSB ERA09LA229Accident · 1 fatalLimited investigationFinal reportGaynor Donald J RV6A · Englewood, FLThe pilot's operation of the airplane while impaired (alcohol) and his decision to attempt aerobatic maneuvers at a low altitude resulting in the loss of aircraft control and subsequent collision with trees.Apr 4, 2009 · N88WG · Substantial damageNTSB WPR09FA175Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Sherwood, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in spatial disorientation and a loss of control.Apr 1, 2009 · N9996D · Substantial damageNTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.Mar 30, 2009 · N74815 · Substantial damageNTSB WPR09CA163Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chowchilla, CAThe pilot's failure to maintain clearance from the power lines.Mar 24, 2009 · N139RJ · Substantial damageNTSB WPR09MA159Accident · 14 fatalClass 1 · MajorFinal reportPilatus PC-12/45 · Butte, MT(1) the pilot's failure to ensure that a fuel system icing inhibitor was added to the fuel before the flights on the day of the accident; (2) his failure to take appropriate remedial actions after a low fuel pressure state (resulting from icing within the…Mar 22, 2009 · N128CM · Substantial damageNTSB CEN09LA225Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-602 · Ville Platte, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.Mar 22, 2009 · N5189P · Substantial damageNTSB WPR09LA160Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.Mar 20, 2009 · N90764 · Substantial damageNTSB WPR09FA154Accident · 1 fatalField investigationFinal reportCessna 180F · Townsend, MTThe pilot's failure to maintain clearance from trees and terrain while maneuvering at a low altitude.Mar 17, 2009 · N2698Y · Substantial damageNTSB ERA09LA200Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Gaithersburg, MDThe pilot’s spatial disorientation after the passenger door opened during flight in instrument meteorological conditions. Contributing to the accident was the pilot’s failure to properly secure the door latch.Mar 15, 2009 · N213CP · Substantial damageNTSB ERA09LA194Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Lee, MAThe pilot's failure to maintain clearance from the overhead wire.Mar 10, 2009 · N369RT · Substantial damageNTSB ERA09LA188Accident · 2 fatalLimited investigationFinal reportMXR Technologies MX2 · Dade City, FLAn in-flight loss of aircraft control for an undetermined reason.Mar 9, 2009 · N262MX · Substantial damageNTSB ERA09LA184Accident · 1 fatalLimited investigationFinal reportKevin Eldredge Stewart · Ocala, FLA loss of engine power due to contamination and clogging of the fuel system by a post-assembly fuel tank sealant.Mar 6, 2009 · N551X · Substantial damageNTSB CEN09CA194Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Harrold, SDThe pilot's failure to maintain clearance from the power lines during his turn to reverse course due to weather. Contributing to the accident was the reduced visibility at the time of the accident.Mar 6, 2009 · N648LA · Substantial damageNTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.Mar 3, 2009 · N9166E · Substantial damageNTSB CEN09CA180Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · O'Donnell, TXThe pilot's failure to maintain control while performing a quick stop maneuver to an out of ground effect (OGE) hover. Contributing to the accident was the high density altitude and near calm wind condition.Feb 25, 2009 · N387AC · Substantial damageNTSB ERA09LA173Accident · 1 fatalLimited investigationFinal reportHughes 369F · Moyock, NCThe flight instructor's failure to verify that the helicopter's skid was clear of an obstruction while demonstrating a one-skid and toe-in landing maneuver. Contributing to the accident was the flight instructor's decision to practice this maneuver at an…Feb 24, 2009 · N5205C · Substantial damageNTSB WPR09LA124Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Salinas, CAThe pilot's failure to maintain clearance from a wire while intentionally maneuvering at a low altitude.Feb 22, 2009 · N2835G · 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 WPR09LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Big Bear Lake, CAThe pilot's failure to maintain clearance from terrain while maneuvering in a ravine. Contributing to the accident was the pilot's decision to continue flight in an area that exceeded the climb rate capabilities of the airplane.Feb 20, 2009 · N6443E · Substantial damageNTSB ERA09FA169Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Deltona, FLThe pilot receiving instruction's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the flight instructor's inadequate supervision and both pilots'…Feb 17, 2009 · N493DA · Substantial damageNTSB ERA09CA177Accident · Serious injuriesData collectionFinal reportHI-Max 1700R · Windham, NHThe non-certificated pilot's failure to maintain clearance from houses while flying an unregistered experimental, amateur-built airplane.Feb 17, 2009 · UNREG · Substantial damageNTSB CEN09IA172Incident · No injuriesIncident investigationFinal reportCessna 150 · Grayslake, ILThe failure of the number 1 cylinder intake valve which resulted in a partial loss of engine power. Contributing to the incident was the failure of the operator to maintain the engine per manufacturer's recommendations.Feb 17, 2009 · N747KA · No damageNTSB ERA09CA175Accident · No injuriesData collectionFinal reportCessna 172 · Reidsville, GAThe pilot's failure to maintain control of the airplane during an attempted recovery from a stall/spin.Feb 16, 2009 · N9289H · Substantial damageNTSB CEN09LA189Accident · No injuriesLimited investigationFinal reportRemos G-3/600 · Hilda, TXThe flight instructor’s failure to maintain clearance from obstacles while maneuvering at low altitude.Feb 12, 2009 · N23GX · Substantial damageNTSB ERA09CA155Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Sevierville, TNThe flight instructor's improper remedial action following the student pilot's loss of control. Contributing to the accident was the student pilot's loss of control.Feb 3, 2009 · N7687H · Substantial damageNTSB WPR09CA105Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Bountiful, UTThe pilot's improper decision to fly at low altitude while maneuvering in mountainous terrain in a canyon and inadvertently exceeding the climb capability of the helicopter. Contributing to the accident were a high density altitude, mountainous terrain, and a…Feb 1, 2009 · N944U · Substantial damageNTSB CEN09FA147Accident · 1 fatalField investigationFinal reportMooney M20C · Elbert, COThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent loss of control.Feb 1, 2009 · N7774M · Substantial damageNTSB WPR09FA104Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Fillmore, CAAn in-flight break-up while maneuvering as a result of the main rotor blades diverging from the normal plane of rotation and severing the tailboom. The underlying reason for the main rotor divergence could not be determined.Jan 31, 2009 · N4160A · Substantial damageNTSB ERA09LA147Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Moscow, TNThe pilot's initiation of a low altitude maneuver followed by an uncontrolled descent into terrain.Jan 31, 2009 · N31254 · Substantial damageNTSB ERA09FA145Accident · 6 fatalField investigationFinal reportPiper PA-34-200T · Huntington, WV(1) The pilot’s failure to perform adequate preflight planning and to use available in flight resources in a timely manner and (2) his decision to continue visual-flight-rules flight in instrument meteorological conditions despite his lack of an instrument…Jan 30, 2009 · N8047C · DestroyedNTSB CEN09LA144Accident · 3 fatalLimited investigationFinal reportCox William M Bearhawk · Anahuac, TXA loss of control in flight for undetermined reasons.Jan 29, 2009 · N3WC · Substantial damageNTSB ERA09LA139Accident · 1 fatalLimited investigationFinal reportHughes OH-6A · Monroe, NCThe pilot-rated-passenger’s failure to maintain clearance from a known wire hazard during low-level maneuvering. Contributing to the accident was the pilot-in-command’s inadequate monitoring of the flight.Jan 22, 2009 · N4191A · Substantial damageNTSB WPR09CA088Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S R582 · Ventura, CAThe pilot's failure to maintain clearance from the water.Jan 17, 2009 · N6976C · DestroyedNTSB WPR09FA089Accident · 1 fatalField investigationFinal reportGlaser-Dirks DG-400 · Volcano, HIThe pilot's loss of pitch control and subsequent exceedance of the glider's airspeed limit for undetermined reasons.Jan 16, 2009 · N777WN · DestroyedNTSB WPR09LA085Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Beaver, UTA loss of engine power while maneuvering due to a sheared propeller blade's pitch change link. Contributing to the accident was lack of suitable terrain for the forced landing.Jan 15, 2009 · N3170C · Substantial damageNTSB WPR09LA074Accident · No injuriesLimited investigationFinal reportRowland GS-2 Sport · Ramona, CAA total loss of engine power for undetermined reasons.Jan 6, 2009 · N756R · Substantial damageNTSB WPR09LA071Accident · Minor injuriesLimited investigationFinal reportPZL PZL-104 35A · Oakland, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.Jan 3, 2009 · N226PF · Substantial damageNTSB ERA09CA120Accident · No injuriesData collectionFinal reportSchweizer 269C · Panama City, FLThe pilot's encounter with a loss of tail rotor effectiveness during an out-of-ground-effect hover.Dec 31, 2008 · N36254 · Substantial damageNTSB CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.Dec 31, 2008 · N899CB · Substantial damageNTSB CEN09LA113Accident · No injuriesLimited investigationFinal reportCotton Galen M Helicycle · Houston, TXThe loss of engine power during a hover landing which resulted in a hard landing.Dec 30, 2008 · N555CX · Substantial damageNTSB ERA09CA129Accident · No injuriesData collectionFinal reportBuckeye Dream Machine · Grant, FLThe pilot's failure to maintain clearance from the wire.Dec 28, 2008 · N6068E · Substantial damageNTSB ERA09LA107Accident · Minor injuriesLimited investigationFinal reportMoore David DM-1 · Salters, SCA hard landing following an autorotation that resulted from the separation of the red main rotor blade cap that led to the uncontrolled movement of the cyclic, autorotation and a hard landing.Dec 25, 2008 · N75EW · Substantial damageNTSB WPR09FA062Accident · 1 fatalField investigationFinal reportDiamond DA 20-C1 · Alamo Lake State Park, AZThe pilot's failure to maintain control during the performance of a maneuver and his failure to recover from the subsequent aerodynamic stall and spin.Dec 20, 2008 · N4196M · Substantial damageNTSB WPR09FA061Accident · 2 fatalField investigationFinal reportBeech V35 · Warner Springs, CAThe failure of the pilot to maintain clearance from terrain during a low altitude maneuver.Dec 20, 2008 · N1587L · Substantial damageNTSB ERA09FA092Accident · 1 fatalField investigationFinal reportCessna 172S · Goodland, FLThe pilot's failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was the night light conditions.Dec 18, 2008 · N967SP · DestroyedNTSB WPR09CA064Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Dinuba, CAThe failure of maintenance personnel to properly install the engine's Py line correctly, which resulted in the total loss of engine power and subsequent force landing. Contributing to the accident was the lack of suitable terrain.Dec 16, 2008 · N1035F · Substantial damageNTSB ERA09CA090Accident · No injuriesData collectionFinal reportBell OH-58C · Osceola County, FLThe pilot's misjudgment of altitude during low-altitude spraying operations, which resulted in an in-flight collision with water.Dec 15, 2008 · N659HA · Substantial damage