NTSB investigations: Robinson Helicopter R44 II
9 cases on aircraft the registry lists as Robinson Helicopter R44 II, 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
| 2008 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 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 ('7640122', '7640123')
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 ('7640122', '7640123')
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 ERA24LA118Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLTail rotor contact with an unseen object while performing a precautionary landing to a closed helipad at night.NTSB ERA22LA188Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calhoun, GAThe pilot’s failure to maintain clearance from wires during takeoff.NTSB WPR21LA341Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Camp Verde, AZThe pilot's inadequate preflight performance calculations which resulted in an aborted takeoff and collision with trees.NTSB GAA17CA450Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Dunlap, ILThe pilot’s failure to visually confirm that the helicopter was disconnected from hoses during refueling operations. Contributing to the accident was the pilot’s and ground crew’s misunderstanding of the hand signals.NTSB GAA16CA006Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Devine, TXThe pilot's failure to maintain obstacle clearance during the takeoff, which resulted in the helicopter striking power lines.NTSB ERA14FA115Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Panacea, FLThe pilot’s failure to maintain adequate clearance from trees during a takeoff at night. Contributing to the accident was the pilot’s lack of recent night flight experience.NTSB WPR13CA424Accident · Minor injuriesData collectionFinal reportRobinson R44 - II · Flagstaff, AZThe pilot's failure to maintain rotor rpm while landing in a gusty wind at a high density altitude.NTSB CEN12LA443Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Red Oak, IAThe pilot's failure to maintain clearance from the ground-support vehicle during landing.NTSB DFW08LA122Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Bartlett, TXThe pilot's failure to maintain tail rotor clearance from terrain (embankment) during takeoff.