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 ATL07CA076Accident · No injuriesData collectionFinal reportBell 206-B · Sevierville, TNThe pilot's improper use of the flight controls while at a hover that resulted in the tail colliding with the ground, a subsequent hard landing, and collapse of the skids.Apr 22, 2007 · N219SH · Substantial damageNTSB SEA07CA103Accident · Minor injuriesData collectionFinal reportCessna 152 · Oak Glen, CAThe flight instructors failure to maintain clearance from trees while maneuvering. Contributing factors were the downdraft weather condition, and the tree.Apr 17, 2007 · N49902 · DestroyedNTSB LAX07FA123Accident · 2 fatalField investigationFinal reportCessna 172N · Page, AZThe pilot's failure to maintain an adequate terrain clearance altitude, and, his failure to maintain an adequate airspeed while maneuvering to reverse course in a box canyon. Contributing to the accident were the rising terrain and the box canyon.Apr 9, 2007 · N6267D · DestroyedNTSB CHI07LA098Accident · 2 fatalLimited investigationFinal reportWakewood Lancair O-200 · Scottsbluff, NEThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident were the low altitude at which the airplane was operating and the gusty wind conditions.Apr 9, 2007 · N351DW · DestroyedNTSB SEA07LA090Accident · 1 fatalLimited investigationFinal reportBurton Fly Baby · Arlington, AZThe pilot exceeding the design stress limits of the aircraft while maneuvering in intentional aerobatics.Apr 4, 2007 · N101LX · Substantial damageNTSB SEA07LA088Accident · No injuriesLimited investigationFinal reportJohnson Zodiac CH601 · Arlington, WAThe pilot's failure to apply carburetor heat when the engine lost power while being operated at a reduced power setting. Factors include carburetor icing condition, the pilot's failure to acquire the temperature/dew point information, and soft terrain in the…Apr 1, 2007 · N601J · Substantial damageNTSB LAX07LA118Accident · 2 fatalLimited investigationFinal reportRyan Navion A · Los Banos, CAthe pilot's intentional performance of aerobatic maneuvers that exceeded the design stress limits of the airplane structure. Also causal was the pilot's impairment due to the effects of alcohol consumption. Contributory was the pilot's impairment due to the…Mar 30, 2007 · N4369K · DestroyedNTSB SEA07CA084Accident · No injuriesData collectionFinal reportBoykin Rotorway Exec 162F · Camarillo, CAThe pilot's failure to maintain main rotor RPM resulting in an uncontrolled descent to a hard landing. A contributing factor was his lack of experience in make and model of aircraft.Mar 25, 2007 · N496SB · Substantial damageNTSB NYC07LA086Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Wawayanda, NYA failure of the crankshaft idler gear, which resulted in a total loss of engine power while maneuvering.Mar 25, 2007 · N53874 · Substantial damageNTSB DFW07LA088Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Laredo, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.Mar 25, 2007 · N854WT · Substantial damageNTSB DFW07CA085Accident · Minor injuriesData collectionFinal reportCessna 150 · Brownfield, TXThe pilot's failure to maintain aircraft control while maneuvering. A contributing factor was the gusty wind conditions.Mar 18, 2007 · N4242U · Substantial damageNTSB LAX07LA113Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Lincoln City, ORIn-flight collision with water for undetermined reasons.Mar 17, 2007 · N75194 · DestroyedNTSB MIA07FA060Accident · 1 fatalField investigationFinal reportAero Vodochody Aero. Works L-39C · Titusville, FLThe pilot’s failure to ensure sufficient altitude while maneuvering in close proximity to the ground during an airshow, which resulted in an impact with terrain.Mar 16, 2007 · N63925 · DestroyedNTSB MIA07CA107Accident · No injuriesData collectionFinal reportRobinson R-44-II · Isla Grande, PRThe pilot's inadvertent encounter with a loss of tail rotor effectiveness which resulted in damage to the helicopter during the subsequent hard landing.Mar 16, 2007 · N72PK · Substantial damageNTSB LAX07CA107Accident · No injuriesData collectionFinal reportPietsch IT · Douglas, AZa loss of directional control during landing due to separation of the rudder cable. A factor was the soft dirt terrain.Mar 14, 2007 · N214GP · Substantial damageNTSB DEN07FA071Accident · 1 fatalField investigationFinal reportBeech A23A · Holman, NMThe pilot's failure to maintain a safe altitude and clearance, and his improper inflight planning/decision to postpone initiating a climbing turn to avoid obstructions.Mar 13, 2007 · N4761J · DestroyedNTSB NYC07LA077Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Plymouth, MAThe student pilot's failure to maintain control of the helicopter during a hover, and the flight instructor's delayed remedial action.Mar 12, 2007 · N2074K · Substantial damageNTSB NYC07MA073Accident · 4 fatalMajor investigationFinal reportAerospatiale AS350BA · Princeville, HIThe failure of maintenance personnel to properly tighten (torque) the flight control servo lower attachment clevis, and reinstall a functioning lock washer, which resulted in a flight control disconnect and a complete loss of helicopter control. Contributing…Mar 9, 2007 · N354NT · Substantial damageNTSB SEA07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Crescent Lake, ORThe loss of a significant amount of engine power for undetermined reasons. Factors include no suitable place in which to make an emergency landing, and densely forested, mountainous/hilly terrain.Mar 6, 2007 · N5547F · Substantial damageNTSB LAX07LA106Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monmouth, ORThe failure of the main drive belt tension assembly shaft due to high cycle, low stress fatigue.Mar 6, 2007 · N785M · Substantial damageNTSB DEN07IA066Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries DA-20-C1 · Pueblo, COThe failure of the horizontal stabilizer forward bracket bolts due to insufficent preload during factory installation.Mar 6, 2007 · N921DA · No damageNTSB CHI07FA079Accident · 2 fatalField investigationFinal reportCessna 150M · Bedford, INSuicide.Mar 5, 2007 · N66513 · Substantial damageNTSB ANC07LA022Accident · No injuriesLimited investigationFinal reportHughes 369D · Gustavus, AKThe inadequate clearance from a tranquilized moose while hovering in ground effect, and the operator's inadequate procedures for such operations, which resulted in an in-flight collision with the moose. Factors associated with the accident were the moose, a…Mar 3, 2007 · N5134V · Substantial damageNTSB MIA07LA058Accident · 2 fatalLimited investigationFinal reportUnknown Kolb Mark III · Panama City, FLThe failure of the pilot to maintain airspeed resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with terrain. A factor in the accident was the loss of engine power for undetermined reasons.Feb 27, 2007 · UNREG · Substantial damageNTSB LAX07CA041Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Tulare, CAThe student pilot's improper use of the collective and cyclic control, which induced a dynamic rollover. Also causal was the certificated flight instructor's inadequate supervision and delayed remedial action.Feb 27, 2007 · N199K · Substantial damageNTSB CHI07CA077Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Melbourne, FLThe flight instructor's inadequate remedial action following a loss of control in flight. A factor to the accident is that the dual student did not maintain directional control of the helicopter while manuevering, which subsequently caused the instructor to…Feb 26, 2007 · N8347V · Substantial damageNTSB ATL07CA046Accident · Serious injuriesData collectionFinal reportRobinson R-44 · Covington, GAThe student pilot's failure to maintain control of the helicopter during liftoff, which resulted in an in-flight collision with the ground.Feb 26, 2007 · N448BP · Substantial damageNTSB SEA07CA064Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Glen Canyon Nat, UTThe pilot's intentional flight over water at low altitude and his subsequent failure to maintain adequate clearance from the water. A contributing factor was the glassy surface condition of the lake.Feb 24, 2007 · N224MT · Substantial damageNTSB DFW07CA081Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Arcola, MSThe pilot's failure to maintain clearance from trees while maneuvering during aerial application.Feb 23, 2007 · N8063K · Substantial damageNTSB DFW07LA076Accident · No injuriesLimited investigationFinal reportAyres S2R-T41 · Turrell, ARThe loss of engine power due to a separated fuel line. A contributing factor was the lack of suitable terrain for the forced landing.Feb 22, 2007 · N678JP · Substantial damageNTSB DFW07CA066Accident · No injuriesData collectionFinal reportBell ARH-70 Exp. · Mansfield, TXFuel starvation due to blockage in a fuel system check valve which was the result of the improper assembly of fuel boost pump by company maintenance personnel.Feb 21, 2007 · N445HR · Substantial damageNTSB DFW07FA073Accident · 1 fatalField investigationFinal reportCessna 210K · Lago Vista, TXThe pilot's failure to maintain clearance from terrain. A factor was the pilot's diverted attention with a reported autopilot malfunction.Feb 19, 2007 · N1162M · DestroyedNTSB LAX07CA087Accident · 1 fatalData collectionFinal reportWampole Mini-Max · Adelanto, CAa loss of control for undetermined reasons.Feb 10, 2007 · UNREG · Substantial damageNTSB LAX07LA079Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Palos Verdes, CAthe failure of both pilots to maintain adequate visual lookout and clearance from each other while maneuvering in close proximity.Feb 3, 2007 · N30140 · 2 aircraft · Substantial damageNTSB ATL07CA037Accident · No injuriesData collectionFinal reportEurocopter France EC120B · Griffin, GAThe first pilot's failure to maintain directional control of the helicopter during hover in ground effect, and the second pilot's (a certificated flight instructor), delayed remedial action, which resulted in an in-flight collision with the ground. A factor…Feb 3, 2007 · N491AE · Substantial damageNTSB ANC07LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Glennallen, AKThe pilot's failure to maintain adequate airspeed to preclude a stall while maneuvering, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors contributing to the accident were variable wind conditions, and an inadvertent…Feb 1, 2007 · N3233M · Substantial damageNTSB ANC07CA017Accident · No injuriesData collectionFinal reportPiper PA-46-500TP · Vero Beach, FLAn in-flight collision with a bird while maneuvering, which resulted in structural damage to the left wing of the airplane.Jan 31, 2007 · N760C · Substantial damageNTSB LAX07CA072Accident · Minor injuriesData collectionFinal reportBell Helicopter 206BIII · Springville, CAThe pilot's failure to maintain terrain/obstacle clearance while maneuvering. Factors were the mountainous terrain, trees, and low-altitude flight maneuvers.Jan 19, 2007 · N185BC · Substantial damageNTSB DEN07CA052Accident · No injuriesData collectionFinal reportCessna 120 · La Salle, COThe pilot's failure to maintain clearance from the ground. Contributing factors included the pilot's intentional low pass and his misjudging his altitude.Jan 17, 2007 · N1670V · Substantial damageNTSB CHI07CA058Accident · No injuriesData collectionFinal reportLearjet 35A · Columbus, OHThe pilot's failure to maintain aircraft control during an inflight maneuver which resulted in the design stress limits of the airplane being exceeded. A factor was the excessive airspeed encountered during recovery.Jan 10, 2007 · N40AN · Substantial damageNTSB SEA07LA043Accident · No injuriesLimited investigationFinal reportBell 206B · Boise, IDThe pilot's failure to maintain clearance from tall brush during a low-hover pedal turn. A factor was the six foot-tall brush located adjacent to the area where the pilot was operating.Jan 7, 2007 · N1882 · Substantial damageNTSB DFW07CA053Accident · No injuriesData collectionFinal reportEnstrom F28A · Bruceville, TXThe instructor pilot's improper demonstration of an autorotation, resulting in the helicopter's main rotor blades impacting the ground.Jan 5, 2007 · N764PC · Substantial damageNTSB DEN07FA045Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Manzanola, COthe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing factors were the pilot's inadequate preflight planning, self-induced…Jan 5, 2007 · N8231D · DestroyedNTSB SEA07LA041Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Lyman, WAThe pilot's intentional flight into adverse weather conditions, which resulted in a loss of engine power during hover due to snow and ice ingestion. Factors associated with the accident are the pilot's delayed remedial actions, and snow and icing conditions.Jan 4, 2007 · N1088G · Substantial damageNTSB DFW07FA049Accident · 3 fatalField investigationFinal reportCessna 172H · Armstrong, TXThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the dark night conditions, the clouds. low ceilings, and the pilot's limited night and instrument experience.Jan 3, 2007 · N3940R · DestroyedNTSB CHI07FA052Accident · 1 fatalField investigationFinal reportBeech 58 · Washington, INThe pilot's failure to maintain clearance from trees and terrain while attempting to return to the departure airport for undetermined reasons after takeoff. The intervening tree line was a contributing factor.Jan 2, 2007 · N678DC · DestroyedNTSB LAX07LA067Accident · 1 fatalLimited investigationFinal reportCessna 150J · San Diego, CAThe pilot's improper use of the throttle and failure to maintain an adequate airspeed that resulted in a stall/spin.Dec 31, 2006 · N50814 · Substantial damageNTSB SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.Dec 30, 2006 · N93TT · Substantial damageNTSB DFW07CA050Accident · No injuriesData collectionFinal reportHughes 269C · Mineral Wells, TXThe loss of control as result of loss of tail rotor effectiveness.Dec 30, 2006 · N9655F · Substantial damageNTSB CHI07FA048Accident · 2 fatalField investigationFinal reportMooney M-20F · Mt. Gilead, OHBoth the pilot-in-command/aircraft owner and the flight instructor failed to recover from the stall and the flight instructor's inadequate supervision of the flight. Contributing to the accident was the failure to maintain stall speed which resulted in the…Dec 27, 2006 · N9596M · Substantial damage