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 CEN15WA448Accident · 1 fatalForeign investigationPitts S2 · Friesach, AustriaOn August 30, 2015, about 1242 UTC, a Pitts S2B airplane, D-EZZT, (s/n 5327), impacted terrain while performing aerobatic maneuvers near Friesach, Austria. The airplane was destroyed and the pilot was fatally injured. This investigation is under the…Aug 30, 2015 · D-EZZT · DestroyedNTSB ERA15FA331Accident · 1 fatalField investigationFinal reportCornell W F/Sahakian J A JR Giles 202 (G202) · Newburgh, NYSeparation of the vertical and horizontal stabilizers from the fuselage due to a fracture that initiated at the bond between the left horizontal stabilizer and the flange that attached the horizontal stabilizer to the fuselage skin. The failure was likely…Aug 28, 2015 · N18FJ · DestroyedNTSB GAA15CA255Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Irwin, IDThe pilot's failure to maintain obstacle clearance during low level flight, which resulted in the airplane striking a wire, impacting water, and nosing over.Aug 27, 2015 · N63BW · Substantial damageNTSB CEN15LA389Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Monroe, NELoss of propeller thrust for reasons that could not be determined, since examination of the airplane's engine, propeller, and associated accessories revealed no anomalies.Aug 27, 2015 · N61267 · Substantial damageNTSB CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…Aug 26, 2015 · N2005C · DestroyedNTSB CEN15LA384Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 602 · Pine Bluff, ARThe pilot’s failure to maintain clearance from terrain during an aerial application flight.Aug 26, 2015 · N3026R · Substantial damageNTSB ANC15FA066Accident · 2 fatalField investigationFinal reportCessna 180 · Kasilof, AKThe total loss of engine power for reasons that could not be determined based on postaccident examination and testing.Aug 23, 2015 · N3043E · Substantial damageNTSB CEN15LA375Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Carlos, TXThe pilot’s improper decision to turn the helicopter toward a tailwind during an out-of-ground-effect hover, which resulted in a loss of tail rotor effectiveness. Contributing to the accident was the accident and lead pilots’ inadequate preflight risk…Aug 22, 2015 · N445HS · Substantial damageNTSB CEN15FA378Accident · 1 fatalField investigationFinal reportCessna 172 · Martinville, ILThe non-certificated pilot's failure to maintain clearance from terrain.Aug 21, 2015 · N8265B · Substantial damageNTSB WPR15LA248Accident · Minor injuriesLimited investigationFinal reportSikorsky S 61A · Ironside, ORA loss of power to the No. 2 engine due to the failure of the accessory gearbox drivetrain. Also causal was the pilot’s inability to release the external longline due to the use of a safety wire across the coupling of the quick-disconnect mechanism, which…Aug 20, 2015 · N1043T · Substantial damageNTSB GAA15CA238Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Ronkonkoma, NYThe student pilot's loss of control during a hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor's lack of action to remediate the student pilot's control inputs and recover aircraft control.Aug 19, 2015 · N86EH · Substantial damageNTSB CEN15LA370Accident · No injuriesLimited investigationFinal reportBell 206B · Cresco, IAThe loss of engine power due to the high-cycle fatigue failure of the third-stage turbine wheel.Aug 18, 2015 · N5743W · Substantial damageNTSB CEN15LA367Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Wiville, ARThe pilot's failure to maintain clearance from a utility pole while maneuvering during an agricultural application flight, which resulted in damage to the right aileron and a subsequent uncontrolled right roll at a low altitude.Aug 18, 2015 · N3070R · DestroyedNTSB GAA15CA230Accident · Minor injuriesData collectionFinal reportBell 412 · Whittier, CAThe pilot's failure to appropriately monitor the helicopter's fuel supply, resulting in fuel exhaustion, loss of engine power, and an autorotation with a hard landing.Aug 17, 2015 · N412LA · Substantial damageNTSB CEN15WA364Accident · Minor injuriesForeign investigationMX MX2 · Châteauneuf-sur-Cher, FranceAug 16, 2015 · N88MX · DestroyedNTSB CEN15LA403Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Big Piney, WYThe pilot's failure to maintain adequate altitude while operating over high mountainous terrain, which resulted in an emergency landing after the airplane's encounter with a downdraft.Aug 16, 2015 · XBYUH · Substantial damageNTSB WPR15LA240Accident · Minor injuriesLimited investigationFinal reportStinson SR 9B · Chula Vista, CAA total loss of engine power due to fuel exhaustion as a result of the pilot’s failure to verify the fuel quantity before the flight.Aug 14, 2015 · N17154 · Substantial damageNTSB CEN15LA377Accident · No injuriesLimited investigationFinal reportGrumman G 164B · Sac City, IAThe loss of engine power for reasons that could not be determined based on the available information.Aug 12, 2015 · N311AL · Substantial damageNTSB CEN15RA352Accident · 1 fatalForeign investigationDehavilland DHC 2 · Akureyri, IcelandOn August 9, 2015, at an unknown time, a De Havilland DHC-2 airplane, United States registration N610LC, was substantially damaged when it impacted mountainous terrain near Akureyri, Iceland. One occupant sustained fatal injuries, and one occupant sustained…Aug 9, 2015 · N610LC · Substantial damageNTSB CEN15LA344Accident · 1 fatalLimited investigationFinal reportErickson Larry D RAF 2000 GT · Humboldt, IAThe pilot’s loss of gyroplane control while maneuvering at low altitude.Aug 9, 2015 · N315LK · Substantial damageNTSB ANC15LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Talkeetna, AKImpact with terrain during low-level cruise flight for reasons that could not be determined based on the available information.Aug 9, 2015 · N9265D · Substantial damageNTSB ERA15WA305Accident · 3 fatalForeign investigationCessna 402B · Vereda Guarigua Cajica, ColombiaOn August 8, 2015, 1505 UTC, a Cessna 402B, HK-4990, registered to and operated by AeroExpress, collided with terrain near Vereda Guarigua Cajica, Cundinamarca, Colombia. Visual meteorological conditions prevailed at the time and flight plan information is…Aug 8, 2015 · HK-4990 · Substantial damageNTSB ERA15WA303Accident · 9 fatalForeign investigationCessna U206F · Istra, RussiaOn August 8, 2015, at 1708 universal coordinated time, a Cessna U206F airplane, Russian registration RA- 67523 registered to a private owner, and a Robinson R44 II helicopter, Russian registration RA- 04383, registered to a private owner, collided while…Aug 8, 2015 · RA-67523 · 2 aircraft · DestroyedNTSB CEN15LA398Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Macine · Zeeland, MIThe noncertificated pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from a tree.Aug 8, 2015 · UNREG · DestroyedNTSB CEN15LA359Accident · Serious injuriesLimited investigationFinal reportAeros Aeros 2 · Albuquerque, NMThe ultralight airplane’s encounter with a downdraft in mountainous terrain, which resulted in a descent into trees.Aug 8, 2015 · N5982V · Substantial damageNTSB CEN15LA355Accident · No injuriesLimited investigationFinal reportWorld Spirit · Granbury, TXThe pilot’s failure to use the fuel boost pump following the loss of engine power and the fuel system’s inadequate design, which did not allow for equalization of fuel between the fuel tanks and led to a total loss of engine power due to fuel starvation and…Aug 7, 2015 · N65XT · Substantial damageNTSB CEN15CA348Accident · Minor injuriesData collectionFinal reportRobinson R44 · Kansasville, WIThe pilot's inability to see and avoid power lines that were low to the ground and a green color that blended with the background crops.Aug 7, 2015 · N20KD · DestroyedNTSB GAA15LA217Accident · Minor injuriesLimited investigationFinal reportMD Helicopter 369E · Whitefish, MTThe pilot’s failure to maintain altitude and a level attitude while hovering over water at night during an external load operation, which resulted in the helicopter’s main rotor contacting the surface of the water.Aug 5, 2015 · N43792 · Substantial damageNTSB WPR15LA230Accident · No injuriesLimited investigationFinal reportGrumman G164 - B · Princeton, CAThe loss of engine power during an agricultural application flight due to a cylinder failure.Aug 4, 2015 · N48452 · Substantial damageNTSB WPR15LA232Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 20B · Logan, UTThe pilot’s failure to maintain glider control when it encountered a strong downdraft while maneuvering near a ridgeline.Aug 2, 2015 · N20YZ · Substantial damageNTSB CEN15LA366Accident · No injuriesLimited investigationFinal reportCessna 206 · Pecos, TXThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 2, 2015 · N5033U · Substantial damageNTSB CEN15FA331Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Wilmot, ARThe pilot's inability to maintain control of the airplane as a result of incapacitation by drug effects or an acute cardiac event.Aug 1, 2015 · N6007N · Substantial damageNTSB CEN15LA330Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Emmett, KSThe engine failure due to several loose, damaged cylinder stud nuts and hold-down bolts. Contributing to the accident was maintenance personnel’s failure to detect that the cylinder nuts and hold-down bolts were not properly secured during the engine’s most…Jul 31, 2015 · N963X · Substantial damageNTSB GAA15CA204Accident · Minor injuriesData collectionFinal reportAirbus AS350-B2 · Tucson, AZThe flight instructor's misperception of the helicopter's altitude in relation to the runway surface during a low altitude maneuver, resulting in ground impact.Jul 29, 2015 · N6095U · Substantial damageNTSB CEN15FA321Accident · 3 fatalField investigationFinal reportChristensen Steve Wheeler Express · Holland, MNThe pilot’s failure to maintain adequate airspeed during a high-pitch, steep right turn, which resulted in the exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall, loss of control, and impact with terrain. Contributing to…Jul 28, 2015 · N3FC · Substantial damageNTSB WPR15FA222Accident · 1 fatalField investigationFinal reportBeech F35 · Riverside, CAThe total loss of engine power for reasons that could not be determined during postaccident examination of the airplane and engine. Also causal to the accident was the pilot's decision to attempt to reach the farthest runway and land into the wind instead of…Jul 27, 2015 · N988RH · DestroyedNTSB CEN15FA320Accident · 4 fatalField investigationFinal reportBeech M35 · Amery, WIThe pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.Jul 27, 2015 · N9CB · DestroyedNTSB ERA15LA289Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fort Lauderdale, FLThe undetected fatigue cracks in the engine and nose landing gear (NLG) strut mount assembly, which prevented the proper alignment of the NLG after it was extended and the pilots from being able to maintain directional control after touchdown.Jul 23, 2015 · N4631J · Substantial damageNTSB WPR15WA231Accident · Minor injuriesForeign investigationBell 407 - NO Series · Tifalmin Village Papua New Guinea, Papua New GuineaOn July 22, 2015, at 1325 local time, a Bell 407, P2-HCB, registered to and operated by Hevilift, experienced a loss of engine power while maneuvering away from a drilling/exploration camp near Tifalmin Village, Papua New Guinea. The helicopter subsequently…Jul 22, 2015 · P2-HCB · Substantial damageNTSB CEN15FA310Accident · 2 fatalField investigationFinal reportAeronca 7BCM (L-16A) · Auburn, WYThe pilot's failure to maintain airspeed while turning at low altitude, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.Jul 22, 2015 · N8362H · DestroyedNTSB WPR15LA219Accident · Minor injuriesLimited investigationFinal reportGarlick UH1H · Walla Walla, WAThe helicopter’s reduction in aerodynamic lift while operating in variable wind conditions for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have…Jul 21, 2015 · N121PT · DestroyedNTSB ANC15FA050Accident · 1 fatalField investigationFinal reportCessna U206G · Trapper Creek, AKThe pilot's failure to maintain clearance from trees while intentionally maneuvering close to the ground.Jul 20, 2015 · N734VB · DestroyedNTSB WPR15WA224Accident · 1 fatalForeign investigationGlasair SH-2FT · Wedderburn, AustraliaOn July 19, 2015 about 1700 local time, an amateur built Glasair SH-2FT, Australian registration VH-HRG, collided with terrain near Wedderburn, Victoria, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The investigation…Jul 19, 2015 · VH-HRG · Substantial damageNTSB GAA15CA232Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Prairie Lea, TXThe pilot's failure to maintain rotor rpm, resulting in an uncontrolled descent and collision with trees.Jul 16, 2015 · N804DF · Substantial damageNTSB CEN15LA323Accident · No injuriesLimited investigationFinal reportCessna 182B · Fults, ILThe malfunction of the flap assembly, which resulted in a restriction of aileron control. Contributing to the accident was maintenance personnel’s inadequate inspection of a corroded flap control cable.Jul 14, 2015 · N2764G · DestroyedNTSB ANC15CA051Accident · No injuriesData collectionFinal reportCessna 140 · Homer, AKThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.Jul 14, 2015 · N72784 · Substantial damageNTSB GAA15LA131Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Escalante, UTThe pilot’s inadequate preflight planning and his subsequent decision to attempt to climb over rising terrain with the helicopter over maximum gross weight while operating in high-density altitude conditions with a tailwind, which resulted in its inability to…Jul 12, 2015 · N441MM · Substantial damageNTSB ERA15CA262Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Viola, TNThe pilot's failure to see and avoid a guy wire, which resulted in contact with the wire and subsequent collision with terrain.Jul 12, 2015 · N577AT · Substantial damageNTSB WPR15WA213Accident · 2 fatalForeign investigationBell 407 - NO Series · Zhejiang Province, P.R. China, ChinaOn July 9, 2015 at 0225 Universal Coordinated Time, a Bell 407, B-7723, was substantially damaged when it crashed at the Qiandao Lake General Aviation airport, Zhejiang Province P. R. China, while conducting a post-repair hovering test. A total of seven…Jul 9, 2015 · B-7723 · Substantial damageNTSB GAA15CA171Accident · No injuriesData collectionFinal reportWeatherly 620B · Hatch, NMThe pilot failed to maintain obstacle clearance, and the airplane struck a transmission line wire during aerial application operations.Jul 9, 2015 · N2034P · Substantial damage