NTSB investigations: Robinson Helicopter R22 BETA, 2013
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\") = 2013
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") = 2013
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 CEN14CA017Accident · No injuriesData collectionFinal reportRobinson R22 - Beta · Chicago, ILThe flight instructor's failure to take remedial action in a timely manner.NTSB CEN13LA325Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · New Braunfels, TXThe pilot's improper flare during an autorotation, which resulted in a hard landing, and a partial loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded…NTSB CEN13CA312Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lansing, ILImproper control inputs by the pilot-receiving-instruction and the inability of the flight instructor to correct the control inputs in sufficient time to avoid the hard landing.NTSB WPR13LA222Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Honolulu, HIThe mechanic’s failure to properly inspect the helicopter following maintenance performed by an apprentice, which resulted in a total loss of engine power due to the improper rigging of the mixture control assembly.NTSB CEN13LA148Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta II · Gillett, TXA loss of tail rotor effectiveness while manuevering at low altitude.NTSB WPR13CA107Accident · No injuriesData collectionFinal reportRobinson R22 · Kona, HIThe pilot’s failure to maintain adequate main rotor rpm during a practice autorotation and the flight instructor's delayed action, which resulted in a hard landing.NTSB ERA13LA116Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Ellington, CTThe separation of the collective push-pull tube and jackshaft assembly, which resulted in the total loss of helicopter control and collision with terrain. Contributing to the accident was the inadequate supervision of maintenance personnel by the operator…NTSB ERA13LA104Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Tampa, FLThe student pilot’s delayed throttle application during the practice autorotation and the flight instructor’s lack of immediate remedial action, which resulted in a hard landing.