NTSB investigations: Robinson Helicopter R22 BETA, MS
4 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
| 1997 | 1 |
|---|---|
| 2001 | 1 |
| 2005 | 2 |
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 c.\"eventStateOrRegion\" = 'MS' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'MS' AND c."eventCountry" = 'USA'
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 MIA05LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Gulfport, MSA loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.NTSB MIA05CA051Accident · No injuriesData collectionFinal reportRobinson R22 · Gulf Port, MSThe student pilot's inadequate flare and his failure to maintain rotor rpm which resulted in a hard landing. Also causal was the instructor's inadequate supervision of the flight.NTSB MIA01LA064Accident · No injuriesLimited investigationFinal reportRobinson R22 · Long Beach, MSThe student pilot's failure to relinquish the flight controls while the CFI was demonstrating a takeoff to a hover. This resulted in an in-flight loss of directional control, in-flight collision with terrain, and subsequent roll over.NTSB ATL97LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · Wiggins, MSthe student pilot misjudged rotor blade clearance from a utility pole, which resulted in a collision. The proximity of the pole was a related factor.