NTSB investigations, 2016
16 cases where NTSB found Sloped/uneven terrain.
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 17 |
| 2010 | 5 |
| 2011 | 12 |
| 2012 | 13 |
| 2013 | 10 |
| 2014 | 21 |
| 2015 | 16 |
| 2016 | 16 |
| 2017 | 18 |
| 2018 | 33 |
| 2019 | 36 |
| 2020 | 8 |
| 2021 | 12 |
| 2022 | 6 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 9 |
| 2026 | 4 |
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\") = 2016
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03021017'))
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") = 2016 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03021017')) 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 ERA16CA313Accident · No injuriesData collectionFinal reportBell Helicopter Textron Canada 429 · Rikers Island, NYThe pilot’s overcontrolling of the helicopter during an aborted slope landing from a hover, which resulted in a main rotor blade strike.NTSB GAA16CA450Accident · No injuriesData collectionFinal reportAirbus AS350 · Peach Springs, AZThe pilot's failure to maintain clearance from terrain while hover taxiing backward, resulting in the tail striking terrain.NTSB GAA16CA399Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Bird Island, MNThe pilot's diverted attention inside the cockpit and failure to maintain the airplane's altitude while maneuvering at a low altitude, resulting in an impact with terrain.NTSB GAA16CA391Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind HK 36 · Blanchester, OHThe pilot's failure to maintain directional control of the powered glider during the landing roll.NTSB GAA16CA384Accident · Minor injuriesData collectionFinal reportBoeing A75 · St. James, MOThe pilot's loss of control while performing an aerobatic maneuver resulting in an inadvertent spin and collision with trees and terrain.NTSB CEN16LA223Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Colorado Springs, COA hard landing on rough terrain due to a faulty deployment of the airplane’s airframe parachute system following a partial loss of engine power for reasons that could not be determined, because postaccident examination revealed no malfunctions or anomalies…NTSB GAA16CA318Accident · No injuriesData collectionFinal reportEurocopter EC120 · Ajo, AZThe pilot's decision to exit the helicopter with the engine and rotors turning and the selection of unsuitable terrain for a landing, which resulted in a roll over.NTSB GAA16CA316Accident · No injuriesData collectionFinal reportCessna 172 · Cornelia, GAThe student pilot's unnecessary pedal application and the flight instructor's delayed remedial action resulting in a loss of directional control, runway excursion and ground impact during the aborted landing.NTSB GAA16CA297Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Chireno, TXThe student pilot's selection of unsuitable terrain for landing, which resulted in the helicopter rolling over during landing, and substantial damage to the tail boom.NTSB CEN16LA219Accident · No injuriesLimited investigationFinal reportFlohr David J R 80 Tiger Moth · Decatur, TXA failure of the electric fuel boost pump, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB ANC16LA029Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802 · Fairbanks, AKThe pilot's inadequate preflight fuel planning, his reliance on the fuel flow indicator without verifying the initial fuel level input, and his improper decision to continue the flight with the low fuel light illuminated, which resulted in fuel exhaustion,…NTSB GAA16CA270Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Mack, COThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, impact with a ditch, and nose over.NTSB CEN16TA194Accident · No injuriesFinal reportNorth American AT6 · Mason, MIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and impact with a ditch.NTSB WPR16LA105Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Groveland, CAThe pilot's decision to conduct an upslope, downwind takeoff combined with an improper flap setting, which resulted in the airplane's inability to clear trees beyond the runway end. The reason for the improper flap setting could not be determined.NTSB CEN16FA087Accident · 1 fatalField investigationFinal reportPiper PA 22-108 · Garden City, TXThe pilot's failure to maintain clearance with terrain during a low altitude flight.NTSB ERA16LA082Accident · Minor injuriesLimited investigationFinal reportPilatus PC-12 · Savannah, GAThe pilots’ failure to follow proper procedures in response to a crew alerting system warning for high engine torque values, which necessitated an off-runway emergency landing during which the airplane sustained substantial damage due to postimpact fire.…