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 ERA20FA013Accident · 1 fatalClass 3 · FieldFinal reportSportine Aviacija LAK17B · Tamaqua, PAThe pilot's exceedance of the glider's critical angle of attack while climbing in thermal lift, which resulted in an aerodynamic stall/spin.Oct 18, 2019 · N830DK · Substantial damageNTSB GAA20CA033Accident · No injuriesData collectionFinal reportWeatherly 620 · Fabens, TXThe pilot's failure to maintain clearance from power wires while maneuvering at a low altitude.Oct 17, 2019 · N9033T · Substantial damageNTSB ERA20FA012Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · New Salem, NCThe pilot's inadequate visual lookout, which resulted in impact with a powerline.Oct 17, 2019 · N167AG · Substantial damageNTSB WPR20LA007Accident · Minor injuriesClass 3 · LimitedFinal reportHiller UH 12E · Susanville, CAA partial loss of engine power due to multiple overtemperature events and a hot start event, which resulted in thermally damaged internal components of the engine. Contributing to the accident was the lack of suitable terrain on which to perform the forced…Oct 14, 2019 · N131HA · Substantial damageNTSB WPR20WA010Accident · No injuriesForeign investigationBell 412 · Port Said City, EgyptOn October 11, 2019, about 1147 coordinated universal time, a Bell Helicopter 412EP, SU-CBX, impacted the sea about 65 miles north of Port Said City, Egypt after losing control in flight. There were no injuries to the two pilots and three passengers, and the…Oct 11, 2019 · SU-CBX · Substantial damageNTSB GAA20CA020Accident · Minor injuriesData collectionFinal reportAyres S2R · Willacoochee, GAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.Oct 11, 2019 · N3090C · Substantial damageNTSB GAA20CA018Accident · Serious injuriesData collectionFinal reportFoxworthy Rick A Sonex · Langley, WAThe pilot's failure to maintain a proper approach path, which resulted in impact with a tree.Oct 11, 2019 · N612RF · Substantial damageNTSB CEN20FA010Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Aberdeen, SDThe noncertificated pilot’s decision to fly in dark night instrument conditions, resulting in impact with terrain.Oct 10, 2019 · N6483B · DestroyedNTSB WPR20LA004Accident · Minor injuriesClass 3 · LimitedFinal reportGlaser Dirks DG500 · Marana, AZThe pilots’ exceedance of the glider’s never-exceed speed (VNE) during recovery from an intentional aerobatic maneuver, which resulted in a failure of the right-wing air brake control drive, asymmetrical air brake deployment, and a subsequent hard landing.Oct 6, 2019 · N600TT · Substantial damageNTSB ERA20FA003Accident · Serious injuriesClass 3 · FieldFinal reportChampion 7ECA · Pembroke Pines, FLThe pilot’s failure to relinquish the airplane controls to the instructor during a power-off stall maneuver, which prevented the instructor’s recovering from the stall.Oct 5, 2019 · N2561G · Substantial damageNTSB ERA20FA002Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Asheboro, NCThe pilot’s loss of airplane control due to spatial disorientation, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent night flight experience.Oct 5, 2019 · N2FB · DestroyedNTSB CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…Oct 5, 2019 · N326CW · DestroyedNTSB ERA20LA004Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Fort Meade, FLThe pilot's failure to maintain control of the helicopter, which resulted in a dynamic rollover and impact with terrain.Oct 3, 2019 · N911RW · Substantial damageNTSB ERA19FA283Accident · 3 fatalClass 3 · FieldFinal reportCessna 421 · Deland, FLThe pilot’s failure to maintain control of the airplane, which resulted in a collision with terrain. Contributing was the pilot’s lack of training and experience in the accident airplane make and model.Sep 29, 2019 · N731PF · DestroyedNTSB ERA19LA286Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass · Dalton, GAThe pilot's exceedance of the aircraft's critical angle of attack during a turn shortly after takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing was the pilot's lack of experience in the accident aircraft.Sep 28, 2019 · UNREG · Substantial damageNTSB CEN19LA334Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Columbus, MSA total loss of engine power control for undetermined reasons.Sep 27, 2019 · N801BF · Substantial damageNTSB CEN19FA323Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · London, OHThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering toward the final leg of the traffic pattern and facing the rising sun, which resulted in a subsequent aerodynamic stall at too low an altitude to recover.Sep 18, 2019 · N5438U · DestroyedNTSB ERA19LA273Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Sardis, GAFatigue failure of the fasteners on the engine crankshaft, which resulted in a partial loss of engine power and a subsequent forced landing.Sep 17, 2019 · N827JE · Substantial damageNTSB ERA19FA275Accident · 2 fatalClass 3 · FieldFinal reportVans RV 8 · Stroudsburg, PAThe pilot's failure to maintain control of the airplane for undetermined reasons.Sep 17, 2019 · N7TL · DestroyedNTSB CEN19TA321Accident · No injuriesClass 3Final reportPiper PA46 · Gulf of MexicoA loss of engine power for undetermined reasons.Sep 15, 2019 · N218MW · DestroyedNTSB CEN19LA318Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Hill City, SDA total loss of engine power for undetermined reasons, which resulted in a hard landing.Sep 12, 2019 · N100CK · Substantial damageNTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.Sep 12, 2019 · N6035L · Substantial damageNTSB WPR19LA261Accident · Minor injuriesClass 3 · LimitedFinal reportHavoc Air Racing Super GT 111 · Reno, NVThe failure of the landing gear to extend for reasons that could not be determined.Sep 9, 2019 · N400MC · Substantial damageNTSB CEN19LA309Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Walkerton, INThe partial loss of engine power due to fuel contamination.Sep 9, 2019 · N19TV · Substantial damageNTSB GAA19CA535Accident · Minor injuriesData collectionFinal reportAir Tractor AT 602 · Turkey, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during a low pass, which resulted in an aerodynamic stall and impact with terrain.Sep 8, 2019 · N602SS · Substantial damageNTSB ERA19LA267Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Berlin, MDThe malfunction of the No. 9 pushrod, which resulted in a total loss of engine power.Sep 8, 2019 · N8386K · Substantial damageNTSB WPR19FA250Accident · 2 fatalClass 3 · FieldFinal reportCessna 210 · Henefer, UTThe pilots’ decision to enter a canyon at low altitude, which resulted in controlled flight into terrain while attempting to exit the canyon.Sep 4, 2019 · N94262 · Substantial damageNTSB ERA19LA263Accident · 1 fatalClass 3 · LimitedFinal reportWeatherly 620 · Russellville, ALThe pilot's failure to see and avoid powerlines during low-altitude agricultural spraying flight operations.Sep 2, 2019 · N90104 · DestroyedNTSB ANC19CA057Accident · Minor injuriesData collectionFinal reportPiper PA22 · Arctic Village, AKThe pilot's failure to maintain adequate airspeed while maneuvering to avoid mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.Aug 30, 2019 · N7056D · Substantial damageNTSB WPR19FA246Accident · 3 fatalClass 3 · FieldFinal reportBeech 33 · St. Ignatius, MTThe pilot’s decision to maneuver the airplane at a low altitude, which resulted in impact with power lines and terrain.Aug 29, 2019 · N9529Y · Substantial damageNTSB WPR19TA245Accident · No injuriesClass 3Final reportBell 47G · North Las Vegas, NVThe noncertificated passenger’s loss of control during attempted hover operations.Aug 28, 2019 · N6064H · Substantial damageNTSB WPR19FA235Accident · 1 fatalClass 3 · FieldFinal reportMeyers Midget 0100 · Big Spring, TXThe pilot’s failure to maintain situational awareness while conducting a roll, which resulted in his inability to recover from the maneuver before the airplane impacted the ground. Contributing to the accident was his inexperience in both aerobatic maneuvers…Aug 24, 2019 · N881MM · Substantial damageNTSB GAA19CA509Accident · Serious injuriesData collectionFinal reportRobinson R44 · Cypress Island, WAThe pilot's failure to maintain adequate clearance from a tree while maneuvering at a low altitude.Aug 21, 2019 · N7186P · Substantial damageNTSB CEN19TA280Accident · Serious injuriesClass 3Final reportBell 47G · Montrose, COA loss of engine power due to fuel starvation, which resulted from attitude-induced unporting of the fuel.Aug 20, 2019 · N1170W · Substantial damageNTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.Aug 20, 2019 · N3631Z · DestroyedNTSB GAA19CA502Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Onida, SDThe pilot's failure to maintain clearance from power wires during agricultural application operations.Aug 16, 2019 · N500KA · Substantial damageNTSB CEN19LA269Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Blair, NEThe loss of main rotor rpm for reasons that could not be determined based on the available evidence, which resulted in a hard landing.Aug 16, 2019 · N106PD · Substantial damageNTSB WPR19LA222Accident · Minor injuriesClass 3 · LimitedFinal reportZenith 601XLB · Jamul, CALoss of engine power due to an undetermined loss of electrical power to the engine control system. Contributing factors were the lack of a redundant system to provide for engine control should the engine control system be deprived of electrical power or fail.Aug 15, 2019 · N662WB · Substantial damageNTSB WPR19LA218Accident · No injuriesClass 3 · LimitedFinal reportExtra EA300 · Mesa, AZThe flight instructor’s operation of the airplane outside of the manufacturer’s limitations, which resulted in fuel starvation and a partial loss of engine power. Contributing to the accident was an inoperative electric fuel boost pump.Aug 14, 2019 · N19AM · Substantial damageNTSB ERA19LA246Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jay, FLThe pilot's improper decision to fly over a river at a very low altitude, which resulted in a collision with power lines.Aug 13, 2019 · N84287 · Substantial damageNTSB ERA19FA243Accident · 2 fatalClass 2 · FieldFinal reportPoberezny Acro Sport II · Jersey Shore, PAThe pilot's decision to conduct low altitude aerobatic maneuvers which resulted in an exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude, which resulted in an aerodynamic stall.Aug 11, 2019 · N43032 · Substantial damageNTSB WPR19LA217Accident · No injuriesClass 3 · LimitedFinal reportCessna 206 · Prospect, ORThe failure of the counterweight retainer pin plate which resulted in a total loss of engine power.Aug 10, 2019 · N5152U · Substantial damageNTSB WPR19LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Phoenix, AZThe failure of the landing gear due to the nose gear being positioned to the far right during retraction, which caused the nose gear to jam upon retraction.Aug 8, 2019 · N10KC · Substantial damageNTSB CEN19FA259Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Sumner, IAThe pilot’s impairment by medical conditions and/or medications, which resulted in the airplane’s impact with power lines and terrain.Aug 8, 2019 · N6113C · DestroyedNTSB CEN19FA253Accident · 1 fatalClass 3 · FieldFinal reportJonker Sailplanes JS1C · Cotulla, TXThe pilot’s failure to maintain sufficient airspeed of the glider, which resulted in exceedance of the glider's critical angle of attack and an aerodynamic stall/spin.Aug 7, 2019 · N213DT · DestroyedNTSB ANC19FA042Accident · 4 fatalField investigationFinal reportPiper PA22-150 · Girdwood, AKThe pilot's failure to maintain clearance from terrain due to his impairment from alcohol consumption.Aug 5, 2019 · N7402D · DestroyedNTSB GAA19CA480Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Waco, NEThe pilot's failure to maintain clearance from wires during an agricultural application flight.Aug 4, 2019 · N730JD · Substantial damageNTSB CEN19LA250Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Lyons, NEThe engine's low cylinder compression, which resulted in low rotor rpm and a subsequent dynamic rollover following landing on soft terrain.Aug 3, 2019 · N440EM · Substantial damageNTSB GAA19CA481Accident · No injuriesData collectionFinal reportRobinson R66 · Vandalia, ILThe pilot's failure to maintain clearance from power lines during an agricultural application flight.Aug 2, 2019 · N1767L · Substantial damageNTSB GAA19CA473Accident · Minor injuriesData collectionFinal reportRobinson R44 · Fessenden, NDThe pilot's failure to maintain clearance from wires during an agricultural application flight.Jul 31, 2019 · N3066T · Substantial damage