NTSB investigations, 2020
6 cases where the defining event was Dynamic rollover.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 5 |
| 2010 | 8 |
| 2011 | 7 |
| 2012 | 6 |
| 2013 | 1 |
| 2014 | 8 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 10 |
| 2018 | 4 |
| 2019 | 6 |
| 2020 | 6 |
| 2021 | 3 |
| 2022 | 11 |
| 2023 | 2 |
| 2024 | 6 |
| 2025 | 7 |
| 2026 | 6 |
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\") = 2020
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '231')
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") = 2020 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '231') 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 ERA21LA046Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Austell, GAThe flight instructor’s failure to maintain adequate clearance above the gravel surface in a hover, which resulted in a dynamic rollover.NTSB CEN21LA081Accident · No injuriesClass 4 · LimitedFinal reportSchweizer 269C · Rhame, NDThe pilot landed the helicopter on unsuitable terrain, which resulted in a rollover.NTSB CEN21LA021Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Washington, WIThe pilot’s failure to maintain lateral control during a hover and improper recovery action after the helicopter contacted the ground, which resulted in a dynamic rollover sequence and an impact with terrain.NTSB CEN20CA180Accident · Minor injuriesClass 4 · Data collectionFinal reportRotorway Exec · Rochester, INThe pilot's failure to maintain control of the helicopter during lift off. Contributing to the accident was the pilot's lack of recent experience flying a helicopter.NTSB CEN20CA090Accident · No injuriesData collectionFinal reportRobinson R22 · Cotulla, TXThe pilot's failure to remove the right skid trailer tie-down before attempting to take off, which resulted in a dynamic roll-over.NTSB WPR20CA059Accident · No injuriesData collectionFinal reportSud SE 3130 Alouette II · Mokelumne Hills, CAThe pilot's failure to maintain adequate clearance from terrain during a hover-taxi, which resulted in the helicopter's skid contacting grass and a subsequent dynamic roll-over.