NTSB investigations, NY
7 cases where the sequence of events included Dynamic rollover.
Cases per year
| 2015 | 1 |
|---|---|
| 2016 | 1 |
| 2018 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2025 | 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\" = 'NY' 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" = 'NY' 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 ERA25LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPaul Dennis Berg Exec 162F · Holley, NYThe pilot’s failure to maintain clearance with the ground while hovering, which resulted in a dynamic rollover.NTSB ERA24LA028Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Ronkonkoma, NYThe student pilot’s abrupt control input and the flight instructor’s inadequate remedial action, which resulted in a dynamic rollover.NTSB ERA23LA084Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Gilgo-Oak Beach-Captree, NYThe flight instructor’s inadequate remedial action while supervising the student pilot’s practice autorotation in gusting wind conditions, which resulted in a dynamic rollover.NTSB ERA22LA135Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · White Plains, NYThe pilot’s failure to maintain stabilized lateral control during landing in gusty conditions which resulted in a dynamic rollover when the skids contacted the platform unevenly.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 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 GAA15CA238Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Ronkonkoma, NYThe student pilot's loss of control during a hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor's lack of action to remediate the student pilot's control inputs and recover aircraft control.