NTSB investigations, 2015
298 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\") = 2015
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") = 2015 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 ERA15FA340Accident · 3 fatalField investigationFinal reportBeech A36 · Kernersville, NCThe pilot's loss of airplane control due to spatial disorientation, which resulted in an aerodynamic stall/spin. Contributing to the accident was deficient Federal Aviation Administration air traffic control training on recognition and handling of…NTSB ERA15LA343Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 · Louisburg, NCThe propeller’s movement to the beta position during landing for reasons that could not be determined during postaccident examination and testing, which resulted in an attempted go-around and subsequent loss of airplane control.NTSB ERA15LA339Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Laconia, NHThe sport pilot’s improper decision to operate the weight-shift-control aircraft at low altitude and his subsequent failure to maintain control of the aircraft, which resulted in a subsequent collision with terrain.NTSB ERA15LA357Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Wilmington, NCThe pilot's improper loading of the airplane, which resulted in a sudden pitch up during the attempted takeoff, the pilot’s subsequent loss of directional control, and an aerodynamic stall.NTSB CEN15WA401Accident · 1 fatalForeign investigationCessna 150F · Brackley, United KingdomOn September 4, 2015, about 1110 coordinated universal time, a Cessna 150F airplane, G-ATKF, impacted terrain during takeoff at the Hinton in the Hedges Airfield, near Brackley, United Kingdom. The pilot was fatally injured and the airplane sustained…NTSB ERA15FA336Accident · 1 fatalField investigationFinal reportHenderson W A/Johnson W L RV 6A · Bon Aqua, TNThe pilot's incapacitation from complications of a recent heart attack, which resulted in a loss of control during cruise flight.NTSB GAA15CA243Accident · No injuriesData collectionFinal reportCessna 172 · New Enterprise, PAThe pilot's exceedance of the critical angle of attack during takeoff, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN15WA448Accident · 1 fatalForeign investigationPitts S2 · Friesach, AustriaOn August 30, 2015, about 1242 UTC, a Pitts S2B airplane, D-EZZT, (s/n 5327), impacted terrain while performing aerobatic maneuvers near Friesach, Austria. The airplane was destroyed and the pilot was fatally injured. This investigation is under the…NTSB CEN15FA388Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Kewanee, ILThe pilot's loss of control due to spatial disorientation shortly after takeoff into low instrument meteorological conditions.NTSB ERA15FA331Accident · 1 fatalField investigationFinal reportCornell W F/Sahakian J A JR Giles 202 (G202) · Newburgh, NYSeparation of the vertical and horizontal stabilizers from the fuselage due to a fracture that initiated at the bond between the left horizontal stabilizer and the flange that attached the horizontal stabilizer to the fuselage skin. The failure was likely…NTSB ERA15FA330Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Alabaster, ALAn in-flight loss of airplane control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN15FA386Accident · 1 fatalField investigationFinal reportBarrow Ted A ONE Easy · Battle Creek, MIThe pilot’s loss of airplane control due to his diverted attention to the canopy opening in flight.NTSB WPR15FA250Accident · 1 fatalField investigationFinal reportPiper PA 25 · Llano, CAThe pilot's loss of airplane control during the landing approach due to an incapacitating medical event.NTSB GAA15CA255Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Irwin, IDThe pilot's failure to maintain obstacle clearance during low level flight, which resulted in the airplane striking a wire, impacting water, and nosing over.NTSB GAA15CA239Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Susanville, CAThe pilot's failure to maintain airspeed control during the landing in gusty wind conditions, resulting in an abnormal runway contact, and collision with terrain.NTSB ERA15FA325Accident · 1 fatalField investigationFinal reportCessna 310R · Titusville, FLThe pilot's continued flight into known convective weather conditions, which resulted in the airplane's encounter with thunderstorms and the pilot's subsequent loss of airplane control during a missed approach. Contributing to the accident was the failure of…NTSB CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…NTSB ERA15LA379Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415 · Atlanta, GAThe pilot's loss of airplane control, which resulted in a hard landing.NTSB CEN15FA374Accident · 1 fatalField investigationFinal reportBeech 35 B33 · El Dorado, ARThe loss of engine power for reasons that could not be determined during postaccident examination of the accident site or based on the available information and the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical…NTSB CEN15FA378Accident · 1 fatalField investigationFinal reportCessna 172 · Martinville, ILThe non-certificated pilot's failure to maintain clearance from terrain.NTSB GAA15CA238Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Ronkonkoma, NYThe student pilot's loss of control during a hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor's lack of action to remediate the student pilot's control inputs and recover aircraft control.NTSB GAA15CA233Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Prescott, AZThe flight instructor's decision to turn the helicopter downwind during a hover taxi which resulted in an uncontrolled descent and impact with terrain.NTSB CEN15WA394Accident · 1 fatalForeign investigationPiper PA-34-220T · Newquay, United Kingdom, United KingdomOn August 17, 2015, about 1833 universal time (UTC), a Czech Republic registered Piper PA-34-220T, OK-OKD, sustained substantial damage during a go-around at the Newquay Cornwall Airport, Newquay, United Kingdom. The pilot was fatally injured. The…NTSB CEN15FA362Accident · 2 fatalField investigationFinal reportZenair CH 2000 · McAllen, TXThe flight instructor's loss of airplane control while departing in gusting wind conditions that were conducive to low-level wind shear.NTSB ERA15FA312Accident · 1 fatalField investigationFinal reportCessna T206H · West Caldwell, NJA loss of engine power due to a malfunction of the turbocharging system likely due to contaminated oil. Also causal were the pilot's decision to continue the takeoff although the airplane was not performing normally and his failure to maintain adequate…NTSB ERA15WA316Accident · 1 fatalForeign investigationRobinson R44 - II · Limpio, ParaguayOn August 14, 2015, about 0830 local time (1130 coordinated universal time), a Robinson R44 Raven II, designated A02 and operated by the Paraguayan National Police, was destroyed when it impacted terrain in Limpio, Paraguay, about 6 nautical miles northeast…NTSB ERA15CA317Accident · Minor injuriesData collectionFinal reportErcoupe 415 C · Fairmont, WVThe pilot's failure to maintain airspeed and his exceedance of the wing's critical angle of attack, which resulted in an aerodynamic stall and subsequent collision with terrain.NTSB WPR15FA241Accident · 2 fatalField investigationFinal reportCessna T182T · Oroville, WAThe pilot’s failure to maintain terrain clearance while maneuvering. Contributing to the accident was the pilots’ selection, for undetermined reasons, of a route different than the most commonly used route.NTSB GAA15CA221Accident · No injuriesData collectionFinal reportBell 47D1 · Clanton, ALThe student pilot's abrupt cyclic and collective inputs during the approach to land which resulted in abnormal runway contact and a subsequent tail boom strike by the main rotor blades.NTSB CEN15CA353Accident · Minor injuriesData collectionFinal reportRatte James Aventura II · Tyler, TXThe loss of airplane control during a go around, which resulted in impact with the water. Contributing to the accident was the pilot's lack of seaplane rating and inexperience in the accident airplane.NTSB CEN15LA344Accident · 1 fatalLimited investigationFinal reportErickson Larry D RAF 2000 GT · Humboldt, IAThe pilot’s loss of gyroplane control while maneuvering at low altitude.NTSB ANC15LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA 18-150 · Talkeetna, AKImpact with terrain during low-level cruise flight for reasons that could not be determined based on the available information.NTSB ERA15WA305Accident · 3 fatalForeign investigationCessna 402B · Vereda Guarigua Cajica, ColombiaOn August 8, 2015, 1505 UTC, a Cessna 402B, HK-4990, registered to and operated by AeroExpress, collided with terrain near Vereda Guarigua Cajica, Cundinamarca, Colombia. Visual meteorological conditions prevailed at the time and flight plan information is…NTSB CEN15LA359Accident · Serious injuriesLimited investigationFinal reportAeros Aeros 2 · Albuquerque, NMThe ultralight airplane’s encounter with a downdraft in mountainous terrain, which resulted in a descent into trees.NTSB CEN15LA343Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hartington, NEThe pilot’s decision to use an excessive, unapproved flap setting for takeoff, which significantly increased the induced drag and resulted in an aerodynamic stall when the airplane flew out of ground effect.NTSB ERA15FA298Accident · 1 fatalField investigationFinal reportMchugh Tony Kitfox Model 1 · Montrose, PAThe pilot's failure to maintain control of the airplane during final approach, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.NTSB ERA15FA297Accident · 4 fatalField investigationFinal reportPiper PA46 · Saranac Lake, NYThe pilot’s loss of airplane control during takeoff, which resulted from his impairment or incapacitation due to an acute cardiac event.NTSB GAA15LA217Accident · Minor injuriesLimited investigationFinal reportMD Helicopter 369E · Whitefish, MTThe pilot’s failure to maintain altitude and a level attitude while hovering over water at night during an external load operation, which resulted in the helicopter’s main rotor contacting the surface of the water.NTSB GAA15CA216Accident · No injuriesData collectionFinal reportCessna 150M · Ellijay, GAThe pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.NTSB CEN15WA349Accident · 1 fatalForeign investigationCessna 172F · La Blanca, GuatemalaOn August 4, 2015, at 1315 coordinated universal time, a Cessna 172F, Guatemalian registration TG-ZAB, operated by AFYCO S.A., was destroyed when it impacted the terrain near La Blanca, Guatemala, during an aerial application flight. The pilot was fatally…NTSB GAA15CA212Accident · Minor injuriesData collectionFinal reportMain Air Rapier · Reidsville, NCThe student pilot landed with variable wind conditions, which resulted in an in-flight loss of control and subsequent impact with terrain.NTSB CEN15LA335Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Virden, ILThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight and with a quartering tailwind.NTSB CEN15FA331Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Wilmot, ARThe pilot's inability to maintain control of the airplane as a result of incapacitation by drug effects or an acute cardiac event.NTSB CEN15LA329Accident · 1 fatalLimited investigationFinal reportO'Dell Aeromaster · Sulphur Springs, TXA total loss of engine power for reasons that could not be determined because postimpact damage precluded a thorough examination of the airplane. Contributing to the accident was the pilot's failure to maintain control following the loss of engine power,…NTSB CEN15FA328Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Milwaukee, WIThe pilot's improper pitch control during the landing, which resulted in the propeller striking the runway, and his failure to maintain adequate airspeed during the subsequent go-around, which resulted in the airplane exceeding its critical angle of attack…NTSB CEN15FA321Accident · 3 fatalField investigationFinal reportChristensen Steve Wheeler Express · Holland, MNThe pilot’s failure to maintain adequate airspeed during a high-pitch, steep right turn, which resulted in the exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall, loss of control, and impact with terrain. Contributing to…NTSB CEN15FA320Accident · 4 fatalField investigationFinal reportBeech M35 · Amery, WIThe pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.NTSB GAA15CA199Accident · Minor injuriesData collectionFinal reportNorton Claude C Tailwind W8 · Portales, NMThe pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack while maneuvering and a subsequent aerodynamic stall.NTSB GAA15CA198Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Eufaula, ALThe pilot's failure to maintain direction control during takeoff, and the pilot's failure to ensure that the canopy of the airplane was secured and locked prior to departure.NTSB ERA15CA307Accident · Minor injuriesData collectionFinal reportJohnny F Anderson Buckeye Dream Machin · Trenton, SCThe non-certificated pilot's inadequate preflight inspection, which resulted in a loss of directional control during takeoff, and collision with trees during the subsequent rejected takeoff.