NTSB investigations, CA
18 cases where the sequence of events included Dynamic rollover.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 1 |
| 2017 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2024 | 1 |
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND 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 WPR24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Carlsbad, CAThe pilot’s failure to maintain lateral control of the helicopter while departing with a crosswind, which resulted in a dynamic rollover.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 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 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 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 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 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 WPR14CA256Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe pilot's failure to maintain aircraft control while maneuvering for landing.NTSB WPR14LA225Accident · No injuriesLimited investigationFinal reportEmery Mark Rotorway 162F · Merced, CAThe helicopter pilot/owner's decision to install a belt type not recommended by the kit manufacturer in the tail rotor drive system using the incorrect tension values, which led to the belt’s in-flight failure and the subsequent loss of tail rotor drive…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 WPR14LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G · El Monte, CAA partial loss of engine power during climbout due to a malfunctioning magneto and spark plugs.NTSB WPR13FA264Accident · Minor injuriesField investigationFinal reportRobinson Helicopter R44 II · Los Angeles, CAThe pilot’s loss of helicopter control following a precautionary landing, 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 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 WPR11CA011Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain an adequate drift control and skid clearance from the ground and the CFI's inadequate supervision while hovering, resulting in dynamic rollover.NTSB WPR10LA458Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mammoth, CADynamic rollover of the helicopter during a precautionary landing.NTSB WPR10CA065Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe flight instructor's failure to arrest the helicopter's descent and to maintain lateral control during a hovering autorotation practice.