NTSB investigations, 2017, AZ
10 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 18 |
|---|---|
| 2009 | 14 |
| 2010 | 12 |
| 2011 | 12 |
| 2012 | 13 |
| 2013 | 6 |
| 2014 | 7 |
| 2015 | 6 |
| 2016 | 7 |
| 2017 | 10 |
| 2018 | 10 |
| 2019 | 7 |
| 2020 | 6 |
| 2021 | 10 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 4 |
| 2025 | 1 |
Where
Latest 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\") = 2017
AND 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\" = '240' 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 year(c."eventDate") = 2017 AND 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" = '240' 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 WPR18LA031Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Page, AZThe pilot's failure to maintain pitch control of the helicopter while transitioning from a hover to forward flight.NTSB WPR18LA014Accident · Serious injuriesClass 3 · LimitedFinal reportAmerican AA 1A · Maricopa, AZThe pilot’s failure to see and avoid unmarked power lines during the approach to land.NTSB WPR18FA011Accident · 1 fatalField investigationFinal reportPeterson Lancair Legacy · Bowie, AZAn in-flight loss of control due to a bird strike.NTSB WPR17FA213Accident · 2 fatalField investigationFinal reportCessna 172L · Perkinsville, AZThe pilot's decision to fly into a canyon during wind conditions conducive to turbulence and downdrafts, and his subsequent loss of aircraft control while maneuvering in the canyon. Contributing to the accident was the pilot's limited canyon flying experience.NTSB WPR17FA155Accident · 2 fatalField investigationFinal reportEvolution 19 Lancair Evolution · Mesa, AZThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent stall/spin. Contributing to the accident was the pilot's distraction due to a failure…NTSB WPR17FA134Accident · 2 fatalField investigationFinal reportJordan John RV7 · Arlington, AZThe inflight overstress separation of the vertical stabilizer and rudder during flight which resulted in the pilot's inability to maintain airplane control. Contributing to the accident was an inflight collision with a bird.NTSB GAA17CA370Accident · Minor injuriesData collectionFinal reportAero-Ace CE 1 · Cottonwood, AZThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB GAA17CA166Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe flight instructor’s incorrect control inputs while taking off with a known quartering tailwind, which resulted in a loss of directional control and runway excursion.NTSB WPR17LA068Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Holbrook, AZThe pilot’s failure to compensate for a loss of effective translational lift while turning from an upwind to a downwind condition at a low altitude and low airspeed, which resulted in a loss of helicopter control.NTSB WPR17FA057Accident · 2 fatalField investigationFinal reportBeech 300 · Tucson, AZThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.