NTSB investigations: Robinson Helicopter R22 BETA, 2024
8 cases on aircraft the registry lists as Robinson Helicopter R22 BETA. 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
| 1985 | 1 |
|---|---|
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 10 |
| 1990 | 17 |
| 1991 | 28 |
| 1992 | 25 |
| 1993 | 22 |
| 1994 | 16 |
| 1995 | 12 |
| 1996 | 11 |
| 1997 | 11 |
| 1998 | 13 |
| 1999 | 16 |
| 2000 | 25 |
| 2001 | 19 |
| 2002 | 22 |
| 2003 | 34 |
| 2004 | 26 |
| 2005 | 28 |
| 2006 | 17 |
| 2007 | 35 |
| 2008 | 17 |
| 2009 | 24 |
| 2010 | 15 |
| 2011 | 20 |
| 2012 | 19 |
| 2013 | 8 |
| 2014 | 13 |
| 2015 | 12 |
| 2016 | 6 |
| 2017 | 17 |
| 2018 | 12 |
| 2019 | 11 |
| 2020 | 5 |
| 2021 | 7 |
| 2022 | 7 |
| 2023 | 9 |
| 2024 | 8 |
| 2025 | 3 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2024
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'))
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") = 2024
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'))
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 CEN25LA063Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Springfield, MOThe student pilot’s failure to maintain control of the helicopter while turning on the blower fan switch after landing that resulted in a dynamic rollover sequence.NTSB CEN25LA031Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Pearland, TXThe pilot’s failure to maintain control of the helicopter during lift off.NTSB WPR24LA183Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Maricopa, AZThe flight instructor’s unstabilized approach during an autorotation that resulted in hard landing.NTSB CEN24LA205Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Palmyra, MOThe pilot’s failure to maintain clearance from power lines during approach.NTSB ANC24LA039Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kailua-Kona, HIThe flight instructor’s failure to implement the correct action for low rotor RPM recovery.NTSB WPR24LA139Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Olympia, WAThe flight instructor’s delayed action to arrest the descending, left pedal turn while maneuvering for a low-altitude hover with the helicopter near the maximum gross weight limitation, which resulted in an impact with the ground and a dynamic rollover.NTSB ERA24LA203Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louisburg, NCThe pilot under instruction’s inadvertent use of the mixture control, which resulted in a total loss of engine power.NTSB CEN24LA097Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kenosha, WIThe pilot’s failure to maintain control of the helicopter while landing.