OpenAirDocs.org

NTSB investigations, 2004

224 cases where the phase of flight was Maneuvering.

Cases per year

19622026

Where

Open the map

Latest cases

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 year(c.\"eventDate\") = 2004
    AND 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 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 damageNTSB 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 damage