NTSB investigations, ID

417 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, ID per year, 1964–2026: 417 cases
196411
196510
19666
196712
19689
19696
19707
19717
19727
19737
197412
19757
197617
19776
19786
19798
19804
19818
19829
19839
19847
19858
198613
19872
19886
19894
19907
19916
19928
19935
199411
19959
19967
19978
199810
199910
20006
20014
20026
200311
200411
20057
20063
20074
20083
20095
20105
20115
20125
20132
20142
20152
20165
20176
20183
20195
20206
20218
20223
20232
20246
20252
20261

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\" = 'ID' 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 WPR26LA188Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 500 · Twin Falls, IDThe pilot’s failure to maintain control while hovering in gusty wind conditions, resulting in the helicopter rolling onto its side.May 14, 2026 · N952SF · Substantial damageNTSB WPR26LA053Accident · Serious injuriesClass 4 · LimitedFinal reportTecnam P2008 · Blackfoot, IDThe student pilot’s failure to maintain altitude and clearance from trees while maneuvering at night.Nov 10, 2025 · N208CM · Substantial damageNTSB WPR25FA100Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 505 · Ririe, IDThe pilot’s inadequate preflight planning and decision to maneuver the helicopter at a low altitude, and his subsequent failure to maintain clearance from power lines.Feb 20, 2025 · N118LG · Substantial damageNTSB WPR25LA036Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Owinza, IDThe pilot’s failure to maintain clearance from the water during a low pass over a lake.Oct 13, 2024 · N9493CNTSB WPR24LA315Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Kooskia, IDThe pilot’s decision to descend into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees and terrain.Sep 26, 2024 · N54829 · Substantial damageNTSB WPR24LA247Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Stanley, IDA sudden wind shift which resulted in a rapid descent and subsequent dynamic rollover and collision into water.Jul 11, 2024 · N21BH · Substantial damageNTSB WPR24FA225Accident · 1 fatalClass 3 · FieldFinal reportGame Composites GB1 Gamebird · Irwin, IDThe pilot’s decision to perform a spin maneuver at an altitude that was insufficient to complete a successful recovery and subsequent failure to properly arrest the spin, which resulted in a secondary stall and an impact with terrain.Jul 4, 2024 · N786AE · Substantial damageNTSB WPR24FA201Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Arco, IDA midair collision between two airplanes during aerial application operations due to both pilots’ insufficient awareness of their proximity to each other and their failure to see and avoid each other. Contributing to the accident was the operator and both…Jun 20, 2024 · N802TP · 2 aircraft · DestroyedNTSB WPR24LA138Accident · Minor injuriesClass 4 · LimitedFinal reportAerospatiale SA315B · Lewiston, IDThe pilot’s failure to maintain clearance from power lines during a low level aerial application.May 2, 2024 · N42PL · Substantial damageNTSB WPR23LA265Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Emmett, IDThe instructor’s failure to maintain airspeed during a simulated turning autorotation, which resulted in a hard landing.Jul 8, 2023 · N74778 · Substantial damageNTSB WPR23LA242Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe premature retraction of the flaps by the student pilot, while just above the airplane’s stall speed. Contributing to the accident was the flight instructor’s inadequate supervision and failure to regain aircraft control from the student pilot.Jun 27, 2023 · N730SC · Substantial damageNTSB WPR22LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Yellow Pine, IDThe pilot's failure to maintain clearance from a tree while maneuvering.Aug 5, 2022 · N722BS · Substantial damageNTSB CEN22FA331Accident · 2 fatalClass 3 · FieldFinal reportColumbia Helicopters CH-47D · North Fork, IDThe failure of the flight crew to properly secure a company-issued iPad, leading to its migration into and jamming of the copilot’s left pedal, preventing the pilot from arresting a left yaw, and resulting in a loss of control.Jul 21, 2022 · N388RA · DestroyedNTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.May 8, 2022 · N801DT · Substantial damageNTSB WPR22LA014Accident · No injuriesClass 3 · LimitedFinal reportAvid Mark IV · Payette, IDA total loss of engine power during cruise flight due to fuel starvation. Contributing to the accident was the lack of an outlet screen on the fuel system header tank.Oct 13, 2021 · N583DM · Substantial damageNTSB WPR21LA360Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182E · Warren, IDThe pilot’s failure to maintain altitude while maneuvering in a valley of mountainous terrain.Sep 27, 2021 · N3121Y · DestroyedNTSB WPR21LA354Accident · No injuriesClass 3 · LimitedFinal reportHiller UH-12E · Bovill, IDA loss of helicopter control for undetermined reasons based on the available evidence for this accident.Sep 23, 2021 · N5334V · Substantial damageNTSB WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.Aug 28, 2021 · N922MA · Substantial damageNTSB WPR21LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Athol, IDThe failure of the windshield during spin recovery for reasons that were not determined.Aug 7, 2021 · N4110L · Substantial damageNTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.Jul 28, 2021 · N46MU · Substantial damageNTSB WPR21LA264Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Twin Falls, IDPartial loss of engine power during a low pass, due to carburetor icing and the pilot’s failure to use carburetor heat during the landing approach.Jul 1, 2021 · N9609H · Substantial damageNTSB WPR21LA107Accident · Serious injuriesClass 3 · LimitedFinal reportHughes OH-6A · Horseshoe Bend, IDA partial loss of engine power due to a leak in the fuel cell outlet valve.Feb 5, 2021 · N6639R · Substantial damageNTSB WPR20LA315Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Emmett, IDThe pilot’s descent below surrounding terrain and his delayed decision to initiate a climb which resulted in impact with terrain. Contributing to the accident were terrain and lighting conditions that affected the pilot’s ability to accurately assess terrain…Sep 23, 2020 · N836MM · Substantial damageNTSB WPR20LA330Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stanley, IDThe pilot's failure to maintain terrain clearance after flying into the wrong canyon in mountainous terrain which resulted in a collision with trees and terrain.Sep 13, 2020 · N52700 · Substantial damageNTSB WPR20LA191Accident · 1 fatalClass 3 · LimitedFinal reportEnstrom 280 · Hayden, IDThe total loss of power while maneuvering at low altitude due to the detonation of two engine cylinders and damaged spark plugs.Jun 24, 2020 · N280MM · DestroyedNTSB WPR20CA179Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Lenore, IDThe pilot's failure to maintain clearance from power lines while maneuvering during an aerial application flight, which resulted in a wire strike.Jun 12, 2020 · N40226 · DestroyedNTSB WPR20CA171Accident · Minor injuriesClass 4 · Data collectionFinal reportEnstrom 480 · Murphy, IDThe pilot's failure to maintain clearance from a power line while maneuvering during an aerial application flight.Jun 4, 2020 · N130JS · Substantial damageNTSB WPR20CA095Accident · No injuriesData collectionFinal reportCessna 172 · Dubois, IDThe student pilot's failure to maintain a proper airspeed and descent rate while conducting a low pass over a snow-covered runway after encountering a downdraft and the flight instructor's delayed action, which resulted in the wheels contacting the snow and…Feb 27, 2020 · N7904G · Substantial damageNTSB WPR20FA015Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · American Falls, IDThe pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…Oct 25, 2019 · N201BJ · Substantial damageNTSB GAA19CA437Accident · Minor injuriesData collectionFinal reportPiper PA36 · Bancroft, IDThe pilot's exceedance of the airplane's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall.Jul 15, 2019 · N57799 · Substantial damageNTSB GAA19CA283Accident · No injuriesData collectionFinal reportRockwell S2R · Grangeville, IDThe pilot's exceedance of the airplane's critical angle of attack while turning at low altitude, which resulted in an aerodynamic stall.May 24, 2019 · N5569X · Substantial damageNTSB WPR19LA092Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Melba, IDThe total loss of engine power due to a separated carburetor idle mixture adjustment screw and spring assembly for reasons that could not be determined.Mar 1, 2019 · N6486J · Substantial damageNTSB GAA19CA110Accident · No injuriesData collectionFinal reportRobinson R44 · Grace, IDThe pilot's failure to maintain clearance from the power lines.Jan 3, 2019 · N4246Z · Substantial damageNTSB WPR18FA276Accident · 3 fatalClass 2 · FieldFinal reportCessna T210 · Silver City, IDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.Sep 30, 2018 · N732MV · DestroyedNTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…Jun 21, 2018 · N1979P · Substantial damageNTSB WPR18LA163Accident · 1 fatalLimited investigationFinal reportNorth Wing Pulse · Mountain Home, IDThe hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…Jun 2, 2018 · N62073 · Substantial damageNTSB WPR18LA050Accident · No injuriesLimited investigationFinal reportGray Jim Robert Exec · Caldwell, IDFailure of the oil pressure gauge line, which resulted in oil exhaustion and a total loss of engine power.Dec 17, 2017 · N716JB · Substantial damageNTSB GAA18CA044Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot’s failure to see and avoid power lines while maneuvering at a low altitude.Nov 7, 2017 · N55234 · Substantial damageNTSB WPR17LA195Accident · 1 fatalLimited investigationFinal reportWalker Edgar E Glastar · Cascade, IDThe pilot's inadequate flight planning, preparation, and navigation, which resulted in the airplane entering a canyon that the pilot was unable to exit by climbing the airplane. Also causal were his in-flight decision-making and his execution of the course…Sep 2, 2017 · N65EW · DestroyedNTSB WPR17FA128Accident · 1 fatalField investigationFinal reportPrescot E. Wilkie RV-3 · Payette, IDThe in-flight failure of the left wing due to the owner's use of improper hardware and his improper assembly of the airplane, which reduced the strength of the left wing and resulted in its subsequent failure following a sharp pullup maneuver.Jun 17, 2017 · N177TT · DestroyedNTSB WPR17LA113Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rockville, IDThe in-flight failure of the engine-to-transmission drive shaft due to a fatigue fracture of one of the KAflex flex frames caused by a loose bolt, which resulted in a total loss of engine power and a subsequent hard landing.May 26, 2017 · N24FS · Substantial damageNTSB GAA17CA202Accident · Minor injuriesData collectionFinal reportCessna 182 · Mackay, IDThe pilot's decision to maneuver the airplane over mountainous terrain in high-density altitude conditions, which resulted in the airplane’s inability to maintain altitude or establish a climb.Mar 25, 2017 · N52743 · Substantial damageNTSB WPR16LA159Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Weiser, IDA partial loss of engine power due to an internal catastrophic failure of the master rod crankpin bearing.Aug 2, 2016 · N23923 · Substantial damageNTSB WPR16LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Salmon, IDA loss of engine power due to water in the fuel system. Contributing to the accident was an inadequate preflight inspection that failed to eliminate water from the fuel system.Jul 2, 2016 · N7748U · Substantial damageNTSB WPR16FA131Accident · 1 fatalField investigationFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.Jun 25, 2016 · N4585F · Substantial damageNTSB WPR16FA120Accident · 1 fatalField investigationFinal reportRockwell S2R · De Smet, IDThe pilot's inadequate visual lookout, which resulted in his failure to maintain clearance from guy wires during an aerial application flight. Contributing to the accident was the pilot's reduced ability to see the guy wires due to sun glare.Jun 6, 2016 · N4191X · Substantial damageNTSB WPR16LA082Accident · No injuriesLimited investigationFinal reportGrumman G164 · Juliaetta, IDA partial loss of engine power due to a crack in the No. 2 cylinder.Mar 12, 2016 · N6894Q · Substantial damageNTSB WPR15LA255Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/L · Jerome, IDThe pilot's failure to maintain clearance from terrain while conducting a low-altitude aerobatic maneuver.Sep 2, 2015 · N4BM · DestroyedNTSB GAA15CA255Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Irwin, IDThe pilot's failure to maintain obstacle clearance during low level flight, which resulted in the airplane striking a wire, impacting water, and nosing over.Aug 27, 2015 · N63BW · Substantial damageNTSB WPR14FA330Accident · 2 fatalField investigationFinal reportDavid Fitzgerald Zenith · Warren, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while climbing to avoid terrain while operating at a high density altitude, which resulted in a stall at too low an altitude to allow recovery.Aug 5, 2014 · N32FZ · Destroyed