NTSB investigations, AZ
7 cases where the first occurrence was “Roll over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 380)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 380) 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 LAX05LA119Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Waddell, AZthe pilot's failure to maintain adequate rotor rpm and obstacle clearance, resulting in a dynamic rollover and collision with terrain.NTSB LAX04LA249Accident · 1 fatalLimited investigationFinal reportBell 206B · Mesa, AZthe pilot's failure to adequately clear the left skid of obstacles resulting in a dynamic rollover of the helicopter and collision with terrain. A factor in the accident was the dark nighttime lighting conditions.NTSB LAX03LA189Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta II · Phoenix, AZThe instructor's inadequate supervision and his failure to maintain aircraft control. The wind gusts were a factor.NTSB LAX97LA021Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Mesa, AZthe selection of an unsuitable landing area by the flight instructor (CFI). Factors relating to the accident were: soft/wet terrain in the selected landing area, and the crosswind condition.NTSB LAX95LA081Accident · No injuriesLimited investigationFinal reportRotorway Rotorway · Chandler, AZthe student pilot's improper use of the helicopter's flight controls and the instructor's inadequate supervision of the flight.NTSB LAX87DUJ05Accident · No injuriesFinal reportHiller UH-12E · Tolleson, AZThe plt stated that he landed the acft on a platform on top of a chemical tank truck. The truck was parked on a slight slope with its left side six inches lower than the right. The plt reduced power to idle and the loader began to load the helicopter with…NTSB LAX82DA133Accident · No injuriesFinal reportRobinson R-22 · Mesa, AZAfter landing in a practice area the instructor told the student to pick the helicopter up to a hover. The aircraft lifted off the ground to approximately 5 feet and yawed to the right 45 degrees. As the instructor applied left pedal and lowered collective…