OpenAirDocs.org

NTSB investigations

18,849 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 GAA24WA061Accident · 3 fatalClass 5 · ForeignAir Tractor AT502 · Carletonville, South AfricaDec 29, 2023 · ZS-XPC · 2 aircraft · Substantial damageNTSB ERA24LA083Accident · No injuriesClass 4 · LimitedFinal reportRabe Richard Exec 162F · Tuscumbia, ALThe pilot’s failure to maintain control of the helicopter, which resulted in the right skid contacting the ground and a subsequent rollover.Dec 16, 2023 · N60932 · Substantial damageNTSB ERA24LA066Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Asheville, NCFatigue failure of the No. 4 inner main bearing cap screw and connecting rod bolts, which resulted in a total loss of engine power. Contributing to the failure were the low material strength of the inner main bearing cap screw and the increased loads on the…Dec 15, 2023 · N907L · Substantial damageNTSB GAA24WA053AccidentClass 5 · ForeignAir Tractor AT301 · Orihueca, ColombiaDec 9, 2023 · HK4952 · Substantial damageNTSB ERA24LA060Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Mount Vernon, ALThe pilot’s decision to operate the airplane at a low altitude over a river, and his failure to maintain clearance from the river while maneuvering.Dec 8, 2023 · N5952T · Substantial damageNTSB WPR24LA092Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calexico, CAThe pilot's failure to maintain clearance from power lines during an aerial application flight.Dec 6, 2023 · N422DX · Substantial damageNTSB GAA24WA052Accident · 5 fatalClass 3 · ForeignBell 412 · Arau, GuyanaDec 6, 2023 · 8R-AYA · DestroyedNTSB ERA24LA057Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Social Circle, GAAn encounter with a downdraft while maneuvering at low altitude, which resulted in a collision with a fence.Dec 5, 2023 · N53AA · Substantial damageNTSB ERA24FA055Accident · 2 fatalClass 3 · FieldFinal reportBeech E95 · Elkmont, ALThe flight instructor’s failure to maintain control of the airplane during slow flight, which resulted in an aerodynamic stall and spin from which he was unable to recover.Dec 4, 2023 · N369BB · Substantial damageNTSB GAA24WA047Accident · Serious injuriesClass 5 · ForeignBell Helicopter Textron 206L-1 · El Mirador, GuatemalaNov 30, 2023 · N2249Z · Substantial damageNTSB CEN24LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Manitowoc, WIMaintenance personnel’s improper servicing of the magnetos, which resulted in their accelerated wear, failure, and the total loss of engine power.Nov 30, 2023 · N8880T · Substantial damageNTSB CEN24FA049Accident · 2 fatalClass 3 · FieldFinal reportMD Helicopters 600 · Sterling City, TXThe pilot’s failure to maintain clearance from a power line pole’s static arm during forecasted gusting wind conditions, un-forecasted light turbulence, and un-forecasted low-level wind shear conditions, resulting in main rotor blade contact with the static…Nov 29, 2023 · N745MB · Substantial damageNTSB GAA24WA045Accident · Minor injuriesClass 5 · ForeignCessna 172 · Vera Cruz, BrazilNov 26, 2023 · PT-OOB · Substantial damageNTSB GAA24WA044Accident · 1 fatalClass 4 · ForeignRobinson R66 · Ramallo, ArgentinaNov 26, 2023 · LV-FQJ · Substantial damageNTSB GAA24WA043Accident · 4 fatalClass 5 · ForeignRockwell 112 · Kasberg, Grünau im Almtal, AustriaNov 25, 2023 · D-ELPO · Substantial damageNTSB WPR24LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Woodland, WAThe flight instructor’s inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.Nov 18, 2023 · N6266K · Substantial damageNTSB WPR24LA036Accident · No injuriesClass 4 · LimitedFinal reportBell OH-58A · Estacada, ORThe pilot’s failure to maintain helicopter control during an external load operation, which resulted in the helicopter’s main rotor blades impacting the tail boom.Nov 15, 2023 · N103WC · Substantial damageNTSB ERA24FA038Accident · 2 fatalClass 3 · FieldFinal reportXtremeair XA42 · Union City, TNThe pilot receiving instruction’s loss of airplane control while performing aerobatics, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the flight instructor’s inadequate supervision.Nov 15, 2023 · N42XM · Substantial damageNTSB WPR24FA035Accident · 2 fatalClass 3 · FieldFinal reportCessna 172G · Provo, UTThe pilot's exceedance of the airplane's critical angle of attack during a chandelle maneuver, which resulted in an aerodynamic stall and descent into trees and terrain. Contributing to the accident was the pilot’s decision to maneuver into a canyon and…Nov 14, 2023 · N3971L · Substantial damageNTSB CEN24LA036Accident · No injuriesClass 3 · LimitedFinal reportTextron 172S · Erie, COA partial loss of engine power while maneuvering at a low altitude due to a stuck exhaust valve.Nov 9, 2023 · N1817E · Substantial damageNTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionOct 31, 2023 · F-HLOU · DestroyedNTSB ERA24LA028Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Ronkonkoma, NYThe student pilot’s abrupt control input and the flight instructor’s inadequate remedial action, which resulted in a dynamic rollover.Oct 28, 2023 · N964SH · Substantial damageNTSB CEN24LA029Accident · No injuriesClass 4 · LimitedFinal reportAg-Cat G-164B · Abbeville, LAThe pilot’s failure to maintain clearance from a power line during an aerial application flight.Oct 28, 2023 · N910MG · Substantial damageNTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…Oct 24, 2023 · N5180W · Substantial damageNTSB CEN24LA031Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Manhattan, KSThe pilot’s improper modification of the engine cooling system that resulted in an engine overheat and total loss of power. Contributing to the accident was the pilot’s decision to continue the flight after the engine overheat light illuminated instead of…Oct 21, 2023 · N52631 · Substantial damageNTSB GAA24WA013Accident · 1 fatalClass 5 · ForeignCessna 208 · Monêtier-Allemont, FranceOct 15, 2023 · F-HSLE · DestroyedNTSB CEN24LA006Accident · 1 fatalClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Saint Peter, MNThe pilot's failure to maintain clearance from power lines during low-level maneuvering through a river valley.Oct 8, 2023 · N557LJ · Substantial damageNTSB CEN24LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Riesel, TXAn in-flight collision with a bird.Oct 6, 2023 · N2444H · Substantial damageNTSB WPR24FA004Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-44-180 · Newberg, ORThe pilot receiving instruction’s failure to maintain control of the airplane and the flight instructor’s inadequate supervision of the flight, which resulted in a stall/spin from which they were unable to recover.Oct 4, 2023 · N8360K · Substantial damageNTSB CEN24LA005Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia Heights, ILThe student pilot’s failure to maintain helicopter control which resulted in impact with the ground.Oct 2, 2023 · N354MH · Substantial damageNTSB WPR24LA009Accident · Serious injuriesClass 3 · LimitedFinal reportStephen D Phillabaum Helicycle · Deer Park, WAA loss of engine power due to fuel starvation resulting from contamination of the fuel system during low-level flight.Oct 1, 2023 · N519SP · Substantial damageNTSB GAA23WA279Accident · No injuriesClass 5 · ForeignHughes 369 · Middlesmoor, United KingdomSep 29, 2023 · G-OBAS · Substantial damageNTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…Sep 29, 2023 · N95SF · Substantial damageNTSB CEN23LA422Accident · Minor injuriesClass 4 · LimitedFinal reportQuicksilver Sport II · Welsh, LAThe pilot’s failure to maintain sufficient altitude from obstacles during the simulated landing approach which led to a collision with a fence and a building.Sep 26, 2023 · N728NN · Substantial damageNTSB WPR23FA351Accident · 1 fatalClass 3 · FieldFinal reportGolden Circle T Bird · Arlington, WAA failure of the forward left wing spar due to an improper repair, which resulted in an inflight separation of the left wing. Contributing to the accident was improper maintenance by splicing the wing spar.Sep 22, 2023 · UNREG · Substantial damageNTSB GAA23WA269Accident · No injuriesClass 5 · ForeignBell 204B · Aratula, AustraliaSep 20, 2023 · VH-EQW · DestroyedNTSB CEN23FA412Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · New Rockford, NDThe pilot’s failure to maintain clearance from overhead power lines during an aerial application flight. Contributing to the accident was the pilot’s decision to fly under the power lines with a small area of clearance available for the airplane.Sep 19, 2023 · N502NB · Substantial damageNTSB GAA23WA264Accident · No injuriesClass 5 · ForeignCessna 170 · Doutor Ulysses, BrazilSep 17, 2023 · PP-DSX · Substantial damageNTSB ANC23LA085Accident · Serious injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · Johnson River, AKThe ground crew’s failure to remain clear of a tag line during sling load operations, resulting in his entanglement.Sep 16, 2023 · N297SH · No damageNTSB ERA23LA369Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland EC135T2 · Fargo, GAThe separation of the outer span of a tail rotor blade during flight as a result of localized intergranular corrosion due to a diminished protective coating at a critical location on the tail rotor blade surface that, combined with cyclic loading, resulted in…Sep 13, 2023 · N273AM · Substantial damageNTSB ANC23LA077Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.Sep 13, 2023 · N95250 · Substantial damageNTSB CEN23FA409Accident · 1 fatalClass 3 · FieldFinal reportThrush S2R-T660 · Ardoch, NDThe pilot’s failure to maintain clearance from a guy wire during an aerial application flight.Sep 12, 2023 · N710TY · Substantial damageNTSB CEN23LA414Accident · Minor injuriesClass 4 · LimitedFinal reportBuckeye Dream Machine · Fortuna, MOThe non-certificated pilot’s failure to maintain the unregistered powered parachute’s clearance from power lines.Sep 11, 2023 · UNREG · Substantial damageNTSB ANC23LA081Accident · Serious injuriesClass 4 · LimitedFinal reportPiper/Gerbi Charles R PA 18-150 · Juneau, AKThe student pilot’s failure to maintain altitude after the airplane encountered a downdraft while maneuvering over an area of hilly terrain.Sep 11, 2023 · N4900C · Substantial damageNTSB WPR23LA338Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Balch Camp, CAThe pilot’s inadequate performance planning for the operation that resulted in an excessive gross weight for the operating conditions, leading to a loss of altitude during maneuvering and contact with trees. Contributing to the accident was the pilot’s…Sep 10, 2023 · N873HL · DestroyedNTSB GAA23WA253Accident · 2 fatalClass 5 · ForeignNorth American T28 · Székesfehérvár, HungarySep 10, 2023 · HA-RDM · DestroyedNTSB WPR23LA339Accident · No injuriesClass 4 · LimitedFinal reportEurocopter France AS350B2 · Silverton, WAThe pilot’s failure to maintain visual reference and altitude while maneuvering over a lake during dusk conditions, which resulted in the helicopter impacting water.Sep 9, 2023 · N350WW · Substantial damageNTSB GAA23WA251Accident · No injuriesClass 5 · ForeignRobinson R44 · Manta, EcuadorSep 8, 2023 · HC-CPV · Substantial damageNTSB WPR23LA336Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-18-135 · Compton, CAAn overstress fracture of the pilot’s seat, which resulted in the loss of control during takeoff and the pilot’s inadvertent movement of the fuel selector and subsequent partial loss of engine power.Sep 3, 2023 · N7199K · Substantial damageNTSB CEN23LA393Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Plover, WIThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.Sep 1, 2023 · N172SP · Substantial damage