NTSB investigations: Robinson Helicopter R22, NY
10 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
| 1985 | 2 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1996 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 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\" = 'NY' 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" = 'NY' 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 NYC02LA086Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe flight instructors failure to maintain aircraft control during a wind gust. A factor in the accident was a sudden gust of wind.NTSB NYC01LA087Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe certified flight instructor’s inadequate supervision and delayed remedial action, which resulted in a roll-over. Factors in this accident were the crosswind condition and soft landing area.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 IAD97LA037Accident · No injuriesLimited investigationFinal reportRobinson R22 HP · Islip, NYThe students pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight.NTSB NYC90LA197Accident · No injuriesLimited investigationFinal reportRobinson R-22HP · Islip, NYImproper use of flt controls.NTSB NYC90LA177Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Shirley, NYImproper use of the flight controls by the student pilot.NTSB NYC89LA068Accident · Serious injuriesLimited investigationFinal reportRobinson R-22HP · Ronkonkoma, NYThe pilot's improper operation of the rotorcraft flight controls and a resulting low rotor RPM condition.NTSB NYC88LA169Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Copake Falls, NYDuring a practice autorotation to an open field, the aircraft struck a wire that had not been observed. An attempt to fly over the wire was unsuccessful and the tail rotor and aft 1/3 of the tail cone was severed from the helicopter. A hovering autorotation…NTSB NYC85FHJ06Accident · Serious injuriesFinal reportRobinson R-22 · Ronkonkoma, NYWhile hovering student pilot applied aft cyclic and the flt instructor could not regain control before tail rotor struck the taxiway. Helicopter rotated violently and rolled over and to rest on the skids. The helicopter was destroyed.NTSB NYC85LA221Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ronkonkoma, NYDuring a local training flight the student was attempting a lift off and began to drift to the left. The students control input was to the left aggravating the situation. The instructor took control of the aircraft however the roll over had progressed to an…