NTSB investigations, 2017
283 cases where the sequence of events included Loss of control in flight.
Cases, newest first
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 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."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 CEN18FA001Accident · 1 fatalField investigationFinal reportBrantly B 2B · Midland, MIThe pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…NTSB GAA17CA562Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · Fullerton, CAThe pilot under evaluation’s failure to maintain adequate airspeed during a simulated hydraulic failure, which resulted in a loss of helicopter control. Contributing to the accident was the check pilot’s delayed remedial action.NTSB GAA17CA557Accident · Minor injuriesData collectionFinal reportBellet James J Vans RV 8 · Orange, MAThe pilot's failure to remove the engine cowl plugs during preflight, which resulted in excessive engine cylinder head temperatures during climb and a total loss of engine power.NTSB CEN17FA364Accident · 2 fatalField investigationFinal reportBeech C35 · Camden, ARThe pilot's improper decision to return to the runway instead of landing straight ahead when the engine lost power and his failure to maintain adequate airspeed while maneuvering for an emergency landing, which resulted in an exceedance of the airplane's…NTSB CEN17FA362Accident · 1 fatalField investigationFinal reportMitsubishi MU 2B-40 · Ainsworth, NEThe pilot's loss of airplane control due to spatial disorientation.NTSB CEN17FA361Accident · 3 fatalField investigationFinal reportCessna TR182 · Thief River Falls, MNThe noninstrument-rated pilot's decision to depart into instrument meteorological conditions, and his subsequent loss of control due to spatial disorientation.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 GAA17CA555Accident · No injuriesData collectionFinal reportGodwin Jeff E Safari · Fayetteville, NCThe student pilot’s failure to maintain lateral control during a hover pedal turn.NTSB ERA17FA330Accident · 1 fatalField investigationFinal reportCessna 150G · Rhine, GAThe student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.NTSB CEN17WA360Accident · 2 fatalForeign investigationVans RV4 · Stafsberg, NorwayOn September 19, 2017, at 1450 UTC, a Vans Aircraft RV-4, experimental, amateur-built airplane, Norwegian registration LN-ABF, impacted terrain near the Hamar Airport (ENHA), Stafsberg, Norway. The pilot and passenger on board were fatally injured and the…NTSB GAA17CA556Accident · No injuriesData collectionFinal reportCessna 172 · Gallatin, TNThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA540Accident · No injuriesData collectionFinal reportCessna 172 · Lynchburg, VAThe pilot's unstabilized approach, which resulted in an aborted go-around, an aerodynamic stall, and a hard landing.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 CEN17FA354Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Glenwood Springs, COThe non-instrument-rated pilot's inadequate preflight weather planning, his decision to depart into forecast instrument meteorological conditions along the route of flight, and his continued visual flight into instrument meteorological conditions, which…NTSB CEN17WA353Accident · 2 fatalForeign investigationMooney M 20K · Braunwald, SwitzerlandNTSB GAA17CA530Accident · Minor injuriesData collectionFinal reportCessna 172 · Plainville, CTThe pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.NTSB CEN17LA375Accident · No injuriesLimited investigationFinal reportHiller UH 12A · Griffith, INThe loss of tail rotor thrust due to a failed tail rotor driveshaft, which resulted in a loss of tail rotor control and a hard landing.NTSB GAA17CA528Accident · No injuriesData collectionFinal reportCessna 152 · Broomfield, COThe student pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB GAA17CA567Accident · No injuriesData collectionFinal reportChancey Gerry M RV-12 · Dunkirk, NYThe pilot's failure to maintain lateral/bank control during takeoff in crosswind conditions.NTSB ERA17FA313Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Jacksonburg, WVThe pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions in the vicinity of adverse weather conditions.NTSB CEN17RA337Accident · 2 fatalForeign investigationCessna U206 · San Jose, Costa RicaimportNTSB GAA17CA517Accident · No injuriesData collectionFinal reportJeff Jardine Kitfox S7 Supersport · Kanab, UTThe pilot's failure to maintain directional control during landing and the airplane’s subsequent failure to attain a climb rate during an attempted go-around in high-density altitude conditions.NTSB ERA17WA318Accident · 2 fatalForeign investigationCessna 172 · Hekpoort, South AfricaOn September 3, 2017, about 0930 coordinated universal time, a Cessna 172M, South African registration ZS-JDN, was destroyed when it impacted a valley in the Magaliesberg Mountain range, near Hekpoort, South Africa. The two commercial pilots were fatally…NTSB WPR17LA195Accident · 1 fatalLimited investigationFinal reportWalker Edgar E Glastar · Cascade, IDThe pilot's inadequate flight planning, preparation, and navigation, which resulted in the airplane entering a canyon that the pilot was unable to exit by climbing the airplane. Also causal were his in-flight decision-making and his execution of the course…NTSB GAA17CA545Accident · No injuriesData collectionFinal reportDedeaux Gary G GN-1 · Elba, ALThe pilot's incorrect pitch control during the initial climb, which resulted in his decision to abort the takeoff and a subsequent hard landing.NTSB GAA17CA518Accident · No injuriesData collectionFinal reportCroft Robert C Kitfox Super Sport · Afton, WYThe pilot’s failure to maintain bank control during an attempted go-around.NTSB ERA17LA312Accident · No injuriesLimited investigationFinal reportPiper PA28 · Lyndonville, VTThe pilot's loss of airplane control during takeoff.NTSB ANC17LA051Accident · No injuriesClass 3 · LimitedFinal reportLeonardo AW139 · Tujunga, CAA yaw excursion and uncontrolled descent due to loss of tail rotor effectiveness during aerial firefighting operations resulting in an impact with trees. A contributing factor was the pilot’s failure to maintain sufficient airspeed, coupled with a quartering…NTSB CEN17FA334Accident · 1 fatalField investigationFinal reportVans RV-12 · Fishers, INThe pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.NTSB GAA17CA513Accident · Minor injuriesData collectionFinal reportCessna 172 · Belle Fourche, SDThe flight instructor's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB GAA17CA514Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Sacramento, CAThe student pilot’s failure to maintain yaw control and the flight instructor’s delayed remedial action.NTSB GAA17CA519Accident · No injuriesData collectionFinal reportPiper J5A · Springfield, VTThe pilot's unstabilized approach, which resulted in landing long and fast, and his subsequent failure to maintain clearance from trees during a go-around.NTSB ERA17LA297Accident · 1 fatalLimited investigationFinal reportTukan Trike · Nicholasville, KYThe noncertificated pilot's failure to maintain control of the weight-shift-control aircraft during takeoff.NTSB GAA17CA507Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Hillsboro, ORThe student pilot’s failure to maintain airplane control while landing in crosswind conditions and the flight instructor’s delayed remedial action.NTSB ANC17FA049Accident · 1 fatalField investigationFinal reportPiper PA-18AS · Tyonek, AKThe noninstrument-rated pilot's decision to initiate a visual flight rules flight into dark night, marginal visual flight rules to instrument flight rules conditions, which resulted in a loss of control due to spatial disorientation.NTSB WPR17LA186Accident · Minor injuriesLimited investigationFinal reportHawker Siddeley Hunter MK.58 · Pacific Ocean (Pacific Ocean)The pilot’s loss of airplane control after flying through another airplane's jet wash during an air defense exercise.NTSB CEN17WA325Accident · 2 fatalForeign investigationAviat Pitts S-2B · Holmestrand, NorwayOn August 22, 2017, at 1025 hours universal coordinated time, an Aviat Pitts S-2B, Norwegian registration LN-PTS, impacted the terrain following a loss of control while performing aerobatic maneuvers near Holmestrand, Norway. The pilot and passenger were…NTSB CEN17LA327Accident · Minor injuriesLimited investigationFinal reportGreene R/Greene S Rans S 17 · Erie, COThe pilot's failure to maintain control following a rejected takeoff for a perceived loss of engine power. Contributing to the accident was the pilot's lack of training and experience in the airplane.NTSB ERA17WA289Accident · 5 fatalForeign investigationLearjet 25 · Naiguata, VenezuelaOn August 19, 2017, about 0415 universal coordinated time, a Learjet 25D, Venezuelan registration YV3191, descended and impacted the ocean about 5 nautical miles north of Naiguatá, Vargas, Venezuela. The two pilots and three passengers were fatally injured.…NTSB GAA17CA494Accident · No injuriesData collectionFinal reportAerotechnik L 13 SEH Vivat · Moses Lake, WAThe pilot's improper takeoff configuration due to his failure to follow the pretakeoff checklist, which resulted in a loss of lift and collision with obstacles.NTSB CEN17WA320Accident · 1 fatalForeign investigationPiper PA36 · Vejer de la Frontera, SpainOn August 15, 2017, a Piper PA-36-375 airplane (EC-EHB, s/n 36-8102001) impacted terrain during fumigation operations in the vicinity of Vejer de la Frontera, Spain. The pilot was fatally injured.This investigation is under the jurisdiction and control of the…NTSB GAA17CA491Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Westby, WIThe pilot's failure to see and avoid power lines while maneuvering at low altitude.NTSB GAA17CA488Accident · Minor injuriesData collectionFinal reportCharles D Walker Walker Curtiss JN4D · Bowling Green, KYThe pilot’s exceedance of the biplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall and collision with trees.NTSB ERA17FA274Accident · 2 fatalField investigationFinal reportBell 407 · Charlottesville, VAThe pilot's loss of helicopter control after entry into vortex ring state, leading to a high rate of descent to the ground with a right spin. Contributing to the accident was the pilot's lack of recent and recurrent training in vortex ring state recognition…NTSB CEN17LA359Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Raton, NMThe pilot's failure to maintain a proper descent rate, which resulted in a bounced landing, and his subsequent failure to attain a proper airspeed during an attempted go-around in shifting wind conditions, which resulted in an aerodynamic stall.NTSB ERA17LA269Accident · Serious injuriesLimited investigationFinal reportRose Herbert D Pietenpol AIR Camper · Tower City, PAThe pilot's incapacitation due to fainting as a result of complications from a previously undiagnosed heart condition.NTSB CEN17LA307Accident · 2 fatalLimited investigationFinal reportPegasus Quantum · Fort Atkinson, WIThe student pilot's failure to maintain aircraft control during a go-around, which resulted in impact with water. Contributing to the accident was the non-instructor sport pilot's decision to allow the student pilot to fly the aircraft.NTSB CEN17LA304Accident · Serious injuriesLimited investigationFinal reportRoger M Allen RA2 · Hector, MNThe pilot’s improper installation of the control stick hardware, which resulted in a loss of elevator control in flight.NTSB GAA17CA465Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Salisbury, NCThe physical interference of the student pilot’s headset control unit with the canopy, which prevented the canopy latches from seating properly and resulted in the canopy opening in flight and the subsequent hard landing.NTSB CEN17LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Marshall, MOThe pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…