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 CEN16WA060Incident · No injuriesForeign investigationSikorsky S92 · Wexford, IrelandOn December 6, 2015, at 1415 universal coordinated time, a Sikorsky S92 helicopter, Irish registration EI-ICG, was involved in an off shore rescue operation. Two victims were being recovered when one of the victims slipped from the recue harness, fell back…Dec 6, 2015 · EI-ICG · No damageNTSB CEN16FA059Accident · 1 fatalField investigationFinal reportCessna 182C · Pattonsburg, MOThe pilot's loss of airplane control while maneuvering during low-level flight for reasons that could not be determined because examination of the airframe and engine did not reveal any preimpact anomalies.Dec 6, 2015 · N8777T · DestroyedNTSB ANC16WA008Accident · 2 fatalForeign investigationRobinson R22 · Annaka City, JapanOn November 22, 2015, at 0157 coordinated universal time, a Japanese registered Robinson R22 helicopter, JA7963, operated by a private individual, impacted the slope face of a speedway in Annaka City, Gunma Prefecture, Japan. The pilot and sole passenger…Nov 22, 2015 · JA7963 · DestroyedNTSB ANC16WA007Accident · 2 fatalForeign investigationBell 206 · New Taipei City, TaiwanOn November 22, 2015, about 0302 Coordinated Universal Time, a Bell 206 helicopter, Taiwan Island registration number B-31127, operated by Emerald Pacific Airlines, was destroyed following an impact with terrain about 7 nautical miles southwest of Taipei…Nov 22, 2015 · B31127 · DestroyedNTSB CEN16LA043Accident · Minor injuriesLimited investigationFinal reportHickham Lancair IV-P · Shawano, WIA total loss of engine power due to a dual magneto failure, as a result of an exceedance of the engine’s operating limitations while maneuvering.Nov 15, 2015 · N10UU · Substantial damageNTSB CEN16LA040Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Sugarland, TXThe overspeed of the main rotor system for reasons that could not be determined based on the available information.Nov 14, 2015 · N7058Z · Substantial damageNTSB CEN16LA039Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Alpine, TXThe pilot’s failure to maintain adequate rotor speed while maneuvering at low altitude, which resulted in a descent from which he was unable to recover. Contributing to the accident was the pilot's decision to conduct the flight at or near the helicopter's…Nov 13, 2015 · N449MC · Substantial damageNTSB CEN16WA041Accident · 2 fatalForeign investigationCessna 182 · Parry Sound, CanadaOn November 10, 2015, at 0020 universal coordinated time, a Canadian registered Cessna 182H airplane, C-GKNZ, impacted terrain shortly after takeoff from the Parry Sound Area Municipal Airport (CNK4), Parry Sound, Ontario, Canada. The pilot and passenger were…Nov 10, 2015 · C-GKNZ · DestroyedNTSB ERA16FA031Accident · 1 fatalField investigationFinal reportFlight Design Ctls · Queens, NYThe noninstrument-rated pilot's spatial disorientation and subsequent loss of airplane control while maneuvering at low altitude, over water with no visible horizon, in dark night conditions, which resulted in a collision with the water.Nov 5, 2015 · N622BT · Substantial damageNTSB CEN16LA031Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Wakeman, OHA loss of engine power/performance for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Nov 4, 2015 · N80825 · Substantial damageNTSB WPR16LA021Accident · No injuriesLimited investigationFinal reportMD Helicopter 369D · Sedro-Woolley, WAThe loss of engine power due to fuel starvation as a result of naphthenate fuel contamination, which blocked the fuel flow through the start pump.Nov 3, 2015 · N510PA · Substantial damageNTSB CEN16LA027Accident · No injuriesLimited investigationFinal reportBell 407 · San Antonio, TXThe failure of the No. 3 tail rotor adapter and shaft due to a loss of torque on the retaining nut. Contributing to the accident was the lack of a requirement to inspect the tail rotor assembly for security in the helicopter manufacturer's maintenance manual…Nov 3, 2015 · N496AE · Substantial damageNTSB WPR16LA020Accident · Minor injuriesLimited investigationFinal reportBell 206B · Dallas, ORA loss of engine power for reasons that could not be determined based on the available information.Nov 2, 2015 · N22743 · Substantial damageNTSB DCA16RA014Accident · 2 fatalForeign investigationBell Helicopter Textron 609 · Tronzano Vercellese, ItalyimportOct 30, 2015 · N609AG · DestroyedNTSB GAA16CA027Accident · No injuriesData collectionFinal reportCessna A188A · Elberta, UTThe pilot's failure to compensate for wind while maneuvering at a low altitude, resulting in a collision with terrain and a postcrash fire.Oct 24, 2015 · N4401Q · Substantial damageNTSB WPR16LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Primm, NVThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision. Contributing to the accident was the pilots' failure to tune to, monitor, and communicate over the common traffic advisory frequency their relative positions…Oct 23, 2015 · N310CD · 2 aircraft · Substantial damageNTSB GAA16CA026Accident · No injuriesData collectionFinal reportRans S-7 · Gerlach, NVThe pilot's failure to maintain pitch and airspeed control, in conjunction with full flaps, while maneuvering at a low altitude, resulting in a tail-stall and subsequent impact with the ground.Oct 21, 2015 · N272X · Substantial damageNTSB CEN16LA015Accident · No injuriesLimited investigationFinal reportBobby Martin Autogyro MTO Sport · Wallisville, TXFracture of the pusher propeller blade due to impact damage from an unknown object while in flight, which resulted in a severe vibration and a loss of thrust.Oct 17, 2015 · N3232Z · Substantial damageNTSB CEN16FA014Accident · 2 fatalField investigationFinal reportZidek Vans RV-4 · Cortland, NEThe pilot's decision to intentionally maneuver at a low altitude and his failure to maintain adequate airspeed during the climbing right turn, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Oct 17, 2015 · N999ZF · DestroyedNTSB ERA16LA015Accident · No injuriesLimited investigationFinal reportBell 206L 3 · Dickinson, ALThe improper installation by company maintenance personnel of the securing hardware of a tail rotor driveshaft section, which resulted in that section of tail rotor driveshaft disconnecting and a complete loss of tail rotor thrust.Oct 15, 2015 · N206CJ · Substantial damageNTSB ERA16LA008Accident · 1 fatalLimited investigationFinal reportCessna 172S · Seville, FLThe airplane’s encounter with a downdraft, and the pilot's decision to maneuver the airplane at a low altitude and airspeed, which provided insufficient time and altitude to recover before impacting terrain.Oct 10, 2015 · N5295Y · Substantial damageNTSB ANC16FA001Accident · 1 fatalField investigationFinal reportCessna 150F · Big Lake, AKThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering, which resulted in a stall at too low an altitude to allow recovery.Oct 8, 2015 · N7064 · Substantial damageNTSB WPR16FA002Accident · 2 fatalField investigationFinal reportCessna 152 · Cedar City, UTThe failure of the pilots to maintain control of the airplane while maneuvering, which resulted in an aerodynamic stall from which they did not recover.Oct 5, 2015 · N6449M · DestroyedNTSB CEN16LA004Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Dexter, MOThe pilot's impairment due to the ingestion of alcohol, which impaired his decision-making and resulted in his taking off and flying the airplane until the engine lost power due to fuel exhaustion.Oct 5, 2015 · N3174J · Substantial damageNTSB CEN16LA003Accident · Minor injuriesLimited investigationFinal reportBell 47G · Huntsville, TXThe pilot's loss of helicopter control during an agricultural application pass for reasons that could not be determined due to the extent of damage to the flight control system.Oct 5, 2015 · N160CS · Substantial damageNTSB CEN16WA010Accident · 1 fatalForeign investigationPiper PA31 · Veracruz, NicaraguaOct 2, 2015 · C-GCMD · Substantial damageNTSB CEN15LA437Accident · Minor injuriesLimited investigationFinal reportCapella Aircraft Corporation ( FW2TDXLS · Bartlesville, OKThe pilot’s failure to maintain airplane control after takeoff.Sep 30, 2015 · N903AB · Substantial damageNTSB CEN15LA428Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-26 · Slidell, TXThe pilot's attempt to recover from an aerobatic maneuver at too low of an altitude to make a safe recovery.Sep 28, 2015 · N596TJ · DestroyedNTSB CEN15FA424Accident · 2 fatalField investigationFinal reportBeech S35 · Pagosa Springs, COImproper engine assembly by unknown maintenance personnel, which resulted in the failure of the No. 6 connecting rod due to oil starvation from the shifting of the crankshaft's No. 4 main bearing.Sep 25, 2015 · N193Q · DestroyedNTSB GAA15LA296Accident · No injuriesLimited investigationFinal reportBell 206 · Ozark, ALThe pilot's failure to maintain clearance from terrain while hovering, which resulted in the helicopter's skid impacting terrain, subsequent abnormal airframe vibrations, and a hard landing during the subsequent hovering autorotation.Sep 24, 2015 · N49660 · Substantial damageNTSB ERA15LA375Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CT · Blacksburg, VAA loss of thermal lift during a motor glider flight, which resulted in an off-airport landing. Contributing to the accident was the pilot’s failure to maintain adequate clearance from power lines during the off-airport landing attempt.Sep 24, 2015 · N710JC · Substantial damageNTSB CEN15LA423Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodville, TXThe loss of engine power due to water contamination in the fuel system. Contributing to the accident were the pilot’s inadequate preflight inspection of the fuel tanks and the operator’s inadequate inspection of the fuel supply truck that did not detect water…Sep 24, 2015 · N648CA · Substantial damageNTSB WPR15LA262Accident · No injuriesLimited investigationFinal reportGraves Bryon S Vans RV-7A · Byron, CAImproper overhaul of the right magneto, which eliminated system redundancy, and resulted in a loss of engine power when the left magneto failed during aerobatic flight maneuvers.Sep 21, 2015 · N507RV · Substantial damageNTSB ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…Sep 21, 2015 · N347SP · Substantial damageNTSB ERA15FA362Accident · 2 fatalField investigationFinal reportCessna 150H · Morrisville, NYThe pilot's failure to maintain airspeed and her exceedance of the airplane's critical angle-of-attack, which led to an aerodynamic stall, following a total loss of engine power for reasons that could not be determined because postaccident examination of the…Sep 20, 2015 · N22721 · DestroyedNTSB ERA15LA363Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Gettysburg, PAThe total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's failure to maintain a proper approach speed during the forced landing, which resulted in impact with trees.Sep 19, 2015 · N3647S · Substantial damageNTSB ANC15LA073Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fort Glenn, AKThe separation of the tail rotor gearbox from the tailboom attachment point due to overstress loads imposed by a tail rotor blade imbalance as the result of impact with an undetermined object during low-level flight operations.Sep 19, 2015 · N7162R · Substantial damageNTSB WPR15LA261Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Forest Grove, ORA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Sep 18, 2015 · N290R · Substantial damageNTSB GAA15CA266Accident · Minor injuriesData collectionFinal reportSchweizer G 164B · Paxton, NEThe pilot's failure to maintain adequate distance from a power line during low altitude flight operations, which resulted in an impact with the power line, and subsequent impact with the ground.Sep 16, 2015 · N3628Z · Substantial damageNTSB ERA15FA359Accident · 5 fatalField investigationFinal reportBoatright Waylon RV10 · Alma, GAThe noncertificated pilot's decision to perform aerobatic maneuvers in his overweight, improperly-loaded airplane in dark night conditions at low altitude, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident…Sep 16, 2015 · N122WK · DestroyedNTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Sep 12, 2015 · N8185F · DestroyedNTSB CEN15LA412Accident · Minor injuriesLimited investigationFinal reportGuisinger Gary G Baby Belle · Stuart, IAThe failure of the tail rotor driveshaft for reasons that could not be determined due to the mechanically and thermally deformed fracture surface.Sep 12, 2015 · N135PA · Substantial damageNTSB GAA15CA258Accident · No injuriesData collectionFinal reportAirbus AS350 · Draper, UTThe ground recovery team member's failure to secure a rescue rope during the helicopter loading process in steep terrain, resulting in the rope fouling the helicopter's main rotor system.Sep 9, 2015 · N253HP · Substantial damageNTSB ERA15LA339Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Laconia, NHThe sport pilot’s improper decision to operate the weight-shift-control aircraft at low altitude and his subsequent failure to maintain control of the aircraft, which resulted in a subsequent collision with terrain.Sep 5, 2015 · N2264X · Substantial damageNTSB GAA15CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402A · Fort Pierre, SDThe pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.Sep 4, 2015 · N321DA · Substantial damageNTSB WPR15LA257Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Manra Island, KiribatiA The loss of helicopter control for reasons that could not be determined asbecause the helicopter sank in the oceanwater and was not recovered.Sep 3, 2015 · N9068F · DestroyedNTSB ERA15LA337Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · New Smyrna Beach, FLThe pilot’s inadequate visual lookout and failure to maintain clearance from trees while maneuvering at low altitude.Sep 3, 2015 · N16056 · 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 ERA15FA335Accident · 2 fatalField investigationFinal reportCooper Michael C RV 8A · Advance, NCThe pilots' failure to maintain airplane control during a low-altitude maneuver.Sep 2, 2015 · N393MC · DestroyedNTSB CEN15WA435Accident · No injuriesForeign investigationBell 206B · Sept-Iles, CanadaOn September 2, 2015, about 1345 Universal Coordinated Time (UTC), a Bell 206B, Canada Registry C-GYBK, impacted terrain about 19 miles north of Sept-iles, Quebec. Of the five occupants that were on board, the pilot sustained minor injuries, two passengers…Sep 2, 2015 · C-GYBK · Substantial damage