NTSB investigations
37 cases where the defining event was Roll over.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 2 |
Where
Open the mapLatest cases
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\" = '097') 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" = '097') 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 CEN27LA026Accident · No injuriesClass 4 · LimitedInvestigation openPiper J3C-65 · Eagle Harbor, MINTSB CEN26LA119Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Graford, TXThe pilot’s failure to maintain sufficient rotor speed during a practice autorotation to soft terrain which resulted in a loss of control and roll over.NTSB ANC25LA034Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182B · Girdwood, AKThe pilot's decision to land on an unsuitable landing surface, which resulted in a nose-over.NTSB ENG25WA033Accident · Serious injuriesClass 5 · ForeignBell 505 · Petersgrat Mountain, SwitzerlandNTSB GAA25WA019Accident · No injuriesClass 5 · ForeignViking Air DHC-2 MK 1 · Whitehaven, AustraliaNTSB ERA24LA236Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Gilbertsville, KYThe pilot's failure to maintain control of the helicopter while attempting to take off from sloping terrain.NTSB WPR23LA147Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Midway, UTThe pilot’s failure to maintain aircraft control during a pinnacle landing that resulted in a hard landing and subsequent roll over.NTSB ERA23LA021Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Daytona Beach, FLThe pilot’s misjudged landing point which resulted in a loss of control and collision with terrain.NTSB ANC21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKThe pilot’s inability to maintain lateral control during the takeoff, which resulted in dynamic rollover. Contributing to the accident was the pilot’s decision to utilize an unsuitable landing area for flight operations.NTSB ANC21LA080Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pelican, AKThe pilot’s loss of control while landing on a remote helipad.NTSB GAA21WA098Accident · No injuriesClass 5 · ForeignRobinson R44 · Región de Ñuble, ChileNTSB GAA21WA069Accident · No injuriesClass 5 · ForeignRotorway Exec · Ledbury, Herefordshire, United KingdomNTSB ERA21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportEnstrom 480 · Woodstock, CTThe pilot’s failure to maintain control of the helicopter while attempting to land on a trailer in gusting wind conditions, which resulted in a dynamic rollover.NTSB GAA19CA428Accident · Minor injuriesData collectionFinal reportRobinson R44 · Council Bluff, IAThe pilot's improper cyclic input during liftoff from a landing deck, which resulted in the right skid hooking onto an opening on the landing deck and a subsequent dynamic rollover.NTSB GAA19CA186Accident · Serious injuriesData collectionFinal reportBell 206 · Valley Center, CAThe ground crew’s attachment of the load fill hose to the helicopter without telling the pilot, which resulted in a loss of helicopter control during takeoff.NTSB CEN18WA372Accident · No injuriesForeign investigationRobinson R22 · Naunton Beauchamp, Worcestershire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB WPR18CA048Accident · Serious injuriesData collectionFinal reportCessna 172P · Valley Springs, CAThe pilot's failure to maintain clearance from trees while maneuvering for landing and his decision to land on a surface with obstructions.NTSB WPR18WA038Accident · No injuriesForeign investigationBell Helicopter 206B · Emerald Aerodrome, AustraliaOn November 18, 2017, about 1430 local time, a Bell 206B helicopter, registration VH-SDZ, rolled over following a precautionary landing near Emerald Aerodrome, Middlemount, Queensland, Australia. The helicopter, which was equipped with a Rolls-Royce 250…NTSB CEN17LA302Accident · Minor injuriesLimited investigationFinal reportJames F Hake MTO Sport · Mentone, INThe pilot’s failure to maintain a proper touchdown attitude, which resulted in a loss of directional control during the landing roll.NTSB GAA16CA297Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Chireno, TXThe student pilot's selection of unsuitable terrain for landing, which resulted in the helicopter rolling over during landing, and substantial damage to the tail boom.NTSB GAA16CA071Accident · No injuriesData collectionFinal reportBell 206 · Christmas Island, KiribatiThe pilot's inadequate preflight inspection and the maintenance crew's failure to remove the tie down.NTSB GAA15CA253Accident · Minor injuriesData collectionFinal reportAir Creation USA Skypper · Stow, MAThe student pilot's improper directional control inputs during the takeoff roll, resulting in a roll over and collision with terrain.NTSB CEN14LA307Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Mt. Comfort, INThe pilot’s installation of an unauthorized main rotor belt and his subsequent failure to properly inspect the belt, which resulted in inadequate belt tension, the belt’s failure, and the subsequent loss of engine power.NTSB WPR14LA159Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Missoula, MTA dynamic rollover during attempted liftoff.NTSB ERA14CA102Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe certificated flight instructor's failure to maintain helicopter control during a run-on landing, resulting in a rollover and ground collision.NTSB WPR14CA082Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Roberts, MTThe pilot's selection of unsuitable terrain during taxi, which resulted in a loss of directional control.NTSB CEN14CA016Accident · No injuriesData collectionFinal reportAmerican Eurocopter AS350B3 · Eagle Pass, TXThe abnormal contact of the helicopter's skids with the landing surface, which resulted in a rollover.NTSB WPR13CA412Accident · Minor injuriesData collectionFinal reportPiper PA 11 · Bozeman, MTThe pilot's failure to maintain aircraft control and inadequate compensation for the high gusty wind conditions during taxi.NTSB CEN13CA176Accident · No injuriesData collectionFinal reportCessna 172A · Vineland, MNThe pilot’s decision to attempt a touch-and-go landing on a narrow, ice-covered road with snow banks on each side.NTSB WPR12CA344Accident · No injuriesData collectionFinal reportRotorway Exec · Colville, WAThe pilot's lack of experience in the helicopter, which resulted in his failure to maintain ground clearance during the taxi hover, followed by inadvertent ground contact and rollover.NTSB ERA11CA505Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Clearwater, FLThe certified flight instructor's delayed remedial action, which resulted in a loss of control and subsequent rollover.NTSB ERA11WA122Accident · No injuriesForeign investigationBell 212 · Cuzco, PeruOn January 17, 2011, at 1940 universal coordinated time, a Bell 212 helicopter, Peruvian registration OB-1767-P, registered to Helicopters Service, and operated by Heliamerica S.A.C., experienced an un-commanded roll over during takeoff from a remote helipad…NTSB CEN10CA371Accident · No injuriesData collectionFinal reportBrantly B-2B · East Troy, WIThe pilot's failure to maintain control during landing.NTSB WPR10CA218Accident · No injuriesData collectionFinal reportCessna 172 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions during taxi.NTSB WPR10CA064Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe pilot's failure to maintain control of the helicopter.NTSB ERA10CA051Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Morovis, PRThe pilot’s delayed attempt to go around.NTSB NYC08CA083Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Fenner, NYThe pilot's delayed decision to perform a precautionary landing. Contributing to the accident was the reduced visibility in snow and the soft terrain.