NTSB investigations: Robinson Helicopter R22
10 cases on aircraft the registry lists as Robinson Helicopter R22, where the first occurrence was “In flight collision with terrain/water”. 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 | 4 |
|---|---|
| 1990 | 2 |
| 2001 | 1 |
| 2002 | 2 |
| 2004 | 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\" = 230))
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" = 230))
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 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 ATL02LA119Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Tunica, MSThe pilot's improper control of cyclic, resulting in impact with terrain and a subsequent dynamic rollover.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 SEA01LA054Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Seattle, WABoth pilots' exceedance of the proper descent rate during the autorotative descent. Factors included the helicopter's low altitude at maneuver initiation, the failure of both pilots to maintain the proper airspeed during the descent, and both pilots' delay in…NTSB SEA90LA157Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Ellensburg, WAThe pilot did not adequately level off the helicopter and collided with the terrain.NTSB NYC90LA103Accident · No injuriesLimited investigationFinal reportRobinson R22 · Millville, NJThe student pilot's improper use of the flight controls, and inadequate supervision of the flight by the instructor (CFI). Contributing to the accident was the lack of total time and experience of both the student and instructor.NTSB CHI82FA267Accident · No injuriesField investigationFinal reportRobinson R22 · Milwaukee, WIAs the student plt was practicing a hovering maneuver, the acft started moving to the left & losing altitude slowly. The CFI was adding collective pitch when the left skid contacted the ground & the acft rolled over. The left skid, m/r blades & tailboom…NTSB LAX82DA223Accident · No injuriesFinal reportRobinson R22 · Concord, CADuring a landing, the pilot reported that he came to a 3 ft hover then initiated a descent by lowering the collective. He stated that when the helicopter was about 6 inches above the ground, he lowered the collective to complete the landing, and at that…NTSB LAX82DA138Accident · No injuriesFinal reportRobinson R-22 · Perris, CAAfter refueling with 12.9 gallons of fuel, the pilot took off with one passenger on board. The pilot stated that after lifting off with 104% prm, he began a normal shallow takeoff with 25 inches of manifold pressure. He reported reaching about 75 ft AGL and…NTSB MIA82FA042Accident · 2 fatalField investigationFinal reportRobinson R-22 · Ormand Beach, FLAfter being told by the operator to remain on the ground until the weather improved the instructor pilot departed ormond Beach airport. The pilot radioed daytona Beach approach control and requested a special VFR clearance and vectors to daytona Beach…