NTSB investigations: Robinson Helicopter R44 II, 2011
6 cases on aircraft the registry lists as Robinson Helicopter R44 II. 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
| 2003 | 2 |
|---|---|
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 7 |
| 2007 | 10 |
| 2008 | 14 |
| 2009 | 13 |
| 2010 | 8 |
| 2011 | 6 |
| 2012 | 16 |
| 2013 | 15 |
| 2014 | 15 |
| 2015 | 15 |
| 2016 | 11 |
| 2017 | 19 |
| 2018 | 15 |
| 2019 | 18 |
| 2020 | 11 |
| 2021 | 23 |
| 2022 | 15 |
| 2023 | 12 |
| 2024 | 14 |
| 2025 | 16 |
| 2026 | 9 |
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 year(c.\"eventDate\") = 2011
AND 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'))
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") = 2011
AND 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'))
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 CEN12FA091Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Hackensack, MNThe helicopter's sudden yaw and subsequent impact with the water for reasons that could not be determined during postaccident examination of the helicopter and its systems.NTSB CEN11CA511Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Broomfield, COA loss of control due to the pilot's diverted attention as a result of an open door.NTSB CEN11FA468Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Rising Sun, INThe noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.NTSB CEN11CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Golden, COThe pilot’s decision to operate the helicopter at a high density altitude near terrain, which resulted in a settling with power condition.NTSB ERA11FA272Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Indiana, PAThe pilot's operation of the helicopter at a low-forward airspeed out of ground effect, which resulted in the helicopter’s loss of translational lift and tail rotor authority and the pilot’s subsequent loss of helicopter control.NTSB ERA11CA180Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Weston, FLThe pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.