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 WPR16WA143Accident · 1 fatalForeign investigationCessna 150 · New Crown Station, AustraliaOn July 12, 2016 about 1130 local time, a Cessna 150G airplane, Australian registration VH-RXU, collided with terrain near New Crown Station, South Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was…NTSB ERA16LA253Accident · 1 fatalLimited investigationFinal reportBell 429 · Georgetown, DEThe emergency response team's failure to ensure that the system operator was secured to the helicopter, which resulted in his fall during the recurrent rescue hoist training operation.NTSB GAA16CA372Accident · Minor injuriesData collectionFinal reportBell OH 58 · Surprise, AZWhile at a low altitude, the pilot's decision to do an abrupt descending right downwind turn which resulted in flying through his own vortices and an impact with terrain.NTSB ANC16WA043Accident · 1 fatalForeign investigationAir Tractor AT301 · Rocanville, CanadaOn July 8, 2016, about 2359 Coordinated Universal Time, an Air Tractor AT-301 airplane, C-GCYV, impacted terrain while low-level maneuvering near Rocanville, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…NTSB CEN16LA260Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Kennett, MOThe pilot's failure to maintain clearance from power lines while maneuvering during the aerial application flight.NTSB DCA16FA199Accident · 2 fatalClass 2 · FieldFinal reportBell 525 · Italy, TXA severe vibration of the helicopter that led to the crew's inability to maintain sufficient rotor rotation speed (Nr), leading to excessive main rotor blade flapping, subsequent main rotor blade contact with the tail boom, and the resultant in-flight…NTSB ERA16LA244Accident · No injuriesLimited investigationFinal reportCessna 305 · Narragansett, RIA total loss of engine power for reasons that could not be determined during a postaccident examination of the airframe and engine.NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.NTSB WPR16LA134Accident · No injuriesLimited investigationFinal reportBell OH 58A · Brawley, CAThe engine's degraded performance due to excessive wear of the engine bleed valve, which prevented it from closing during the accident flight. Contributing to the accident was the operator's failure to overhaul the bleed valve within the…NTSB WPR16LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Salmon, IDA loss of engine power due to water in the fuel system. Contributing to the accident was an inadequate preflight inspection that failed to eliminate water from the fuel system.NTSB ERA16WA243Accident · 1 fatalForeign investigationCessna A188 · Puerto Lopez, ColombiaOn July 2, 2016, about 1810 coordinated universal time, a Cessna A188, Colombian registration HK1398, operated by Comercializadora de Aviacion Agricola - ECO, was destroyed when it collided with a utility tower near Puerto Lopez, Colombia. The certificated…NTSB ERA16LA242Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Laurel, DEA total loss of engine power due to an encounter with a bird, which collided with the spray pump fan assembly and subsequently sent blade fragments into the engine compartment, damaging the throttle linkage.NTSB WPR16LA136Accident · Serious injuriesLimited investigationFinal reportRans S6 · Bridgeport, CAThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering and his improper decision to maneuver low over a home, which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB GAA16CA358Accident · No injuriesData collectionFinal reportCessna 172 · Bountiful, UTThe pilot's decision to fly into a canyon without sufficient room to reverse course if necessary, which resulted in an emergency landing, loss of directional control, collision with terrain, and a post-crash fire.NTSB CEN16LA247Accident · Serious injuriesLimited investigationFinal reportBeech E 90 · Longmont, COThe pilot's unintentional activation of the green jump light before the airplane was properly configured and slowed for a jump and the jumpers' improper decision to continue with the jump after they recognized that the airplane was at a higher-than-normal…NTSB WPR16FA131Accident · 1 fatalField investigationFinal reportCessna A185F · Coeur d'Alene, IDThe pilot's failure to maintain clearance from trees while maneuvering at low altitude in mountainous terrain.NTSB GAA16CA332Accident · No injuriesData collectionFinal reportThrush S2R · Lazbuddie, TXThe pilot's failure to avoid the metering loop pole during an aerial application.NTSB WPR16LA129Accident · No injuriesClass 3 · LimitedFinal reportBurkes BR-1 · Brigham City, UTA loss of engine power as a result of a failure of the primary and backup ignition system.NTSB GAA16CA339Accident · Minor injuriesData collectionFinal reportHughes 269B · Princeton, CAThe uncertificated pilot's failure to maintain pitch and directional control, which resulted in an impact with terrain and a rollover.NTSB CEN16LA222Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6D · Henley, MOThe pilot’s decision to conduct extended inverted flight, which resulted in a total loss of engine power due to fuel flow disruption. Contributing to the accident was his decision to conduct aerobatic maneuvers at low altitude, which precluded him from…NTSB ERA16LA216Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Chatham, MAThe inadequate maintenance of the lower forward clutch actuator bearing for a prolonged period of time, which resulted in a bearing failure. Contributing to the accident was an erroneous maintenance entry, which resulted in the helicopter being operated…NTSB CEN16WA226Accident · 1 fatalForeign investigationZivko Aeronautics Edge 540 · Kyviškes, LithuaniaNTSB ERA16CA227Accident · No injuriesData collectionFinal reportPezetel SZD 48-1JANTAR STD 2 · Maysville, WVThe glider's encounter with insufficient atmospheric lift conditions where the lift was not sufficient to maintain soaring flight, which resulted in an off-airport landing.NTSB CEN16FA215Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Jonesboro, ARThe pilot's failure to maintain helicopter control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of alcohol and diphenhydramine, which led to his improper decision to fly after drinking alcohol and degraded…NTSB GAA16CA312Accident · No injuriesData collectionFinal reportPiper PA 28 · Gilmer, TXThe student pilot's failure to see and avoid powerlines during landing, and the flight instructor's delayed remediation when the student cut the base to final turn short, resulting in a wire strike and collision with terrain. Contributing to the accident was…NTSB ERA16LA209Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M 18A · Brunswick, NCThe failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…NTSB ERA16CA214Accident · Minor injuriesData collectionFinal reportHanson Robert H Pietenpol Aircamper · Dundee, MSThe pilot’s failure to maintain clearance from a power line.NTSB CEN16LA213Accident · Minor injuriesLimited investigationFinal reportBell 47G 5 · Laureles, TXThe pilot's failure to apply additional engine power when he applied collective input, which led to a loss of rotor speed and the exceedance of the helicopter’s performance capability.NTSB GAA16CA296Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Cahokia/St. Louis, ILThe flight instructor's delayed remedial action and his failure to remain vigilant as the helicopter entered the weathercock stability region, in gusting wind conditions, resulting in loss of tail rotor effectiveness and ground impact.NTSB CEN16FA209Accident · 1 fatalField investigationFinal reportPruss Richard S Kitfox IV · De Smet, SDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a steep turn at a low altitude, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.NTSB WPR16FA120Accident · 1 fatalField investigationFinal reportRockwell S2R · De Smet, IDThe pilot's inadequate visual lookout, which resulted in his failure to maintain clearance from guy wires during an aerial application flight. Contributing to the accident was the pilot's reduced ability to see the guy wires due to sun glare.NTSB CEN16LA219Accident · No injuriesLimited investigationFinal reportFlohr David J R 80 Tiger Moth · Decatur, TXA failure of the electric fuel boost pump, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN16LA208Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Ropesville, TXThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall while maneuvering.NTSB ANC16WA030Accident · 1 fatalForeign investigationWag-Aero Super Tri-Pacer · Williston Lake, CanadaOn June 04, 2016, about 1500 Coordinated Universal Time, a Wag-Aero Super Tri-Pacer airplane, CGSMJ, impacted terrain near Williston Lake, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The…NTSB GAA16CA303Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Nicolaus, CAThe pilot's insufficient clearance from a power line during aerial application operations, which resulted in a power line strike, a forced landing on unsuitable terrain, loss of directional control, and collision with terrain.NTSB GAA16CA266Accident · Minor injuriesData collectionFinal reportCessna 177 · Pine Bluff, ARThe pilot’s failure to maintain adequate airspeed and her exceedance of the airplane’s critical angle-of-attack during a low-altitude turn, which resulted in an aerodynamic stall.NTSB ERA16WA207Accident · 4 fatalForeign investigationPiper PA-28-160 · Corumbaiba, BrazilNTSB ERA16CA197Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCBC · Warner, NHAn encounter with instrument meteorological conditions, which resulted in the pilot's spatial disorientation and a loss of airplane control.NTSB WPR16FA118Accident · 2 fatalField investigationFinal reportMoore Joseph O Varieze · Santa Paula, CAA total loss of engine power due to fatigue failure of the camshaft drive gear teeth.NTSB CEN16LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Cozad, NEAn in-flight loss of control for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB ERA16WA321Accident · 2 fatalForeign investigationVans RV7 · Cordoba, ArgentinaOn May 19, 2016, about 2015 coordinated universal time, an experimental, amateur-built Vans RV-7, Argentine registration LV-X566, operated by a private individual, was destroyed when it impacted terrain during aerobatic maneuvers near Cordoba, Argentina. The…NTSB WPR16FA112Accident · 2 fatalField investigationFinal reportNorth American AT 6 · Mesa, AZThe pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.NTSB CEN16FA188Accident · 1 fatalField investigationFinal reportCessna P210N · Sheridan Lake, COThe pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…NTSB ERA16WA205Accident · No injuriesForeign investigationPiper PA-25-235 · Unai, BrazilOn May 17, 2016, about 0830 local time, a Piper PA-25-235, Brazilian registration PR-TAC, was substantially damaged when it impacted the ground while crop dusting near Unaí, Minas Gerais, Brazil. The Brazilian pilot was fatally injured. The local aerial…NTSB ERA16FA182Accident · 1 fatalField investigationFinal reportGreg Connell Pitts S-2SW · Atlanta, GAThe pilot's failure to maintain proper positioning during performance of an aerobatic maneuver and his subsequent failure to discontinue maneuvering when unable to reestablish proper positioning during a steep descent toward the ground.NTSB CEN16LA181Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502 · West, TXThe pilot’s failure to see and avoid cellular tower guy wires. Contributing to the accident was the pilot’s decision to operate at low altitude.NTSB CEN16LA180Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Lyons Point, LAA total loss of engine power due to debris contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB ANC16CA025Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · McCarthy, AKThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall from which he could not recover.NTSB GAA16CA213Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Troutdale, ORThe flight instructor's failure to monitor outside the helicopter during hover flight, which resulted in a collision with terrain and rollover.NTSB CEN16FA171Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Helicopter 369E · Reedsville, WIThe failure of the power turbine governor's dual-spool bearing due to a lack of lubrication, which resulted in a complete loss of engine power and subsequent impact with terrain.