NTSB investigations: Robinson Helicopter R22 BETA, 2019
3 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\") = 2019
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") = 2019
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 CEN20LA037Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Beeville, TXThe solo student pilot's improper cyclic input during takeoff, which resulted in dynamic rollover.NTSB GAA20CA035Accident · No injuriesData collectionFinal reportRobinson R22 · Overton, NVThe pilot’s failure to maintain a proper approach and the flight instructor's subsequent failure to maintain an adequate climb rate during an attempted go-around in gusting tailwind conditions, which resulted in a hard landing and dynamic rollover.NTSB GAA19CA347Accident · Minor injuriesData collectionFinal reportRobinson R22 · San Antonio, TXThe pilot receiving instruction's improper cyclic control input during landing, which resulted in a dynamic rollover, and the flight instructor's improper decision to practice landings in tall grass in gusting wind conditions.