OpenAirDocs.org

NTSB investigations

18,849 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 WPR12FA282Accident · 4 fatalField investigationFinal reportAerospatiale AS350B · Camp Verde, AZThe pilot's improper decision to fly at a low altitude through a river canyon, contrary to voluntary guidance within the Special Conservation Area, which led to collision with a cable. Contributing to the pilot’s decision were his cognitive and psychomotor…Jun 30, 2012 · N729DP · Substantial damageNTSB CEN12CA403Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Minden, NEThe pilot’s failure to maintain clearance from the wake turbulence from a previous pass.Jun 28, 2012 · N3299Z · Substantial damageNTSB WPR12LA279Accident · Serious injuriesLimited investigationFinal reportBell UH-1F · Concrete, WAArcing of an energized electrical power line to the external long line and the conduct of electrical energy to ground personnel.Jun 26, 2012 · N4582D · No damageNTSB CEN12CA402Accident · No injuriesData collectionFinal reportSchweizer TH55A/269A · Grinnell, IAThe pilot’s inadequate compensation for the wind during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.Jun 26, 2012 · N488MC · Substantial damageNTSB WPR12LA292Accident · No injuriesLimited investigationFinal reportSikorsky S-58B · Brewster, WAAn in-flight fire during hover for reasons that could not be determined due to the extent of fire damage that subsequently consumed the structure.Jun 24, 2012 · N9043N · Substantial damageNTSB ERA12LA411Accident · 1 fatalLimited investigationFinal reportUniversal Stinson 108 · Portland, MEA fatigue failure of the No. 3 piston skirt, which resulted in a total loss of engine power and the subsequent ditching in the ocean.Jun 24, 2012 · N39443 · Substantial damageNTSB ANC12CA057Accident · No injuriesData collectionFinal reportChampion 7GCB · Tyonek, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering.Jun 23, 2012 · N466RV · Substantial damageNTSB WPR12CA271Accident · Serious injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Okanogan, WAThe pilot's failure to maintain clearance from power lines while maneuvering.Jun 20, 2012 · N6861K · Substantial damageNTSB WPR12LA265Accident · Serious injuriesLimited investigationFinal reportRoetman Ryland K JR Eagle · Rexburg, IDA loss of engine oil pressure, which led to the subsequent uncommanded loss of thrust and decrease in the propeller rpm during a low-level aerobatic maneuver.Jun 16, 2012 · N106BD · Substantial damageNTSB ERA12LA400Accident · No injuriesLimited investigationFinal reportBarney Oldfield Baby Lakes · Anderson, SCA total loss of engine power as a result of an inadequate amount of lubricating oil in the engine. Contributing to the accident was the pilot's improper preflight inspection.Jun 16, 2012 · N10XB · Substantial damageNTSB WPR12LA259Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · East Wenatchee, WAThe pilot’s failure to adequately monitor the environment and maintain clearance from the power lines while maneuvering at low altitude.Jun 12, 2012 · N282MC · Substantial damageNTSB CEN12LA349Accident · 1 fatalLimited investigationFinal reportFlower Roger P J D · Spring Valley, OHThe in-flight failure of the left wing spar, which resulted in the in-flight separation of the left wing.Jun 9, 2012 · N9010T · Substantial damageNTSB CEN12CA360Accident · No injuriesData collectionFinal reportBirchler Boyd Eagle 540 · Kokomo, INThe pilot's failure to maintain adequate clearance from the trees during a low-level aerobatic maneuver.Jun 9, 2012 · N34BJ · Substantial damageNTSB ERA12LA386Accident · 1 fatalLimited investigationFinal reportBowen Christopher W Dogbee · Wrens, GAThe pilot’s loss of control during a low-altitude maneuver for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision…Jun 8, 2012 · N1481 · Substantial damageNTSB WPR12LA250Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Sparks, NVThe failure of both pilots to see and avoid each other, which resulted in a midair collision.Jun 7, 2012 · N943SB · 2 aircraft · Substantial damageNTSB CEN12CA347Accident · Serious injuriesData collectionFinal reportCameron Balloons Z-90 · Sellersburg, INThe balloon pilot’s failure to maintain clearance from power lines.Jun 7, 2012 · N401DJ · Minor damageNTSB CEN12LA340Accident · 1 fatalLimited investigationFinal reportQuicksilver Sport II · Manchester, IAAn inadvertent aerodynamic stall while maneuvering at a low altitude.Jun 5, 2012 · N4396H · Substantial damageNTSB WPR12LA244Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Pasco, WAThe pilot's failure to maintain the helicopter's rotor rpm while maneuvering at a low altitude over a fruit orchard.Jun 4, 2012 · N93467 · Substantial damageNTSB CEN12LA336Accident · 1 fatalLimited investigationFinal reportBellanca 8GCBC · Zahl, NDThe non-certificated pilot's improper preflight planning, which resulted in fuel exhaustion, and his failure to maintain airplane control after a total loss of engine power.Jun 4, 2012 · N88095 · Substantial damageNTSB WPR12GA243Accident · 2 fatalFinal reportLockheed P2V-7 · Modena, UTThe flight crew's misjudgment of terrain clearance while maneuvering for an aerial application run, which resulted in controlled flight into terrain. Contributing to the accident was the flight crew's failure to follow the lead airplane's track and to…Jun 3, 2012 · N14447 · Substantial damageNTSB ERA12LA373Accident · Minor injuriesLimited investigationFinal reportFaltin John R Rotorway Exec 162F · Smoketown, PAA loss of control during a post-maintenance test flight due to improper tracking of the helicopter’s main rotor blades by the pilot/aircraft builder.May 31, 2012 · N8707E · Substantial damageNTSB WPR12CA236Accident · No injuriesData collectionFinal reportBell 206B · Burbank, WAThe failure of maintenance personnel to properly torque an air tube fitting, which resulted in a total loss of engine power.May 30, 2012 · N106TV · Substantial damageNTSB WPR12LA247Accident · No injuriesLimited investigationFinal reportPiper PA28R · Peoria, AZA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 29, 2012 · N963WW · Substantial damageNTSB WPR12FA235Accident · 4 fatalField investigationFinal reportCirrus SR20 · Duck Creek Village, UTThe pilot's failure to maintain sufficient airspeed and airplane control while maneuvering a heavily loaded airplane over high mountainous terrain in a high density altitude environment. Contributing to the accident was the pilot’s lack of experience…May 29, 2012 · N187PG · Substantial damageNTSB CEN12LA330Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-27 · Ionia, MIThe pilot's failure to maintain a proper airspeed in gusting wind conditions, which resulted in an inadvertent stall while maneuvering at an altitude that did not provide a margin for recovery.May 29, 2012 · N127PC · Substantial damageNTSB ERA12RA367Accident · 2 fatalForeign investigationBeech V35B · Sumerduck, VAOn May 28, 2012, about 1604 eastern daylight time, a Beech V35B, N6658R, and a Piper PA-28-140, N23SC, collided in flight in the vicinity of Sumerduck, Virginia. The Beech was destroyed, and the pilot and flight instructor were fatally injured; the Piper was…May 28, 2012 · N6658R · 2 aircraft · DestroyedNTSB CEN12LA324Accident · 1 fatalLimited investigationFinal reportNorth American T-6G · Perry, MIThe pilot’s failure to maintain control while maneuvering at low altitude after takeoff, resulting in a collision with a barn.May 28, 2012 · N3753G · Substantial damageNTSB WPR12LA233Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Wilton, CAThe failure of the hopper gate mechanism and subsequent sulfur fire during a low-level maneuver.May 27, 2012 · N8380 · Substantial damageNTSB WPR12LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Silver City, IDThe pilot‘s failure to maintain airspeed while maneuvering in mountainous terrain with reduced visibility, which resulted in an aerodynamic stall.May 27, 2012 · N4640L · Substantial damageNTSB CEN12IA385Incident · No injuriesIncident investigationFinal reportCessna 182 · Fowlerville, MIThe airplane’s encounter with clear air turbulence, which caused a momentary loss of control and minor damage to the airplane.May 27, 2012 · N287TC · Minor damageNTSB WPR12LA227Accident · No injuriesLimited investigationFinal reportCessna 150F · San Diego, CAA total loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 26, 2012 · N7093F · Substantial damageNTSB ERA12LA365Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dansville, NYA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.May 26, 2012 · N9629G · Substantial damageNTSB ERA12LA364Accident · 1 fatalLimited investigationFinal reportMoyes B/Bailey B Dragonfly · Trenton, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation and it could not be determined whether the…May 26, 2012 · N56FP · Substantial damageNTSB WPR12FA237Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Lakeview, ORThe pilot’s decision to take off in known adverse weather conditions and his subsequent failure to maintain sufficient airspeed while maneuvering in mountainous terrain and an area of low ceilings, snow, and fog, which resulted in a loss of airplane control.May 25, 2012 · N26837 · Substantial damageNTSB CEN12LA318Accident · Serious injuriesLimited investigationFinal reportAeros Ltd/Skyranger Skyranger II · Saline, MIThe pilot did not maintain proper control of the airplane while maneuvering at low altitude, which resulted in an aerodynamic stall.May 25, 2012 · N192RR · Substantial damageNTSB CEN12CA319Accident · Serious injuriesData collectionFinal reportHughes 369HS · Delavan, MNThe pilot’s failure to maintain clearance with power lines during an aerial application flight.May 25, 2012 · N11ZX · Substantial damageNTSB WPR12CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Royal City, WAThe pilot’s failure to maintain adequate clearance from an object during an aerial application, which resulted in damage to the landing gear and led to the airplane ground looping during the subsequent landing.May 24, 2012 · N8468V · Substantial damageNTSB WPR12LA228Accident · No injuriesLimited investigationFinal reportCessna 150L · Tulare, CAA partial loss of engine power, which was likely the result of carburetor icing.May 23, 2012 · N11428 · Substantial damageNTSB CEN12FA312Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Sedgwick, ARThe inability of both pilots to see and avoid the other airplane, which resulted in a midair collision. Contributing to the accident was the distraction of the Air Tractor pilot by a cellular telephone conversation during the flight.May 23, 2012 · N4126T · 2 aircraft · Substantial damageNTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.May 23, 2012 · N30951 · Substantial damageNTSB WPR12IA248Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Seattle, WAFailure of maintenance personnel to ensure that the tail rotor pitch change link bolt was properly secured, which resulted in an in-flight separation of the bolt and subsequent vibration.May 22, 2012 · N105TV · Minor damageNTSB WPR12WA446Accident · 1 fatalForeign investigationHughes 369D · Lake Sumner, New Zealand, New ZealandOn May 21, 2012, at 0200 universal coordinated time, a Hughes 369D, ZK-HXZ, registered to and operated by Way to Go Heliservices, crashed into Lake Sumner, New Zealand, under unknown circumstances. The helicopter sank in 125 meters of water and was not…May 21, 2012 · ZK-HXZ · Substantial damageNTSB WPR12LA220Accident · 1 fatalLimited investigationFinal reportGrumman G 164D · Nicolaus, CAThe pilot’s failure to maintain airplane control during a low-altitude maneuver.May 21, 2012 · N8267K · Substantial damageNTSB ERA12FA345Accident · 1 fatalField investigationFinal reportShepard Jimmy D JR Pitts S1D · Port Richey, FLThe pilot's decision to conduct aerobatic flight at a low altitude, which resulted in a collision with the water.May 21, 2012 · N360MW · Substantial damageNTSB WPR12LA218Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-5M · Kingston, NVThe pilot's failure to maintain control of the glider while maneuvering in flight.May 19, 2012 · N186P · Substantial damageNTSB ERA12CA344Accident · No injuriesData collectionFinal reportCessna 170B · Winterville, NCThe pilot's excessive bank at low altitude, which resulted in an aerodynamic stall.May 19, 2012 · N170ED · Substantial damageNTSB ERA12CA352Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2CT · Duncansville, PAThe glider’s encounter with atmospheric lift conditions not sufficient to clear terrain, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to continue turning toward a ridgeline.May 18, 2012 · N900BM · Substantial damageNTSB CEN12LA306Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Marion, ARThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.May 15, 2012 · N43635 · Substantial damageNTSB CEN12LA299Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Shawnee, OKThe improper installation of the mixture cable by maintenance personnel, which allowed the mixture cable to entangle with the landing gear during gear extension and led to the subsequent loss of engine power.May 14, 2012 · N7171P · Substantial damageNTSB ERA12WA354Accident · 2 fatalForeign investigationCessna T210M · Manabi Province, EcuadorOn May 13, 2012, about 2030 local time (May 14, 2012, about 0030 coordinated universal time), a Cessna T210M, Mexican registration XB-MPL, was substantially damaged when it impacted terrain in Manabí Province, Ecuador. The pilot and passenger, both of unknown…May 13, 2012 · XB-MPL · Substantial damage