NTSB investigations
3,842 cases where the defining event was 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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240') 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 c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '240') 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 GAA15CA292Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Lake City, COThe pilot's failure during takeoff to attain sufficient airspeed for conditions, and to maintain yaw control and a positive rate of climb, resulting in a loss of directional control, an uncontrolled descent, and collision with trees and terrain.NTSB CEN15LA428Accident · Serious injuriesLimited investigationFinal reportSukhoi SU-26 · Slidell, TXThe pilot's attempt to recover from an aerobatic maneuver at too low of an altitude to make a safe recovery.NTSB GAA15CA288Accident · No injuriesData collectionFinal reportCessna 305F · Bentonville, ARThe pilot's failure to maintain yaw control during a go-around, which resulted in a right main landing gear collapse and the right wing impacting terrain during a runway excursion.NTSB CEN15FA427Accident · 1 fatalField investigationFinal reportCessna 182 · Lexington, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a climbing turn, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.NTSB CEN15FA426Accident · 1 fatalField investigationFinal reportJones Ralph D Zodiac CH 601 HD · Ama, LAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack following a loss of engine power for reasons that could not be determined based on available evidence, which resulted in an aerodynamic stall and…NTSB GAA15LA296Accident · No injuriesLimited investigationFinal reportBell 206 · Ozark, ALThe pilot's failure to maintain clearance from terrain while hovering, which resulted in the helicopter's skid impacting terrain, subsequent abnormal airframe vibrations, and a hard landing during the subsequent hovering autorotation.NTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.NTSB WPR15LA265Accident · Serious injuriesLimited investigationFinal reportAero Commander 680 E · Boise, IDThe pilot's failure to maintain airplane control following an engine problem for reasons that could not be determined because postaccident examination of both engines and the rudder revealed no malfunctions or anomalies that would have precluded normal…NTSB ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…NTSB GAA15LA265Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Palmer, AKThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during final approach to landing, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA15CA272Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Sanford, NCThe student pilots failure to maintain a climb after takeoff, which resulted in an impact with terrain.NTSB ERA15LA367Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 19B · Saratoga Springs, NYThe pilot's failure to maintain glider control while attempting to land.NTSB ERA15FA361Accident · 1 fatalField investigationFinal reportCessna U206 · Spring Hill, FLThe pilot's failure to maintain a stabilized instrument approach, which resulted in a loss of control.NTSB ANC15FA071Accident · 3 fatalField investigationFinal reportDehavilland DHC 3T · Iliamna, AKThe pilot's decision to depart in dark night, visual meteorological conditions over water, which resulted in his subsequent spatial disorientation and loss of airplane control. Contributing to the accident was the pilot's failure to determine the airplane's…NTSB GAA15CA267Accident · No injuriesData collectionFinal reportCessna 180H · Delta Junction, AKThe pilot's failure to attain and maintain yaw control during the approach and attempted go around, which resulted in impact with trees and terrain.NTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.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 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 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 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 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 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 ERA15LA379Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415 · Atlanta, GAThe pilot's loss of airplane control, which resulted in a hard landing.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 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 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 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 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 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 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 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.