NTSB investigations, AZ
5 cases where the sequence of events included Dynamic rollover.
Cases per year
| 2009 | 2 |
|---|---|
| 2016 | 1 |
| 2022 | 1 |
| 2024 | 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\" = 'AZ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '231' 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 c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '231' 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 WPR24LA239Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369 · Mesa, AZThe pilot receiving instruction’s failure to maintain helicopter control during autorotation, which resulted in a dynamic rollover. Contributing to the accident was the delayed remedial action from the flight instructor.NTSB WPR22LA146Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Phoenix, AZThe pilot’s failure to maintain helicopter control while on the ground when his attention was diverted, which resulted in a dynamic rollover.NTSB WPR17LA019Accident · Serious injuriesLimited investigationFinal reportBell 206B · Yuma, AZThe pilot’s inability to maintain helicopter control after its skid got caught on the landing pad while he was maneuvering the helicopter to land on it, which resulted in a dynamic roll-over.NTSB WPR09CA198Accident · Minor injuriesData collectionFinal reportBetter Burn LLC/Startube Div Exec 162F · Chandler, AZThe flight instructor's inadequate supervision of the flight and delay in taking remedial action to prevent the helicopter from touching down while drifting. Contributing to the accident was the design of the skid shoes.NTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.