NTSB investigations: Robinson Helicopter R22, 1987
7 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\") = 1987
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") = 1987
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 LAX88LA037Accident · No injuriesLimited investigationFinal reportRobinson R-22 · San Luis Obispo, CAA Robinson R22 landed hard while on a VFR business flight. The pilot reported that he landed hard during a downwind approach to a landing site. He examined the helicopter and noticed the aft landing gear cross tube was bent. He felt the helicopter was…NTSB NYC87LA217Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sterling, MABefore flying solo, the student plt & his instructor (CFI) practiced autorotations for about 1/2 hr. The CFI deplaned & the student took off on a solo flt. He flew to a reservoir area for more practice. After descending from about 1000' to 500', the eng lost…NTSB CHI87LA178Accident · No injuriesLimited investigationFinal reportRobinson 22 · Minnetonka, MNWhile attempting to land on a flat spot on top of a hill the tail rotor hit the ground and the tail boom broke off. One witness reports that when the helicopter touched down it bounced up about 10 feet. No mechanical malfunctions were reported.NTSB NYC87LA178Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sterling, MAWhile practicing hovering in the designated hover area at the arpt, the stu plt accidently pulled aft cyclic while the helicopter was drifting backwards. This caused the tail structure and rotor blades to contact the ground. The main rotor blades then…NTSB NYC87LA134Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Ellington, CTDuring an instructional flight, the instructor pilot simulated a forced landing at about 250 feet and 60 KIAS. The student pilot at this time entered an autorotation and the helicopter started to descend. Collective was pulled but this failed to stop the…NTSB BFO87FA022Accident · 2 fatalField investigationFinal reportRobinson R22 · Myersville, MDThe non-instrument rated commercial pilot departed hgr in a Robinson helicopter that was not equipped to fly in instrument conditions. The pilot had not logged any instrument time and elected to depart in IFR conditions under a special VFR clearance. ATC…NTSB SEA87LA054Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAWhen psgr became nauseous in flt, plt attempted downwind lndg onto pinnacle in rough terrain. Acft contacted slope short of intended point of lndg, main rotor flexed downward, severing tail boom.