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 CEN14WA254Accident · 1 fatalForeign investigationAir Tractor AT802 · Seron, SpainOn May 26, 2014, about 1400 UTC, an Air Tractor AT-802 airplane, EC-LCA, (s/n 802-0326), impacted terrain during a firefighting operation near Seron, Spain. A post-impact fire occurred and the airplane was subsequently destroyed. The pilot sustained fatal…May 26, 2014 · EC-LCA · DestroyedNTSB ERA14CA262Accident · Minor injuriesData collectionFinal reportEvolution Trikes Revo · Williamsburg, VAThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with water.May 25, 2014 · N9912S · Substantial damageNTSB WPR14FA203Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Santa Paula, CAThe pilot's failure to maintain clearance from power lines while flying at a low altitude.May 23, 2014 · N4081H · Substantial damageNTSB WPR14CA196Accident · No injuriesData collectionFinal reportBell 47G · Bakersfield, CAThe pilot's failure to maintain aircraft control after the helicopter's skid catching on the side of a trailer during takeoff, which resulted in a dynamic rollover.May 18, 2014 · N16414 · Substantial damageNTSB ERA14CA239Accident · Serious injuriesData collectionFinal reportTaylorcraft BC 65 · Summerville, GAThe pilot's selection of an inadequate altitude during low level maneuvering, which resulted in an in-flight collision with trees.May 13, 2014 · N29611 · Substantial damageNTSB ERA14CA234Accident · Minor injuriesData collectionFinal reportSam R Peachey Just Aircraft Highla · Roxbury, PAThe pilot's failure to maintain adequate airspeed during low altitude maneuvering.May 11, 2014 · N209SP · Substantial damageNTSB ERA14WA247Accident · 2 fatalForeign investigationCessna 140A · Cachoeira do Sul, BrazilOn May 10, 2014, at 2025 coordinated universal time, a Cessna 140A, Brazilian registration PT-AGS, experienced a loss of control and subsequently impacted terrain near Cachoeira do Su, Brazil. The two pilots onboard were fatally injured. The instructional…May 10, 2014 · PT-AGS · Substantial damageNTSB CEN14LA243Accident · 1 fatalLimited investigationFinal reportHoffius Stowe Challenger II · Attica, INThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an…May 10, 2014 · N824SH · Substantial damageNTSB CEN14LA235Accident · Minor injuriesLimited investigationFinal reportPazmany PL 4 · Yates City, ILA loss of propeller thrust due to a failure of the reduction drive unit resulting from the improper installation of the unit. Contributing to the accident was a lack of documentation for the reduction drive unit installation.May 10, 2014 · N44PL · Substantial damageNTSB WPR14FA183Accident · 2 fatalField investigationFinal reportCessna 150 - F · Santa Clara, UTThe flight instructor’s failure to arrest the airplane’s descent and maintain clearance from mountainous terrain while maneuvering at a low altitude.May 7, 2014 · N8236F · Substantial damageNTSB CEN14LA229Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Hessmer, LAA partial loss of engine power for reasons that could not be determined because a full examination of the engine could not be performed.May 5, 2014 · N7309Z · Substantial damageNTSB CEN14FA230Accident · No injuriesField investigationFinal reportPiper PA 25-235 · Northglenn, COThe pilot's decision to operate the banner-tow flight below the minimum safe altitude specified by federal regulation, which likely limited his ability to recover from a potential loss of airspeed due to a gusting wind condition. Also causal was the pilot’s…May 5, 2014 · N4519Y · DestroyedNTSB WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…May 4, 2014 · N68828 · DestroyedNTSB ERA14CA220Accident · Serious injuriesData collectionFinal reportSchleicher ASW 20 · Monroe, GAThe pilot's improper selection of an off-airport landing site and his subsequent failure to maintain clearance from trees during an off airport landing.May 4, 2014 · N777LR · Substantial damageNTSB ERA14WA221Accident · 2 fatalForeign investigationPiper PA-31 · Santander, ColombiaOn May 3, 2014, about 1500 coordinated universal time, a Piper PA-31, Canadian registration C-GSVM, was substantially damaged when it impacted terrain near Santander, Colombia. The pilot and passenger were fatally injured. The local survey flight departed…May 3, 2014 · C-GSVM · Substantial damageNTSB CEN14FA232Accident · No injuriesField investigationFinal reportBell 407 · Telluride, COThe failure of the power turbine thrust (No. 5) bearing due to overheating as a result of oil starvation, which led to the engine failure. Also causal to the accident was an undocumented repair to the gearbox cover oil delivery tube port during which an…May 3, 2014 · N407MH · Substantial damageNTSB ERA14CA217Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Frederick, MDThe student pilot's failure to maintain directional control during the hover, and the flight instructors lack of remedial action, resulting in a dynamic rollover and structural damage to the helicopter.May 1, 2014 · N802CP · Substantial damageNTSB CEN14WA535Accident · 2 fatalForeign investigationAlpi Pioneer · Evora, PortugalOn April 30, 2014, at 1851 coordinated universal time, an Alpi Aviation Pioneer 300J airplane, Portuguese registered CS-UOV, impacted terrain after a low pass near the Evora Airport (LPEV), Evora, Portugal. The two pilots were fatally injured and the airplane…Apr 30, 2014 · CS-UOV · DestroyedNTSB ANC14CA025Accident · No injuriesData collectionFinal reportCessna 182J · Cooper Landing, AKThe pilot's failure to correctly use carburetor heat, resulting in a loss of engine power and collision with terrain.Apr 30, 2014 · N3024F · Substantial damageNTSB WPR14GA176Accident · Serious injuriesFinal reportHughes OH 6 · Bullfrog, UTA loss of engine power while the helicopter was hovering for reasons that could not be determined because postaccident examination of the engine and rotor drive system revealed no evidence of a mechanical malfunction or failure that would have precluded…Apr 29, 2014 · N37929 · Substantial damageNTSB WPR14FA174Accident · 1 fatalField investigationFinal reportCessna 210E · Richmond, CABoth pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot.Apr 27, 2014 · N4962U · 2 aircraft · DestroyedNTSB ERA14CA229Accident · No injuriesData collectionFinal reportGingras Michel Aventura II · Punta Gorda, FLThe pilot's failure to maintain clearance from the water while operating at a low altitude.Apr 27, 2014 · N543MG · Substantial damageNTSB CEN14LA222Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Cleburne, TXThe student pilot's failure to maintain tail rotor clearance from terrain while transitioning to a hover taxi and the instructor pilot's inadequate remedial action to prevent the impending tail rotor contact.Apr 25, 2014 · N90636 · Substantial damageNTSB CEN14WA214Accident · 4 fatalForeign investigationCessna 172 - M · Gracias, HondurasOn April 23, 2014, at 1900 universal coordinated time, a Cessna 172M airplane, bearing Honduran registration HR-AVH, was destroyed upon impact with trees and terrain under unknown circumstances, near Gracias, Department of Lempira, in the Republic of…Apr 23, 2014 · HR-AVN · DestroyedNTSB CEN14LA211Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Garfield, KSThe pilot’s inadequate preflight planning and subsequent failure to remain clear of power lines while maneuvering low to the ground.Apr 22, 2014 · N51990 · Substantial damageNTSB CEN14WA206Accident · 7 fatalForeign investigationSui RY, Laurinen Janne, KääRiä Comp AIR 8 · Jamijarvi, FinlandOn April 20, 2014, at 1240 UTC, a Comp Air 8, Finnish registration OH-XDZ, was destroyed when it departed controlled flight and subsequently impacted in a forest near Jamijarvi Airfield (EFJM), Jamijarvi, Finland. A post-impact fire ensued. Eight of the 10…Apr 20, 2014 · OH-XDZ · DestroyedNTSB WPR14LA161Accident · 1 fatalLimited investigationFinal reportNorthwing Apache Sport · Brigham City, UTThe pilot’s failure to maintain aircraft control while maneuvering near power lines.Apr 8, 2014 · N58AS · Substantial damageNTSB ANC14FA022Accident · 2 fatalField investigationFinal reportCessna 208B · Kwethluk, AKThe check airman's delayed remedial action and initiation of a recovery procedure after a simulated pitch trim excursion, which resulted in a loss of airplane control.Apr 8, 2014 · N126AR · DestroyedNTSB WPR14FA158Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Green River, UTA loss of engine power due to fuel contamination while maneuvering at a low altitude and the pilot's inadequate preflight inspection, which failed to detect the contamination.Apr 6, 2014 · N13HG · Substantial damageNTSB ERA14FA182Accident · 2 fatalField investigationFinal reportMonroe Dennis RV-7 · Summerfield, FLThe pilot's failure to maintain airplane control while maneuvering at a low airspeed, which resulted in an aerodynamic stall, and his decision to maneuver at an altitude that did not allow an adequate margin to recover from a stall.Apr 6, 2014 · N57DC · Substantial damageNTSB WPR14LA160Accident · Serious injuriesLimited investigationFinal reportAgustawestland AW109SP · Astoria, ORThe decision by the ship pilot and the helicopter crew to lower the ship pilot to a location on the ship that did not provide the helicopter pilot with an adequate view of the ship. Contributing to the accident was the inadequate pre-mission coordination…Apr 5, 2014 · N361CR · No damageNTSB CEN14WA184Accident · 2 fatalForeign investigationCessna T210L · San Marcos, GuatemalaOn April 1, 2014, about 1340 local time, a Cessna T210L, single engine airplane, N732JY, was destroyed after impacting mountainous terrain near San Marcos, Guatemala. The pilot and passenger were fatally injured. About 1318 the airplane departed from…Apr 1, 2014 · N732JY · DestroyedNTSB CEN14LA174Accident · No injuriesLimited investigationFinal reportBell 47G 3B · Oglesby, TXMaintenance personnel’s failure to safety wire the throttle control adapter per maintenance instructions when the carburetor was replaced and to detect that the adapter was not safety wired during the annual inspection, which resulted in the throttle control…Mar 30, 2014 · N147WT · Substantial damageNTSB WPR14WA311Accident · Serious injuriesForeign investigationRobinson Helicopter R22 Beta · Borroloola, Australia, AustraliaOn March 27, 2014, at 0900 universal coordinated time, a Robinson R22 Beta, VH-HRX, collided with terrain near Borroloola, Australia during an aerial mustering flight. The helicopter was operated by the pilot under the pertinent civil regulations of the…Mar 27, 2014 · VH-HRX · Substantial damageNTSB WPR14LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · InarajanA total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Mar 26, 2014 · N9551L · Substantial damageNTSB WPR14WA148Accident · 1 fatalForeign investigationMD Helicopter 500N · Gisborne, New Zealand, New ZealandOn March 19, 2014, at 2030 universal coordinated time, a MD Helicopters 500N, ZK-HQP, was preparing for a fire lighting operation when it crashed in Hawkes Bay near Gisborne, New Zealand. The helicopter was operated by Gisborne Helicopters Limited under the…Mar 19, 2014 · ZK-HQP · Substantial damageNTSB CEN14FA163Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Aurora, COThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control.Mar 19, 2014 · N90464 · DestroyedNTSB CEN14CA164Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Ruidoso, NMThe pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance.Mar 19, 2014 · N3398M · Substantial damageNTSB CEN14LA161Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Greenwood, INThe flight instructor's failure to ensure that carburetor heat was used while performing maneuvers at reduced power settings in conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power due to carburetor ice.…Mar 18, 2014 · N9432U · Substantial damageNTSB WPR14CA138Accident · Minor injuriesData collectionFinal reportDG Flugzeugbau DG 1000S · Wrightwood, CAThe pilot's inadequate in-flight planning/decision to maneuver the glider where the lift was not sufficient to maintain flight, resulting in an off airport landing.Mar 15, 2014 · N624RM · Substantial damageNTSB CEN14CA160Accident · Minor injuriesData collectionFinal reportPiper PA 28-235 · De Beque, COThe pilot's failure to maintain control of the airplane while maneuvering at low altitude.Mar 14, 2014 · N9172W · Substantial damageNTSB ERA14WA245Accident · Minor injuriesForeign investigationCessna T188C · Canton Naranjal, EcuadorOn March 13, 2014, a Cessna T188C, Ecuadorian registration HC-BTA, was substantially damaged when it lost engine power and impacted terrain near Canton Naranjal, Ecuador. A postaccident fire ensued. The foreign certificated pilot received minor injuries. The…Mar 13, 2014 · HC-BTA · Substantial damageNTSB WPR14FA135Accident · 2 fatalField investigationFinal reportEvolution Trikes Revo · Kekaha, HIThe pilot's reconfiguration of the fuel venting system, which resulted in a loss of engine power and subsequent loss of aircraft control.Mar 11, 2014 · N98EV · Substantial damageNTSB ERA14FA144Accident · 3 fatalField investigationFinal reportRogers George T Lancair IVP · Hartsville, SCFailure of the flying pilot to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident were the…Mar 8, 2014 · N724HP · Substantial damageNTSB ERA14WA148Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540T · Al Khor, QatarOn March 17, 2014, about 1725 local time, a Zivko Aeronautics Edge 540T, N149WA, was substantially damaged when it collided with the ground during an airshow performance at Al Khor Airport (OTBK), Al Khor, Qatar. The commercial pilot was fatally injured. The…Mar 7, 2014 · N149WA · Substantial damageNTSB CEN14LA149Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Presidio, TXThe pilot’s failure to maintain sufficient rotor rpm when transitioning the helicopter from a hover to forward flight, which resulted in a loss of helicopter control.Feb 24, 2014 · N360AH · Substantial damageNTSB ERA14LA137Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Macon, GAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern at low altitude in gusting wind. Contributing to the accident was the pilot’s improper decision to maneuver in the traffic pattern at a low altitude that did not allow…Feb 19, 2014 · N9026N · Substantial damageNTSB CEN14LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Church Point, LAThe pilot’s improper preflight inspection and in-flight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Feb 19, 2014 · N5035R · Substantial damageNTSB WPR14CA115Accident · No injuriesData collectionFinal reportBell 47G 5A · Greenfield, CAThe pilot's failure to maintain clearance from a power pole during low-altitude maneuvering flight.Feb 18, 2014 · N715BH · Substantial damageNTSB ERA14WA132Accident · 2 fatalForeign investigationRobinson R22 - Beta · Rio de Janeiro, BrazilOn February 18, 2014, about 1315 universal coordinated time, a Robinson R22 - BETA, Brazilian registration PT-YFV, was destroyed when it impacted water, near Rio de Janeiro, Brazil. The flight instructor and student pilot were fatally injured. The local…Feb 18, 2014 · PT-YFV · Destroyed