NTSB investigations: Robinson Helicopter R22 BETA, AK
6 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
| 1999 | 1 |
|---|---|
| 2002 | 1 |
| 2007 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2016 | 1 |
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\" = 'AK' 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" = 'AK' 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 ANC17LA011Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Unalaska, AKThe pilot’s failure to maintain adequate clearance from terrain during a precautionary landing in whiteout conditions, which resulted in an in-flight collision with terrain.NTSB ANC12CA111Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Anchorage, AKThe flight instructor's inadequate supervision of the student pilot during a hovering autorotation, which resulted in a dynamic rollover.NTSB ANC11LA099Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Unalaska, AKA loss of engine power in cruise flight for undetermined reasons.NTSB ANC08CA011Accident · No injuriesData collectionFinal reportRobinson R-22 · Nikolski, AKThe pilot's inadequate compensation for wind gusts while maneuvering, which resulted in the tail rotor striking an undetermined object, and an emergency descent and landing. Factors contributing to the accident were the wind gusts, and the failure of the tail…NTSB ANC02LA021Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's Failure to maintain a proper descent rate during landing. Factors associated with the accident are variable wind conditions, and the pilot's improper approach to the landing site.NTSB ANC99LA040Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Fairbanks, AKThe failure of the pilot to maintain rotor rpm during a downwind turn. A factor in the accident was the inadequate altitude to recover from the loss of rotor rpm.