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 LAX05LA007Accident · 1 fatalLimited investigationFinal reportDeRosier DR-107 · San Diego, CAthe pilot's failure to maintain adequate clearance from terrain while performing low-level aerobatic maneuvers.Oct 15, 2004 · N31SH · Substantial damageNTSB ANC05FA008Accident · 1 fatalField investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and collision with water during maneuvering flight. Factors contributing to the accident were fog and low ceilings.Oct 15, 2004 · N4126E · DestroyedNTSB SEA05LA006Accident · 1 fatalLimited investigationFinal reportCaldwell Glasair II · Hermiston, ORThe pilot's failure to maintain an airspeed above stall speed while executing a wingover maneuver at the top of a vertical climb, leading to an inadvertent spin, and the pilot's inadequate remedial action in attempting to recover from the spin. Factors…Oct 14, 2004 · N706C · DestroyedNTSB ATL05CA003Accident · Minor injuriesData collectionFinal reportBell 206 B · Eutaw, ALThe pilots inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.Oct 14, 2004 · N300HT · Substantial damageNTSB NYC05CA008Accident · No injuriesData collectionFinal reportHughes 269C · Minerva, OHThe pilot's failure to maintain control of the helicopter during liftoff.Oct 10, 2004 · N7423F · Substantial damageNTSB DFW05CA004Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-26E · El Paso, TXThe pilot's misjudgment of distance and altitude during a local soaring flight. A contributing factor was the lack of suitable terrain for the landing.Oct 8, 2004 · N17911 · Substantial damageNTSB DEN05FA003Accident · 1 fatalField investigationFinal reportCessna A185E · Luna, NMthe pilot's improper use of the mixture control, his failure to maintain clearance from the trees, and his improper preflight planning resulting in his taking off into a canyon and subsequently impacting the trees and terrain. Factors contributing to the…Oct 3, 2004 · N5964 · DestroyedNTSB DEN05FA002Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Santa Fe, NMthe pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…Oct 2, 2004 · N92CG · DestroyedNTSB ATL04LA195Accident · 2 fatalLimited investigationFinal reportCessna 172L · Gadsden, ALThe flight instructors failure to maintain clearance and his inadequate visual lookout while flying low over a river resulting in an in-flight collision with a wire.Sep 29, 2004 · N4336Q · DestroyedNTSB LAX04CA332Accident · No injuriesData collectionFinal reportBell 222U · Santa Rosa, CAthe pilot-in-command's (examinee's) incorrect collective control response to a simulated power loss of the number 1 engine.Sep 28, 2004 · N222UT · Substantial damageNTSB DEN04LA149Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS-350-B3 · Las Cruces, NMThe pilot's failure to maintain aircraft control during takeoff resulting in the helicopter's skid striking the helipad and the helicopter's subsequent rollover. Factors contributing to the accident were the pilot's improper preflight planning/decision, his…Sep 28, 2004 · N497AE · Substantial damageNTSB CHI04LA280Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Kingman, KSThe lack of engine oil due to the mechanic's improper maintenance in not securing the loose "B" nut for the oil pressure line to the turbocharger leading to the loss of engine power while maneuvering. An additional cause was the unsuitable terrain the pilot…Sep 27, 2004 · N2027S · Substantial damageNTSB LAX04FA329Accident · 5 fatalClass 1 · FieldFinal reportBell 206B · Kalaheo, HIThe pilot's decision to continue flight under visual flight rules into an area of turbulent, reduced visibility weather conditions, which resulted in the pilot's spatial disorientation and loss of control of the helicopter. Contributing to this accident was…Sep 25, 2004 · N16849 · DestroyedNTSB CHI04LA279Accident · Serious injuriesLimited investigationFinal reportErnst Pitts S2E · Hanover, INThe pilot's failure to maintain clearance to the trees and terrain during the aerobatic maneuver. Contributing factors were the pilot's decision to perform a low-level, ostentatious aerobatic display and the trees.Sep 25, 2004 · N8005X · Substantial damageNTSB ATL04FA190Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Euharlee, GAThe pilot's failure to maintain adequate control of the airplane, which resulted in the pilot exceeding the design limits of the airplane and subsequent in-flight separation.Sep 21, 2004 · N801SP · Substantial damageNTSB SEA04FA191Accident · 1 fatalField investigationFinal reportCessna 172D · Mountain Home, IDThe pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.Sep 19, 2004 · N2650U · Substantial damageNTSB LAX04CA323Accident · No injuriesData collectionFinal reportAero Commander S2R · Firebaugh, CAthe failure of the pilot to maintain clearance from high tension wires in dark night conditions. The reason for the loss of engine power after the wire collision was not determined.Sep 18, 2004 · N8822Q · Substantial damageNTSB DEN04LA145Accident · No injuriesLimited investigationFinal reportBell 214B-1 · Aspen, COthe inadvertent activation of the engine's fuel shut off valve, resulting in the reduction of engine power to 50 percent due to an improper cannon plug wire repair on the engine's wire harness assembly. Contributing factors include the improper wire repair,…Sep 17, 2004 · N214B · Substantial damageNTSB FTW04TA237Accident · 1 fatalFinal reportBell OH-58C · Beaumont, TX**This probable cause was modified on 2/22/2016. Please see the public docket for this accident for additional details.** The pilot's failure to maintain a safe altitude, resulting in collision with the water. A factor was the dark night.Sep 16, 2004 · N9273T · DestroyedNTSB MIA04FA135Accident · 4 fatalField investigationFinal reportCessna 336 · Magee, MSThe student pilot/ airplane owner's lack of training in night operations, which resulted in spatial disorientation, a loss of control, an uncontrolled descent, and an impact with trees.Sep 15, 2004 · N3832U · DestroyedNTSB SEA04FA190Accident · 1 fatalField investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain aircraft control.Sep 14, 2004 · N20GV · Substantial damageNTSB IAD04LA046Accident · 1 fatalLimited investigationFinal reportScott Rans S-12 · Seneca, NYThe student pilot's failure to maintain airspeed above stall speed, which resulted in an inadvertant stall/spin. A factor in the accident was the pilot's lack of pilot certification.Sep 12, 2004 · N195CB · DestroyedNTSB ANC04LA106Accident · No injuriesLimited investigationFinal reportCessna 180A · Kasiloff, AKThe pilot's improper use of the carburetor heat control which resulted in carburetor ice and the loss of engine power. A factor associated with the accident was the carburetor icing conditions.Sep 12, 2004 · N5304D · Substantial damageNTSB ATL04LA177Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Lake Wales, FLThe pilot's inadequate preflight planning and preparation, and his inadequate visual lookout, which resulted in a collision with a television tower.Sep 11, 2004 · N962AB · Substantial damageNTSB ATL04LA181Accident · Minor injuriesLimited investigationFinal reportHughes HU-369-D · Waynesboro, GAThe tail rotor assembly failed due to a fatigue fracture of the input gearshaft in the tail rotor gearbox assembly, which resulted in a loss of tail rotor control and subsequent collision with trees.Sep 10, 2004 · N5211R · Substantial damageNTSB ATL04LA176Accident · 2 fatalLimited investigationFinal reportLemoine Marvin J. Jr. Christian Eagle II · Cleveland, GAThe pilot's failure to maintain clearance from trees while conducting aerobatic maneuvers.Sep 10, 2004 · N83BL · Substantial damageNTSB ATL04LA173Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401B · Bainbridge, GAThe pilot's failure to maintain adequate airspeed during an abrupt maneuver which resulted in a stall and collision with the ground.Sep 4, 2004 · N3047A · Substantial damageNTSB LAX04CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Willits, CAthe pilot's inadvertent descent and controlled flight into obstacles while maneuvering to land. Contributing factors were the dark, nighttime condition, which impaired the pilot's visual perceptions, and the pilot's failure to obtain a pertinent Notice to…Sep 2, 2004 · N897TW · DestroyedNTSB FTW04LA227Accident · No injuriesLimited investigationFinal reportGrumman 164B · East Bernard, TXThe loss of engine power as result of the failure of the number four cylinder. A factor was the lack of suitable terrain for the forced landing.Aug 31, 2004 · N8222K · Substantial damageNTSB SEA04FA173Accident · 2 fatalField investigationFinal reportBeech C35 · Kalispell, MTThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.Aug 29, 2004 · N63AC · DestroyedNTSB NYC04FA197Accident · 2 fatalField investigationFinal reportRobinson R-22 · Northport, NYAn improper maneuver by the flightcrew while attempting to avoid a kite, which resulted in mast bumping, the separation of the main rotor system, and a subsequent uncontrolled descent into water.Aug 29, 2004 · N871CL · Substantial damageNTSB LAX04LA305Accident · Serious injuriesLimited investigationFinal reportGibbs Kitfox IV · Payson, AZthe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent collision with terrain. Contributing factors to the accident were the turbulence and the gusting wind conditions.Aug 28, 2004 · N728KF · Substantial damageNTSB LAX04FA304Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Prescott, AZThe failure of both pilots to maintain adequate clearance from each other while performing formation aerobatic maneuvers.Aug 28, 2004 · N561ER · 2 aircraft · DestroyedNTSB ANC04LA098Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-3 · McGrath, AKThe pilot's inadequate in-flight planning/decision making, his continued VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Factors contributing to the accident were low ceilings due to smoke, rain, and mist.Aug 28, 2004 · N197TT · DestroyedNTSB MIA04LA123Accident · No injuriesLimited investigationFinal reportBell 206B3 · Panama City, FLInadequate maintenance inspection resulting in the partial loss of engine power due to a loose pneumatic line on the governor and ditching of the helicopter.Aug 24, 2004 · N107PH · Substantial damageNTSB MIA04LA122Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · West Palm Beach, FLThe partial loss of engine power due to low cylinder compression during recovery from a practice autorotation resulting in a hard landing and damage to the helicopter.Aug 24, 2004 · N4062X · Substantial damageNTSB FTW04LA221Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Shreveport, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 24, 2004 · N9714Q · Substantial damageNTSB DEN04LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Atlantic City, WYthe pilot's inability to maintain aircraft control, improper in-flight planning and decision making, and failure to compensate for wind conditions, resulting in collision with terrain. Contributing factors were the intentional low-level maneuver, and the wind…Aug 23, 2004 · N2751U · Substantial damageNTSB FTW04TA219Accident · Serious injuriesFinal reportCessna 182Q · Lamar, OKThe pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.Aug 22, 2004 · N10HP · Substantial damageNTSB SEA04FA169Accident · 1 fatalField investigationFinal reportCessna A185F · Toutle, WAThe pilot's continued flight into known adverse weather conditions. Inadequate preflight planning/preparation, trees, a low ceiling and no suitable terrain available for the landing were factors.Aug 21, 2004 · N7562Q · DestroyedNTSB CHI04LA245Accident · Serious injuriesLimited investigationFinal reportFall Cub · Rockville, INThe fuel starvation encountered due to the builder's inadequate fuel system design and the subsequent loss of engine power during a maneuver for the landing approach. Factors were the tree and corn.Aug 21, 2004 · N25MF · Substantial damageNTSB SEA04LA168Accident · 1 fatalLimited investigationFinal reportCessna 150L · Angela, MTThe failure of the pilot to maintain clearance while maneuvering. A factor contributing to the accident was the physical impairment of the pilot due to an elevated blood alcohol level.Aug 19, 2004 · N17062 · DestroyedNTSB SEA04TA163Accident · 1 fatalFinal reportBell 206B · Mead, WAThe reversal of the reel machine during a sock line pull which resulted in a loss of control while hovering out of ground effect. Factors were the failure of company management to develop adequate procedures for conducting sock line pulls, the inadequate…Aug 17, 2004 · N34698 · DestroyedNTSB DEN04LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Spanish Fork, UTthe pilot's improper inflight planning and decision making, and his failure to maintain terrain clearance. Contributing factors were his intentional low altitude flight and maneuvering, the aircraft's climb performance being exceeded, and the trees.Aug 13, 2004 · N6249K · DestroyedNTSB ANC04LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Soldotna, AKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and uncontrolled descent.Aug 13, 2004 · N8653Y · Substantial damageNTSB CHI04LA225Accident · 1 fatalLimited investigationFinal reportCessna A188B · Mylo, NDThe pilot's failure to maintain clearance from the windmill. The windmill was a contributing factor.Aug 12, 2004 · N92806 · DestroyedNTSB SEA04TA158Accident · 1 fatalFinal reportBell 205A1 · Leavenworth, WAThe pilot's failure to maintain clearance from the snag while hovering out of ground effect during an external load operation. Factors were the smoke jumper's misjudgment of the tree heights in the area, which resulted in the use of too short a long line, and…Aug 11, 2004 · N205XP · DestroyedNTSB CHI04LA220Accident · 1 fatalLimited investigationFinal reportAllied Ag Cat Productions G-164B · Moville, IAThe pilot's inadequate in-flight planning/decision by his failure to maintain obstacle clearance. Contributing factors were low altitude flying and the tree.Aug 11, 2004 · N48424 · DestroyedNTSB FTW04LA209Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Denton, TXThe student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight by his delay in taking remedial action.Aug 9, 2004 · N204LH · Substantial damageNTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.Aug 9, 2004 · N911JR · Destroyed