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 ERA16WA180Accident · 2 fatalForeign investigationRobinson R22 · Sao Paulo, BrazilOn May 5, 2016, about 1515 universal coordinated time, a Robinson R22 Beta, Brazilian registration PR-RCA, operated by AGD Aviation, was substantially damaged when it impacted wires and then terrain while maneuvering in Sao Paulo, Brazil. The flight…May 2, 2016 · PR-RCA · Substantial damageNTSB WPR16FA097Accident · 2 fatalField investigationFinal reportExtra Flugzeugproduktions-Und EA 300/L · Henderson, NVThe pilot's failure to monitor and maintain clearance with terrain while maneuvering at low level. Contributing to the accident, was the pilot's failure to conduct an adequate amount of clearing turns while maneuvering at low level.Apr 30, 2016 · N330MT · DestroyedNTSB WPR16LA099Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 5 · San Ardo, CAThe failure of the pin in the outboard end of the lateral flight control torque tube.Apr 29, 2016 · N6288N · Substantial damageNTSB GAA16CA205Accident · Minor injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Marana, AZThe glider's loss of lift as a result of unfavorable wind conditions for glider operations, consequently resulting in a collision with trees.Apr 24, 2016 · N40880 · Substantial damageNTSB CEN16FA169Accident · 1 fatalField investigationFinal reportCessna 182L · Carrollton, OHAn in-flight collision with trees and terrain for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were observed during the examination.Apr 24, 2016 · N42411 · Substantial damageNTSB CEN16LA161Accident · Serious injuriesLimited investigationFinal reportBell 47G-2A · Los Fresnos, TXThe pilot's inability to see and avoid the power lines because of trees obscuring his view.Apr 21, 2016 · N64702 · DestroyedNTSB CEN16WA174Accident · 1 fatalForeign investigationCessna 150 · Strakonice, CzechiaOn April 20, 2016, at 1253 universal coordinated time (UTC), a Cessna 150 airplane, Czech Republic registration OK-OKA, serial number 150741140, sustained substantial damage when it impacted terrain near the Strakonice Airport (LKST), Strakonice, Czech…Apr 20, 2016 · OK-OKA · Substantial damageNTSB ANC16FA019Accident · 4 fatalField investigationFinal reportCessna 172 · Chugiak, AKThe in-flight collision with one or more large birds (Bald Eagle), which resulted in a loss of airplane control.Apr 20, 2016 · N63541 · Substantial damageNTSB CEN16LA156Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Arden Hills, MNA partial loss of engine power for reasons that could not be determined based on the available evidenceApr 18, 2016 · N119SP · Substantial damageNTSB CEN16LA154Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Kilbourne, LAThe failure of the operator to comply with the terminating action of the airworthiness directive, which resulted in the subsequent failure and separation of the vertical stabilizer due to fatigue.Apr 18, 2016 · N301LA · DestroyedNTSB ERA16CA160Accident · No injuriesData collectionFinal reportBell 206 · Baltimore, MDThe pilot's inadequate compensation for the wind while hovering out of ground effect, which resulted in a loss of tail rotor effectiveness.Apr 16, 2016 · N326AC · DestroyedNTSB CEN16FA146Accident · 2 fatalField investigationFinal reportRockwell 690B · Taylor, TXA loss of control while maneuvering for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or anomalies with the airplane.Apr 9, 2016 · N690TH · DestroyedNTSB ERA16FA144Accident · 5 fatalField investigationFinal reportBell 206 · Pigeon Forge, TNAn inflight loss of engine power due to a failure of the engine fuel pump, which resulted in a collision with trees and terrain during the subsequent autorotation. The failure of the engine fuel pump resulted from the absence of adequate grease leading to…Apr 4, 2016 · N16760 · DestroyedNTSB GAA16CA173Accident · Minor injuriesData collectionFinal reportBeech F35 · Long Island, NCThe pilot's decision to maneuver at low altitude, which resulted in a collision with power lines and substantial damage to the vertical stabilizer.Mar 30, 2016 · N4212B · Substantial damageNTSB CEN16LA139Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-402 · Beyersville, TXThe pilot's failure to maintain visual separation from the power line due to a lack of identifiable and contrasting features, which led to an inflight collision with the line while maneuvering in gray, hazy conditions.Mar 29, 2016 · N4555E · Substantial damageNTSB GAA16CA165Accident · Minor injuriesData collectionFinal reportBell 206B · Hanford, CAThe pilot's decision to release the collective while flying at 10 feet above ground level, resulting in the rapid helicopter descent and impact with terrain.Mar 26, 2016 · N52Q · Substantial damageNTSB WPR16WA089Accident · 1 fatalForeign investigationBell 206 · Carmila West, AustraliaOn March 25, 2016, at 1028 local time, a Bell 206B, VH-WHU, collided with power lines during an aerial agriculture flight near Carmila West, Australia. The helicopter was destroyed by the post impact fire and the pilot was fatally injured. The flight was…Mar 25, 2016 · VH-WHU · DestroyedNTSB GAA16CA166Accident · Minor injuriesData collectionFinal reportPiper J5A · Lake Harbor, FLThe pilot's exceedance of the critical angle of attack while maneuvering at low altitude, which resulted in an accelerated aerodynamic stall, spin, and impact with terrain.Mar 25, 2016 · N41239 · Substantial damageNTSB CEN16LA135Accident · Serious injuriesLimited investigationFinal reportBrantly B 2B · Galena, MOThe pilot’s loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Mar 25, 2016 · N2266U · Substantial damageNTSB ERA16LA139Accident · 1 fatalLimited investigationFinal reportHall, Wendall W Harmon Rocket II · Cheraw, SCThe pilot's decision to fly at low altitude, which resulted in a collision with power lines.Mar 24, 2016 · N729PS · Substantial damageNTSB WPR16FA087Accident · 2 fatalField investigationFinal reportNorth American AT 6A · Astoria, ORThe pilot's loss of aircraft control during a low-altitude ash dispersal maneuver. Contributing to the accident was his degraded performance due to his medical conditions.Mar 23, 2016 · N7055D · DestroyedNTSB GAA16CA160Accident · Minor injuriesData collectionFinal reportRobinson R44 · Oak Island, NCThe student pilot's failure to maintain a stabilized hover, resulting in a loss of control and an impact with terrain.Mar 23, 2016 · N843JB · Substantial damageNTSB CEN16FA130Accident · 1 fatalField investigationFinal reportAeronca 7AC · Ellsworth, NEThe pilot's impairment due to carbon monoxide poisoning from a known cracked engine exhaust muffler, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to continue flying the airplane without properly repairing…Mar 20, 2016 · N84580 · DestroyedNTSB 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 CEN16LA123Accident · Serious injuriesLimited investigationFinal reportBrockman William A Challenger II · Neshkoro, WIA total loss of engine power for reasons that could not be determined, as postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the non-certificated pilot's decision to maneuver at low…Mar 12, 2016 · N710WB · Substantial damageNTSB CEN16LA121Accident · Serious injuriesLimited investigationFinal reportAriosto James J Ariosto Mustang II · Normangee, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector positioning procedures during the flight.Mar 4, 2016 · N12JA · Substantial damageNTSB WPR16LA079Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Fountain Hills, AZA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Mar 2, 2016 · N4356A · Substantial damageNTSB WPR16LA075Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R66 · Torrance, CAA vibration of the helicopter, which resulted in an autorotation to soft terrain and subsequent impact of the tail boom with the main rotor. The reason for the vibration could not be determined because postaccident examination revealed no malfunctions or…Feb 23, 2016 · N266RH · Substantial damageNTSB ERA16LA106Accident · 2 fatalLimited investigationFinal reportPiper PA28 · Destin, FLThe noninstrument-rated pilot's decision to turn the airplane away from the lighted airport at low altitude, over water, with no visible horizon, in dark night conditions, which resulted in spatial disorientation and a loss of airplane control.Feb 13, 2016 · N2209W · DestroyedNTSB WPR16FA067Accident · 2 fatalField investigationFinal reportFlight Design Ctls · Springville, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude in hilly terrain, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident were the…Feb 11, 2016 · N911TS · DestroyedNTSB WPR16FA065Accident · 3 fatalField investigationFinal reportBeech M35 · San Pedro, CAThe failure of the pilots of both airplanes to see and avoid each other as they converged nearly head-on, which resulted in a midair collision. Contributing to the accident was sun glare on the pilot.Feb 5, 2016 · N9872R · 2 aircraft · Substantial damageNTSB WPR16FA064Accident · 2 fatalField investigationFinal reportNorth American F51 · Maricopa, AZThe pilot’s failure to maintain airplane control while performing an acrobatic maneuver and his subsequent failure to recover from an inadvertent spin due to insufficient altitude.Feb 5, 2016 · N551JP · Substantial damageNTSB ERA16WA101Accident · Serious injuriesForeign investigationRobinson R66 · Aviatornyi, RussiaOn February 2, 2016, about 0730 Coordinated Universal Time (UTC), a Robinson R66, RA-06239, registered to Southeast Agricultural Group, LLC, collided with terrain near Aviatornyi Township, Kirsanov District, Tambov Region, Russia. Visual meteorological…Feb 2, 2016 · RA-06239 · DestroyedNTSB GAA16LA117Accident · No injuriesLimited investigationFinal reportHelicopteres Guimbal Cabri · Beaumont, TXThe pilot's inadequate compensation for wind during a hover-taxi and his failure to maintain helicopter control due to a loss of tail rotor effectiveness.Jan 30, 2016 · N503DS · Substantial damageNTSB CEN16WA165Accident · Serious injuriesForeign investigationDiamond DA42 · Vasteras, SwedenOn January 22, 2016, at 1807 universal coordinate time, a Diamond DA42, Swedish registration SE-LVR, operated by Airways Flygutbildning, collided with the terrain in Vasteras, Sweden, following a loss of control. The flight instructor, the pilot receiving…Jan 22, 2016 · SE-LVR · Substantial damageNTSB CEN16LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA31 · Denton, TXThe total loss of engine power due to fuel exhaustion 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.Jan 22, 2016 · N997DN · Substantial damageNTSB GAA16LA100Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28 · Ritter Butte, ORThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain.Jan 13, 2016 · N756H · Substantial damageNTSB GAA16CA101Accident · No injuriesData collectionFinal reportCessna 182 · Baton Rouge, LAAn inadvertent collision with a bird while maneuvering during an aerial observation flight.Jan 11, 2016 · N4423R · Substantial damageNTSB WPR16FA046Accident · 2 fatalField investigationFinal reportAerostar S A YAK 52 · Alpine, WYThe pilot's failure to maintain clearance from snow-covered terrain in flat light conditions.Jan 4, 2016 · N912EB · DestroyedNTSB WPR16LA045Accident · No injuriesLimited investigationFinal reportPiper PA18 · Newman Lake, WAA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Jan 1, 2016 · N2684A · Substantial damageNTSB ANC16LA011Accident · 1 fatalLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's intentional flight into a building.Dec 29, 2015 · N914CP · DestroyedNTSB CEN16LA084Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Warrenton, MOThe noninstrument-rated pilot's continued flight into instrument meteorological conditions at night, which resulted in the loss of visual reference to the ground and his subsequent failure to maintain clearance from trees.Dec 22, 2015 · N292B · DestroyedNTSB GAA16CA102Accident · No injuriesData collectionFinal reportPiper PA 18A · Girdwood, AKFuel contamination resulting in the loss of engine power, a forced landing on a highway, and subsequent right wing impact with highway signage.Dec 21, 2015 · N2791P · Substantial damageNTSB WPR16FA040Accident · 2 fatalField investigationFinal reportAirbus Helicopters AS350 · Superior, AZThe pilot's loss of helicopter control in mountainous terrain as the result of operating the helicopter outside the performance envelope of its hydraulic system and encountering the servo transparency phenomenon. Contributing to the accident was the pilot's…Dec 16, 2015 · N74317 · Substantial damageNTSB ERA16LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Charles Town, WVThe flight instructor's inadequate remedial action and the student pilot's failure to maintain yaw control while practicing a stall, which resulted in an unintentional spin.Dec 16, 2015 · N614CD · Substantial damageNTSB GAA16CA082Accident · No injuriesData collectionFinal reportAeronca 7BCM · Reidsville, NCThe pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.Dec 13, 2015 · N1316V · Substantial damageNTSB GAA16CA080Accident · Minor injuriesData collectionFinal reportAviat A1 · Broadus, MTThe pilot's failure to maintain clearance from the wires while flying at a low altitude resulting in a wire strike, a loss of airplane control, and the consequent impact with terrain.Dec 13, 2015 · N29712 · Substantial damageNTSB WPR16FA036Accident · 2 fatalClass 3 · FieldFinal reportBarnett Allen S RV7 · Hurricane, UTThe pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.Dec 10, 2015 · N307AB · Substantial damageNTSB CEN16LA058Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 600N · Angleton, TXA loss of control while hovering for reasons that could not be determined, because postaccident examination revealed no mechanical anomalies or failures that would have precluded normal operation.Dec 7, 2015 · N607BP · Substantial damageNTSB CEN16FA054Accident · 2 fatalField investigationFinal reportCessna 140 · Keytesville, MOThe non-instrument-rated pilot's decision to operate in dark night conditions with low clouds, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's use of methamphetamine, which impaired his…Dec 7, 2015 · N90123 · Substantial damage