NTSB investigations: Robinson Helicopter R44 II, Outside the U.S.
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
| 2004 | 1 |
|---|---|
| 2008 | 1 |
| 2010 | 1 |
| 2016 | 1 |
| 2021 | 1 |
| 2022 | 1 |
Latest 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.\"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 ('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 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 ('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 GAA22WA311Accident · 1 fatalClass 5 · ForeignRobinson Helicopter R44 II · Kildare, IrelandNTSB GAA21WA047Accident · Minor injuriesClass 5 · ForeignRobinson Helicopter R44 II · Rosh Pinna, IsraelNTSB CEN16WA149Accident · Serious injuriesForeign investigationRobinson Helicopter R44 II · Atemajac de Brizuela, MexicoOn April 2, 2015, about 2120 universal coordinated time, a Robinson Helicopter Company R44 II helicopter, N565AC, impacted terrain near Atemajac de Brizuela, Mexico. The pilot and two passengers were uninjured and one passenger sustained a serious injury. The…NTSB ERA10WA133Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Restauracion, Dominican Republic, Dominican RepublicOn February 4, 2010, about 1940 Atlantic standard time, a Robinson R44II helicopter, N7535F, impacted the side of Mount Jina Mocha, in the city of Restauracion, Dominican Republic, at night, while en route from Port Au Prince, Haiti to Cibao International…NTSB CEN09WA074Accident · 1 fatalForeign investigationRobinson Helicopter R44 II · Saint-Marc, HaitiNTSB SEA05WA031Accident · 1 fatalForeign investigationRobinson R-44 II · Fairmont Hot Sp, Canada