OpenAirDocs.org

NTSB investigations, 2005

212 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\") = 2005
    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 LAX06FA069Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369FF · Lihue, HIThe pilot's failure to maintain aircraft control while hovering out of ground effect during an external load operation. A contributing factor was the pilot's lack of experience in external load operations.Dec 26, 2005 · N530MD · Substantial damageNTSB DEN06LA026Accident · 2 fatalLimited investigationFinal reportSyracuse Kitfox · Niwot, COThe pilot's improper in-flight decision to perform aerobatics at a low altitude resulting in a loss of control and impact with terrain. A contributing factor was the pilot's lack of aerobatic experience.Dec 24, 2005 · N94CV · DestroyedNTSB MIA06LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Opa-Locka, FLThe failure of the pilot-in-command to maintain airspeed following a reported loss of engine power, resulting in a stall/mush, uncontrolled descent, and in-flight collision with terrain. Factors in the accident were the pilot's intentional operation of the…Dec 18, 2005 · N86AB · Substantial damageNTSB SEA06LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Butte, MTThe pilot's failure to maintain clearance from the terrain during low-level maneuvering at night. Factors included the pilot’s improper in-flight decision to continue into an area that was forecasted to possibly contain snow, fog, and low ceilings. Additional…Dec 17, 2005 · N4350F · DestroyedNTSB NYC06CA041Accident · No injuriesData collectionFinal reportRobinson R-22B · Rochester, NHThe flight instructor's failure to maintain adequate clearance while providing hovering instruction, which resulted in tail rotor ground contact. A factor in this accident was the gusty wind conditions.Dec 3, 2005 · N40CP · Substantial damageNTSB LAX06FA049Accident · 1 fatalField investigationFinal reportNavion G · Imperial, CAThe pilot's failure to maintain clearance from a tree and transmission wires while performing a low altitude maneuver. Also causal was the pilot's impaired judgment and performance due to alcohol ingestion.Nov 29, 2005 · N2455T · DestroyedNTSB ATL06LA019Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Blairsville, GAThe non-instrument rated pilot's continued flight into known adverse weather and his failure to maintain clearance in mountainous terrain, resulting in an in-flight collision with trees and the ground. A factor in the accident was the pilot's lack of an…Nov 27, 2005 · N6485R · Substantial damageNTSB DEN06FA018Accident · 1 fatalField investigationFinal reportAmerican Champion 8KCAB · Calhan, COthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the low altitude, and the resultant stall/spin.Nov 21, 2005 · N70MT · DestroyedNTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.Nov 18, 2005 · N9928H · DestroyedNTSB LAX06LA036Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Lincoln, CAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall while maneuvering.Nov 15, 2005 · N56038 · Substantial damageNTSB DFW06LA027Accident · 1 fatalLimited investigationFinal reportArrow Falcon Exporters Arrow F OH-58A · West Memphis, ARThe loss of engine power due to a disconnected pneumatic (Pc) line. A contributing factor was the ravine.Nov 5, 2005 · N331TA · DestroyedNTSB NYC06CA020Accident · Minor injuriesData collectionFinal reportRobinson R44 · Bourne, MAThe inadvertent contact of a lift strap with the tail rotor during external load operations, which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the gusty wind conditions.Nov 1, 2005 · N319CD · Substantial damageNTSB NYC06LA024Accident · Minor injuriesLimited investigationFinal reportLo-N-Slo Airsports Maxair Drifter XP-50 · Cobbs Creek, VAFailure of the ignition system, which resulted in a loss of engine power.Oct 31, 2005 · N41094 · Substantial damageNTSB NYC06LA019Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Doylestown, PAThe flight instructor's inadequate remedial action, which resulted in a hard landing and subsequent rollover.Oct 29, 2005 · N8176B · Substantial damageNTSB ANC06LA007Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Unalakleet, AKThe pilot's failure to maintain altitude/clearance from terrain while performing a low altitude maneuver.Oct 24, 2005 · N1263Y · Substantial damageNTSB SEA06LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Gleneden Beach, ORThe pilot's failure to maintain clearance from objects while maneuvering over the airport environment. Dark night conditions, trees, and ground fog were factors.Oct 21, 2005 · N6000A · Substantial damageNTSB ATL06LA007Accident · 1 fatalLimited investigationFinal reportNorth American AT-6D · Mocksville, NCThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation and an in-flight collision with trees and the ground.Oct 15, 2005 · N494S · DestroyedNTSB SEA06CA013Accident · Serious injuriesData collectionFinal reportNorth Wing Apache ST Trike · Medical Lake, WAThe loss of engine power while maneuvering for undetermined reasons.Oct 14, 2005 · UNREG · Substantial damageNTSB LAX06LA006Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R-22 Beta II · Eagar, AZThe pilots' inadequate in-flight planning, which led the helicopter toward rising terrain in excess of the performance capability of the helicopter. Contributing factors were the high density altitude, and the rapidly rising terrain.Oct 14, 2005 · N7196J · Substantial damageNTSB ATL06CA006Accident · Serious injuriesData collectionFinal report1200 G103 · Benton, TNThe pilot's misjudgment of distance and failure to maintain a visual look out during a forced landing resulting in an in flight collision with a guy wire and the ground.Oct 14, 2005 · N381SL · Substantial damageNTSB NYC06CA009Accident · No injuriesData collectionFinal reportSikorsky S-76B · New York City, NYThe pilot flying's failure to maintain adequate aft hover clearance from a fence, and the pilot in command's delayed remedial action. A factor was the dark night lighting conditions.Oct 12, 2005 · N76UT · Substantial damageNTSB NYC06CA008Accident · No injuriesData collectionFinal reportEnstrom F-28C · Smoketown, PAThe student pilot's failure to maintain aircraft control while performing pedal turns at a hover, resulting in a collision with terrain.Oct 11, 2005 · N51772 · Substantial damageNTSB SEA06LA004Accident · No injuriesLimited investigationFinal reportBeech G35 · Longview, WARuddervator flutter which resulted in the buckling of the empennage. The reason for the ruddervator flutter was undetermined.Oct 7, 2005 · N4647D · Substantial damageNTSB LAX06CA002Accident · Serious injuriesData collectionFinal reportBell 206B · Pixley, CAthe pilot's failure to maintain clearance with the wire during a low altitude aerial application flight.Oct 2, 2005 · N201SC · Substantial damageNTSB SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.Sep 30, 2005 · N655GS · DestroyedNTSB LAX05LA321Accident · 1 fatalLimited investigationFinal reportCessna 150 · Taft, CAThe pilot's failure to maintain terrain clearance while maneuvering. The mountainous terrain was a factor.Sep 28, 2005 · N1238Q · Substantial damageNTSB LAX05LA318Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pioche, NVcontrolled flight into mountainous terrain due to the pilot's inadequate preflight planning and preparation and his inadequate in-flight decisions, which created a low fuel state emergency situation that led directly to the CFIT during flight assist efforts…Sep 26, 2005 · N5031T · Substantial damageNTSB MIA05CA163Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Opa Locka, FLThe pilot's failure to maintain airspeed, during a banner pick up, resulting in a stall/mush and collision with terrain during the uncontrolled descent.Sep 25, 2005 · N7788Z · Substantial damageNTSB SEA05MA199Accident · 3 fatalClass 1 · MajorFinal reportAerospatiale AS350BA · Haena, HIThe pilot's decision to continue flight into adverse weather conditions, which resulted in a loss of control due to an encounter with a microburst. Contributing to the accident was inadequate Federal Aviation Administration surveillance of Special Federal…Sep 24, 2005 · N355NT · Substantial damageNTSB IAD05LA142Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper 912 · Millstone, NJThe pilot's failure to maintain control of the airplane, which resulted in an uncontrolled descent and impact with trees.Sep 24, 2005 · UNREG · Substantial damageNTSB LAX05CA313Accident · No injuriesData collectionFinal reportHiller UH 12-E · Five Points, CAThe pilot's failure to refuel the helicopter, which resulted in fuel exhaustion.Sep 22, 2005 · N141HA · Substantial damageNTSB ANC05LA149Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Wasilla, AKThe pilot's failure to maintain adequate airspeed while maneuvering over wildlife, which resulted in an uncontrolled descent and subsequent collision with trees. A factor contributing to the accident was an inadvertent stall.Sep 22, 2005 · N4384C · Substantial damageNTSB SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.Sep 21, 2005 · N9527A · Substantial damageNTSB LAX05LA308Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350B3 · Running Springs, CAThe pilot's failure to maintain an adequate clearance from trees while performing long line external lift operations.Sep 21, 2005 · N814CE · Substantial damageNTSB DFW05FA244Accident · 2 fatalField investigationFinal reportDiamond Aircraft Industries DA20-C1 · Pleasanton, TXThe flight instructor's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.Sep 21, 2005 · N63PA · DestroyedNTSB DFW05CA250Accident · No injuriesData collectionFinal reportRobinson R44 · Batesville, TXThe pilot's failure to maintain rotor rpm and his subsequent encounter with settling with power.Sep 21, 2005 · N748BP · Substantial damageNTSB DEN05LA148Accident · 1 fatalLimited investigationFinal reportBrown Hi-MAX 1700R · Fort Morgan, COThe pilot's failure to maintain control of the airplane during a forced landing. Contributing factors were the resultant and inadvertent stall, the loss of engine power for undetermined reasons, and the pilot's lack of familiarity with the airplane.Sep 17, 2005 · UNREG · DestroyedNTSB DFW05FA240Accident · 3 fatalField investigationFinal reportCessna 175B · Cleveland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A contributing factor was the low altitude.Sep 15, 2005 · N8285T · DestroyedNTSB DFW05CA238Accident · No injuriesData collectionFinal reportCessna A188B · Paris, TXThe loss of engine power due the failure of a connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.Sep 14, 2005 · N9640G · Substantial damageNTSB DFW05CA236Accident · Serious injuriesData collectionFinal reportGrumman G-164B · Epps, LAThe pilot's failure to maintain clearance with the power lines.Sep 14, 2005 · N6667Q · Substantial damageNTSB DEN05LA137Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Rock Springs, WYthe pilot's failure to maintain control of the helicopter during the attempted autorotation after he experienced an engine overspeed that occurred for reasons undetermined.Sep 13, 2005 · N24SD · Substantial damageNTSB ANC05FA144Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Nenana, AKThe pilot's failure to maintain minimum airspeed to avoid a stall while maneuvering, which resulted in a loss of control, a stall/spin, and impact with terrain. Factors associated with the accident were an aerobatic maneuver, and a stall/spin.Sep 13, 2005 · N36237 · Substantial damageNTSB LAX05CA291Accident · No injuriesData collectionFinal reportRobinson R22 · Santa Clarita, CAthe pilot's improper use of the collective control while attempting to free the right skid, which induced a dynamic rollover.Sep 8, 2005 · N8348T · Substantial damageNTSB LAX05FA290Accident · 2 fatalField investigationFinal reportCessna 172RG · Avalon, CAan in-flight loss of control for undetermined reasons.Sep 7, 2005 · N9636B · DestroyedNTSB DFW05LA239Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Orleans, LAThe pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.Sep 7, 2005 · N230CA · Substantial damageNTSB LAX05LA289Accident · Serious injuriesLimited investigationFinal reportBell 206B · Long Beach, CAthe pilot's decision not to release the banner when it became entangled on itself, which resulted in the banner tow rope becoming ensnarled with the tail rotor system.Sep 5, 2005 · N667JM · Substantial damageNTSB DFW05LA229Accident · 1 fatalLimited investigationFinal reportCessna A188B · Blytheville, ARThe pilot's failure to maintain control of the aircraft for undetermined reasons.Sep 5, 2005 · N9083G · DestroyedNTSB LAX05LA288Accident · Minor injuriesLimited investigationFinal reportGoodlett Safari · Trona, CAthe in-flight fatigue failure of a control system connecting rod, which resulted in a loss of helicopter control.Sep 3, 2005 · N912TT · Substantial damageNTSB SEA05LA188Accident · 1 fatalLimited investigationFinal reportKirner Fisher FP404 · Prineville, ORThe design stress limits of the aircraft were exceeded resulting in a wing separation while the pilot was accomplishing maneuvers of hard banking turns, spins and steep descents.Sep 2, 2005 · UNREG · Substantial damageNTSB DEN05LA131Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Duchesne, UTthe loss of control during external load operations for undetermined reasons.Sep 2, 2005 · N220SH · Substantial damage