NTSB investigations, AK
8 cases where the defining event was Dynamic rollover.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2018 | 2 |
| 2023 | 1 |
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 c.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA' 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 ANC24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3 · Palmer, AKThe pilot's failure to maintain clearance from snow-covered terrain during the landing approach in flat light conditions.NTSB ANC18CA056Accident · Minor injuriesClass 4 · Data collectionFinal reportEurocopter AS 350 B3 · Kobuk, AKThe pilot's inadvertent dynamic rollover during takeoff.NTSB GAA18CA147Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a dynamic rollover.NTSB ANC13CA041Accident · No injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Anaktuvuk Pass, AKThe pilot's failure to maintain lateral control while hovering over an area of snow-covered terrain, in flat light conditions, which resulted in a dynamic rollover.NTSB ANC12FA084Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Helicopter 600N · Delta Junction, AKThe pilot’s failure to clear the left landing gear skid, which resulted in the entanglement of the left landing gear skid with a log, and his subsequent application of collective pitch, which resulted in a dynamic rollover.NTSB ANC12CA025Accident · No injuriesData collectionFinal reportHughes 369 · Trading Bay, AKThe pilot's selection of an unsuitable landing site in flat-light conditions, which resulted in an inadvertent dynamic rollover.NTSB ANC11LA108Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 BA · Juneau, AKUpslope wind conditions while the helicopter was operating at ground idle, which resulted in the helicopter rollover. Contributing to the accident was the lack of manufacturer data regarding the effect of upslope wind conditions on helicopter ground idle…NTSB ANC10CA040Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Seward, AKThe pilot's failure to maintain clearance from snow-covered terrain while hovering in flat light conditions, which resulted in a dynamic rollover.