NTSB investigations: Robinson Helicopter R22 BETA, 2002
5 cases on aircraft the registry lists as Robinson Helicopter R22 BETA, where the first occurrence was “Hard landing”. 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
| 1989 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 6 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 2 |
| 2007 | 8 |
Where
Latest 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\") = 2002
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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") = 2002
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 NYC02LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's delayed remedial action. A factor was the manufacturer's inadequate written guidance regarding simulated engine failures during takeoff.NTSB LAX02LA239Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZthe student pilot's failure to maintain adequate main rotor rpm, the CFI's delayed remedial action and inadequate supervision of the flight, resulting in a hard landing. Wind gusts and the high density altitude were factors in the accident.NTSB LAX02LA183Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe dual student's improper autorotation and the flight instructor's inadequate supervision.NTSB LAX02LA119Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe failure of the flight instructor to properly judge the landing flare and add adequate cyclic, resulting in a hard landing which collapsed the left skid. The wind gusts were a factor.NTSB SEA02FA035Accident · Serious injuriesField investigationFinal reportRobinson R-22 Beta · Silver City, MTBoth the pilot/owner and the FAA inspector pilots' failure to maintain adequate rotor RPM during a practice auto rotation landing which resulted in a hard landing. A contributing factor was the pilot/owner's application of excessive anti-torque pedal during…