NTSB investigations
102 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '231') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '231') 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 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 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 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 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 WPR15CA119Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · San Bernardino, CAThe pilot's failure to maintain adequate clearance from the ground, which resulted in a loss of control and subsequent dynamic rollover.NTSB CEN15TA017Accident · Minor injuriesFinal reportAirbus Helicopters AS 350 B3 · Lordsburg, NMThe pilot’s failure to maintain adequate drift control and skid clearance from the ground during takeoff, which resulted in a dynamic rollover when the aft right skid contacted a rock.NTSB CEN15CA007Accident · Serious injuriesData collectionFinal reportBell 206B · Atlanta, ARThe pilot's inadequate preflight inspection when he did not remove a tie-down strap prior to takeoff, which resulted in a dynamic rollover.NTSB WPR14CA373Accident · Minor injuriesData collectionFinal reportBell 407 · Moab, UTThe pilot's failure to ensure adequate clearance from terrain while landing on sloped terrain.NTSB WPR14CA319Accident · No injuriesData collectionFinal reportBell 206B · Salinas, CAThe pilot's failure to ensure adequate clearance from ground obstacles during takeoff which resulted in loss of aircraft control.NTSB WPR14CA196Accident · No injuriesData collectionFinal reportBell 47G · Bakersfield, CAThe pilot's failure to maintain aircraft control after the helicopter's skid catching on the side of a trailer during takeoff, which resulted in a dynamic rollover.NTSB ERA14CA217Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Frederick, MDThe student pilot's failure to maintain directional control during the hover, and the flight instructors lack of remedial action, resulting in a dynamic rollover and structural damage to the helicopter.NTSB WPR14LA113Accident · No injuriesLimited investigationFinal reportBell 206 · Bountiful, UTThe pilots' inaccurate assessment of the snow depth on the landing zone, which resulted in a landing on snow deeper than that for which the helicopter was equipped and led to dynamic rollover.NTSB CEN14CA108Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Beaumont, TXThe student pilot not controlling the helicopter following a wind gust and the flight instructor's inadequate remedial action resulting in the helicopter rolling over on its side during a landing.NTSB ANC13CA041Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Anaktuvuk Pass, AKThe pilot's failure to maintain lateral control while hovering over an area of snow-covered terrain, in flat light conditions, which resulted in a dynamic rollover.NTSB WPR12CA405Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lake Newman, WAThe flight instructor's failure to maintain clearance from terrain while correcting for the student pilot's failure to maintain directional control of the helicopter.NTSB ANC12FA084Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Helicopter 600N · Delta Junction, AKThe pilot’s failure to clear the left landing gear skid, which resulted in the entanglement of the left landing gear skid with a log, and his subsequent application of collective pitch, which resulted in a dynamic rollover.NTSB WPR12FA298Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Murrieta, CAThe pilot's failure to maintain clearance from high vegetation while making a hovering turn, which resulted in a dynamic rollover.NTSB CEN12CA191Accident · No injuriesData collectionFinal reportBell 206L-3 · Southern Timbalier 52CAThe pilot’s inadequate preflight inspection when he did not remove a tie-down strap prior to takeoff, which resulted in a dynamic rollover.NTSB ANC12CA025Accident · No injuriesData collectionFinal reportHughes 369 · Trading Bay, AKThe pilot's selection of an unsuitable landing site in flat-light conditions, which resulted in an inadvertent dynamic rollover.NTSB ERA12LA210Accident · Minor injuriesLimited investigationFinal reportBell 206B · Titusville, FLThe flight instructor's attempted takeoff in gusting wind conditions while the student pilot was adjusting her anti-torque pedals, which resulted in a dynamic rollover event.NTSB ANC11LA108Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 BA · Juneau, AKUpslope wind conditions while the helicopter was operating at ground idle, which resulted in the helicopter rollover. Contributing to the accident was the lack of manufacturer data regarding the effect of upslope wind conditions on helicopter ground idle…NTSB CEN11CA627Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Batesville, TXThe pilot’s inadequate preflight inspection that failed to ensure all tie-down clamps were removed prior to takeoff, which resulted in the helicopter’s dynamic rollover.NTSB CEN11CA524Accident · Minor injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Creston, ILThe pilot's failure to maintain adequate skid clearance from the helicopter cart during landing, resulting in a dynamic rollover.NTSB WPR11LA190Accident · Minor injuriesLimited investigationFinal reportBell 47G · Torrance, CAThe pilot did not maintain adequate altitude during takeoff, which resulted in ground contact and a dynamic rollover.NTSB ERA11CA201Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Mount Pocono, PAThe flight instructor's selection of an unsuitable landing site to practice autorotations, which resulted in an inadvertent dynamic rollover during touchdown.NTSB CEN11CA213Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Glenwood Springs, COThe pilot’s improper takeoff procedure, which resulted in a dynamic rollover when the left skid contacted the ground.NTSB CEN11CA167Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Anoka, MNThe student pilot's control inputs that resulted in an inadvertent dynamic rollover and the CFI's inadequate supervision of the flight.NTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.NTSB CEN10CA537Accident · Minor injuriesData collectionFinal reportLewis Brandon Scott Exterminator · Rockford, ILThe pilot's failure to maintain control of the gyrocopter while practicing takeoffs and landings.NTSB CEN10LA477Accident · No injuriesLimited investigationFinal reportBell 206B · Rocky Mount, MOA dynamic rollover inadvertently induced by the pilot during landing.NTSB ERA10CA319Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe CFI's failure to prevent ground contact during hover, which resulted in a dynamic rollover.NTSB ANC10CA040Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Seward, AKThe pilot's failure to maintain clearance from snow-covered terrain while hovering in flat light conditions, which resulted in a dynamic rollover.NTSB ERA10CA242Accident · No injuriesData collectionFinal reportSeymour Robert M Rotorway 162F · Dallas, GAThe student pilot's failure to maintain control of the helicopter during landing resulting in a roll over.NTSB CEN10CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Houston, TXThe student pilot's loss of directional control during takeoff, resulting in a dynamic rollover of the helicopter.NTSB WPR10CA100Accident · No injuriesData collectionFinal reportBell 206B · Kalispell, MTThe pilot's failure to maintain lateral drift control during landing.NTSB CEN10FA079Accident · No injuriesField investigationFinal reportSikorsky S-76C++ · Gulf of Mexico (Gulf of Mexico)The pilot's failure to fully land the helicopter prior to entering a turn in strong, crosswind conditions, which resulted in a dynamic rollover.NTSB ERA10CA065Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Georgetown, KYThe pilot's failure to maintain adequate clearance from the surface during lateral hover, which resulted in dynamic rollover.NTSB ERA09CA337Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Meredith, NHThe pilot’s failure to maintain control during landing.NTSB ERA09CA249Accident · No injuriesData collectionFinal reportBell 206 · West Palm Beach, FLThe pilot’s failure to maintain aircraft control during taxi, which resulted in a dynamic rollover.