NTSB investigations: Robinson Helicopter R22 BETA
16 cases on aircraft the registry lists as Robinson Helicopter R22 BETA, where the first occurrence was “Loss of engine power”. 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
| 1987 | 1 |
|---|---|
| 1990 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 4 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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 ('7640110', '7640103')
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\" = 350))
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 ('7640110', '7640103')
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" = 350))
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 DFW07LA116Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Morgan City, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA088Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Laredo, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC06FA020Accident · 2 fatalField investigationFinal reportRobinson R22 · Scottsdale, AZA loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain rotor rpm, which resulted in an uncontrolled descent and collision with terrain.NTSB MIA05LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Gulfport, MSA loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.NTSB LAX04LA073Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Temecula, CAa loss of engine power for undetermined reasons.NTSB CHI03FA218Accident · Serious injuriesField investigationFinal reportRobinson R22-Beta · Flint, MIThe loss of engine power for undetermined reasons, and the pilot's inadequate decision to land on an unsuitable area.NTSB DEN03LA085Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · West Jordan, UTThe loss of power for undetermined reasons. Also causal was the student's failure to maintain aircraft control and the instructor's inadequate supervision. The instructor's delayed remedial action as a contributing factor.NTSB SEA03LA052Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mabton, WAA partial loss of power, for undetermined reasons, during a shallow approach, that ultimately lead to a situation where the pilot found it necessary to attempt a forced landing while the helicopter was moving slightly sideways. Factors include rough/uneven…NTSB CHI02LA263Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Seneca, ILThe loss of engine power for undetermined reasons. Factors were the low altitude, the trees, and the unsuitable terrain encountered for the forced landing.NTSB MIA01FA004Accident · 2 fatalField investigationFinal reportRobinson R-22 · Pembroke Pines, FLThe pilot's failure to maintain rotor rpm and the proper rate of descent during a forced landing/autorotation resulting in an in-flight collision with terrain. Contributing to the accident was a loss of engine power due to the failure of the No. 3 exhaust…NTSB FTW97LA327Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Terrell, TXthe student pilot's premature flare for landing from an autorotation, and the ensuing loss of rotor rpm, which resulted in a hard landing. A factor relating to the accident was: partial loss of engine power for undetermined reason(s).NTSB MIA94GA072Accident · Minor injuriesFinal reportRobinson R-22B · Pompano Beach, FLFailure of the pilot-in-command to use carburetor heat during a poweroff autorotation, resulting in the engine not responding to throttle input during recovery due to carburetor ice buildup.NTSB FTW93LA015Accident · No injuriesLimited investigationFinal reportRobinson R22B · Robert Lee, TXThe loss of engine/rotor RPM for undetermined reasons.NTSB LAX92LA076Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lodi, CAThe pilot's improper use of the carburetor heat control and delay in flaring the helicopter for an autorotative touchdown. Carburetor icing conditions and the soft terrain were contributing factors in the accident.NTSB ATL90FA117Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Griffin, GALoss of engine power for an unknown reason. The presence of trees in the emergency landing area was a related factor.NTSB MIA88FA006Accident · 1 fatalField investigationFinal reportRobinson R-22-B · Plymouth, FLThe private pilot, with an expired medical certificate and a license restricted to no carriage of passengers, took off and experienced an engine failure for undetermined causes. He did not execute an autorotation and the aircraft crashed. The pilot had also…