NTSB investigations: Robinson Helicopter R22 ALPHA, CA
9 cases on aircraft the registry lists as Robinson Helicopter R22 ALPHA. 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
| 1983 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1998 | 1 |
| 1999 | 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\" = 'CA' 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 ('7640104'))
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" = 'CA' 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 ('7640104'))
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 LAX99LA186Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · San Luis Obispo, CAThe student's inadvertent and uncoordinated application of forward cyclic during an autorotation flare, which resulted in a loss of main rotor rpm; and the flight instructor's inadequate supervision.NTSB LAX98FA098Accident · 1 fatalField investigationFinal reportRobinson R22 · Littlerock, CAThe pilot's improper use of the rotorcraft cyclic control in response to encountering terrain induced turbulence. A factor in the accident was the pilot's failure to obtain a preflight weather briefing which contained precautionary notices for turbulence.NTSB LAX91LA097Accident · No injuriesLimited investigationFinal reportRobinson R22A · Piru, CAFailure of the CFI to maintain main rotor RPM during a demonstrated autorotation.NTSB LAX90LA204Accident · No injuriesLimited investigationFinal reportRobinson R22A · Torrance, CAThis accident was a dynamic roll over due to the right skid encountering soft soil during the forced landing.NTSB LAX90LA074Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ramona, CAThe pilot encountered a tailwind while on final approach, but delayed the go-around. During the go-around the pilot failed to maintain airspeed and entered a descent (settling with power).NTSB LAX90LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R22A · Simi Valley, CAStudent pilot's failure to maintain the proper altitude.NTSB LAX89FA092Accident · 2 fatalField investigationFinal reportRobinson R22A · Santa Barbara, CAFailure of the pilot to maintain adequate altitude, proper airspeed for the reduced visibility, and an adequate visual outlook to avoid a collision with power transmission cable. Contributing to the accident was reduced visibility due to fog.NTSB LAX88FA032Accident · 2 fatalField investigationFinal reportRobinson R22A · Moraga, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact with the cockpit area.NTSB LAX83FA226Accident · No injuriesField investigationFinal reportRobinson R22 · Torrance, CAThe helicopter was on an FAA certification test flt with a part-time company employee in the left seat as pilot- in-command (PIC). An FAA test plt was in the right seat. The purpose of the flt was to establish new data for the helicopter's height-velocity…