NTSB investigations: Robinson Helicopter R22 ALPHA, 1985
3 cases on aircraft the registry lists as Robinson Helicopter R22 ALPHA. 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
| 1983 | 1 |
|---|---|
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 5 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2012 | 1 |
| 2016 | 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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640104'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640104'))
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 ANC85LA121Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Summit Lake, AKHelicopter struck glassy water lake during a low alt turn. Plt/flt instructor said he became disoriented during the turn, after he looked inside the helicopter briefly to check the rotor RPM. Accident occured during a bright night.NTSB SEA85LA129Accident · No injuriesLimited investigationFinal reportRobinson R22 · Port Orchard, WAThe instructor plt (CFI) with only 358 hrs total flt time was demonstrating an autorotation with a power recovery. During the recovery, the CFI failed to fully regain RPM & the helicopter settled to the surface. With a low rotor RPM, there was a loss of tail…NTSB FTW85FPJ02Accident · No injuriesFinal reportRobinson R-22A · Mcalester, OKThe plt was using the helicopter to round up cattle. One cow charged the helicopter and struck the tail rotor. The helicopter pitched nose down, the main rotor blade struck the ground. The helicopter came to rest in an upright position.