NTSB investigations: Robinson Helicopter R22 BETA

82 cases on aircraft the registry lists as Robinson Helicopter R22 BETA, where the sequence of events included Collision with terr/obj (non-CFIT). 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, newest first

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 ('7640110', '7640103')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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.

NTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.Apr 5, 2012 · N104MH · Substantial damageNTSB WPR12LA109Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Antioch, CAThe failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision. Contributing to the accident was the failure of air traffic control personnel to issue the helicopter pilot a prompt and appropriate alternate…Feb 20, 2012 · N7508Y · 2 aircraft · Substantial damageNTSB ERA12CA137Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · St Petersburg, FLThe flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…Jan 6, 2012 · N8066U · Substantial damageNTSB ERA12LA063Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe pilot’s failure to maintain airspeed during a low-altitude turn into gusty tailwind conditions, which resulted in a loss of translational lift and settling with power. Contributing to the accident was the pilot's lack of total flight experience.Nov 5, 2011 · N413RM · Substantial damageNTSB CEN12CA009Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hibbing, MNThe private pilot's failure to maintain control of the helicopter during the landing flare.Oct 4, 2011 · N4170M · Substantial damageNTSB WPR11CA467Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Douglas, WYThe pilot's failure to maintain yaw control of the helicopter while hover taxiing in gusty wind conditions.Sep 24, 2011 · N3070S · Substantial damageNTSB ERA11CA448Accident · No injuriesData collectionFinal reportRobinson R22 · Titusville, FLThe private pilot's incorrect manipulation of the engine mixture control which resulted in an inadvertent engine shutdown.Aug 11, 2011 · N62JF · Substantial damageNTSB ERA11LA409Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Dayton, NJThe pilot's inadequate compensation for wind during an out-of-ground-effect hover, which resulted in a loss of control due to settling with power and loss of tail rotor effectiveness.Jul 20, 2011 · N83509 · Substantial damageNTSB CEN11FA422Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Del Valle, TXThe divergence of the main rotor from its normal plane of rotation for reasons that cannot be determined because the pilot’s control inputs leading up to the event are unknown, resulting in mast bumping and main rotor blade separation.Jun 27, 2011 · N7779M · Substantial damageNTSB WPR11CA264Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the helicopter during taxi, resulting in a loss of tail rotor effectiveness and a subsequent hard landing.Jun 18, 2011 · N334DC · Substantial damageNTSB CEN11CA351Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lansing, ILThe student pilot’s failure to maintain control of the helicopter while hovering.May 20, 2011 · N7197Z · Substantial damageNTSB CEN11LA318Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Yancey, TXThe loss of engine power due to the unintentional closure of the fuel shutoff valve.May 3, 2011 · N927SH · Substantial damageNTSB ERA11LA204Accident · No injuriesLimited investigationFinal reportRobinson R22 · Goshen, NYThe pilot’s failure to adhere to published preflight checklist limitations and procedures, resulting in excessive slack and subsequent failure of the power transmission belts and a total loss of rotor system drive.Mar 22, 2011 · N259TW · Substantial damageNTSB WPR11LA161Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta II · North Las Vegas, NVThe partial loss of engine power for undetermined reasons. Contributing to the accident was the certified flight instructor's decision to continue the flight after the helicopter exhibited inadequate performance capabilities and an unresolved power production…Mar 11, 2011 · N8360T · Substantial damageNTSB CEN11LA226Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Bulverde, TXThe in-flight separation of the fuel cap, which impacted the helicopter’s tail rotor and resulted in the loss of tail rotor thrust. Contributing to the accident was the inadequate preflight inspection by both pilots, who did not ensure that the fuel cap was…Mar 9, 2011 · N112HE · Substantial damageNTSB WPR10LA298Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Hillsboro, ORA partial loss of engine power while on approach for undetermined reasons.Jun 19, 2010 · N2548S · Substantial damageNTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…Jun 2, 2010 · N522SA · Substantial damageNTSB CEN10CA156Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Houston, TXThe student pilot's loss of directional control during takeoff, resulting in a dynamic rollover of the helicopter.Mar 13, 2010 · N822SH · Substantial damageNTSB CEN10FA139Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Cotulla, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning. Contributing to the accident was the low-altitude operating environment that would not allow for a successful autorotation after the loss of engine power.Mar 6, 2010 · N922SH · Substantial damageNTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.Nov 14, 2009 · N74632 · Substantial damageNTSB ERA10CA039Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Scranton, SCThe pilot’s failure to maintain control of the helicopter.Oct 24, 2009 · N822U · Substantial damageNTSB WPR09FA459Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Forest Grove, ORThe flight crew’s failure to maintain adequate main rotor speed while maneuvering, which resulted in a main rotor blade stall and an uncontrolled descent into terrain.Sep 20, 2009 · N956SH · Substantial damageNTSB WPR09FA284Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Morristown, AZThe pilot's failure to maintain clearance from the power line.Jun 11, 2009 · N149SH · Substantial damageNTSB ERA09CA205Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Richmond, VAA loss of engine power due to the pilot inadvertently shutting down the engine.Mar 22, 2009 · N2360M · Substantial damageNTSB CEN09CA180Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · O'Donnell, TXThe pilot's failure to maintain control while performing a quick stop maneuver to an out of ground effect (OGE) hover. Contributing to the accident was the high density altitude and near calm wind condition.Feb 25, 2009 · N387AC · Substantial damageNTSB CEN09CA157Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Cypress, TXThe student pilot's failure to maintain adequate main rotor rpm and the instructor's delayed remedial action.Feb 6, 2009 · N234LA · Substantial damageNTSB SEA08CA208Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Flagstaff, AZThe pilot's decision to attempt a takeoff in a high density altitude high gross weight condition that exceeded the takeoff performance capability of the helicopter. The pilot's failure to maintain adequate rotor rpm was also causal. Contributing factors were…Sep 24, 2008 · N926EL · Substantial damageNTSB SEA08FA185Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Olalla, WAThe complete loss of engine power due to the accumulation of ice in the carburetor as a result of the pilot's failure to use carburetor heat.Aug 17, 2008 · N301MA · DestroyedNTSB CHI08CA238Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Buffalo, NDThe pilot's excessive descent rate and his failure to maintain clearance from terrain during the spray run entry.Aug 5, 2008 · N57UP · Substantial damageNTSB DFW08CA198Accident · No injuriesData collectionFinal reportRobinson R22 · Rosharon, TXThe pilot's failure to maintain terrain clearance while maneuvering. Contributing to the accident was the low altitude.Jul 25, 2008 · N2330Y · Substantial damageNTSB LAX08CA185Accident · Minor injuriesData collectionFinal reportRobinson R-22 Beta · Philomath, ORThe student pilot's failure to maintain rotor rpm during a pinnacle approach and the flight instructor's delayed remedial action and inadequate supervision of the flight. Contributing to the accident was the downdraft weather condition.Jun 17, 2008 · N4000Y · Substantial damageNTSB NYC08FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta II · Wilmington, NCThe pilot's failure to maintain proper rotor rpm after a partial loss of engine power.Mar 13, 2008 · N2215R · Substantial damage