NTSB investigations, 2014
311 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\") = 2014
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") = 2014 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 CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.NTSB WPR15CA009Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Mulino, ORA loss of aircraft control during approach for landing for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR15CA006Accident · No injuriesData collectionFinal reportMaule MX 7-235 · Big Creek, IDThe pilot's failure to maintain aircraft control while on final approach with shifting wind conditions.NTSB ERA15CA012Accident · No injuriesData collectionFinal reportSchweizer SGS 2 33A · Waynesboro, VAThe glider's inadvertent encounter with low altitude wind shear.NTSB CEN15LA021Accident · No injuriesLimited investigationFinal reportRaytheon 58 · Dixon, ILThe pilots’ improper decision to continue flight in icing conditions after the deicing boots could not shed accumulated ice, which resulted in a temporary loss of airplane control.NTSB CEN15FA003Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L 1 · Wichita Falls, TXThe pilot’s failure to maintain yaw control when he applied power to execute a go-around at a low airspeed in dark, night conditions, which resulted in a rapid, uncommanded right yaw due to a loss of tail rotor effectiveness.NTSB WPR14CA397Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Rancho Murieta, CAThe student pilot's failure to maintain adequate airspeed during takeoff and the certified flight instructors delayed remedial action, which resulted in the stall.NTSB ERA14LA462Accident · Serious injuriesLimited investigationFinal reportQuicksilver Eipper Acft GT 400 · Lebanon, CTThe pilot’s misjudgment of the takeoff distance needed to clear trees at the end of the runway.NTSB ERA14FA461Accident · 1 fatalField investigationFinal reportEagle R&D Helicycle · Gallatin, TNThe pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…NTSB WPR14FA393Accident · 1 fatalField investigationFinal reportTifft Kitfox III · Lake Stevens, WAThe pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…NTSB CEN14LA527Accident · 1 fatalLimited investigationFinal reportButcher Russell A RV9A · Shepherd, TXThe pilot’s loss of airplane control during the landing approach after a loss of engine power, which led to a collision with trees and terrain. Contributing to the accident was the pilot’s inadequate preflight fuel planning, which led to fuel exhaustion and…NTSB CEN14LA520Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Albuquerque, NMThe pilot's failure to maintain main rotor rpm during a pinnacle approach, which resulted in a loss of helicopter control and collision with terrain. Contributing to the accident was the pilot's decision to attempt the approach given the helicopter's weight…NTSB CEN14CA525Accident · No injuriesData collectionFinal reportBell 206B · Nashoba, OKThe pilot's loss of directional control due a loss of tail rotor effectiveness.NTSB ANC14CA086Accident · No injuriesData collectionFinal reportMiller Gregory S Bushwacker · Iliamna, AKThe pilot's failure to maintain control on landing, resulting in the collision with terrain.NTSB ERA14LA450Accident · Serious injuriesLimited investigationFinal reportBarger Jerry L Challenger II · Clarion, PAThe pilot's inadequate preflight planning, which resulted in a takeoff with the airplane's center of gravity aft of its limit and led the airplane to exceed its critical angle of attack and experience an aerodynamic stall during the initial climb.…NTSB CEN14LA507Accident · 2 fatalLimited investigationFinal reportManweiller Acro Sport II · Middletown, OHThe failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…NTSB ANC14CA087Accident · No injuriesData collectionFinal reportHelio H 250 · Arctic Village, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in an inflight collision with terrain during takeoff.NTSB ERA14FA455Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Fort Gaines, GAThe pilot’s failure to maintain airplane control during flight, which resulted in a collision with a river.NTSB ANC14CA083Accident · No injuriesData collectionFinal reportCessna 175 · Ambler, AKThe pilot's decision to takeoff from a rough airstrip in gusty wind conditions, which resulted in a loss of control.NTSB ANC14CA082Accident · Minor injuriesData collectionFinal reportHelio H 295 · Prospect Creek, AKThe pilot's loss of directional control during takeoff, in gusty and variable wind conditions, resulting in a collision with terrain.NTSB CEN14CA499Accident · Serious injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Newark, ILThe student pilot did not maintain proper airspeed during the simulated emergency landing and failed to relinquish control to the flight instructor when the flight instructor attempted to intervene, which resulted in the loss of control. Contributing was the…NTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.NTSB WPR14FA369Accident · 1 fatalField investigationFinal reportBackovich George C G P 5 · Reno, NVThe failure of the right wing under normal race loads due to an improper repair of the right wing spar that reduced its structural strength following a previous landing accident.NTSB CEN14CA490Accident · Serious injuriesData collectionFinal reportBuckeye Dream · Monee, ILThe pilot's failure to see and avoid power lines while maneuvering low to the ground, which resulted in a collision and loss of control.NTSB CEN14CA488Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Belen, NMThe student pilot's improper recovery from a bounced landing.NTSB CEN14LA485Accident · 2 fatalLimited investigationFinal reportCismowski Tierra II · Montevideo, MNThe pilot's impaired judgment due to the use of marijuana, which led to his improper decision to fly the airplane over its maximum gross weight and his subsequent loss of airplane control during takeoff with gusting wind conditions.NTSB WPR14TA370Accident · No injuriesFinal reportEurocopter AS 350 B3 · Lincoln, CAThe failure of the engine to provide sufficient power when commanded by the pilot during the power recovery phase of a practice autorotation for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or…NTSB WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.NTSB ANC14CA074Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Fairbanks, AKThe pilot's inability to maintain directional control of the airplane resulting in a runway excursion and collision with terrain.NTSB ERA14LA423Accident · 1 fatalLimited investigationFinal reportMcmurray David C Searey · Webb, NYThe pilot’s failure to maintain control of the amphibious airplane while practicing touch-and-go takeoffs and landings on a reservoir.NTSB WPR14CA363Accident · Serious injuriesData collectionFinal reportHughes 369D · Willows, CAThe pilot's failure to adequately secure cargo (a jacket), which resulted in the jacket exiting the cabin compartment and colliding with the tail rotor during cruise flight.NTSB ERA14LA418Accident · Serious injuriesLimited investigationFinal reportLorenz Stephen Kitfox Series 5 · Greene, NYThe pilot’s failure to attain adequate airspeed during the initial climb, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the…NTSB CEN14LA471Accident · Serious injuriesLimited investigationFinal reportBoring Robert Burton RV6A · Las Cruces, NMThe pilot’s failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing a stall/spin.NTSB CEN14CA532Accident · Minor injuriesData collectionFinal reportAirborne Edge X · Willow Springs, MOThe pilot's loss of control after the weight-shift-control aircraft encountered low-level wind shear shortly before touchdown. Also causal to the accident was the pilot's inadequate preflight weather assessment that failed to correctly determine the actual…NTSB CEN14CA481Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Plymouth, INThe sun glare and the pilot's subsequent loss of airplane control.NTSB ANC14CA072Accident · No injuriesData collectionFinal reportPiper PA 12 · Talkeetna, AKThe pilot's inadequate recovery from a bounced landing, resulting in a runway excursion and collision with trees.NTSB ERA14FA416Accident · 1 fatalField investigationFinal reportPiper PA-25-260 · St. Petersburg, FLThe pilot's improper deployment of the banner-tow hook, which resulted in it becoming entangled between the left elevator and horizontal stabilizer, restricted the movement of the elevator, and led to a loss of airplane control.NTSB WPR14LA361Accident · Serious injuriesLimited investigationFinal reportTravel Air C 4000 · Williams, CAThe failure of the elevator control tube due to corrosion, which resulted in a loss of elevator control and collision with terrain.NTSB CEN14CA469Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Granby, COThe pilot did not maintain control of the airplane during the go-around.NTSB WPR14LA356Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Gardnerville, NVThe pilot’s failure to monitor the environment and to maintain clearance from wires during takeoff.NTSB WPR14FA355Accident · 1 fatalField investigationFinal reportThomas C Sikes Loehle 5151 Mustang · Chehalis, WAThe pilot’s failure to maintain adequate airspeed during initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin. Contributing to the accident was that pilot’s psychiatric disease, which…NTSB ERA14CA410Accident · Minor injuriesData collectionFinal reportBertagna John Just Highlander · Birdsboro, PAThe pilot's improper landing flare and recovery from a bounced landing resulting in loss of aircraft control.NTSB ANC14CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Beluga, AKThe pilot's selection of an unsuitable takeoff area, resulting in an inflight collision with vegetation/brush during takeoff.NTSB CEN14LA458Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe pilot’s failure to maintain airplane control during takeoff. Contributing to the severity of the accident was the pilot’s retraction of the landing gear before establishing a positive climb rate, which resulted in a gear-up landing.NTSB CEN14LA456Accident · Minor injuriesLimited investigationFinal reportMaule MT 7-235 · Edon, OHThe pilot’s inability to maintain airplane control while attempting a precautionary landing after takeoff due to his incorrect setting of the rudder trim tab, which resulted in a significant turning tendency during flight.NTSB CEN14FA453Accident · 4 fatalField investigationFinal reportCessna 172R · Willoughby Hills, OHThe pilot's failure to maintain control of the airplane while returning to the airport immediately after takeoff, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall during the turn. Contributing to the…NTSB WPR14CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe student pilot's failure to maintain helicopter control during a practice hover. Contributing to the accident was the flight instructor's delayed remedial reaction.NTSB CEN14LA454Accident · 1 fatalLimited investigationFinal reportRans S17 · Lowell, MIThe pilot’s overconfidence, which led to his improper decision to continue flight in the recently purchased, unregistered airplane without acquiring training and to his continued erratic handling of the airplane and subsequent loss of airplane control.NTSB CEN14FA448Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Lago Vista, TXThe pilot's decision to fly at a low altitude and his subsequent failure to see and avoid the power lines.NTSB ANC14CA067Accident · Minor injuriesData collectionFinal reportCessna 175 · Talkeetna, AKThe pilot's selection of an unsuitable takeoff area, resulting in a loss of control and subsequent inflight collision with terrain during takeoff. Contributing to the accident was the pilot's failure to use the checklist, resulting in an improper propeller…