NTSB investigations, GA
49 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 3 |
| 2014 | 5 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 5 |
| 2018 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2024 | 2 |
| 2025 | 1 |
Where
Open the mapLatest cases
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\" = '241' 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" = '241' 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 ERA25FA151Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · LaFayette, GAThe pilot’s exceedance of the airplane’s critical angle of attack while landing and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB ERA24FA221Accident · 1 fatalClass 3 · FieldFinal reportRadley Vincent Quicksilver Sport 2S · Cleveland, GAThe pilot’s failure to maintain control of the airplane during the takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin at low altitude. Contributing to the accident was the pilot’s lack of…NTSB ERA24FA206Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · Augusta, GAThe pilot’s excessive turn rate and bank angle while at low airspeed and altitude, resulting in an accelerated aerodynamic stall, loss of airplane control, and collision with terrain.NTSB ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.NTSB ERA22LA335Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Calhoun, GAThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in a loss of directional control, a runway excursion, and substantial damage to the airplane.NTSB ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA22FA050Accident · 1 fatalClass 3 · FieldFinal reportMooney M20F · Villa Rica, GAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin.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 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 GAA17CA283Accident · No injuriesData collectionFinal reportCessna 172 · Atlanta, GAThe student’s incorrect use of the go-around procedure, which resulted in an aerodynamic stall, and the flight instructor’s delayed remedial action.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 GAA17CA115Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Bainbridge, GAThe student pilot's exceedance of the airplane’s critical angle of attack during final approach, which resulted in an aerodynamic stall, and his subsequent loss of directional control after touchdown.NTSB ERA17LA078Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Atlanta, GAThe pilot's exceedance of the airplane's critical angle of attack while attempting a short-field takeoff, which resulted in an aerodynamic stall.NTSB ERA17LA015Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Stockbridge, GAA partial loss of engine power due to a stuck exhaust valve and the pilot's exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA17CA004Accident · Serious injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 L · Fort Valley, GAThe failure of the aircraft’s right overcenter washout strut split ring, which resulted in the pilot’s inability to maintain lateral control of the aircraft and subsequent ground impact.NTSB 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 ERA16LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Savannah, GAThe pilot's inadequate preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and a total loss of engine power during approach. Contributing to the accident were the pilot’s failure to maintain adequate airspeed and his…NTSB ERA16FA005Accident · 1 fatalField investigationFinal reportPiper PA 38-112 · Jasper, GAThe student pilot's failure to accurately determine the airplane's fuel state, subsequent fuel exhaustion, and a total loss of engine power during initial climb. Contributing to the accident was the flight instructor's inadequate oversight of the student…NTSB ERA15FA359Accident · 5 fatalField investigationFinal reportBoatright Waylon RV10 · Alma, GAThe noncertificated pilot's decision to perform aerobatic maneuvers in his overweight, improperly-loaded airplane in dark night conditions at low altitude, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident…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 ERA15FA103Accident · 1 fatalField investigationFinal reportLuscombe 8 · Fort Valley, GAThe flight instructor’s failure to maintain airspeed during an approach with a simulated engine failure, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall/spin.NTSB ERA15LA075Accident · 1 fatalLimited investigationFinal reportJohnson David Earl Renegade Spirit · Brunswick, GAThe pilot's decision to fly the airplane with known engine deficiencies and his subsequent exceedance of the airplane's critical angle of attack following a loss of engine power, which resulted in an aerodynamic stall and loss of control after takeoff.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 ERA14LA316Accident · Serious injuriesLimited investigationFinal reportCzech Sport Piper Sport · Peachtree City, GAThe pilot's incomplete assessment of the risk presented by operating an airplane with an unresolved history of engine power losses; a partial loss of engine power during takeoff due to operation of the engine with an excessively rich fuel/air mixture; and the…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 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 ERA13CA250Accident · Minor injuriesData collectionFinal reportThomas David W Rans S-12 XL · Cleveland, GAThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of overall recent flight experience and lack of experience in make and model.NTSB DCA13IA058Incident · Minor injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Bowman, GAthe captain's inappropriate climb speed, his failure to monitor airspeed during the level off, and his inappropriate response to multiple stall warnings.NTSB ERA13LA015Accident · Serious injuriesLimited investigationFinal reportVelline'S Breezy RLU-1 · Madison, GAThe pilot’s failure to maintain airspeed following a loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the airplane’s…NTSB ERA12FA561Accident · 2 fatalField investigationFinal reportHall Don H RV-7 · Cumming, GAThe pilot’s failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and collision with terrain.NTSB ERA12FA513Accident · 1 fatalField investigationFinal reportMcleod Alan FW-190 1/2 Scale · Columbus, GAThe pilot’s failure to maintain airspeed while maneuvering following a partial loss of engine power. Contributing to the accident was the pilot’s decision not to land on the remaining runway ahead, and the partial loss of engine power due to carburetor ice.NTSB ERA12FA467Accident · 1 fatalField investigationFinal reportBrenholt Larry R RV-4 · Cedartown, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions and his failure to maintain airspeed while maneuvering for a forced landing, which resulted in an aerodynamic stall and collision with terrain.NTSB ERA12LA141Accident · 1 fatalLimited investigationFinal reportBowers Fly Baby 1-A · Jefferson, GAThe pilot’s failure to maintain airplane control which resulted in an aerodynamic stall and spin. Also causal was the partial loss of engine power during the initial climb due to the improper installation of a magneto. Contributing to the accident was the…NTSB ERA11CA337Accident · No injuriesData collectionFinal reportFlightstar Flightstar II-SL · Kingston, GAThe pilot's failure to maintain clearance from trees during low-altitude maneuvering flight.NTSB ERA11LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.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 ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB ERA10LA164Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Savannah, GAThe pilot's failure to maintain airspeed and inadvertent stall after takeoff.NTSB ERA10LA141Accident · Serious injuriesLimited investigationFinal reportLiberty Aerospace Liberty XL-2 · Brunswick, GAThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.NTSB ERA09LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Brinson, GAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA09LA203Accident · Serious injuriesLimited investigationFinal reportWayne O Robinson S6S Rans · Cartersville, GAThe pilot's failure to maintain airspeed following a partial loss of engine power during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was chafed wires in the ignition system.NTSB ERA09CA175Accident · No injuriesData collectionFinal reportCessna 172 · Reidsville, GAThe pilot's failure to maintain control of the airplane during an attempted recovery from a stall/spin.NTSB MIA08FA141Accident · 1 fatalField investigationFinal reportSocata TBM700 · Kennesaw, GAThe pilot’s failure to maintain airspeed during final approach resulting in an aerodynamic stall.NTSB NYC08LA235Accident · 1 fatalLimited investigationFinal reportLanier James A Talon XP · Cleveland, GAAn inadvertent stall during the initial climb.NTSB NYC08LA150Accident · Serious injuriesLimited investigationFinal reportHatle Rans S-12 · Rincon, GAThe pilot's failure to maintain airspeed during initial climb which led to an aerodynamic stall.