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 NYC06FA104Accident · 1 fatalField investigationFinal reportCessna 172L · Montgomery Twp, PAAn impact with mountainous terrain for an undetermined reason.Apr 25, 2006 · N7604G · DestroyedNTSB CHI06LA119Accident · 1 fatalLimited investigationFinal reportWoods Skyboy Quick Kit · Huntington, INThe flight's impact with terrain while maneuvering due to undetermined reasons.Apr 24, 2006 · N758RW · Substantial damageNTSB LAX06LA147Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Creston, CAThe pilot's failure to maintain an adequate clearance from obstacles while intentionally flying at a low altitude.Apr 23, 2006 · N96088 · Substantial damageNTSB NYC06FA100Accident · 2 fatalField investigationFinal reportBell 47G-3B-1 · East Hanover Tw, PAThe pilot's improper decision to hover out-of-ground-effect in a tailwind, and his failure to maintain aircraft control. A factor in the accident was the tailwind.Apr 20, 2006 · N22MP · DestroyedNTSB DFW06LA093Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Houston, TXThe failure by maintenance personnel to secure the tail rotor driveshaft cowling after performing maintenance which resulted in a loss of tail rotor control. A contributing factor was the pilot's improper preflight inspection of the tail rotor driveshaft area.Apr 19, 2006 · N8063R · Substantial damageNTSB DFW06CA109Accident · No injuriesData collectionFinal reportCessna 150M · Roanake, TXThe pilot's failure to maintain clearance from an unmarked transmission wire. A contributing factor was the low altitude flight.Apr 19, 2006 · N3419V · Substantial damageNTSB CHI06CA116Accident · No injuriesData collectionFinal reportPalulis John Exec 162F · Kalkaska, MIThe compensation for wind conditions not performed by the pilot during hover. An additional cause was the tailwind.Apr 16, 2006 · N42996 · Substantial damageNTSB DFW06LA103Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Meridian, MSThe pilot's failure to maintain clearance from trees. Contributing factors were the drug impairment and low maneuvering altitude.Apr 15, 2006 · N5003E · DestroyedNTSB CHI06FA109Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Chelsea, MIThe pilot's inadequate preflight inspection of the helicopter that failed to discover water in the fuel, resulting in a loss of engine power while maneuvering, and an in-flight collision with trees and terrain. Factors associated with the accident were…Apr 13, 2006 · N887BC · Substantial damageNTSB DEN06LA061Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Smith Center, KSthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush, and subsequent impact with the field and fence. A factor contributing to the accident was the pilot's inadequate flight planning and preparation.Apr 12, 2006 · N9886P · Substantial damageNTSB DEN06CA060Accident · Minor injuriesData collectionFinal reportAir Tractor AT-602 · Ulysses, KSthe loss of engine power due to fuel starvation. A contributing factor was the impact with a ditch during the forced landing.Apr 11, 2006 · N50669 · Substantial damageNTSB SEA06TA071Accident · No injuriesFinal reportBell 206B · Sprague, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering. Mountainous terrain was a factor.Apr 7, 2006 · N96NW · Substantial damageNTSB CHI06LA105Accident · 1 fatalLimited investigationFinal reportCessna 177 · Blackburn, MOThe pilot's failure to maintain obstacle clearance from the power line during low altitude maneuvering. A factor was the power line.Apr 7, 2006 · N34200 · DestroyedNTSB DFW06FA095Accident · 2 fatalField investigationFinal reportPiper/Stevens PA18A-150 · Hollandale, MSThe pilots failure to maintain control of the airplane. A contributing factor was the pilots impairment.Apr 5, 2006 · N3887P · DestroyedNTSB DFW06LA094Accident · No injuriesLimited investigationFinal reportAviation Specialties Unlimited Challenger II · Coushatta, LAThe loss of control due to premature failure of the elevator's push-pull tube rod-end bearing.Apr 4, 2006 · N260HP · DestroyedNTSB ATL06LA059Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B2B · Cullman, ALThe pilot's failure to maintain a visual look out while maneuvering resulting in an in-flight collision with wires and the ground. A factor in the accident was the pilot's lack of recent experience in rotorcraft operations.Apr 2, 2006 · N2183U · DestroyedNTSB LAX06LA134Accident · No injuriesLimited investigationFinal reportBell UH-1H · Yuba City, CAThe pilot's in-flight loss of control of the helicopter for undetermined reasons. A factor was the trees.Apr 1, 2006 · N710WD · Substantial damageNTSB ATL06LA058Accident · Serious injuriesLimited investigationFinal reportCessna 182T · Double Springs, ALThe pilot's failure to maintain airspeed resulting in a stall. A factor in the accident was the pilot's physical impairment due to dementia and his failure to report the medical condition to the aviation medical examiner..Apr 1, 2006 · N2157V · Substantial damageNTSB ANC06LA029Accident · 1 fatalLimited investigationFinal reportCooper Harmon Rocket ll · McKittrick, CAThe pilot's failure to maintain altitude/clearance while performing intentional low altitude aerobatic flight maneuvers. Factors associated with the accident are the low altitude aerobatic flight maneuvers.Mar 25, 2006 · N96CR · DestroyedNTSB ANC06LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Kailua-Kona, HIThe flight instructor's delayed remedial action while conducting hover practice with a student pilot, which resulted in the helicopter contacting the ground and rolling over. A factor contributing to the accident was an inadvertent dynamic roll over.Mar 23, 2006 · N203DH · Substantial damageNTSB SEA06CA069Accident · No injuriesData collectionFinal reportKearsley Exec 162F · Morgan, UTThe pilot's inadequate in-flight decision to attempt to hover out of ground effect above the kit manufacturers published recommendations. A factor was mountainous terrain.Mar 22, 2006 · N520DK · Substantial damageNTSB ANC06LA038Accident · No injuriesLimited investigationFinal reportMD Helicopters MD 900 · Mesa, AZThe manufacturer's inadequate design clearance of the main rotor blade grip pitch cases, which resulted in damage to the pitch cases when they contacted main rotor perimeter bolts during maneuvering flight.Mar 22, 2006 · N912LH · Substantial damageNTSB DFW06LA088Accident · 1 fatalLimited investigationFinal reportBeech C23 · Mena, ARThe pilot's continued flight into instrument meteorological conditions. Contributing factors were the mountainous terrain and the low ceilings.Mar 21, 2006 · N2160W · Substantial damageNTSB ANC06LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in a loss of control and collision with snow-covered terrain. A factor contributing to the accident was an inadvertent stall.Mar 21, 2006 · N6770B · Substantial damageNTSB CHI06FA094Accident · 4 fatalField investigationFinal reportPiper PA34-200T · Branson, MOThe pilot's failure to maintain sufficient airspeed, which resulted in an inadvertent stall/spin while maneuvering to return to the departure airport for landing after declaring an emergency for unspecified reasons. Additional factors were the low cloud…Mar 20, 2006 · N21RR · DestroyedNTSB SEA06FA067Accident · 1 fatalField investigationFinal reportKaman K-1200 · Dayville, ORThe improper overhaul of the reduction gear box assembly and improper installation of the N1 seal and nut assembly lockcup by maintenance personnel, which resulted in failure of the reduction gear box and a total loss of engine power. A contributing factor…Mar 17, 2006 · N263KA · Substantial damageNTSB CHI06CA093Accident · No injuriesData collectionFinal reportCessna 182G · Lebanon, INFailure by the flightcrew (dual student and flight instructor) to accurately determine the fuel quantity prior to flight, which resulted in fuel exhaustion. An additional cause was the flight instructor's inadequate supervision of the flight due to his…Mar 17, 2006 · N3675U · Substantial damageNTSB DEN06CA048Accident · No injuriesData collectionFinal reportEnstrom 280F · Peetz, COThe pilot's failure to maintain aircraft control while maneuvering resulting in an impact with terrain. Contributing factors were the gusty winds, downdrafts, and box canyon.Mar 15, 2006 · N811Z · Substantial damageNTSB SEA06LA065Accident · Minor injuriesLimited investigationFinal reportKaman K-1200 · Dexter, ORThe pilot's failure to identify the overspeed of the helicopter's main rotors due to a turbine governor malfunction, and his failure to take the appropriate actions described in the Flight Manual's emergency procedures section. Factors include the malfunction…Mar 12, 2006 · N133KA · Substantial damageNTSB ANC06LA025Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ilimana, AKThe pilot's continued flight into adverse weather conditions, and his spatial disorientation and loss of control during a subsequent landing attempt. Factors associated with the accident are flat light and whiteout conditions, fog, and snow-covered terrain.Mar 12, 2006 · N7528Z · Substantial damageNTSB LAX06FA124Accident · 2 fatalField investigationFinal reportAero Vodochody L39 · California City, CAThe flight crew's failure to maintain terrain clearance during an intentionally performed course reversal turn at low altitude.Feb 26, 2006 · N39DF · DestroyedNTSB NYC06LA073Accident · 1 fatalLimited investigationFinal reportCessna 182D · Weyers Cave, VAThe pilot's improper decision to maneuver at a low altitude at night, and his failure to maintain adequate altitude/clearance, which resulted in a collision with power lines. A factor in this accident was the night light conditions.Feb 24, 2006 · N9178X · DestroyedNTSB SEA06CA056Accident · No injuriesData collectionFinal reportCessna 150L · Hillsboro, ORThe student pilot's delayed use of carburetor heat in carburetor icing conditions while maneuvering. Soft terrain was a factor.Feb 23, 2006 · N11568 · Substantial damageNTSB DEN06FA043Accident · 3 fatalField investigationFinal reportCessna 182E · Austin, COthe pilot's failure to maintain clearance from the transmission wire resulting in the airplane's outboard wing portion to be severed, and the subsequent loss of control and ground impact. Factors contributing to the accident were the pilot's impairment from…Feb 23, 2006 · N9298X · DestroyedNTSB NYC06FA071Accident · 2 fatalField investigationFinal reportCessna 172R · Mitchellville, MDThe pilot's improper inflight planning/decision to attempt a landing in weather conditions below landing minimums, and his failure to maintain airspeed while maneuvering. Factors in the accident were the fog and snow.Feb 22, 2006 · N3536C · DestroyedNTSB NYC06LA062Accident · Serious injuriesLimited investigationFinal reportBell 206B · Big Creek, KYThe pilot's inadvertent settling with power during a descent. Contributing to the accident was mechanical turbulence in the lee of an obstruction in windy conditions.Feb 17, 2006 · N36HF · Substantial damageNTSB LAX06CA116Accident · Minor injuriesData collectionFinal reportRobinson R22 · El Monte, CAthe pilot's inadequate compensation for the wind conditions, which resulted in the helicopter dynamically rolling over.Feb 15, 2006 · N23617 · Substantial damageNTSB LAX06LA110Accident · 3 fatalLimited investigationFinal reportCarpenter BJ/Carpenter Glasair II-S FT · Roseville, CAThe pilot's failure to maintain an adequate airspeed while performing low level aerobatics that led to a stall/spin.Feb 12, 2006 · N540FT · DestroyedNTSB LAX06LA103Accident · No injuriesLimited investigationFinal reportHarwood Kenneth Lancair 360A · Thermal, CAA loss of engine power caused by the separation of the number three cylinder due to the improper torque on the hold down nuts.Feb 6, 2006 · N15KH · Substantial damageNTSB CHI06FA077Accident · 3 fatalField investigationFinal reportShort Brothers SD-360-300 · Watertown, WIThe other airplane's flight crew failure to maintain clearance while maneuvering during formation flight. Contributing to the accident was the decision of both flight crews to fly in formation.Feb 5, 2006 · N3735W · 2 aircraft · DestroyedNTSB MIA06FA050Accident · 3 fatalField investigationFinal reportCirrus Design SR-22 · Stuart, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent and impact with the water. Contributing to the accident were a reported instrument failure, pilot disorientation, and instrument meteorological conditions. A factor in…Feb 4, 2006 · N667WP · DestroyedNTSB CHI06LA074Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Chesterfield, INThe pilot's failure to maintain aircraft control after becoming spatially disorientated shortly after departure. Contributing to the accident was the pilot's inadequate preflight weather evaluation, his inadvertent flight into night instrument meteorological…Feb 2, 2006 · N593AE · DestroyedNTSB DFW06CA063Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gail, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/mush.Jan 30, 2006 · N744 · Substantial damageNTSB CHI06LA073Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Pontiac, MIThe excessive bank angle executed by the flight crew and their failure to maintain airspeed during the turn, which led to the inadvertent stall and subsequent impact with the ground. A factor was the low altitude.Jan 27, 2006 · N55CW · DestroyedNTSB SEA06FA147Accident · 1 fatalField investigationFinal reportCessna 421C · Carson, WAThe pilot's failure to maintain aircraft control while maneuvering. Icing conditions, clouds and the pilot's continued flight into known adverse weather were factors.Jan 25, 2006 · N69KM · DestroyedNTSB SEA06CA043Accident · No injuriesData collectionFinal reportAviat A1-A · Pine, IDThe pilot's failure to maintain clearance from terrain while maneuvering. Snow covered terrain and flat light conditions are contributing factors.Jan 14, 2006 · N456AM · Substantial damageNTSB DFW06CA055Accident · No injuriesData collectionFinal reportBell 47-B3 · Dennison, TXThe in-flight separation of the stabilizer bar tube.Jan 13, 2006 · N1575 · Substantial damageNTSB DFW06TA054Accident · Serious injuriesFinal reportAerospatiale AS350-B2 · Eagle Pass, TXThe pilot's failure to maintain clearance from the unmarked transmission lines. A factor was the pilot's diverted attention while monitoring ground activity.Jan 12, 2006 · N840BP · Substantial damageNTSB LAX06FA087Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Lancaster, CAThe student pilot's failure to maintain an adequate airspeed while maneuvering, and, the flight instructor's inadequate supervision of the flight. A factor in the accident was the strong tailwind encountered as the airplane turned from an upwind to a downwind…Jan 9, 2006 · N526CD · DestroyedNTSB 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 damage