NTSB investigations: Robinson Helicopter R44, NE
5 cases on aircraft the registry lists as Robinson Helicopter R44. 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
| 2006 | 1 |
|---|---|
| 2014 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 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.\"eventStateOrRegion\" = 'NE' 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 ('7640120'))
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" = 'NE' 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 ('7640120'))
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 CEN26LA289Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Raven 1 · Scribner, NEThe pilot's failure to maintain clearance from power lines while maneuvering at low-level altitude during an agricultural operation.NTSB CEN20CA316Accident · Minor injuriesClass 4 · Data collectionFinal reportRobinson R44 · Hebron, NEA loss of engine power due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight to sump the fuel tanks prior to flight.NTSB GAA18CA408Accident · No injuriesData collectionFinal reportRobinson R44 · Rulo, NEThe pilot's improper collective application, which resulted in low rotor rpm during the takeoff climb and a subsequent ground collision. Contributing to the accident was the pilot’s self-induced pressure to complete the operation.NTSB CEN14CA403Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Allen, NEThe pilot did not ensure sufficient obstacle clearance for potential wind conditions, which resulted in his loss of control of the helicopter.NTSB CHI06CA143Accident · No injuriesData collectionFinal reportRobinson R44 · Stapleton, NEThe pilot not maintaining clearance fron the tree during landing. A factor was the tree.