NTSB investigations: Robinson Helicopter R22 MARINER
11 cases on aircraft the registry lists as Robinson Helicopter R22 MARINER, where the first occurrence was “Loss of control - in flight”. 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 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 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 ('7640115')
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\" = 250))
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 ('7640115')
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" = 250))
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 SEA04CA122Accident · Minor injuriesData collectionFinal reportRobinson R22 Mariner · Hillsboro, ORThe pilot's failure to maintain aircraft control resulting in an uncontrolled descent and subsequent roll over. Low altitude flight and the pilot's encounter with settling with power were contributing factors.NTSB FTW01LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sunnyvale, TXThe flight instructor's inadequate supervision of his student and his failure to maintain control of the helicopter. Factors were the student pilot allowing the airspeed and main rotor RPM to get too low during the simulated emergency.NTSB ANC99LA068Accident · No injuriesLimited investigationFinal reportRobinson R22 · Glennallen, AKThe pilot's failure to maintain rotor RPM during takeoff. Factors associated with the accident were a downdraft, and uneven terrain.NTSB SEA99LA005Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Scappoose, ORAircraft control was not maintained. Inadequate remedial action is a factor.NTSB LAX94LA374Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Chico, CAthe student pilot's improper use of the flight controls. The student pilot's lack of experience in the helicopter is a factor in this accident.NTSB ANC94LA096Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's failure to maintain rotor RPM. Factors were the ravine and the tailwind.NTSB SEA94LA171Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Portland, ORTail rotor gearbox failure due to inadequate assembly and inspection procedures by the manufacturer.NTSB ATL92FA085Accident · 1 fatalField investigationFinal reportRobinson R-22 · Atlanta, GAThe pilot's inadequate evaluation of the weather (wind condition), and the inflight decision to hover with gusting tailwinds, which resulted in a complete loss of tail rotor control. A factor was gusting tailwinds.NTSB FTW91LA162Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Lewisville, TXLoss of control due to foreign object damage induced binding flight controls. A factor was improper maintenance.NTSB NYC90LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Lawrence, MAThe pilot's improper use of flight controls, resulting in loss of control.NTSB NYC87FA160Accident · 2 fatalField investigationFinal reportRobinson R22 Mariner · So. Windsor, CTA loss of control in flight for undetermined reasons.