NTSB investigations: Robinson Helicopter R22 BETA, ID
11 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
| 1997 | 1 |
|---|---|
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 2 |
| 2015 | 2 |
| 2023 | 2 |
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\" = 'ID' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
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 WPR24LA008Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe pilot’s failure to maintain directional control during landing, resulting in a roll over.NTSB WPR23LA265Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Emmett, IDThe instructor’s failure to maintain airspeed during a simulated turning autorotation, which resulted in a hard landing.NTSB GAA15CA224Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe helicopter flight instructor's delayed remedial action during an autorotation resulting in a loss of control and impact with terrain.NTSB GAA15CA181Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDAbnormal ground contact during a 180 degree autorotation, resulting in a severed tail rotor driveshaft by a main rotor blade. A factor contributing to the accident was the rotor blowback condition due to the aft tilting of the main rotor disk.NTSB WPR10CA042Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Marsing, IDThe pilot's failure to maintain adequate main rotor rpm during the approach and subsequent go-around and the certified flight instructor's inadequate supervision of the flight.NTSB WPR09LA314Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Lewiston, IDA loss of engine power while in cruise flight for undetermined reasons.NTSB SEA08CA019Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Parma, IDThe student pilot's improper use of the flight controls while performing a hovering autorotation and the flight instructor's excessive remedial action which resulted in a hard landing.NTSB SEA06CA160Accident · No injuriesData collectionFinal reportRobinson R-22B · Boise, IDThe instructor pilot's inadvertent excessive descent rate, and his delay of remedial action during the demonstration of a 180 degree autorotation.NTSB SEA05CA182Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Boise, IDInadequate communications between the certified flight instructor and student pilot, and the student pilot's delay in relinquishing controls resulting in a hard landing during a practice autorotation.NTSB SEA04CA149Accident · No injuriesData collectionFinal reportRobinson R-22 · Boise, IDThe pilot's failure to initiate a flare prior to contacting the ground while attempting to land the helicopter on a dark night. Factors include a distraction created by the flicker of a low rotor rpm light, the glare of nearby flood lights, and the lack of…NTSB SEA97LA115Accident · No injuriesLimited investigationFinal reportRobinson R22B · Boise, IDimproper handling of the helicopter by the student pilot/applicant, during a hover autorotation, which resulted in loss of tail rotor effectiveness. The check pilot's inadequate remedial action was a related factor.