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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR13LA407Accident · No injuriesLimited investigationFinal reportMooney M20J · Lund, NVThe pilot’s failure to monitor the environment, which led to a collision with power lines during climbout. Contributing to the accident was the loss of engine power during low-altitude flight for reasons that could not be determined because postaccident…NTSB CEN13WA548Accident · 3 fatalForeign investigationRobinson R44 · Wygonin, PolandOn September 13, 2013, about 0750 coordinated universal time, a Robinson R44 II helicopter, SP-WNP, impacted terrain near Wygonin, Poland. A postimpact fire ensued. The pilot and two passengers were fatally injured and the helicopter was destroyed. The flight…NTSB CEN13CA550Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Princeton, MNAn in-flight collision with a bald eagle.NTSB WPR13CA425Accident · No injuriesData collectionFinal reportCessna M337B · Spanish Fork, UTThe pilot's failure to properly manage fuel which resulted in fuel exhaustion and subsequent loss of power to the forward engine.NTSB ANC13FA095Accident · 1 fatalField investigationFinal reportZenith 701 · Big Lake, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he could not recover.NTSB WPR13FA400Accident · 1 fatalField investigationFinal reportCantrell LW Challenger II SP · Prineville, ORThe in-flight failure of the left elevator control torque tube. Contributing to the accident was the improper assembly of the elevator control torque tubes.NTSB CEN13TA535Accident · Minor injuriesFinal reportBell 206L-3 · Amistad, NMThe pilot's failure to arrest the descent following an abrupt maneuver to avoid birds, which resulted in an impact with terrain.NTSB WPR13FA399Accident · 1 fatalField investigationFinal reportTyler Ives SD-1 TG · Spanish Fork, UTThe pilot’s failure to maintain airplane control while performing prohibited aerobatic maneuvers and the deployment and separation of the ballistic parachute system from the airframe for reasons that could not be determined due to the severity of impact…NTSB CEN13LA537Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Arlington, MNThe pilot’s failure to maintain control of the helicopter while maneuvering when he removed his hand from the collective control while plugging in his radio connection to his helmet, which resulted in the collective moving to the full-down position.NTSB CEN13LA533Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Atlantic, IAThe pilot’s delay in releasing product to reduce the airplane’s weight and improve its climb performance, which was reduced because of the high density altitude.NTSB ANC13FA093Accident · 1 fatalField investigationFinal reportCessna 170B · Glennallen, AKThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and impact with the ground.NTSB ERA13LA410Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Woodrow, SCA failure of the right rudder pedal arm due to corrosion as a result of inadequate maintenance and inspection of the rudder pedal assembly.NTSB CEN13FA517Accident · 3 fatalField investigationFinal reportRobinson R44 II · Caballo, NMThe pilot’s failure to see and avoid power lines while maneuvering near the ground because dust stirred up by the rotor wash obscured his visibility.NTSB CEN13LA546Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Rothbury, MIThe pilot’s failure to maintain helicopter control while turning to avoid trees during an aborted takeoff in gusting wind conditions.NTSB ANC13FA090Accident · 2 fatalField investigationFinal reportChampion 7ECA · Sutton, AKThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in an aerodynamic stall/spin and collision with terrain. Contributing to the accident was the pilot’s use of marijuana, which likely degraded his psychomotor…NTSB WPR13FA388Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Desert Center, CAThe pilot's abrupt maneuver, which resulted in an accelerated stall and a loss of airplane control at low altitude.NTSB CEN13LA507Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Clayton, NMThe pilot's loss of vertical control after the helicopter encountered a gusty tailwind while maneuvering at a low altitude and near the helicopter's maximum gross weight.NTSB CEN13CA501Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369FF · Reese, MIThe failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.NTSB WPR13FA380Accident · 1 fatalField investigationFinal reportNelson KR-2 · Cataldo, IDThe pilot’s decision to intentionally enter a spin in the airplane, which had unknown spin characteristics due to the engine modification, from which he was unable to recover.NTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…NTSB CEN13LA493Accident · Serious injuriesLimited investigationFinal reportTrick Trikes Storm Trooper · Covert, MIThe student pilot’s loss of control while maneuvering at low altitude over a congested beach area. Contributing to the accident was the pilot’s ostentatious display.NTSB WPR13FA370Accident · 2 fatalField investigationFinal reportChampion 7GCAA · Paradise, CAThe pilot's failure to maintain airplane control during low-altitude maneuvering after encountering an updraft.NTSB WPR13GA374Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Burns, ORThe total loss of engine power during cruise flight due to the separation of one of the 4th-stage turbine wheel blades due to low-cycle fatigue cracking that had progressed to high-cycle fatigue cracking, which ultimately led to the overload failure of the…NTSB CEN13LA484Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Larchwood, IAA complete loss of engine power during an agricultural application flight for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA361Accident · No injuriesLimited investigationFinal reportBryant Frederick M Rans S-12 · Vienna, MDThe student pilot’s inadequate control of the airplane, which resulted in an aerodynamic stall and subsequent impact with water.NTSB CEN13WA492Accident · 1 fatalForeign investigationAerostar International S-55A · Mont-St-Grégoire, CanadaOn August 11, 2013, at 0730 eastern daylight time, an Aerostar International Inc. model S-55A, United States registration N25QL, serial number S55A1-1017, was not damaged when a member of the balloon ground-support team was fatally injured after falling to…NTSB CEN13LA487Accident · No injuriesLimited investigationFinal reportBell 206B · Albers, ILFuel contamination, which resulted in the loss of engine power.NTSB ANC13CA077Accident · No injuriesData collectionFinal reportAviat A-1B · Arctic Village, AKThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.NTSB CEN13LA464Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Santa Teresa, NMThe pilot’s failure to maintain clearance from a tree at the completion of an agricultural spray run. Contributing to the accident was the pilot’s decision to accept a high level of risk to spray a small field bordered by multiple obstacles and his fatigue…NTSB ANC13LA074Accident · No injuriesClass 3 · LimitedFinal reportHughes 500D · Delta Junction, AKA total loss of engine power for undetermined reasons, which necessitated an emergency hovering autorotation, during which the helicopter impacted trees and terrain.NTSB WPR13LA360Accident · No injuriesLimited investigationFinal reportVersteeg Helicycle · Richland, WAThe pilot’s failure to maintain helicycle control during hover due to an inadvertent control input.NTSB CEN13LA461Accident · 2 fatalLimited investigationFinal reportHughes 369D · Ackerly, TXThe pilot’s failure to identify and maintain adequate clearance from a shield wire that was suspended between power transmission line towers.NTSB WPR13LA358Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chualar, CAMaintenance personnel's failure to properly tighten the bolts securing the main driveshaft to the transmission, which resulted in fatigue failure of the bolts and disconnection of the driveshaft during low-altitude flight.NTSB CEN13LA472Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Simmesport, LAThe pilot's failure to maintain proper airplane pitch control while maneuvering at an altitude that was too low for recovery.NTSB CEN13WA578Accident · 2 fatalClass 5 · ForeignCirrus Design SR20 · Poncins, FranceOn July 31, 2013, about 1420 universal coordinated time, a Cirrus SR-20 airplane, F-HCPT, impacted terrain near Poncins, France. The two occupants were fatally injured. This investigation is under the jurisdiction of the government of France. Any further…NTSB ERA13LA344Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Center Point, WVA total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13LA342Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Leonardtown, MDThe improper installation and inspection of the throttle linkage by maintenance personnel, which resulted in the throttle linkage coming loose and a subsequent partial loss of engine power.NTSB ERA13FA340Accident · 1 fatalField investigationFinal reportFolland Gnat T 1 · Georgetown, SCThe loss of airplane control for reasons that could not be determined due to postcrash fire damage. Contributing to the accident was the pilot’s decision to perform an aerobatic maneuver at low altitude, which did not allow sufficient time for him to regain…NTSB CEN13LA444Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Eagle Lake, MNThe pilot's misjudgment of tree heights, which resulted in the collision with a tree.NTSB CEN13LA442Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H/M74A · Streator, ILThe pilot's diverted attention during an agricultural application maneuver, which resulted in the helicopter impacting a corn field.NTSB CEN13LA448Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Capron, ILThe pilot's failure to maintain main rotor speed while maneuvering at low altitude during an agricultural application flight, which resulted in an uncontrolled descent into terrain.NTSB CEN13LA439Accident · 1 fatalLimited investigationFinal reportWoods Rufus III Vans RV-8A · Lucas, KSThe noninstrument-rated pilot's inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and a subsequent loss of airplane control.NTSB WPR13FA343Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Thompson Falls, MTThe pilot's failure to maintain helicopter control while operating in conditions conducive to a loss of tail rotor effectiveness.NTSB DCA13CA172Accident · No injuriesData collectionFinal reportNasa Ames Research Center Sierra · Beaufort Sea, AKcontinued operation into engine intake system icing conditions resulting in a loss of power; due to schedule pressure and an insufficient risk management process.NTSB CEN13TA441Accident · Serious injuriesFinal reportCessna 182S · Tecumseh, OKThe pilot's inadvertent aerodynamic stall at a low altitude, which resulted in a loss of control and impact with terrain.NTSB CEN13LA437Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28A · Danbury, TXThe loss of collective control for reasons that could not be determined due to extensive fire damage.NTSB CEN13LA436Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Champaign, ILThe pilot’s failure to maintain control of the helicopter during an aerial application maneuver.NTSB WPR13GA338Accident · 1 fatalFinal reportBell HH-1H · Mount Charleston, NVThe premature hoisting operation and the inadvertent disengagement of the hoist hook on the rescuer’s harness in dark night conditions. Contributing to the accident was a lack of direct audio communication between the rescuer and the hoist operator.NTSB WPR13LA334Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Las Vegas, NVThe pilot receiving instruction's failure to maintain control of the helicopter in a hover, which resulted in a tail rotor ground strike.NTSB ERA13FA330Accident · 1 fatalField investigationFinal reportCessna 172M · Fredericksburg, VAThe pilot's intentional descent into the ground to commit suicide.