NTSB investigations, 2016
13 cases where the sequence of events included Roll over.
Cases per year
| 2008 | 20 |
|---|---|
| 2009 | 15 |
| 2010 | 14 |
| 2011 | 13 |
| 2012 | 18 |
| 2013 | 12 |
| 2014 | 19 |
| 2015 | 19 |
| 2016 | 13 |
| 2017 | 17 |
| 2018 | 34 |
| 2019 | 20 |
| 2020 | 7 |
| 2021 | 8 |
| 2022 | 4 |
| 2023 | 8 |
| 2024 | 6 |
| 2025 | 6 |
| 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\") = 2016
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '097' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2016 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '097' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 ANC17LA011Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Unalaska, AKThe pilot’s failure to maintain adequate clearance from terrain during a precautionary landing in whiteout conditions, which resulted in an in-flight collision with terrain.NTSB ERA17LA046Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · West Chester, PAThe flight instructor's decision to continue the practice autorotation in known gusting wind conditions, which resulted in a hard landing and roll over.NTSB CEN17LA027Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT 502B · Hereford, TXThe pilot's failure to maintain clearance from a cotton crop while maneuvering during agricultural application operations, which resulted in a loss of airplane control.NTSB WPR17LA002Accident · Minor injuriesLimited investigationFinal reportTamarack Helicopters UH-1H · Gila Bend, AZThe separation of the 90° tail rotor gearbox assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs due to the helicopter experiencing highly repetitive agricultural flight profiles for which it was not designed.NTSB ERA16LA326Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Ozark, ALA total loss of engine power for reasons that could not be determined following a successful postaccident engine run on the accident helicopter.NTSB GAA16CA405Accident · Minor injuriesData collectionFinal reportBell 206 · Outlook, WAThe pilot and ground crew's failure to visually inspect the helicopter's skids before takeoff, which resulted in a water hose becoming entangled on the right skid, a loss of control, an impact with terrain, and a post-crash fire.NTSB GAA16CA369Accident · No injuriesData collectionFinal reportStinson 108 · Red Lodge, MTA deer running across the runway and impacting the left side of the airplane, resulting in a loss of directional control, a runway excursion, and a ground loop.NTSB GAA16CA339Accident · Minor injuriesData collectionFinal reportHughes 269B · Princeton, CAThe uncertificated pilot's failure to maintain pitch and directional control, which resulted in an impact with terrain and a rollover.NTSB GAA16CA297Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Chireno, TXThe student pilot's selection of unsuitable terrain for landing, which resulted in the helicopter rolling over during landing, and substantial damage to the tail boom.NTSB GAA16CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Las Vegas, NVThe pilot receiving instruction's incorrect action of interfering with the flight controls and failure to comply with the flight instructor's commands, which resulted in a loss of lateral bank control and a rollover.NTSB GAA16CA240Accident · No injuriesData collectionFinal reportMills Gregory T AIR Commander LRT · Tybee Island, GAThe pilot's decision to perform a touch-and-go on unsuitable terrain, which resulted in a loss of directional control and a rollover.NTSB ERA16LA167Accident · No injuriesLimited investigationFinal reportBell 47D1 · Myerstown, PAA total loss of engine power for reasons that could not be determined because examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB GAA16CA179Accident · Minor injuriesData collectionFinal reportBell 206 · Supai, AZThe pilot's decision to fly a normal approach and forgetting that the long line remained attached to the helicopter, which resulted in the line snagging on a ridgeline, a loss of lateral control, and a rollover.