NTSB investigations: Robinson Helicopter R22, 1990
10 cases on aircraft the registry lists as Robinson Helicopter R22. 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
| 1975 | 1 |
|---|---|
| 1977 | 1 |
| 1980 | 2 |
| 1981 | 13 |
| 1982 | 18 |
| 1983 | 8 |
| 1984 | 9 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 3 |
| 1990 | 10 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 5 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 5 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 4 |
| 2023 | 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 year(c.\"eventDate\") = 1990
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640102'))
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 year(c."eventDate") = 1990
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640102'))
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 NYC91LA049Accident · No injuriesLimited investigationFinal reportRobinson R22 · West Kingston, RIThe pilot's failure to maintain directional control. Contributing was the malfunction of the pedal assembly.NTSB LAX90LA317Accident · Serious injuriesLimited investigationFinal reportRobinson R22A · Beatty, NVThe pilot's selection of an inadequate cruise altitude and his failure to maintain adequate rotor RPM. Contributing factors related to the high density altitude, rising terrain, and the pilot's delayed and improper use of the collective.NTSB NYC90LA197Accident · No injuriesLimited investigationFinal reportRobinson R-22HP · Islip, NYImproper use of flt controls.NTSB SEA90LA157Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Ellensburg, WAThe pilot did not adequately level off the helicopter and collided with the terrain.NTSB NYC90LA177Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Shirley, NYImproper use of the flight controls by the student pilot.NTSB LAX90LA227Accident · No injuriesLimited investigationFinal reportRobinson R22A · Pinon Hills, CAThe pilot's failure to maintain adequate rotor RPM during an attempted takeoff. A contributing factor was the high density altitude.NTSB LAX90LA203Accident · No injuriesLimited investigationFinal reportRobinson R22 · Corona, CAThe student pilot's failure to maintain directional control, failue to maintain correct rotor RPM, and improper use of the flight controls.NTSB CHI90DEK04Accident · Minor injuriesFinal reportRobinson R-22 · St. Mary'S, OHThe pilot's failure to see and avoid wires in his operating area.NTSB NYC90LA103Accident · No injuriesLimited investigationFinal reportRobinson R22 · Millville, NJThe student pilot's improper use of the flight controls, and inadequate supervision of the flight by the instructor (CFI). Contributing to the accident was the lack of total time and experience of both the student and instructor.NTSB LAX90LA157Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Mammoth Lakes, CAPilot's encounter with a strong downdraft while cruising at an inadequate altitude. A contributing factor was the high altitude which limited available engine power for recovery.