OpenAirDocs.org

NTSB investigations

18,851 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 LAX05LA086Accident · Minor injuriesLimited investigationFinal reportAustin Pitts Special · Coolidge, AZthe pilot's failure to maintain an adequate altitude from the airport surface when performing an intentional low altitude flyby maneuver.Feb 6, 2005 · N109WM · Substantial damageNTSB CHI05LA065Accident · 1 fatalLimited investigationFinal reportRamsey RV-8A · Rochester, INThe pilot failed to obtain a preflight weather briefing for his destination airport and he initiated the flight into known adverse weather conditions at the departure airport. The pilot subsequently failed to maintain adequate altitude while circling the…Feb 5, 2005 · N44RX · Substantial damageNTSB CHI05CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Minneapolis, MNThe pilot's inadequate compensation for the wind conditions and his failure to maintain control of the helicopter while maneuvering to center the helicopter on a cart. A factor associated with the accident was the wind gusts.Feb 5, 2005 · N7091C · Substantial damageNTSB DEN05CA052Accident · No injuriesData collectionFinal reportHughes 269C · Englewood, COthe student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight. Contributing factors were low rotor rpm, low airspeed, and the instructor's delay in taking remedial action.Jan 29, 2005 · N9688F · Substantial damageNTSB DFW05FA058Accident · 2 fatalField investigationFinal reportBeech J-35 · Abernathy, TXThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.Jan 21, 2005 · N399RH · DestroyedNTSB SEA05FA037Accident · 2 fatalField investigationFinal reportAero Commander AC200D (Meyers) · Hatch, UTThe pilot's failure to maintain aircraft control while maneuvering. Inadequate airspeed, the pilot's diverted attention, and low altitude flight were factors.Jan 18, 2005 · N49J · Substantial damageNTSB DFW05TA056Accident · Minor injuriesFinal reportSchweizer 269D · San Antonio, TXThe inadequate supervision and delayed remedial action by the flight instructor, which resulted in an inadvertent dynamic rollover.Jan 18, 2005 · N296RL · Substantial damageNTSB IAD05FA032Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Coconut Creek, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent to the ground. Factors included an avionics failure, pilot disorientation, and instrument meteorological conditions. A factor in the severity of the impact was the…Jan 15, 2005 · N889JB · DestroyedNTSB DFW05FA052Accident · 1 fatalField investigationFinal reportCessna 150M · Coleman, TXThe pilot's inadequate in-flight planning/decision by his VFR flight into IMC which resulted in his failure to maintain aircraft control. Contributing factors were fog and the pilot's inadequate preflight preparation.Jan 10, 2005 · N45173 · DestroyedNTSB LAX05FA061Accident · 2 fatalField investigationFinal reportVail Lancair 235 · Sacaton, AZThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall/spin.Jan 6, 2005 · N64BV · DestroyedNTSB LAX05LA060Accident · Minor injuriesLimited investigationFinal reportEurocopter France EC135T1 · Casa Grande, AZthe separation of a main rotor control link due to improper maintenance installation.Jan 3, 2005 · N135NW · Substantial damageNTSB NYC05LA033Accident · 3 fatalLimited investigationFinal reportCessna 172N · Mount Gilead, OHThe pilot's failure to maintain control of the airplane following an inadvertent encounter with instrument meteorological conditions. A factor in the accident was the rapidly deteriorating weather.Dec 30, 2004 · N737AZ · Substantial damageNTSB LAX05FA056Accident · 1 fatalField investigationFinal reportEurocopter France AS350BA · Panamint Spring, CAThe pilot's misjudged lateral distance from a mountainside and failure to maintain an adequate clearance from terrain and obstacles while performing a low altitude filming maneuver.Dec 30, 2004 · N410JC · DestroyedNTSB DEN05FA044Accident · 1 fatalField investigationFinal reportCessna 172S · Roswell, NMthe pilot not maintaining control of the aircraft resulting in an uncontrolled descent and collision on a highway. Factors contributing to the accident were the dark night and the pilot experiencing spatial disorientation.Dec 28, 2004 · N849SP · DestroyedNTSB SEA05TA028Accident · Serious injuriesFinal reportChristen Industries A-1 · Terreton, IDThe pilot's failure to maintain adequate airspeed while maneuvering which resulted in an inadvertent stall and subsequent collision with terrain.Dec 20, 2004 · N2898D · Substantial damageNTSB DFW05LA041Accident · Serious injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Texas City, TXThe pilot's failure to maintain clearance with terrain while performing aerobatics at a low altitude.Dec 19, 2004 · N992RS · Substantial damageNTSB LAX05LA083Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH-2000 · Jean, NVan in-flight separation of the left cockpit door due to the failure of the hinges from repeated exposure to wind or propeller slip stream forces while in the open position. The hinge failures were the ultimate result of the failure of persons unknown to…Dec 17, 2004 · N285AM · Minor damageNTSB DFW05FA040Accident · 1 fatalField investigationFinal reportBell 407 · Ship Shoal 130EThe pilot's failure to maintain clearance with a stationary object while maneuvering for landing. Contributing factors were the inadequate facilities available for landing, the pilot's lack of information regarding the landing area, and the operational status…Dec 17, 2004 · N976AA · DestroyedNTSB ATL05LA035Accident · No injuriesLimited investigationFinal reportBell UH-1H · Rockford, ALThe pilot's failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tree.Dec 16, 2004 · N51AG · Substantial damageNTSB DFW05LA037Accident · 2 fatalLimited investigationFinal reportCrosley Christen Eagle II · Morris, OKThe pilot's intentional spin, which was unrecoverable due to exceeded aircraft weight and balance limitations as a result of improper preflight planning/preparation.Dec 12, 2004 · N222CE · DestroyedNTSB DEN05LA035Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Monte Vista, COthe pilot's failure to maintain adequate airspeed which resulted in a stall during low level flight.Dec 12, 2004 · N23375 · Substantial damageNTSB DFW05FA032Accident · Serious injuriesField investigationFinal reportHughes 369D · Zachary, LAThe loss of engine power as a result of fatigue cracking of the compressor adaptor coupling initiated by fretting on the pilot diameter and subsequent disconnection of the compressor from the turbine assembly. A contributing factor was the low operating…Dec 9, 2004 · N7148Z · Substantial damageNTSB DEN05FA032Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXthe in-flight separation of the left wing as a result of extensive fatigue cracking throughout the wing carry-through structure.Dec 7, 2004 · N141SW · DestroyedNTSB DFW05FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hammond, LAA loss of engine power due to the pilot's in-flight mismanagement of the available fuel supply by his failure to switch fuel tank position, which resulted in fuel starvation. Factors were the low ceilings and the prevailing dark night conditions.Dec 6, 2004 · N4750L · DestroyedNTSB SEA05FA023Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Belgrade, MTThe pilot's failure to maintain altitude/clearance while maneuvering in mountainous terrain, which resulted in an inflight collision with trees and terrain. Contributing factors were the mountainous terrain and the downdraft.Dec 4, 2004 · N1159C · DestroyedNTSB NYC05LA027Accident · 2 fatalLimited investigationFinal reportClose Air Command · Wilmont, OHThe pilot's failure to maintain clearance from a wire while maneuvering to land in an open field.Dec 3, 2004 · UNREG · Substantial damageNTSB MIA05FA035Accident · 2 fatalField investigationFinal reportCessna 195 · Kilmichael, MSThe pilot's ostentatious display, flying at low altitude, resulting in collision with a static wire power line, in-flight loss of control, and collision with terrain. A factor in the accident was sun glare.Nov 25, 2004 · N195DD · DestroyedNTSB SEA05LA017Accident · 1 fatalLimited investigationFinal reportTrikes GTE 503 SL · Emmett, IDThe pilot intentionally performing an aerobatic maneuver while not maintaining clearance of the terrain.Nov 22, 2004 · UNREG · DestroyedNTSB MIA05LA033Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cocoa Beach, FLThe pilot's failure to maintain altitude resulting in flight collision with ground and subsequent collision with fence.Nov 22, 2004 · N44263 · Substantial damageNTSB NYC05LA020Accident · Serious injuriesLimited investigationFinal reportUnknown Sky Raider · Rappahannock Ac, VAThe uncertificated pilot's failure to maintain airspeed, which resulted in a stall, and collision with terrain. A factor in this accident was the pilot's lack of total flight experience.Nov 21, 2004 · UNREG · Substantial damageNTSB LAX05FA035Accident · 3 fatalField investigationFinal reportCessna 337B · Drake, AZthe pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…Nov 16, 2004 · N133JW · DestroyedNTSB NYC05CA016Accident · Serious injuriesData collectionFinal reportSyreini Hipps J3 Kitten · Delaware, OHThe pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with wires.Nov 14, 2004 · UNREG · Substantial damageNTSB IAD05LA031Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Galloo Island, NYA partial loss of engine power for undetermined reasons. A factor was the pilot's improper decision to operate the helicopter outside the height velocity curve.Nov 14, 2004 · N51739 · Substantial damageNTSB DEN05LA024Accident · No injuriesLimited investigationFinal reportBell 206B3 · Eureka, UTthe pilot's improper in-flight planning and decision making and failure to maintain obstacle clearance, resulting in contact with a power transmission line. Contributing factors include the intentional low-level maneuver, the power transmission line, and the…Nov 13, 2004 · N130JH · Substantial damageNTSB CHI05CA029Accident · Minor injuriesData collectionFinal reportGray Skybolt · St. Clair, MIThe pilot's improper spin recovery procedure, which resulted in a failure to maintain control of the aircraft during the intentional spin. An additional cause was the pilot's inability to maintain clearance to the trees and terrain during recovery.…Nov 13, 2004 · N80TG · Substantial damageNTSB DFW05LA022Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Eagle Pass, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the unsuitable terrain for landing.Nov 8, 2004 · N995JW · Substantial damageNTSB CHI05LA026Accident · 1 fatalLimited investigationFinal reportBruce Protech PT2B · Anita, IAThe pilot's failure to maintain sufficient airspeed and an inadvertent stall/spin resulting in loss of control and an in-flight collision with terrain. An additional cause was a loss of engine power for undetermined reasons.Nov 6, 2004 · N46WT · Substantial damageNTSB DFW05FA015Accident · 1 fatalField investigationFinal reportPiper PA-30 · Boise City, OKThe pilot's incapacitation (cardiovascular) resulting in a loss of aircraft control.Nov 5, 2004 · N7415Y · Substantial damageNTSB SEA05FA013Accident · 1 fatalField investigationFinal reportCessna 172P · Olympia, WAThe pilot's failure to maintain clearance from terrain while maneuvering in known adverse weather conditions. Clouds, rain, high wind, dark night, trees, mountainous terrain and the pilot's inadequate in-flight planning/decision were factors.Oct 30, 2004 · N53161 · Substantial damageNTSB DFW05LA012Accident · 1 fatalLimited investigationFinal reportHuber DR 107 · Fletcher, OKThe pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.Oct 28, 2004 · N255HR · DestroyedNTSB CHI05FA017Accident · 2 fatalField investigationFinal reportCessna 182J · Springfield, MOThe pilot's failure to maintain a proper altitude and his failure to maintain obstacle clearance while turning to reverse direction on final approach. A factor associated with the accident was the night lighting conditions which existed at the time of the…Oct 27, 2004 · N2703F · Substantial damageNTSB IAD05LA007Accident · 1 fatalLimited investigationFinal reportSanClemente Zenith CH 601HDS · Leominster, MAA loss of aircraft control for an undetermined reason.Oct 26, 2004 · N166DK · DestroyedNTSB LAX05TA018Accident · Serious injuriesFinal reportHughes OH-6A · Tucson, AZThe loss of engine power due to a fatigue fracture of the PC line from the governor to fuel control, resulting from fretting damage induced by excessive vibration, which was due to the failure of maintenance personnel to install the proper bearings in the…Oct 25, 2004 · N6188L · DestroyedNTSB CHI05LA015Accident · 1 fatalLimited investigationFinal reportStrissel Pitts S1S · Liberal, KSThe pilot's failure to maintain control of the airplane while performing aerobatic flight maneuvers resulting in an in-flight collision with terrain.Oct 24, 2004 · N230SB · DestroyedNTSB LAX05LA014Accident · 1 fatalLimited investigationFinal reportAMS Flight Carat A · Minden, NVthe pilot's likely inadvertent entry into instrument meteorological conditions created by the rapidly changing cloud conditions that resulted in his spatial disorientation and exceeding the glider's ultimate design loads while in a spiral dive, which resulted…Oct 23, 2004 · N418AP · DestroyedNTSB SEA05LA001Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Winifred, MTThe pilot's failure to maintain airspeed which resulted in an aerodynamic stall while maneuvering.Oct 19, 2004 · N79795 · Substantial damageNTSB MIA05CA006Accident · No injuriesData collectionFinal reportSchweizer 269C · Diamond Head, MSThe pilot's inadvertent loss of tail rotor effectiveness during takeoff to a hover and aborted landing in a grass area resulting in the grass catching fire from the engine exhaust and the helicopter being consumed by fire.Oct 16, 2004 · N119DM · DestroyedNTSB SEA05FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Grand Ronde, ORThe pilot's failure to maintain clearance from high terrain while maneuvering. A factor contributing to the accident was the high terrain.Oct 15, 2004 · N454FL · DestroyedNTSB LAX05TA008Accident · No injuriesFinal reportHughes OH-6A · Jacumba, CAthe pilot's failure to maintain adequate clearance from the mountainous terrain, which resulted in the helicopter's tail rotor blades impacting rocks. A factor in the accident was the pilot's complacency.Oct 15, 2004 · N6639R · Substantial damageNTSB LAX05LA009Accident · 1 fatalLimited investigationFinal reportBrackett And Peltz Kit Fox III · Aguila, AZthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall. The nature and scope of the problem reported by the pilot is undetermined.Oct 15, 2004 · N543BP · Substantial damage