NTSB investigations, 2014
12 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\") = 2014
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") = 2014 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 WPR15FA062Accident · 1 fatalField investigationFinal reportPiper PA 18-150 · Ronan, MTThe pilot’s failure to maintain clearance from terrain while performing an intentional, abrupt low-level maneuver.NTSB WPR15TA002Accident · No injuriesFinal reportRockwell International 690B · Grass Valley, CAThe pilot’s unstabilized approach and failure to go around and his subsequent failure to maintain directional control during the landing roll.NTSB ERA14FA445Accident · 2 fatalField investigationFinal reportNorth American T 28C · Alton, VAThe pilot’s failure to maintain altitude while performing low-level aerobatic maneuvers, which resulted in collision with terrain. Contributing to the accident was the pilot’s improper decision to attempt aerobatics at such a low altitude.NTSB CEN14CA488Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Belen, NMThe student pilot's improper recovery from a bounced landing.NTSB CEN14CA409Accident · Minor injuriesData collectionFinal reportGlasflugel H 301 B Libelle · Brenham, TXThe pilot's attempt to maneuver away from power lines during a forced landing, which resulted in a collision with a tree and a fence.NTSB ANC14LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot’s failure to maintain directional control during the landing due to his decision to attempt a landing with a quartering tailwind, which resulted in a ground loop and impact with the runway surface.NTSB ERA14LA346Accident · 1 fatalLimited investigationFinal reportCessna 172N · Elliott Key, FLThe airplane’s vertical descent into water for reasons that could not be determined because postaccident airplane examinations revealed no mechanical anomalies.NTSB CEN14FA339Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51D · Durango, COThe pilot's failure to compensate for the high-performance airplane's tendency to enter a torque roll during the initial climb, which resulted in the airplane entering a torque roll and the subsequent loss of control at too low of an altitude to recover.…NTSB WPR14CA256Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe pilot's failure to maintain aircraft control while maneuvering for landing.NTSB WPR14LA233Accident · 1 fatalLimited investigationFinal reportNorth Wing Apache Sport · Polson, MTThe pilot’s loss of airplane control during initial climb due to his experiencing an incapacitating medical event.NTSB CEN14CA280Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus 3/24.5 · Wallis, TXThe pilot's failure to maintain direction control of the glider during takeoff in gusty wind conditions.NTSB WPR14FA183Accident · 2 fatalField investigationFinal reportCessna 150 - F · Santa Clara, UTThe flight instructor’s failure to arrest the airplane’s descent and maintain clearance from mountainous terrain while maneuvering at a low altitude.