NTSB investigations: Robinson Helicopter R44
8 cases on aircraft the registry lists as Robinson Helicopter R44, where the defining event was Collision during takeoff/land. 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
| 2009 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2020 | 2 |
| 2026 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640120')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '490'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7640120')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '490'))
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 ANC26LA082Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 · Macedonia, IANTSB CEN20CA313Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dakota, ILThe pilot’s failure to maintain main rotor clearance from a ground obstacle during a landing.NTSB ERA20CA260Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Whitehall, MDThe pilot's failure to maintain adequate clearance from a known obstacle while landing from a hover.NTSB CEN16LA006Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Parkston, SDThe pilot’s decision to take off from a confined area and his failure to adequately compensate for wind conditions during the takeoff, which resulted in collision with obstacles.NTSB GAA15CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Sandusky, MIThe pilot's failure to monitor the landing environment while operating in a confined off-airport site resulting in a wire strike and substantial damage to the helicopter.NTSB ERA14CA413Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Hayesville, NCThe pilot's failure to maintain control of the helicopter, and adequate clearance, which resulted in a collision with a hangar.NTSB CEN13CA022Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Loop, TXThe pilot’s inadequate performance calculations, which resulted in an overweight takeoff for the conditions and the subsequent hard impact with terrain.NTSB WPR10CA193Accident · No injuriesData collectionFinal reportRobinson R44 · San Juan Batista, CAThe pilot's failure to maintain adequate clearance from wires while maneuvering and his subsequent improper use of the collective control, which resulted in the main rotor contacting the tail boom.