NTSB investigations: Robinson Helicopter R22, UT
7 cases on aircraft the registry lists as Robinson Helicopter R22. 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
| 2004 | 3 |
|---|---|
| 2007 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2023 | 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\" = 'UT' 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 ('7640102'))
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" = 'UT' 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 ('7640102'))
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 WPR23LA191Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Spanish Fork, UTThe instructor pilot’s improper landing flare during a straight-in autorotation, which resulted in a hard landing.NTSB WPR13LA315Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Alta, UTThe flight instructor's decision to follow a route over mountainous terrain in conditions that exceeded the helicopter’s ability to maintain terrain clearance.NTSB WPR12CA307Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Bountiful, UTThe student’s failure to maintain adequate rotor rpm and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB SEA07CA171Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Park City, UTThe pilot's failure to maintain rotor RPM during hover taxi. A contributing factor was the high density altitude weather condition.NTSB DEN05LA036Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Provo, UTthe flight instructor's failure to maintain clearance from the water. Contributing to the accident was the flight instructor's inability to detect a descent because of the obscuration between the water and the horizon due to the gray skyNTSB DEN04LA142Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Spanish Fork, UTthe instructor's premature flare, resulting in a hard landing, and his failure to align the helicopter with the direction of travel, resulting in a rollover.Contributing factors were the low rotor RPM and inadequate airspeed. The reason for the loss of engine…NTSB DEN04CA061Accident · No injuriesData collectionFinal reportRobinson R22 · Nephi, UTthe flight instructor's failure to maintain control of the helicopter resulting in a hard landing.