NTSB investigations
163 cases where the sequence of events included Dynamic rollover.
Cases, newest first
Query with SQL
duckdb -csv -c "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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '231' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '231' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 CEN21LA135Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58 · Greensburg, LAThe pilot’s failure to maintain lateral control and terrain clearance while hovering, which resulted in a dynamic rollover.NTSB CEN21LA124Accident · No injuriesClass 4 · LimitedFinal reportHiller UH12C · Lafayette, INThe pilot’s failure to maintain control of the helicopter shortly after liftoff into a hover, which resulted in a dynamic rollover when the left landing skid contacted the ground.NTSB ERA21LA046Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Austell, GAThe flight instructor’s failure to maintain adequate clearance above the gravel surface in a hover, which resulted in a dynamic rollover.NTSB CEN21LA081Accident · No injuriesClass 4 · LimitedFinal reportSchweizer 269C · Rhame, NDThe pilot landed the helicopter on unsuitable terrain, which resulted in a rollover.NTSB CEN21LA021Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Washington, WIThe pilot’s failure to maintain lateral control during a hover and improper recovery action after the helicopter contacted the ground, which resulted in a dynamic rollover sequence and an impact with terrain.NTSB CEN20CA180Accident · Minor injuriesClass 4 · Data collectionFinal reportRotorway Exec · Rochester, INThe pilot's failure to maintain control of the helicopter during lift off. Contributing to the accident was the pilot's lack of recent experience flying a helicopter.NTSB CEN20CA090Accident · No injuriesData collectionFinal reportRobinson R22 · Cotulla, TXThe pilot's failure to remove the right skid trailer tie-down before attempting to take off, which resulted in a dynamic roll-over.NTSB WPR20CA059Accident · No injuriesData collectionFinal reportSud SE 3130 Alouette II · Mokelumne Hills, CAThe pilot's failure to maintain adequate clearance from terrain during a hover-taxi, which resulted in the helicopter's skid contacting grass and a subsequent dynamic roll-over.NTSB CEN20LA037Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Beeville, TXThe solo student pilot's improper cyclic input during takeoff, which resulted in dynamic rollover.NTSB GAA20CA060Accident · No injuriesData collectionFinal reportRobinson R22 · Smoketown, PAThe student pilot's improper cyclic input while hovering and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.NTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.NTSB GAA20CA035Accident · No injuriesData collectionFinal reportRobinson R22 · Overton, NVThe pilot’s failure to maintain a proper approach and the flight instructor's subsequent failure to maintain an adequate climb rate during an attempted go-around in gusting tailwind conditions, which resulted in a hard landing and dynamic rollover.NTSB ERA20LA004Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Fort Meade, FLThe pilot's failure to maintain control of the helicopter, which resulted in a dynamic rollover and impact with terrain.NTSB GAA20CA002Accident · No injuriesData collectionFinal reportRobinson R44 · Carlsbad, CAThe student pilot's incorrect collective and cyclic applications during landing and the flight instructor's delayed remedial action, which resulted in a roll-over.NTSB GAA19CA567Accident · No injuriesData collectionFinal reportGeorge W. Felix Mosquito · Kershaw, SCThe pilot's improper cyclic input during takeoff, which resulted in a loss of helicopter control, the skid impacting the ground, and a subsequent dynamic rollover.NTSB GAA19CA519Accident · No injuriesData collectionFinal reportBell 206 · San Diego, CAThe pilot's failure to maintain yaw and pitch control while repositioning the helicopter, which resulted in dynamic rollover.NTSB CEN19LA250Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Lyons, NEThe engine's low cylinder compression, which resulted in low rotor rpm and a subsequent dynamic rollover following landing on soft terrain.NTSB GAA19CA347Accident · Minor injuriesData collectionFinal reportRobinson R22 · San Antonio, TXThe pilot receiving instruction's improper cyclic control input during landing, which resulted in a dynamic rollover, and the flight instructor's improper decision to practice landings in tall grass in gusting wind conditions.NTSB GAA19CA279Accident · No injuriesData collectionFinal reportGuimbal Cabri · St. Louis, ILThe flight instructor's improper emergency procedure instruction to the student pilot, which resulted in the student improperly using the throttle to correct the loss of yaw control, which resulted in ground impact and a dynamic rollover.NTSB ERA19CA147Accident · Minor injuriesData collectionFinal reportGaskins Safari 400 · Gallatin, TNThe pilot/owner's improper decision to make a right turn instead of terminating the approach to a hover and his subsequent loss of helicopter control while attempting to land on sloping terrain, which resulted in a roll-over.NTSB GAA19CA195Accident · No injuriesData collectionFinal reportRobinson R44 · Taunton, MAThe pilot's improper decision to land with a gusting left quartering tailwind and his subsequent attempt to reposition the helicopter and take off, which resulted in a dynamic rollover.NTSB CEN19LA068Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 · Ponca City, OKThe pilot's failure to maintain altitude during the hover operation while his view was obstructed due to the fogged-over windshield.NTSB ERA19FA035Accident · 2 fatalField investigationFinal reportAerospatiale AS 355F2 · Beekmantown, NYThe pilot's failure to keep the helicopter clear of a utility pole while hovering with a tailwind, which resulted in a dynamic rollover into active power lines.NTSB GAA18CA483Accident · No injuriesData collectionFinal reportRobinson R22 · Ocean City, NJThe flight instructor's decision to conduct hover practice at a lower altitude than recommended and his delayed remedial action during recovery from an unstable hover, which resulted in a dynamic rollover.NTSB CEN18LA306Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G 3B · Custer, SDThe pilot’s mismanagement of rotor RPM and subsequent forced landing on uneven terrain which led to a dynamic rollover.NTSB GAA18CA450Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lantana, FLThe student pilot’s improper pitch control during landing, which resulted in a dynamic rollover.NTSB ANC18CA056Accident · Minor injuriesClass 4 · Data collectionFinal reportEurocopter AS 350 B3 · Kobuk, AKThe pilot's inadvertent dynamic rollover during takeoff.NTSB ERA18LA170Accident · Minor injuriesLimited investigationFinal reportBell OH 58A · Raleigh, NCThe pilot's inadequate preflight inspection, during which he failed to detach ground handling equipment from the helicopter before initiating the takeoff, which resulted in the subsequent dynamic rollover.NTSB GAA18CA159Accident · No injuriesData collectionFinal reportHughes 269 · Jacksonville, FLThe pilot’s failure to maintain rotor rpm during a practice autorotation, which resulted in ground contact and a dynamic rollover.NTSB GAA18CA147Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a dynamic rollover.NTSB GAA18CA089Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Newark, OHThe pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in dynamic rollover.NTSB WPR18LA004Accident · No injuriesClass 3 · LimitedFinal reportWestern International Avia UH 1H · Arbuckle, CAA collective control malfunction for reasons that could not be determined.NTSB GAA17CA551Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Santa Barbara, CAThe student pilot’s unstabilized hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA17CA509Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Bremerton, WAThe student pilot’s improper bank control during takeoff, which resulted in a dynamic rollover.NTSB CEN17RA377Accident · Minor injuriesForeign investigationMcdonnell Douglas MD900 · Heiligenblut, AustriaOn August 1, 2017, at 1815 UTC, a McDonnell Douglas MD 900 Helicopter, Austrian registration OE-XWF, impacted mountainous terrain about 8 miles west-northwest of Heiligenblut, Austria. One medical crewmember sustained minor injuries. The pilot, the other…NTSB GAA17CA383Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Easton, PAThe pilot’s distraction during liftoff due to the tail rotor chip warning light illuminating, which resulted in the helicopter drifting right, the skid touching down, and a dynamic roll-over.NTSB GAA17CA296Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Eden Prairie, MNThe student pilot's loss of lateral control while practicing autorotations from a hover and the flight instructor's delayed remedial action, which resulted in a bounced landing and dynamic roll-over.NTSB ERA17CA187Accident · No injuriesData collectionFinal reportRobinson R22 · Linden, NJThe flight instructor's failure to maintain helicopter control while hovering, which resulted in skid contact with the ground and a dynamic roll-over.NTSB GAA17CA251Accident · No injuriesData collectionFinal reportBender Joseph KIT Rotoway · Wheatland, WYThe pilot's decision to operate the helicopter in gusting wind and high-density altitude conditions and his positioning of the helicopter such that it resulted in a right quartering tailwind, which resulted in a loss of helicopter control due to a loss of…NTSB ERA17LA103Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC 135 · Beattyville, KYThe pilot's failure to maintain helicopter control while landing, which resulted in a hard landing and subsequent roll over.NTSB GAA17CA132Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206 · Carson City, NVThe pilot-in-command’s delayed remedial action to arrest the right yaw after the bounced landing while operating in a flight regime conducive to the loss of tail rotor effectiveness, which resulted in a roll-over.NTSB GAA17CA130Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Armstrong, TXThe pilot’s failure to remove the left helicopter skid tie-down before takeoff, which resulted in dynamic roll-over.NTSB GAA17CA092Accident · No injuriesData collectionFinal reportPitcairn PA 18 · Philadelphia, PAThe pilot’s failure to correct the gyroplane’s right roll during the landing, which resulted in the exceedance of its critical angle and a subsequent roll-over. Contributing to the accident were the pilot’s focus on preventing a potential ground loop instead…NTSB WPR17LA019Accident · Serious injuriesLimited investigationFinal reportBell 206B · Yuma, AZThe pilot’s inability to maintain helicopter control after its skid got caught on the landing pad while he was maneuvering the helicopter to land on it, which resulted in a dynamic roll-over.NTSB CEN16LA182Accident · 1 fatalLimited investigationFinal reportBell 47G 3B 1 · Portia, ARThe pilot's decision to perform a sliding takeoff from the elevated platform, which resulted in a dynamic rollover when the right skid plate caught on a protruding screw. Contributing to the accident was the pilot's failure to adequately inspect the landing…NTSB GAA16CA163Accident · No injuriesData collectionFinal reportEnstrom F280 · Sodus, NYThe pilot's improper collective application at touchdown during a practice run-on landing, which resulted in the main rotor system impacting the tailboom and the forward portion of the fuselage impacting terrain during remedial action by the flight…NTSB WPR16LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G 3B 1 · Carson City, NVThe pilot's failure to maintain sufficient main rotor rpm, which resulted in a loss of helicopter control and a dynamic rollover.NTSB ERA16LA104Accident · Serious injuriesLimited investigationFinal reportBell 206 · Linden, NJThe pilot receiving instruction's failure to maintain helicopter control during the initial takeoff, which resulted in a dynamic rollover. Contributing to the accident was the flight instructor's inadequate remedial action due to his distraction by looking…NTSB CEN16LA096Accident · 1 fatalLimited investigationFinal reportRaymond Z Brown Condor · Centralia, ILThe failure of the prerotator belt, which impeded the engine's timing belt and resulted in a loss of engine power at low altitude.NTSB ERA16CA102Accident · No injuriesData collectionFinal reportTucker Mitchel C H 13 · Zephyrhills, FLThe pilot's failure to maintain aircraft control while on ground standing with the engine running during high crosswind conditions which resulted in a static rollover and collision with the ground.