NTSB investigations, GA
118 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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' 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 GAA19CA099Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Jasper, GAThe student pilot's exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall, and the flight instructor's delayed remedial action.NTSB ERA19LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Barnesville, GAThe student pilot’s failure to maintain airplane control during takeoff and the flight instructor’s delayed remedial action, which resulted in an off-runway landing and subsequent collision with trees.NTSB ERA19FA049Accident · 1 fatalClass 2 · FieldFinal reportLancair Legacy RG · Gainesville, GAThe pilots’ failure to execute a go-around when the nighttime autopilot-coupled approach became unstable, which resulted in a loss of control and subsequent impact with terrain. Also causal was the flight instructor's inadequate supervision of the pilot and…NTSB ERA19LA037Accident · 1 fatalLimited investigationFinal reportCessna 150 · Woodstock, GAThe pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.NTSB ERA18FA149Accident · 1 fatalField investigationFinal reportTaylorcraft BC12 · Commerce, GAThe pilot's failure to effectively mitigate an accumulation of carburetor ice, which resulted in an undetected partial loss of engine power and an aerodynamic stall during takeoff.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 ERA17FA222Accident · 4 fatalField investigationFinal reportPiper PA23 · Chatsworth, GAThe noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…NTSB ERA17FA135Accident · 1 fatalField investigationFinal reportCessna 500 · Marietta, GAThe pilot's failure to maintain adequate airspeed while manually flying the airplane, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's inability control…NTSB ERA17FA118Accident · 1 fatalField investigationFinal reportCessna 421 · Canton, GAThe pilot's failure to maintain control of the airplane during a night visual landing approach. Contributing to the accident was the pilot's impairment due to his use of a combination of medications.NTSB ERA17FA106Accident · 2 fatalField investigationFinal reportBeech C23 · Winder, GAThe flight instructor's inadequate preflight planning and operation of the airplane outside its center of gravity envelope, which resulted in a loss of control while maneuvering.NTSB ERA17FA066Accident · 1 fatalField investigationFinal reportFairchild SA227 · Camilla, GAThe pilot's decision to initiate and continue the flight into known adverse weather conditions, which resulted spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.NTSB ERA17FA050Accident · 2 fatalField investigationFinal reportCurtiss JN4 · Williamson, GAThe in-flight failure of the propeller due to excessive engine vibration loads and the use of an incorrectly-sized propeller, which resulted in a fatigue crack of the leading edge strip. Contributing to the accident was the inadequate repair of the propeller…NTSB ERA17FA027Accident · 1 fatalField investigationFinal reportNanchang CJ6 · Blackshear, GAThe Bama 3 pilot's failure to properly conduct an overshoot maneuver and his premature climb before he was clear of the lead airplane, Bama 1, which lead to a midair collisionNTSB ERA16FA316Accident · 1 fatalField investigationFinal reportCessna A188 · Alapaha, GAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude during aerial application operations, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall and spin.NTSB ERA16CA314Accident · Minor injuriesData collectionFinal reportQuicksilver Manufacturing Sport 2S · Cleveland, GAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA16FA097Accident · 3 fatalField investigationFinal reportBrook Aaron D Lancair IV P · Albany, GAThe pilots' failure to maintain control during a takeoff attempt in a high-performance airplane. Contributing to the accident were the pilots' decision to operate the airplane above its maximum gross weight and with an aft center of gravity and their lack of…NTSB ERA16FA035Accident · 2 fatalField investigationFinal reportCessna 441 · Climax, GAThe pilot’s loss of airplane control due to spatial disorientation. Also causal to the accident was the pilot’s impairment by the combined effects of multiple medications and drugs.NTSB ERA16FA032Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Cornelia, GAThe pilot's decision to initiate the flight into known adverse weather conditions, which resulted in his spatial disorientation and loss of airplane control.NTSB ERA15LA379Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415 · Atlanta, GAThe pilot's loss of airplane control, which resulted in a hard landing.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 ERA15LA156Accident · 1 fatalLimited investigationFinal reportKolb Twinstar · Reynolds, GAThe student pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the student pilot's decision to operate…NTSB ERA15LA052Accident · Serious injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Williamson, GAThe pilot’s failure to maintain airspeed while maneuvering, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall at an insufficient altitude to fully recover before collision with obstacles and terrain.NTSB ERA15FA017Accident · 1 fatalField investigationFinal reportAeronca 7EC · Cordele, GAAn in-flight loss of control for reasons that could not be determined based on the available evidence.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 ERA14FA339Accident · 2 fatalField investigationFinal reportAllen Steen Skybolt · Carrollton, GAAn in-flight loss of airplane control for reasons that could not be determined during postaccident examinations or based on the available evidence.NTSB ERA14FA168Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Brunswick, GAAn inflight failure of the airplane's only operating vacuum pump, which resulted in the loss of attitude information provided by vacuum-driven flight instruments. Also causal was the pilots' failure to maintain control of the airplane while operating in…NTSB ERA14FA128Accident · 3 fatalField investigationFinal reportBeech 95-B55 · LaGrange, GAThe pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…NTSB ERA14LA137Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Macon, GAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern at low altitude in gusting wind. Contributing to the accident was the pilot’s improper decision to maneuver in the traffic pattern at a low altitude that did not allow…NTSB ERA14FA058Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Dawsonville, GAThe pilot’s in-flight loss of airplane control due to spatial disorientation while operating in dark night instrument meteorological conditions, which resulted in the exceedance of the airplane’s design stress limitations and a subsequent in-flight breakup.…NTSB ERA14FA002Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Tifton, GAThe noninstrument-rated pilot’s improper decision to continue visual flight rules flight into known instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA13CA417Accident · Serious injuriesData collectionFinal reportMiller/Culpepper Christen Eagle II · Blythe, GAThe pilot's failure to maintain aircraft control during takeoff which resulted in a stall and collision with terrain.NTSB ERA13LA252Accident · No injuriesLimited investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate preflight planning, which resulted in the airplane being loaded in excess of its maximum gross weight at an aft center of gravity for a takeoff with a quartering tailwind and high-density altitude conditions, all of which degraded the…NTSB ERA13CA150Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brunswick, GAThe pilot's failure to maintain directional control while landing in a strong, gusting crosswind.NTSB ERA13LA093Accident · 1 fatalLimited investigationFinal reportRussom Roy G Hummel H5 · Calhoun, GAThe pilot’s impairment or incapacitation due to the effects of medication, worsening cardiac disease, or cardiac arrhythmia, which resulted in his loss of control of the airplane.NTSB ERA13FA083Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Lake Park, GAThe noninstrument-rated pilot’s improper decision to depart in dark, night marginal visual flight rules conditions, which resulted in his spatial disorientation and subsequent loss of airplane control.NTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.NTSB ERA13CA009Accident · Minor injuriesData collectionFinal reportPowrachute Pegasus · Cumming, GAThe operation of the powered parachute by a non-certificated pilot, and his failure to maintain directional control during the initial climb, which resulted in a collision with trees.NTSB ERA12FA423Accident · 1 fatalField investigationFinal reportPiper PA-31P · Dalton, GAThe pilot’s failure to maintain airplane control following loss of power in the right engine for reasons that could not be determined because of fire and impact damage. Contributing to the accident was the pilot’s delayed feathering of the right propeller…NTSB ERA12LA386Accident · 1 fatalLimited investigationFinal reportBowen Christopher W Dogbee · Wrens, GAThe pilot’s loss of control during a low-altitude maneuver for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision…NTSB ERA12LA364Accident · 1 fatalLimited investigationFinal reportMoyes B/Bailey B Dragonfly · Trenton, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation and it could not be determined whether the…NTSB ERA12LA231Accident · 1 fatalLimited investigationFinal reportFirefly Balloons Firefly 8 · Fitzgerald, GAThe pilot's intentional flight into adverse weather. Contributing to the accident was the pilot's failure to obtain a weather briefing and his failure to follow the balloon manufacturer's published emergency procedure for weather deterioration during flight.NTSB ERA12FA057Accident · 1 fatalField investigationFinal reportEckenrode Carl J Vans RV-6 · Taylorsville, GAThe airplane's entry into an uncontrolled descent for reasons that could not be determined because postaccident examination of the airplane and the pilot’s medical history did not reveal any anomalies that would have precluded normal operation.NTSB ERA11LA416Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Hinesville, GAThe total loss of engine power due to the improper installation of the carburetor air filter by maintenance personnel, which resulted in the filter becoming dislodged and obstructing the carburetor. Contributing to the accident was the pilot did not maintain…NTSB ERA11FA406Accident · 1 fatalField investigationFinal reportMooney M20K · Augusta, GAThe pilot’s decision to fly the airplane after maintenance personnel advised him that the airplane should not be flown because the pilot provided an incorrect propeller for installation and the subsequent failure of the propeller attachment bolts and the…NTSB ERA11FA374Accident · 1 fatalField investigationFinal reportBinkley Richard Sonex · Calhoun, GAThe total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.NTSB ERA11CA343Accident · No injuriesData collectionFinal reportCessna 172S · Covington, GAThe pilot's failure to maintain directional control during takeoff.NTSB ERA11FA183Accident · 2 fatalField investigationFinal reportDehavilland DHC-6-100 · Hampton, GAThe pilot did not maintain airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB ERA11CA077Accident · Serious injuriesData collectionFinal reportAntares MA-33M R582 · Rising Fawn, GAThe student pilot's failure to relinquish control of the weight-shift control aircraft to the certified flight instructor, which resulted in an inadvertent stall.NTSB ERA11LA022Accident · 2 fatalLimited investigationFinal reportNewcomer RV6 · Monticello, GAThe pilot's loss of aircraft control during the initial climb.NTSB ERA11LA003Accident · Minor injuriesLimited investigationFinal reportYost Edwin S Glasair SH-2 · Jackson, GAThe pilot's loss of aircraft control for undetermined reasons.