NTSB investigations: Robinson Helicopter R44, 2004
7 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
| 1993 | 1 |
|---|---|
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 7 |
| 2005 | 12 |
| 2006 | 11 |
| 2007 | 3 |
| 2008 | 5 |
| 2009 | 8 |
| 2010 | 8 |
| 2011 | 7 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 8 |
| 2015 | 7 |
| 2016 | 6 |
| 2017 | 10 |
| 2018 | 10 |
| 2019 | 8 |
| 2020 | 9 |
| 2021 | 6 |
| 2022 | 12 |
| 2023 | 10 |
| 2024 | 9 |
| 2025 | 4 |
| 2026 | 8 |
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\") = 2004
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 year(c."eventDate") = 2004
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 NYC04CA199Accident · No injuriesData collectionFinal reportRobinson R44 · Wildwood, NJThe pilot's inadequate visual lookout while conducting a nighttime landing to a dolly, which resulted in a stuck skid, and subsequent hard landing. A factor was the nighttime conditions.NTSB CHI04LA212Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Chesterfield, MOThe pilot's inadequate preflight planning due to his selection of an unsuitable takeoff area and his failure to maintain clearance from the open hangar door. A contributing factor was the open hangar door.NTSB ATL04FA141Accident · 3 fatalField investigationFinal reportRobinson R44 · Barnesville, GAThe certified flight instructor's in-flight decision to continue VFR flight into IMC, which resulted in spatial disorientation, and the subsequent in a loss of control. A factor was fog.NTSB IAD04FA025Accident · 2 fatalField investigationFinal reportRobinson R-44 · Killingly, CTThe pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…NTSB MIA04LA061Accident · No injuriesLimited investigationFinal reportRobinson R44 · Ocala, FLThe failure of the pilot to maintain control of the helicopter following a reported loss of engine power after picking up to a hover from a dolly.NTSB CHI04LA079Accident · No injuriesLimited investigationFinal reportRobinson R44 · Burlington, WIThe pilot's inadequate visual lookout and his failure to obtain/maintain clearance from the transmission wire during the takeoff. Factors contributing to the accident were the transmission wire and the pole.NTSB MIA04CA048Accident · No injuriesData collectionFinal reportRobinson R44 · Vero Beach, FLThe failure of the pilot to maintain clearance with bushed resulting in in-flight contact and susequent dynamic roll-over.