NTSB investigations: Robinson Helicopter R22 MARINER, AK
5 cases on aircraft the registry lists as Robinson Helicopter R22 MARINER. 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
| 1994 | 1 |
|---|---|
| 1996 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2006 | 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.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640115'))
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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640115'))
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 ANC06CA031Accident · No injuriesData collectionFinal reportRobinson R22 · Anchorage, AKThe pilot's decision to land the helicopter on an icy airport parking ramp, which resulted in a loss of control on touchdown, and subsequent collision with another parked and unoccupied helicopter.NTSB ANC02LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Fairbanks, AKThe pilot's failure to maintain clearance from objects while maneuvering. A factor associated with the accident is an undetermined object.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 ANC96FA081Accident · 1 fatalField investigationFinal reportRobinson R-22 Mariner · Mekoryuk, AKA loss of engine power due to fuel contamination found in the fuel supply and helicopter fuel system. Factors in the accident were the pilot's inadequate filtration (servicing of the helicopter) of the fuel supply, and the pilot's inadequate performance of…NTSB ANC94LA096Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's failure to maintain rotor RPM. Factors were the ravine and the tailwind.