NTSB investigations: Robinson Helicopter R22
15 cases on aircraft the registry lists as Robinson Helicopter R22, where the first occurrence was “In flight collision with object”. 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 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1998 | 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\" = 220))
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" = 220))
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 LAX98FA149Accident · 1 fatalField investigationFinal reportRobinson R22 · Irwindale, CAThe failure of the pilot to observe in a timely manner and maintain clearance from electrical power transmission wires and her improper maneuver to avoid the obstruction.NTSB LAX95LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Redding, CAthe pilot's improper use of the flight controls. The downward-sloping terrain and the intermittent gusty wind conditions were factors in this accident.NTSB LAX94LA033Accident · No injuriesLimited investigationFinal reportRobinson R22A · Santa Rosa, CAthe separation of the tail rotor due to a collision with a mylar balloon and the subsequent hard landing during an autorotation. A factor in the accident was the dark night lighting conditions which limited the pilot's ability to see and avoid the balloon.NTSB NYC93FA138Accident · 2 fatalField investigationFinal reportRobinson R22 · Warsaw, KYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance with ground obstacles, which resulted in an inflight collision with a power line.NTSB LAX92LA301Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Fresno, CAThe cfi's poor in-flight decision to proceed over the trees instead of the previously performed right circling turns and both pilots inadequate visual look-out. Contributing to this accident were the trees that partially obstructed the view of the power line…NTSB CHI90DEK04Accident · Minor injuriesFinal reportRobinson R-22 · St. Mary'S, OHThe pilot's failure to see and avoid wires in his operating area.NTSB LAX89LA331Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZImproper in-flight planning/decision by the instructor pilot (CFI). Factors related to the accident were: the cfi's lack of familiarity with the geographic area, and the fence.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 LAX88LA089Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Sun City, AZNTSB CHI86FEM12Accident · No injuriesFinal reportRobinson R-22HP · Grayling, MIThe helicopter, during cruise flight, was flying low in an attempt to remain clear of clouds when it struck a power line and was forced to make an emergency landing. The helicopter received substantial damaged when it struck the power line and reportedly…NTSB MIA86FA181Accident · 1 fatalField investigationFinal reportRobinson R22 HP · Lk Buena Vista, FLMotorists obsd the helicopter flying low ovr & along an interstate hiway. In the vicinity of a hiway rest area, the helicopter maneuvered to the side of the hiway, then flew back ovr the median. Two witnesses said it came to a hover, then started to continue…NTSB FTW86FRG09Accident · Serious injuriesFinal reportRobinson R22 HT · Sonora, TXThe helicopter contacted the terrain in an uncontrolled descent after colliding with power lines during a climbing turn to the west. The plt reported he could not see the power lines because of glare from the setting sun.NTSB NYC84LA232Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ellington, CTAfter being directed to do so by the arpt mgr the pilot was air taxiing to parking when the main rotor blades contacted one main rotor blade of a parked bell 206. The pilot related that he assumed he would clear the 206 since he was watching the airport mgr…NTSB LAX84FA193Accident · 2 fatalField investigationFinal reportRobinson R22 · Thousand Oaks, CAThe helicopter collided with 2 cables supported by 150 ft tall twin towers. It then went out of control & crashed into a 15 ft deep drainage ditch & burned. The plt had been cited on 2/20/84 for 'careless & reckless operation of an acft.' Another person who…NTSB FTW82DA370Accident · Minor injuriesFinal reportRobinson R22 · Eden, TXThe pilot reportd that he lifted off to a three foot hover, checked his instrument readings, then took off. He reported climbing to 15 feet to clear some bushes and two fences that were in his flight path. As he approached the first fence, the helicopter was…