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 ERA21FA318Accident · 2 fatalClass 3 · FieldFinal reportPitts 12 · Ocklawaha, FLThe pilot’s failure to maintain airplane control while performing aerobatic maneuvers, which resulted in an inverted flat spin from which he was unable to recover.Aug 9, 2021 · N112JH · 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 ERA21FA317Accident · 2 fatalClass 3 · FieldFinal reportRotorway Exec 162F · Argyle, NYThe pilot’s abrupt control inputs, which resulted in a low G condition, main rotor mast bumping, and the subsequent severing of the tail boom by a main rotor blade.Aug 7, 2021 · N162KJ · DestroyedNTSB CEN21LA362Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Topeka, KSThe pilot’s decision to continue low-level aerial application flight maneuvers after the low fuel warning light illuminated, which resulted in a partial loss of engine power due to fuel exhaustion.Aug 6, 2021 · N502CP · Substantial damageNTSB GAA21WA195Accident · 2 fatalClass 5 · ForeignTecnam P2002 · Khabarovsk, RussiaAug 4, 2021 · RA-2329G · Substantial damageNTSB CEN21LA356Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Corydon, INThe pilot’s failure to see and avoid power lines.Aug 4, 2021 · N59552 · Substantial damageNTSB CEN21LA354Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Wooster, OHThe pilot inadvertently collided with powerline wires during an agricultural spraying flight, resulting in a loss of aircraft control and subsequent impact with the ground.Aug 4, 2021 · N1519U · Substantial damageNTSB CEN21LA350Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Waukon, IAThe pilot’s failure to maintain adequate clearance from a powerline during an agricultural application pass.Aug 4, 2021 · N775AK · Substantial damageNTSB CEN21FA355Accident · 2 fatalClass 3 · FieldFinal reportNorth American T-6G · Starkville, MSThe pilot’s failure to maintain clearance from trees while maneuvering at low altitude.Aug 4, 2021 · N7197C · DestroyedNTSB GAA21WA198Accident · No injuriesClass 5 · ForeignCessna 182 · Tannheim, GermanyJul 31, 2021 · D-EEHR · Substantial damageNTSB CEN21LA349Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Randolph, WIThe pilot’s failure to maintain clearance from power lines during a low-level aerial application flight.Jul 31, 2021 · N285RG · 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 WPR21FA298Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Banning, CAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.Jul 30, 2021 · N8520G · Substantial damageNTSB CEN21LA348Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Merry, NEThe pilot’s failure to maintain clearance from a wire during a low-level aerial application flight.Jul 30, 2021 · N857TL · 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 GAA21WA189Accident · 4 fatalClass 3 · ForeignAerospool WT10 · Sheparivtsi Village, UkraineJul 28, 2021 · UR-PAMA · DestroyedNTSB ANC21LA064Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-14 · Anchorage, AKThe fatigue fracture of the American Iron and Steel Institute (AISI) 1025 carbon steel rudder post, which resulted in structural failure of the rudder. Contributing to the fatigue failure was the post’s susceptibility to fatigue cracking under normal service…Jul 23, 2021 · N4206H · Substantial damageNTSB GAA21WA180Accident · 2 fatalClass 5 · ForeignPiper PA28 · Contrada Coccaro Fasano, ItalyJul 20, 2021 · I-SVBA · Substantial damageNTSB CEN21LA452Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mineral Point, WIThe pilot’s failure to see and avoid a wire during an aerial application flight, resulting in a collision with the wire.Jul 20, 2021 · N44XB · Substantial damageNTSB CEN21LA339Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · West Liberty, IAThe pilot’s failure to see and avoid a wire while maneuvering at low altitude during an aerial application flight, resulting in a collision with the wire.Jul 20, 2021 · N983HA · Substantial damageNTSB CEN21FA330Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Elgin, MNThe pilot’s decision to operate the helicopter under powerlines, which resulted in a main rotor blade striking a powerline, causing the helicopter to descend from a low altitude and impact terrain.Jul 19, 2021 · N44BJ · DestroyedNTSB CEN21FA327Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8F · Comstock, TXImpact with terrain for reasons that could not be determined based on the available information.Jul 18, 2021 · N2054B · DestroyedNTSB GAA21WA181Accident · 2 fatalClass 5 · ForeignCessna 150 · Marcos Paz, ArgentinaJul 16, 2021 · LV-JFK · Substantial damageNTSB ERA21LA292Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Princeton, KYThe pilot’s inadequate preflight planning in that he failed to accurately determine the takeoff weight of the helicopter, which resulted in exceeding the helicopter’s maximum weight capability.Jul 16, 2021 · N512RT · Substantial damageNTSB ERA21LA289Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Easton, MDA total loss of left engine power and uncommanded feathering of the left propeller for reasons that could not be determined.Jul 15, 2021 · N776MC · Substantial damageNTSB CEN21LA319Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-401 · Carroll, IAThe wear-related failure of the airframe fuel boost pump, which resulted in fuel starvation and a loss of engine power.Jul 13, 2021 · N7315P · Substantial damageNTSB CEN21FA314Accident · 1 fatalClass 3 · FieldFinal reportPZL Mielec M18 · Seiling, OKThe pilot’s in-flight loss of control due to the structural failure of a wing fitting and separation of the outboard wing section. Also causal were the inadequate wing fitting inspections, which failed to detect the initial corrosion and crack before it…Jul 12, 2021 · N9310R · DestroyedNTSB CEN21LA313Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Newell, IAThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.Jul 11, 2021 · N949TM · Substantial damageNTSB WPR21FA265Accident · 2 fatalClass 3 · FieldFinal reportNorth Wing Mustang · Albany, ORThe noncertificated pilot’s loss of aircraft control after a low-level turn with a bank angle that exceeded the manufacturer’s operating limitations.Jul 10, 2021 · UNREG · Substantial damageNTSB CEN21LA432Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Berlin, ILThe pilot’s failure to maintain control of the helicopter with a stuck skid, which resulted in a dynamic rollover.Jul 9, 2021 · N170AM · Substantial damageNTSB WPR21LA268Accident · No injuriesClass 3 · LimitedFinal reportBell 212HP · Weed, CAThe pilot’s failure to maintain altitude during an approach to a lake. Contributing to the accident was the pilot’s failure to release the full water bucket as the helicopter was settling, which reduced the helicopter’s out-of-ground-effect performance.Jul 7, 2021 · N911KW · Substantial damageNTSB CEN21LA318Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Nappanee, INThe pilot’s failure to maintain clearance from the tower during low-level agricultural operations.Jul 6, 2021 · N602RE · 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 GAA21WA156Accident · 1 fatalClass 4 · ForeignBell 212 · Evansburg, CanadaJun 29, 2021 · C-GYHQ · DestroyedNTSB CEN21LA296Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Hoxie, ARThe pilot’s failure to ensure an adequate fuel supply for the intended flight.Jun 29, 2021 · N6611K · Substantial damageNTSB ERA21LA273Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Woodland, TNThe student pilot’s inadequate monitoring of his fuel state during a solo training flight, which resulted in fuel starvation, a total loss of engine power, and a forced landing.Jun 28, 2021 · N818TF · Substantial damageNTSB ERA21LA272Accident · Minor injuriesClass 4 · LimitedFinal reportBell 47G-2A-1 · Brasstown, NCThe pilot’s inflight loss of control while conducting a hovering maneuver.Jun 28, 2021 · N147AH · Substantial damageNTSB WPR21FA243Accident · 1 fatalClass 3 · FieldFinal reportFeraca Edward M Searey LSX · Logan, UTThe pilot’s loss of airplane control while maneuvering at a low altitude, which resulted in a collision with a house.Jun 27, 2021 · N62EF · Substantial damageNTSB ERA21LA270Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Waxhaw, NCThe pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight.Jun 27, 2021 · N7078V · Substantial damageNTSB CEN21LA292Accident · Minor injuriesClass 4 · LimitedFinal reportCurnutt Elton E SKY Ranger B · Ellicott, COThe pilot’s loss of control while maneuvering at low altitude.Jun 27, 2021 · N7714E · Substantial damageNTSB ERA21LA269Accident · 1 fatalClass 3 · LimitedFinal reportGarlick Helicopters OH-58A+ · Alpine, ALThe pilot’s failure to maintain clearance from powerlines during a low-level aerial application flight, resulting in main rotor blade impact with a fiber-optic cable, a loss of control, and the helicopter’s subsequent impact with terrain.Jun 25, 2021 · N372NS · Substantial damageNTSB CEN21LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAyres S2R-T34 · Leoti, KSThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in his inability to maintain airplane control during low-level flight and an impact with terrain. Contributing to the accident was the…Jun 21, 2021 · N4328P · Substantial damageNTSB CEN21LA283Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Edwardsburg, MIThe pilot’s failure to identify rising terrain and to maintain terrain clearance from trees during an aerial application pass that resulted in an in-flight collision with trees and terrain.Jun 20, 2021 · N8523Z · Substantial damageNTSB ERA21LA262Accident · Serious injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Swan Lake, NYThe pilot's failure to maintain adequate clearance from the power transmission tower structure during powerline maintenance work, which resulted in the helicopter's main rotor striking the lifeline support bracket for the tower catwalk and the subsequent loss…Jun 18, 2021 · N371EE · Substantial damageNTSB ERA21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 150 · Yulee, FLThe flight instructor’s decision to conduct slow flight training at an altitude below the flight school’s minimum recovery altitude and his delayed remedial action when an aerodynamic stall occurred.Jun 18, 2021 · N1300Q · DestroyedNTSB ERA21FA257Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-402B · Kinston, NCThe pilot’s decision to conduct low-level aerobatic maneuvers in an airplane not approved for aerobatic flight, which resulted in an aerodynamic stall and spin, a loss of control, and an impact with terrain.Jun 18, 2021 · N402SJ · DestroyedNTSB CEN21LA273Accident · No injuriesClass 3 · LimitedFinal reportTony Dubeansky RV10 · Fort Worth, TXA partial loss of engine power due to a separated electronic ignition system connector. Contributing to the accident was the location of the ignition boxes, which provided limited access to the connectors for visual inspection.Jun 16, 2021 · N878TD · Substantial damageNTSB CEN21FA270Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor 502B · Paragould, ARAn inflight loss of control and subsequent impact with terrain during an aerial application flight for reasons that could not be determined based on the available evidence.Jun 15, 2021 · N6088K · DestroyedNTSB CEN21LA271Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210L · Buena Vista, COThe partial loss of engine power due to a vane failure in the engine-driven fuel pump.Jun 14, 2021 · N30286 · Substantial damageNTSB CEN21LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Saint James, LAThe in-flight fatigue failure of an air-conditioning system hose which resulted in a precautionary landing and impact with a road sign.Jun 10, 2021 · N365CP · Substantial damage