NTSB investigations: Robinson Helicopter R22 BETA, 1986
5 cases on aircraft the registry lists as Robinson Helicopter R22 BETA. 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
| 1985 | 1 |
|---|---|
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 10 |
| 1990 | 17 |
| 1991 | 28 |
| 1992 | 25 |
| 1993 | 22 |
| 1994 | 16 |
| 1995 | 12 |
| 1996 | 11 |
| 1997 | 11 |
| 1998 | 13 |
| 1999 | 16 |
| 2000 | 25 |
| 2001 | 19 |
| 2002 | 22 |
| 2003 | 34 |
| 2004 | 26 |
| 2005 | 28 |
| 2006 | 17 |
| 2007 | 35 |
| 2008 | 17 |
| 2009 | 24 |
| 2010 | 15 |
| 2011 | 20 |
| 2012 | 19 |
| 2013 | 8 |
| 2014 | 13 |
| 2015 | 12 |
| 2016 | 6 |
| 2017 | 17 |
| 2018 | 12 |
| 2019 | 11 |
| 2020 | 5 |
| 2021 | 7 |
| 2022 | 7 |
| 2023 | 9 |
| 2024 | 8 |
| 2025 | 3 |
| 2026 | 4 |
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\") = 1986
AND 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'))
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") = 1986
AND 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'))
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 BFO87LA005Accident · Serious injuriesLimited investigationFinal reportRobinson R22B · Harborton, VADuring an apch to land, the plt expereinced a loss of tail rotor effectiveness and the acft rotated to the right. The airspeed was reported as 30 mph with a descent rate of 150 fpm and the acft was less than 50 ft AGL. The acft then descended to a collision…NTSB LAX87LA012Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Dolan Springs, AZThe pilot stated that he was climbing the helicopter up a dry wash and planned to cross a 3000 foot high ridge at about 10 feet above the terrain. As he approached the ridge the helicopter yawed to the right about 70 degrees and the acft main rotor lost RPM.…NTSB NYC86LA220Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Rochester, NHPilot made a steep descent and lost directional control. The aircraft collided with the ground while still turning causing the helicopter to roll over.NTSB MIA86FA199Accident · Serious injuriesField investigationFinal reportRobinson R22 · Islamorada, FLWitnesses reported seeing the helicopter flying at approximately 8 to 10 feet off the water. The helicopter entered a left turn and as the turn progressed the helicopter descended striking the water with a skid and cartwheeling.NTSB LAX86LA175Accident · No injuriesLimited investigationFinal reportRobinson R22 · Grand Canyon, AZThe pilot stated that he was attempting to land on a dirt road and that the helicopter was at a two to five foot hover when a gust of wind pivoted the tail into the wind. The helicopter touched down and rolled over onto its right side. The pilot further…