OpenAirDocs.org

NTSB investigations, 2007

222 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\") = 2007
    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 NYC08FA071Accident · 3 fatalField investigationFinal reportBell 206L-3 · Cherokee, ALThe pilot's failure to maintain control of the helicopter during an out-of-ground-effect hover. Contributing to the accident was a loss of tail rotor effectiveness.Dec 30, 2007 · N109AE · Substantial damageNTSB LAX08FA043Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Paso Robles, CAThe pilot's encounter with isolated moderate (or greater) turbulence, updrafts, and downdrafts associated with localized mountain wave conditions at low altitude, and, his failure to maintain adequate airspeed during the encounter that resulted in an…Dec 30, 2007 · N254SR · Substantial damageNTSB DFW08LA052Accident · 2 fatalLimited investigationFinal reportAlthouse RAF 2000 GTX · Crowley, TXThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.Dec 29, 2007 · N136DG · DestroyedNTSB CHI08CA056Accident · No injuriesData collectionFinal reportErcoupe 415D · Abingdon, ILThe loose clamp on the throttle cable which prevented application of engine power. A factor in the accident was the low altitude when the throttle cable slipped.Dec 29, 2007 · N94131 · Substantial damageNTSB SEA08CA055Accident · No injuriesData collectionFinal reportBrooks Exec 162F · Santa Maria, CAThe pilot's failure to maintain control of the helicopter during hover. Contributing to the accident was the pilot's lack of experience in rotorcraft.Dec 22, 2007 · N66012 · Substantial damageNTSB NYC08CA068Accident · No injuriesData collectionFinal reportCessna 170B · Alton, NHThe pilot's failure to maintain clearance above a frozen lake while maneuvering. Factors contributing to the accident were the pilot's attempt of the low altitude maneuver, and unfavorable lighting conditions.Dec 22, 2007 · N3070A · Substantial damageNTSB DEN08LA040Accident · 1 fatalLimited investigationFinal reportGarniss Stol 701 · Mesilla, NMThe pilot's failure to maintain aircraft control during an intentional low altitude maneuver due to impairment, resulting in the in-flight collision with terrain.Dec 15, 2007 · N45500 · DestroyedNTSB SEA08FA046Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Orting, WAThe pilot's failure to maintain clearance from trees while maneuvering. A contributing factor was the dark night.Dec 7, 2007 · N4388P · Substantial damageNTSB LAX08CA034Accident · Serious injuriesData collectionFinal reportAir Tractor AT-401 · Soledad, CAThe pilot's failure to maintain an adequate clearance from mountainous terrain while maneuvering during an aerial application mission. Contributing to the accident was the pilot's diverted attention inside the cockpit.Dec 6, 2007 · N6024M · DestroyedNTSB DFW08FA040Accident · 2 fatalField investigationFinal reportCessna 172N · Marlow, OKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin and impact with terrain. Contributing to the accident were the low altitude for recovery and the gusty tailwind.Nov 28, 2007 · N6555D · Substantial damageNTSB DEN08FA036Accident · 1 fatalField investigationFinal reportCessna 182Q · Farmerville, LAThe pilot's failure to maintain aircraft control due to the effects of impairment from alcohol consumption resulting in the collision with the trees.. A contributing factor was the Federal Aviation Administration's failure to identify existing evidence of…Nov 28, 2007 · N5134N · DestroyedNTSB MIA08CA019Accident · Minor injuriesData collectionFinal reportLake LA-4-200 · Jacksonville, FLThe pilot's failure to maintain altitude while maneuvering over water. Contributing to the accident was glassy water conditions.Nov 25, 2007 · N1055L · Substantial damageNTSB SEA08LA038Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Yuma, AZFatigue fracture of the control rotor blade spar and failure of maintenance personnel to follow maintenance directives.Nov 24, 2007 · N104EA · Substantial damageNTSB NYC08LA043Accident · No injuriesLimited investigationFinal reportRobinson R22 · Suffolk, VAThe V-drive belts' rolling off the sheaves for undetermined reasons, resulting in a loss of power to the rotor system, and the pilot's failure to maintain adequate rotor rpm during the autorotation, resulting in a hard landing.Nov 24, 2007 · N442FA · Substantial damageNTSB NYC08CA032Accident · No injuriesData collectionFinal reportBrand, Richard Bateleur 2000 · West Ossipee, NHThe pilot's failure to maintain aircraft control, while practicing aerobatics.Nov 11, 2007 · N38PC · DestroyedNTSB NYC08LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Hollywood, FLThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident were an inoperative stall warning system and an erroneous airspeed indicator.Nov 10, 2007 · N131AB · Substantial damageNTSB ERA13IA006Incident · No injuriesIncident investigationFinal reportLockheed WP-3D · A1Extensive salt buildup in the inlets of all four engines, which resulted in compressor stalls and tailpipe fires in three of the four engines.Nov 9, 2007 · N42RF · No damageNTSB CHI08CA043Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Loop City, NEThe obstruction clearance not maintained by the pilot during an aerial application of a field and the subsequent hard landing onto the field. Contributing factors were the power line and rough/uneven terrain.Nov 9, 2007 · N9192X · Substantial damageNTSB SEA08FA022Accident · 1 fatalField investigationFinal reportHughes 269C · Baker City, ORThe pilot’s failure to maintain main rotor rpm while maneuvering.Nov 8, 2007 · N381MC · Substantial damageNTSB SEA08LA020Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58+ · Cougar, WAThe pilot's failure to maintain clearance from a nearby tree while performing a hover-climb. Factors include his failure to maintain clearance from his long-line cable, and his likely diverted attention to the entanglement of the cable on the helicopter's…Nov 6, 2007 · N831SD · Substantial damageNTSB NYC08LA024Accident · 2 fatalLimited investigationFinal reportBlondin 601HDS · Farmington, DEThe reason for this occurrence could not be determined.Nov 4, 2007 · N27S · DestroyedNTSB NYC08CA025Accident · Serious injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Windham, NYAn inadvertent encounter with a wind gust while maneuvering.Nov 4, 2007 · N46009 · Substantial damageNTSB CHI08FA033Accident · 1 fatalField investigationFinal reportCessna 172I · Gladwin, MIThe pilot's failure to maintain aircraft control while maneuvering at a low altitude. Contributing to the accident was the pilot's diverted attention while attempting to photograph ground objects.Nov 3, 2007 · N8353L · Substantial damageNTSB NYC08FA023Accident · 1 fatalField investigationFinal reportDaniel R. Lloyd Trish's Ride Home · Greenville, PAThe pilot/builder's improper installation of the electrical system.Nov 2, 2007 · N289DT · DestroyedNTSB MIA08CA011Accident · Serious injuriesData collectionFinal reportSmith Miniplane DSA-1 · Alburgh, VTThe pilot's failure to maintain control of the airplane during aerobatic maneuvers which resulted in a loss of control and in-flight collision with trees.Nov 2, 2007 · N58MB · Substantial damageNTSB CHI08LA031Accident · 1 fatalLimited investigationFinal reportWRB Associates Zodiac 601 XL · La Belle, MOThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of recent flight experience and his total lack of experience in the accident airplane model.Nov 1, 2007 · N634WB · DestroyedNTSB LAX08CA022Accident · No injuriesData collectionFinal reportBagnall Harold E Kitfox Lite 2 · N. Bonneville, WAThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude that resulted in a stall-mush condition and collision with the water.Oct 30, 2007 · N46361 · Substantial damageNTSB ANC08CA011Accident · No injuriesData collectionFinal reportRobinson R-22 · Nikolski, AKThe pilot's inadequate compensation for wind gusts while maneuvering, which resulted in the tail rotor striking an undetermined object, and an emergency descent and landing. Factors contributing to the accident were the wind gusts, and the failure of the tail…Oct 30, 2007 · N185MH · Substantial damageNTSB CHI08GA028Accident · No injuriesFinal reportMcDonnell Douglas Helicopter 369E · Columbus, OHThe inadequate turbine wheel design that led to a turbine airfoil (blade) failure/separation, resulting in the loss of engine power.Oct 29, 2007 · N556CP · Substantial damageNTSB DEN08LA017Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Salida, COThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain.Oct 26, 2007 · N36LB · DestroyedNTSB LAX08CA018Accident · No injuriesData collectionFinal reportBell 206L-1 · Ramona, CAThe pilot's failure to maintain control and correct a descent and a loss of tail rotor effectiveness while maneuvering at a low altitude and reduced airspeed.Oct 25, 2007 · N412KK · Substantial damageNTSB LAX08CA016Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Long Beach, CAThe student pilot's improper execution of low rotor rpm procedures. Contributing to the accident was the flight instructor's inadequate supervision, failure to guard the throttle, and failure to take immediate remedial action.Oct 24, 2007 · N7188S · Substantial damageNTSB DFW08LA020Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Catarina, TXThe loss of control due to the pilot's failure to maintain clearance with trees while hovering . A contributing factor was the low altitude.Oct 24, 2007 · N744RG · Substantial damageNTSB MIA08LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Farmingdale, NYThe failure of both pilots to see and avoid while maneuvering resulting in a midair collision. Contributing to the accident was the local controller's failure to properly identify conflicting traffic.Oct 21, 2007 · N43450 · 2 aircraft · Substantial damageNTSB ANC08LA004Accident · Serious injuriesLimited investigationFinal reportBell 206B · Prudhoe Bay, AKFuel starvation due to the blockage of fuel inlet screens, and improper service procedures by ground personnel.Oct 20, 2007 · N345TV · Substantial damageNTSB DFW08LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · New Iberia, LAThe private pilot's failure to maintain main rotor rpm, which resulted in a hard landing and subsequent rollover. Also causal was the flight instructor's delayed remedial action. A factor was the lack of suitable terrain the forced landing.Oct 18, 2007 · N92HS · Substantial damageNTSB CHI08CA021Accident · Minor injuriesData collectionFinal reportBell 206B-III · Medora, NDThe pilot failed to maintain clearance from the fence while maneuvering at a low altitude, which resuled in the helicopter rolling over and impacting the terrain. A factor associated with the accident was the fence.Oct 18, 2007 · N51698 · Substantial damageNTSB SEA08LA008Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Santaquin, UTA total loss of engine power for undetermined reasons. Factors include rough/uneven vegetation-covered terrain at the location where the pilot executed his emergency forced landing.Oct 11, 2007 · N465US · Substantial damageNTSB DFW08CA010Accident · No injuriesData collectionFinal reportEurocopter EC 130 · Bay St Louis, MSThe pilot's encounter with dynamic rollover as result of his inadequate preflight inspection.Oct 11, 2007 · N997PT · Substantial damageNTSB LAX08MA007Accident · 10 fatalMajor investigationFinal reportCessna 208B · Naches, WAThe pilot's failure to maintain an adequate airspeed to avoid an aerodynamic stall while maneuvering. Contributing to the accident were the pilot's impaired physiological state due to hypoxia, the pilot's inadequate preflight weather evaluation, and his…Oct 8, 2007 · N430A · DestroyedNTSB CHI08CA007Accident · Serious injuriesData collectionFinal reportKrueger Quickie · Antigo, WIThe inadequate preflight planning and preparation by the pilot, the proper climb rate not obtained/maintained by the pilot, and the airspeed not obtained/maintained by the pilot. Contributing factors were the lack of total experience in the type of aircraft…Oct 8, 2007 · N5425D · Substantial damageNTSB NYC08LA005Accident · 1 fatalLimited investigationFinal reportPelt Mad Max II Special · Blacksburg, VAA loss of engine power for undetermined reasons. Contributing to the accident was a lack of suitable terrain for a forced landing.Oct 6, 2007 · N26VT · Substantial damageNTSB CHI08CA001Accident · No injuriesData collectionFinal reportDusenberry 1905 Wright Flyer · Dayton, OHThe altitude not maintained by the pilot for a turning maneuver.Oct 5, 2007 · N3635N · Substantial damageNTSB SEA08FA005Accident · 1 fatalField investigationFinal reportPiper PA-18 · Crowley Ranch, ORThe pilot's failure to maintain adequate clearance from a power transmission line while maneuvering. Contributing to this accident was the pilot's diverted attention, and decision to maneuver at a low altitude.Oct 3, 2007 · N91254 · Substantial damageNTSB MIA08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Walthourville, GAThe non-instrument rated pilot's loss of control at night in marginal night VFR operations due to spatial disorientation. A factor in the accident was the pilot's improper decision to continue the flight.Oct 3, 2007 · N96HA · DestroyedNTSB DFW07IA212Incident · No injuriesIncident investigationFinal reportSchweizer 269D · Houston, TXThe fatigue failure during hover of the drive adapter between the engine and lower pulley drive shaft.Sep 30, 2007 · N8374F · Minor damageNTSB DEN07LA167Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Silver City, NMThe student pilot's failure to maintain control of the helicopter resulting in his settling with power and subsequent impact with terrain. A factor contributing to the accident was the trees.Sep 29, 2007 · N74557 · Substantial damageNTSB ATL07LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Pittsgrove, NJA partial loss of engine power due to low compression for undetermined reasons.Sep 29, 2007 · N8761H · Substantial damageNTSB LAX07TA277Accident · No injuriesFinal reportAir Tractor AT-802A · Big Bear City, CALoss of engine power while maneuvering due to the failure of the number 1 bearing that was caused by electrical discharge damage to the bearing originating from the starter-generator. Contributing to the accident was the operator's failure to follow the…Sep 17, 2007 · N91357 · Substantial damageNTSB DFW07LA199Accident · 1 fatalLimited investigationFinal reportMonocoupe 110SP · Utopia, TXThe pilot's loss of control while performing a low level inverted flight maneuver.Sep 15, 2007 · N110SP · Destroyed