NTSB investigations: Robinson Helicopter R22 BETA, 2009
5 cases on aircraft the registry lists as Robinson Helicopter R22 BETA, where the sequence of events included Dynamic rollover. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2009 | 5 |
|---|---|
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 3 |
| 2014 | 4 |
| 2015 | 2 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 2 |
| 2026 | 2 |
Where
Latest 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 year(c.\"eventDate\") = 2009
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640110', '7640103')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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 year(c."eventDate") = 2009
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640110', '7640103')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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" DESCRun 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 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 ERA10CA039Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Scranton, SCThe pilot’s failure to maintain control of the helicopter.NTSB ERA09CA401Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Bedford, MAThe flight instructor's inadequate remedial action while conducting hover practice with a student pilot, which resulted in the helicopter rolling over when it contacted the ground.NTSB CEN09CA271Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Harlingen, TXThe pilot's decision to leave the helicopter unattended with the engine running in gusty wind conditions.NTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.