NTSB investigations, 2017
10 cases where the defining event was Abrupt maneuver.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2010 | 10 |
| 2011 | 11 |
| 2012 | 7 |
| 2013 | 9 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 11 |
| 2017 | 10 |
| 2018 | 12 |
| 2019 | 8 |
| 2020 | 3 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 3 |
| 2024 | 8 |
| 2025 | 5 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '270')
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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '270') 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 ERA17FA339Accident · 1 fatalField investigationFinal reportHickox Andy Andys Gyroplane · Umatilla, FLThe pilot's improper response to a total loss of engine power, which resulted in main rotor blade contact with the rudder and vertical stabilizer, and a subsequent uncontrolled descent. The loss of engine power was due to the separation of the electrical…NTSB ERA17LA328Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Hanover Township, PAThe pilot's failure to maintain roll control while maneuvering, which resulted in a collision with trees and terrain.NTSB GAA17CA350Accident · No injuriesData collectionFinal reportWard Christopher Barry RAI 6 · Williston, FLThe pilot’s failure to maintain the airplane’s pitch control during rotation and his subsequent loss of directional control.NTSB GAA17CA341Accident · No injuriesData collectionFinal reportCessna 172 · Galena, IDThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in a power-on stall and subsequent loss of airplane control.NTSB WPR17FA120Accident · 2 fatalField investigationFinal reportPiper PA 28-180 · Santa Rosa Valley, CAThe pilot's exceedance of the airplane's critical angle of attack while intentionally maneuvering in a steep bank at low altitude, which resulted in an accelerated aerodynamic stall and subsequent loss of control.NTSB GAA17CA381Accident · No injuriesData collectionFinal reportAeronca 7AC · Soldotna, AKThe pilot’s abrupt maneuver to avoid a moose cow and calf during taxi, which resulted in an impact with a tree.NTSB CEN17WA193Accident · 1 fatalForeign investigationQuicksilver GT500 · Barcelona, SpainOn May 20, 2017, at 1000 local time, a Quicksilver GT-500, EC-BQ3, impacted terrain after making a steep left turn during takeoff from Gurb Aerodrome in Barcelona, Spain. The aircraft was destroyed, and the pilot was fatally injured. The flight was being…NTSB WPR17FA101Accident · 2 fatalField investigationFinal reportIcon A5 · Lake Berryessa, CAThe pilot's failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot's mistaken entry into a canyon surrounded by steep rising terrain while at a low altitude for reasons that could not be…NTSB GAA17CA167Accident · No injuriesData collectionFinal reportEurocopter EC130 · Las Vegas, NVThe pilot's abrupt cyclic/pitch attitude control movement, which resulted in a Fenestron ground strike.NTSB GAA17CA162Accident · No injuriesData collectionFinal reportCessna T337 · Linden, NJThe pilot’s abrupt maneuver to avoid birds during short final approach, which resulted in a hard, bounced landing.