NTSB investigations, AZ
11 cases where the sequence of events included Roll over.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 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\" = '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 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" = '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 GAA18CA312Accident · No injuriesData collectionFinal reportPiper PA 46 · Prescott, AZThe pilot’s improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB GAA18CA049Accident · Minor injuriesData collectionFinal reportJohn Roscoe Autogyro Cavalon · Casa Grande, AZThe pilot’s improper landing flare, which resulted in loss of directional control and a subsequent runway excursion.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 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.NTSB WPR11GA115Accident · 1 fatalFinal reportMcdonnell Douglas Heli 369FF · Marana, AZAn inadvertent tail rotor strike during an attempted pinnacle landing, which resulted in the pilot's loss of control of the helicopter. Inhospitable terrain/topography contributed to the severity of the accident.NTSB WPR11CA031Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe student pilot's failure to maintain the proper airspeed and the certificated flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing and rollover.NTSB WPR10LA161Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9 118 · Phoenix, AZThe pilot’s improper preflight inspection of the balloon’s rapid deflation system, which resulted in its inhibited functionality during landing.NTSB WPR10CA064Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe pilot's failure to maintain control of the helicopter.NTSB WPR09IA128Incident · No injuriesIncident investigationFinal reportCessna 172H · Tucson, AZThe flight instructor’s inadequate situational awareness while taxiing that led to an encounter with jet blast.NTSB WPR09CA008Accident · No injuriesData collectionFinal reportBell 47J-2A · Florence, AZThe pilot’s inadequate compensation for a wind shift encountered during the landing approach, which resulted in a hard landing and rollover. Contributing to the accident was the encounter with the wind shift.NTSB LAX08CA298Accident · Minor injuriesData collectionFinal reportRobinson R22B · Prescott, AZThe student pilot's failure to maintain adequate main rotor rpm and the instructor's inadequate supervision and delayed remedial action.