NTSB investigations: Robinson Helicopter R22
10 cases on aircraft the registry lists as Robinson Helicopter R22, where the first occurrence was “Hard landing”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 2 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2004 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640102')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 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 DEN04CA061Accident · No injuriesData collectionFinal reportRobinson R22 · Nephi, UTthe flight instructor's failure to maintain control of the helicopter resulting in a hard landing.NTSB NYC99LA090Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Port Jefferson, NYthe lack of supervision by the flight instructor which resulted in a low rotor condition and subsequent hard landing.NTSB FTW98LA330Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lubbock, TXThe pilot's failure to perform an adequate flare, and his improper touchdown technique. Factors were the pilot's improper evaluation of the weather conditions, and the high density altitude and crosswind weather condition.NTSB MIA94LA157Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Bunnell, FLThe pilot-in-command's improper use of flight controls (cyclic/collective) resulting in a hard landing.NTSB LAX88LA037Accident · No injuriesLimited investigationFinal reportRobinson R-22 · San Luis Obispo, CAA Robinson R22 landed hard while on a VFR business flight. The pilot reported that he landed hard during a downwind approach to a landing site. He examined the helicopter and noticed the aft landing gear cross tube was bent. He felt the helicopter was…NTSB CHI87LA178Accident · No injuriesLimited investigationFinal reportRobinson 22 · Minnetonka, MNWhile attempting to land on a flat spot on top of a hill the tail rotor hit the ground and the tail boom broke off. One witness reports that when the helicopter touched down it bounced up about 10 feet. No mechanical malfunctions were reported.NTSB LAX85LA317Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Piru, CAThe flight instructor instructed the 25-hour student plt to perform an autorotation with a pwr recovery at 20 ft AGL. The instructor became aware too late that the student was 'dead locked' on the controls and he was unable to recover prior to touchdown. A…NTSB FTW85LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · New Orleans, LAAccording to the CFI there was no intention to perform 'touchdown' autorotation landings. During the third simulated power loss the CFI reported that he initiated the flare at about 55 ft AGL. As airspeed dissipated and the sink rate continued the CFI…NTSB LAX82DA156Accident · Minor injuriesFinal reportRobinson R-22HP · North Las Vegas, NVThe passenger stated that during the approach to the landing area he noticed a decrease in rpm's and that the pilot was having difficulty in stabilizing the aircraft. He also noted that the helicopter was descending faster than the prior approach. Damage…