NTSB investigations: Robinson Helicopter R44, 2000
3 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\") = 2000
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") = 2000
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 NYC01FA053Accident · 3 fatalField investigationFinal reportRobinson R-44A · Sandgap, KYthe pilot's improper weather evaluation, and his failure to maintain terrain clearance while operating over unlighted terrain at night. Factors were the isolated areas of fog, and night conditions.NTSB LAX00LA086Accident · No injuriesLimited investigationFinal reportRobinson R44 · Palo Alto, CAThe pilot's failure to use carburetor heat, resulting in a loss of engine power, and, his misjudged autorotation approach that resulted in a collision with the ground during the landing flare. Contributing to the accident was the conditions conducive to…NTSB MIA00FA060Accident · No injuriesField investigationFinal reportRobinson R44 · Cayey, PRThe pilot's failure to use carburetor heat as required by the Pilot's Operating Handbook resulting in a loss of engine and rotor rpm, forced landing to none suitable terrain (residence), and subsequent roll over.