NTSB investigations
5,010 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 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 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 CEN15LA137Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Andrews, TXThe pilot's failure to note that icing conditions existed in the airport area despite having received that information in a preflight briefing, which resulted in his flight into an area of icing and the subsequent loss of airplane control due to ice…NTSB CEN15FA136Accident · 1 fatalField investigationFinal reportCessna 441 · Argyle, TXThe pilot's failure to maintain adequate airspeed during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin at a low altitude.NTSB CEN15FA135Accident · 1 fatalField investigationFinal reportPiper PA46 500TP · Lubbock, TXThe pilot's loss of airplane control due to spatial disorientation and light ice accumulation while operating in night, instrument meteorological conditions with gusting wind.NTSB CEN15LA131Accident · No injuriesLimited investigationFinal reportBell-Watson 47 G · North Little Rock, ARThe flight instructor’s failure to maintain adequate rotor rpm during the practice touchdown autorotation, which resulted in a subsequent loss of helicopter control and impact with terrain.NTSB WPR15CA094Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · La Verne, CAThe student pilot's loss of directional control during takeoff from a runway, which resulted in a collision with a sign.NTSB DCA15WA054Accident · 3 fatalForeign investigationHal Dhruv · Tena, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving an Ecuadorian Air Force Hal Dhruv helicopter, which occurred on January 27, 2015. The NTSB has appointed a U.S Accredited Representative to assist. All investigative…NTSB WPR15LA092Accident · 1 fatalLimited investigationFinal reportAlexander RV-7 · Seabeck, WAA loss of airplane control for reasons that could not be determined because the airplane impacted water, and the majority of the wreckage was not recovered.NTSB ERA15FA109Accident · 2 fatalField investigationFinal reportPiper PA-23 · Lakeland, FLAn in-flight loss of control for reasons that could not be determined during postaccident investigation; the loss of control likely occurred during a simulated loss of power in the right engine during an instructional flight.NTSB WPR15FA088Accident · 2 fatalField investigationFinal reportBeech 36 · Mountain Pass, CAAn in-flight loss of control for reasons that could not be determined based on available information.NTSB CEN15LA111Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Lowell, MIThe student pilot’s loss of airplane control during a go-around after not applying sufficient engine power.NTSB WPR15LA099Accident · No injuriesLimited investigationFinal reportBeech A36TC · Flagstaff, AZThe pilot's improper landing flare and loss of airplane control, which resulted in a hard landing and the subsequent failure of the nose landing gear.NTSB ERA15FA102Accident · 2 fatalField investigationFinal reportSchmidt Albert D Aventura II · Sebring, FLThe pilot's failure to maintain control while maneuvering at low altitude, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN15LA104Accident · 1 fatalLimited investigationFinal reportBaker Bobby J Safari · The Woodlands, TXAn in-flight separation of the helicopter’s horizontal stabilizer due to undetected fatigue cracking of the stabilizer spar, which resulted in a loss of control.NTSB ERA15CA101Accident · No injuriesData collectionFinal reportCessna 150L · Stow, MAThe flight instructor's delayed remedial action in response to the student pilot's improper go-around, which resulted in the airplane exceeding its critical angle of attack, experiencing an aerodynamic stall, and impacting a parked airplane.NTSB CEN15LA109Accident · No injuriesLimited investigationFinal reportCessna 182R · Santa Fe, NMThe pilot’s failure to remove ice from the airplane’s surfaces before departure, which resulted in the airplane’s inability to attain sufficient airspeed shortly after takeoff, the subsequent exceedance of the airplane’s critical angle-of-attack, and an…NTSB ERA15FA099Accident · 1 fatalField investigationFinal reportCessna 152 · New Smyrna Beach, FLThe pilot's failure to maintain control of the airplane while operating under visual flight rules (VFR) in night, instrument meteorological conditions, likely due to spatial disorientation. Contributing to the outcome was the radar controller's failure to…NTSB DCA15WA053Accident · Minor injuriesForeign investigationHal Dhruv · Guayaquil, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving a HAL Dhruvhelicopter, which occurred on January 13, 2015. The NTSB has appointed a U.S Accredited Representative to assist.All investigative information will be released…NTSB WPR15LA084Accident · 1 fatalLimited investigationFinal reportBruct J Myers RV-9A · Prineville, ORThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during the climb, which resulted in an aerodynamic stall/spin.NTSB ERA15FA096Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Catano, PRThe student pilot’s failure to maintain rotor rpm while maneuvering in the airport traffic pattern, which resulted in the helicopter’s uncontrolled descent to the water. Contributing to the accident was the student’s distraction with other aircraft operating…NTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…NTSB CEN15LA114Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pontiac, ILThe flight instructor’s loss of directional control during an attempted go-around with a crosswind. Contributing to the accident was the loss of engine power for reasons that could not be determined during examination of the engine.NTSB CEN15CA128Accident · Serious injuriesData collectionFinal reportBurton Calidus · Grand Junction, COThe pilot's failure to maintain clearance with terrain that was along the planned route of flight.NTSB CEN15LA098Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Parker City, INThe pilot’s loss of airplane control while troubleshooting an engine issue in instrument meteorological conditions, which resulted in impact with trees and terrain.NTSB ERA15CA118Accident · No injuriesData collectionFinal reportDayton A Babcock Storm · Eustis, FLThe pilot's failure to maintain adequate spacing from the preceding aircraft during a formation landing, resulting in an inadvertent "prop wash" encounter, loss of control, and impact with terrain.NTSB ERA15CA089Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Barranquitas, PRThe pilot's failure to maintain control of the helicopter while landing which resulted in a tailrotor ground strike and collision with terrain.NTSB WPR15CA073Accident · Minor injuriesData collectionFinal reportCessna 140 · Yuma, AZThe pilot's failure to compensate for crosswind conditions during takeoff, which resulted in the loss of directional control and collision with terrain.NTSB ERA15LA087Accident · No injuriesLimited investigationFinal reportMDS Fying Zenith Zodiac CH 650 · Fort Pierce, FLThe inadequate modification of the airplane’s canopy latching mechanism, which resulted in the inadvertent opening of the canopy while on final approach to land and a subsequent loss of pitch control.NTSB CEN15FA088Accident · 1 fatalField investigationFinal reportPiper PA 23-160 · Port Clinton, OHThe pilot's loss of control following a loss of left engine power for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.NTSB CEN15FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Port Huron, MIThe pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.NTSB CEN15FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Odessa, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at an excessive bank angle at a low altitude, which resulted in an accelerated stall and spin with insufficient altitude for a recovery.NTSB WPR15LA067Accident · Serious injuriesLimited investigationFinal reportFarthing James W II Beaver · Perris, CAThe partial loss of engine power during takeoff due to an improperly configured carburetor and fuel supply system. Contributing to the accident was the pilot's loss of airplane control during the off-field landing, which resulted in an aerodynamic stall.NTSB WPR15CA066Accident · No injuriesData collectionFinal reportFerdon Thorp T 18 · San Rafael, CAThe pilot's delayed decision to abort the takeoff. Contributing to the accident are an inadequate modification to the seat position, and the pilot's failure to check flight controls for freedom and correct movement.NTSB CEN15FA081Accident · 1 fatalField investigationFinal reportBeech V35A · Seagoville, TXThe pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.NTSB CEN15WA113Incident · No injuriesForeign investigationSaab-Scania Saab 2000 · Sumburgh, United KingdomOn December 15, 2014, about 1955 coordinated universal time, a SAAB-Scania SAAB 2000 airplane, G-LGNO, lost elevator control following a lightning strike on approach to Sumburgh Airport, Sumburgh, United Kingdom. The damage to the airplane is unknown. The…NTSB WPR15CA059Accident · Serious injuriesData collectionFinal reportCessna 182T · Wendover, UTThe pilot's failure to maintain situational awareness during a turn which resulted in a loss of airplane control.NTSB DCA15WA031Accident · No injuriesForeign investigationBeech F33 - A · Krugersdorp, South AfricaNTSB DCA15MA029Accident · 6 fatalClass 1 · MajorFinal reportEmbraer EMB-500 · Gaithersburg, MDthe pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…NTSB CEN15LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Collins, COThe student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…NTSB ERA15FA066Accident · 1 fatalField investigationFinal reportPiper PA28 · Sommerville, TNThe noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…NTSB ERA15CA064Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Athens, ALThe pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.NTSB CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.NTSB CEN15LA062Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Addison, TXThe pilot's failure to maintain directional control during landing with a gusting crosswind, which resulted in a hard landing adjacent to the runway.NTSB CEN15FA060Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boonville, MOThe pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…NTSB DCA15WA030Accident · 4 fatalForeign investigationRobinson R44 - II · Dar es Salaam, TanzaniaNTSB WPR15FA049Accident · 1 fatalField investigationFinal reportCessna 170B · Alzada, MTThe pilot's failure to maintain airplane control while maneuvering, which resulted in a collision with mountainous terrain.NTSB WPR15CA069Accident · No injuriesData collectionFinal reportCessna 172M · ObyanThe student pilot's loss of airplane control during the landing flare in gusting wind conditions.NTSB ERA15CA059Accident · No injuriesData collectionFinal reportHiller OH 23B · Leesburg, VAA loss of tail rotor effectiveness while hovering in gusting crosswind conditions resulting in the student pilot's loss of control of the helicopter. Contributing was the delayed remedial action of the flight instructor.NTSB CEN15LA059Accident · 1 fatalLimited investigationFinal reportRoss H/Herriott M Vans Aircraft RV 3 · Las Cruces, NMThe pilot’s failure to maintain airplane control, which resulted in a stall/spin. Contributing to the accident was the pilot’s failure to obtain adequate familiarization in the accident airplane type before the accident.NTSB WPR15CA047Accident · No injuriesData collectionFinal reportCessna 182Q · San Luis Obispo, CAThe pilot's failure to maintain airplane control during the landing flare with a crosswind.NTSB CEN15FA048Accident · 1 fatalField investigationFinal reportAero Commander 500 B · Chicago, ILThe pilot's failure to maintain airspeed while attempting to return to the airport after a reported engine problem, which resulted in an aerodynamic stall/spin.