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 CEN15IA230Incident · No injuriesIncident investigationFinal reportCessna 152 · Pilot Point, TXThe loss of engine power due to the separation of the distributor gear arm on the left magneto.Apr 30, 2015 · N49158 · Minor damageNTSB CEN15FA211Accident · 1 fatalField investigationFinal reportHoffman Zenith 701 · Trinidad, COThe noncertificated pilot's failure to maintain airspeed following a loss of engine power while maneuvering at a low altitude, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the…Apr 30, 2015 · N95MH · Substantial damageNTSB CEN15FA210Accident · 1 fatalField investigationFinal reportEurocopter Deutschland MBB BK 117 C-2 · Austin, TXThe helicopter rescue specialist was not properly attached to the hoist system, which resulted in a fall during a night hoist operation.Apr 28, 2015 · N392TC · No damageNTSB DCA15WA115Accident · 2 fatalForeign investigationBell UH1H - NO Series · Bainskloof, South AfricaThe government of South Africa has notified the NTSB of an accident involving a BELL UH-1H helicopter that occurred on April 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…Apr 22, 2015 · ZU-UHI · DestroyedNTSB CEN15WA208Accident · 1 fatalForeign investigationEdge 360 · Norfolk, United KingdomOn April 22, 2015, about 1340 coordinated universal time, an Edge 360 airplane, G-EDGJ, impacted terrain while performing aerobatic maneuvers near Norfolk, United Kingdom. The pilot was fatally injured. The accident investigation is under the jurisdiction and…Apr 22, 2015 · G-EDGJNTSB WPR15LA150Accident · 1 fatalLimited investigationFinal reportCessna 206H · Redding, CAThe pilot's intentional descent into terrain.Apr 18, 2015 · N3535M · DestroyedNTSB WPR15LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · La Quinta, CAMaintenance personnel’s failure to properly repair a propeller deformation, which resulted in a fatigue crack, separation of a propeller blade tip, and forced landing onto uneven terrain.Apr 17, 2015 · N162SC · Substantial damageNTSB WPR15WA145Accident · 1 fatalForeign investigationBell 206 - B · Ziyang City, China, ChinaOn April 13, 2015, at 0800 local time, a Bell 206 BIII, B-7607, collided with a wire during an aerial application flight near Ziyang City, Sichuan Province, China. The helicopter was operated by Hubei Tongcheng General Aviation Ltd under the pertinent civil…Apr 13, 2015 · B-7607 · Substantial damageNTSB ERA15WA193Accident · 1 fatalForeign investigationCessna 210L · Assuncao do Piaui, BrazilOn April 11, 2015, at 2200 coordinated universal time, a privately owned Cessna 201L, Brazilian registered PR-APG, was destroyed when it impacted terrain under unknown circumstances near Assuncao do Piaui Municipality, State of Piaui, Brazil. The pilot was…Apr 11, 2015 · PR-APG · DestroyedNTSB WPR15LA142Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 27 · Reno, NVThe glider's encounter with severe turbulent atmospheric conditions after the pilot inadvertently entered clouds, which led to his inability to maintain a proper airspeed and the subsequent in-flight breakup of the glider.Apr 5, 2015 · N27QV · Substantial damageNTSB GAA15CA037Accident · No injuriesData collectionFinal reportJabiru Jabiru - SP · Surprise, AZThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Apr 4, 2015 · N593J · Substantial damageNTSB CEN15WA191Accident · 2 fatalForeign investigationPiper Piper PA-28-140 · Loch Etive, United KingdomOn April 4, 2015, at an unknown time, a United Kingdom registered Piper PA-28-140 airplane, G-BHXK,impacted mountainous terrain near Lock Etive, Oban, Argyll, and Bute, United Kingdom.The two occupants were fatally injured. The investigation is under the…Apr 4, 2015 · G-BHXK · DestroyedNTSB CEN15IA200Incident · No injuriesIncident investigationFinal reportAir Tractor AT 402A · Brickeys, ARThe in-flight separation of the attachment hardware at the elevator control pushrod due to maintenance personnel's improper reinstallation of the attachment hardware.Apr 4, 2015 · N623LA · Minor damageNTSB WPR15FA140Accident · 1 fatalField investigationFinal reportQuicksilver Enterprises MXL II · Petaluma, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and structural failure. Contributing to the accident was the pilot's impairment from his use of diphenhydramine.Apr 3, 2015 · N476VB · DestroyedNTSB GAA15CA032Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Fort Davis, TXThe pilot's failure to maintain control of the helicopter during flight, which resulted in the helicopter impacting terrain.Apr 3, 2015 · N8363D · Substantial damageNTSB CEN15FA194Accident · 1 fatalField investigationFinal reportS C Aerostar S A YAK 52TW · Advance, INThe pilot’s loss of airplane control while maneuvering for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.Apr 3, 2015 · N555GD · DestroyedNTSB ERA15WA180Accident · 4 fatalForeign investigationBell 206 - L4 · Diego de Almagro, ChileOn March 31, 2015, about 2210 universal coordinated time (UTC), a Bell 206L4, Chilean registration CC-APP, operated by a private individual, was destroyed during a collision with power lines and a subsequent postcrash fire, while maneuvering near Diego de…Mar 31, 2015 · CC-APP · DestroyedNTSB ERA15FA173Accident · 2 fatalField investigationFinal reportBell Helicopter Textron 206 L-1 · Saucier, MSA loss of engine power for reasons that could not be determined due to postaccident fire damage.Mar 30, 2015 · N50KH · DestroyedNTSB WPR15LA138Accident · No injuriesLimited investigationFinal reportHiller UH 12E · Firebaugh, CAA 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.Mar 29, 2015 · N130HA · Substantial damageNTSB ERA15LA172Accident · No injuriesClass 3 · LimitedFinal reportMerian Richard F RV 8 · Tuscaloosa, ALThe RV-8 pilot's failure to maintain adequate clearance from the RV-6 while maneuvering during an air show, which resulted in a midair collision.Mar 29, 2015 · N8JL · 2 aircraft · Substantial damageNTSB CEN15LA175Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · New Roads, LAThe loss of engine power due to three stuck exhaust valves.Mar 17, 2015 · N9755 · Substantial damageNTSB CEN15FA174Accident · 1 fatalField investigationFinal reportCessna 182Q · El Paso, TXThe pilot's decision to continue a visual flight rules flight into known instrument flight rules conditions, which resulted in controlled flight into terrain.Mar 17, 2015 · N735KF · DestroyedNTSB ERA15LA156Accident · 1 fatalLimited investigationFinal reportKolb Twinstar · Reynolds, GAThe student pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the student pilot's decision to operate…Mar 15, 2015 · N193Y · Substantial damageNTSB WPR15CA128Accident · No injuriesData collectionFinal reportEnstrom F28 - C · Shelby, MTThe pilot's failure to maintain main rotor RPM during a low altitude operation, which resulted in a loss of aircraft control and collision with terrain.Mar 14, 2015 · N5688N · Substantial damageNTSB ANC15CA012Accident · No injuriesData collectionFinal reportBell 206B · Palmer, AKThe pilot's failure to maintain control while hovering at a low altitude, which resulted in an impact with frozen lake ice. Contributing to the accident was the pilot's decision to operate the helicopter from the left seat contrary to the rotorcraft flight…Mar 10, 2015 · N86TA · Substantial damageNTSB ERA15FA147Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Kosciusko, MSThe pilot's decision to make a low pass over a lake near trees and his subsequent failure to maintain airplane control while maneuvering at a low altitude to avoid trees, which resulted in an inadvertent cross-control aerodynamic stall from which he was…Mar 8, 2015 · N7698S · Substantial damageNTSB WPR15LA126Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Merced, CAThe separation of the flight control stick from the stub due to its improper installation.Mar 7, 2015 · N5385Y · Substantial damageNTSB CEN15WA450Accident · 1 fatalForeign investigationPiper PA28 · Witzenhausen, Germany, GermanyOn March 4, 2015, about 0718 UTC, a Piper PA28, German registration D-ERIF, owned by a private individual, was substantially damaged when it impacted heavily wooded terrain near Witzenhausen, Germany, under unknown circumstances. The pilot was fataly injured.…Mar 4, 2015 · D-ERIF · Substantial damageNTSB ERA15LA145Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Venice, FLA total loss of engine power for reasons that could not be determined because postaccident testing of the engine revealed no anomalies.Mar 3, 2015 · N498TC · Substantial damageNTSB CEN15WA161Accident · No injuriesForeign investigationCirrus SR22 · Ljubljana, Moste, Slovenia, SloveniaThe accident investigation is under the jurisdiction and control of the Slovenian government. This report is for information purposes only and contains only information released by or obtained from the Slovenian government. Further information pertaining to…Feb 28, 2015 · S5-DJW · Substantial damageNTSB WPR15LA116Accident · Serious injuriesLimited investigationFinal reportBell 47G 2A · Ivanhoe, CAThe pilot’s failure to maintain clearance from a power line while maneuvering at low altitude.Feb 27, 2015 · N4774S · Substantial damageNTSB CEN15FA154Accident · 1 fatalField investigationFinal reportRose Thunder Mustang · Helotes, TXThe pilot’s failure to maintain terrain clearance from terrain after initiating an aerobatic maneuver at a low altitude.Feb 25, 2015 · N7TR · DestroyedNTSB WPR15WA108Accident · 2 fatalForeign investigationRobinson R44 II · Queenstown, New Zealand, New ZealandOn February 19, 2015, at 0244 universal coordinated time, a Robinson R44 II, ZK-IPY, operated by Over the Top Limited, collided with terrain under unknown circumstances near Queenstown, New Zealand. The two occupants on board were fatally injured and the…Feb 19, 2015 · ZK-IPY · Substantial damageNTSB WPR15LA109Accident · No injuriesLimited investigationFinal reportBell/Garlick UH 1H · Shelton, WAThe fatigue failure of the engine-to-transmission driveshaft adapter attachment bolt due to the application of inadequate torque on the bolt during assembly.Feb 19, 2015 · N166DR · Substantial damageNTSB ERA15LA133Accident · 1 fatalLimited investigationFinal reportJohnson Joel H Rans S-6ES Coyote II · Rincon, PRThe inadequate maintenance and inspection of the fuel system, which resulted in partial blockage of a fuel filter, a partial loss of engine power, and subsequent ditching.Feb 19, 2015 · N5196W · Substantial damageNTSB WPR15WA124Accident · No injuriesForeign investigationBell 206 - L4 · Wabo, Papua New Guinea, Papua New GuineaOn February 15, 2015, at 1020 local time, a Bell 206 L4, P2-HFZ, experienced a loss of engine power while maneuvering with an external load and subsequently landed hard near Wabo, Papua New Guinea. The helicopter was operated by Helifax Operations Limited…Feb 15, 2015 · P2-HFZ · Substantial damageNTSB WPR15CA107Accident · No injuriesData collectionFinal reportPiper PA28 - 180 · Garfield, WAThe pilot did not maintain clearance from a power line while maneuvering at a low altitude.Feb 15, 2015 · N7928W · Substantial damageNTSB CEN15CA153Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Asherton, TXThe pilot did not maintain adequate clearance from the trees.Feb 15, 2015 · N7181S · Substantial damageNTSB ERA15WA131Accident · 1 fatalForeign investigationCessna A188 · Tapes, BrazilOn February 7, 2015, about 1100 universal coordinated time, a Cessna A188, Brazilian registration PT-LOA, was destroyed when it struck a high-tension powerline and impacted terrain while maneuvering over a soybean field near Tapes, Brazil. The pilot was…Feb 7, 2015 · PT-LOA · DestroyedNTSB CEN15WA162Accident · No injuriesForeign investigationHughes 269A · Oresten, SwedenFeb 6, 2015 · N90584 · Substantial damageNTSB ERA15CA120Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Brookneal, VAThe flight instructor and pilot-rated student's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Feb 4, 2015 · N619GB · Substantial damageNTSB WPR15LA096Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Calexico, CAA partial loss of engine power 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.Feb 1, 2015 · N510KJ · Substantial damageNTSB ERA15CA127Accident · No injuriesData collectionFinal reportSchweizer 269C 1 · Carthage, NYThe non-helicopter-rated pilot's improper decision to operate the helicopter at low-level and his inability to adequately see the horizon over snow and ice, which resulted in controlled flight into terrain.Feb 1, 2015 · N20059 · Substantial damageNTSB CEN15FA127Accident · 1 fatalField investigationFinal reportEagleston John H Vans RV9A · Kingston, OKThe pilot’s continuation of a banked turn following the loss of engine power, which resulted in his failure to maintain adequate airspeed and the airplane exceeding its critical angle of attack and entering an accelerated stall at low altitude. Contributing…Jan 28, 2015 · N708JE · Substantial damageNTSB DCA15WA054Accident · 3 fatalForeign investigationHal Dhruv · Tena, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving an Ecuadorian Air Force Hal Dhruv helicopter, which occurred on January 27, 2015. The NTSB has appointed a U.S Accredited Representative to assist. All investigative…Jan 27, 2015 · FAE-605 · DestroyedNTSB WPR15LA092Accident · 1 fatalLimited investigationFinal reportAlexander RV-7 · Seabeck, WAA loss of airplane control for reasons that could not be determined because the airplane impacted water, and the majority of the wreckage was not recovered.Jan 26, 2015 · N747BA · DestroyedNTSB CEN15LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Routt County, COThe pilot’s intentional flight into terrain.Jan 25, 2015 · N8368U · Substantial damageNTSB ERA15FA109Accident · 2 fatalField investigationFinal reportPiper PA-23 · Lakeland, FLAn in-flight loss of control for reasons that could not be determined during postaccident investigation; the loss of control likely occurred during a simulated loss of power in the right engine during an instructional flight.Jan 22, 2015 · N465JA · DestroyedNTSB ERA15WA105Accident · No injuriesForeign investigationRobinson R66 · Tashanta, RussiaOn January 20, 2015, at an undetermined time, a Robinson Helicopter R66, Russian registration RA-06205, was substantially damaged during a forced landing near Tashanta, Russia. The pilot and two passengers were not injured. The flight originated in…Jan 20, 2015 · RA-06205 · Substantial damageNTSB CEN15LA106Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Shipshewana, INThe total loss of engine power due to impact ice obstructing the primary air induction system, which resulted from the student pilot’s failure to operate the alternate air control. Contributing to the accident was the student pilot’s lack of knowledge about…Jan 19, 2015 · N979DC · Substantial damage