NTSB investigations, 2024
59 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 80 |
|---|---|
| 2009 | 114 |
| 2010 | 75 |
| 2011 | 115 |
| 2012 | 88 |
| 2013 | 77 |
| 2014 | 87 |
| 2015 | 90 |
| 2016 | 91 |
| 2017 | 95 |
| 2018 | 106 |
| 2019 | 97 |
| 2020 | 62 |
| 2021 | 68 |
| 2022 | 79 |
| 2023 | 69 |
| 2024 | 59 |
| 2025 | 48 |
| 2026 | 30 |
Where
Latest 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 year(c.\"eventDate\") = 2024
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 year(c."eventDate") = 2024 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 CEN25LA058Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Smithville, TXA loss of engine power for undetermined reasons.NTSB ERA25FA066Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW24 · Vero Beach, FLOn December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…NTSB ERA25LA053Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Doylestown, PAThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with terrain and a parked airplane.NTSB WPR25FA020Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Las Cruces, NMThe pilot’s entry into an aerobatic maneuver at an altitude that was insufficient to complete a successful recovery, which resulted in an accelerated stall and impact with terrain.NTSB CEN25FA014Accident · 1 fatalClass 3 · FieldPreliminary reportRans S12 · Church Point, LAOn October 15, 2024, at 1514 central daylight time, a Rans S12S, N912RS, was involved in an accident near Church Point, Louisiana. The airline transport pilot sustained fatal injuries. The airplane was destroyed. The airplane was operated under Title 14 Code…NTSB ERA25LA004Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Parsonsburg, MDA total loss of engine power for reasons that were not determined.NTSB CEN24LA367Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lakeway, TXThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and loss of control during a go-around.NTSB ERA24FA391Accident · 1 fatalClass 3 · FieldFinal reportAviat S-1-11B · Chapmansboro, TNThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in the airplane entering an inverted flat spin at an altitude too low for recovery.NTSB CEN24LA363Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox IV 1200 Spdst · Cleburne, TXThe pilot’s failure to maintain aircraft control, which resulted in an aerodynamic stall and impact with terrain.NTSB ANC24LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · McKinley Village, AKThe pilot’s late decision to go-around, failure to maintain proper airspeed, and his exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB ANC24LA098Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with obstacles and a subsequent aerodynamic stall.NTSB ANC24FA092Accident · 1 fatalClass 3 · FieldFinal reportJon Bergstedt JP Flyer · Wasilla, AKThe installation of an improperly sized fuel line that did not allow for adequate fuel flow to the engine, resulting in a partial loss of engine power and collision with trees.NTSB ERA24FA371Accident · 4 fatalClass 3 · FieldFinal reportPiper PA28R · Vergennes, VTThe flight instructor’s failure to maintain control of the airplane, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall. Contributing to the accident was the flight instructor's failure to properly…NTSB WPR24FA298Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75L3 · Yacolt, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN24FA340Accident · 4 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Anderson, INThe pilot’s inadequate airspeed management during the missed approach which resulted in an inadvertent aerodynamic stall and loss of control at low altitude.NTSB CEN24LA334Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Shell Knob, MOThe pilot’s failure to maintain aircraft control and airspeed during final approach, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN24LA331Accident · No injuriesClass 4 · LimitedFinal reportLet L 33 Solo · Kingman, KSThe pilot’s loss of control on short final.NTSB ANC24FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18-150 · McGrath, AKThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.NTSB GAA24WA270Accident · 1 fatalClass 4 · ForeignPiper PA18 · Defford, United KingdomNTSB ANC24LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · King Salmon, AKThe pilot’s failure to maintain control during takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB CEN24FA305Accident · 1 fatalClass 3 · FieldFinal reportCessna 172F · Brazoria, TXThe pilot’s failure to attain adequate airspeed for takeoff, which led to the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident was the pilot’s failure to abort the takeoff after not maintaining directional…NTSB CEN24LA292Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Lewisville, TXThe pilot’s failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and impact with water. Contributing to the accident were crosswind gusts.NTSB WPR24LA273Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel Standard Libelle · Fields, ORThe glider’s encounter with a gusting wind and downdraft conditions, which resulted in exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a hard landing.NTSB CEN24FA278Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Oxford, INThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover.…NTSB CEN24LA281Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Mansfield, MOThe pilot’s failure to maintain control after takeoff, which resulted in an aerodynamic stall.NTSB WPR24LA243Accident · No injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Cottonwood, AZThe pilot’s low-speed, high-power maneuvering in high density altitude and near maximum gross weight, which resulted in an uncommanded right yaw due to a loss of tail rotor effectiveness and a subsequent hard landing.NTSB WPR24FA226Accident · 2 fatalClass 3 · FieldFinal reportChampion 7GCBC · Eatonville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees, which resulted in an aerodynamic stall.NTSB ERA24LA296Accident · Serious injuriesClass 4 · LimitedFinal reportMissoula Super Drifter · Lafayette, TNThe pilot's failure to maintain control of the airplane during a go-around in gusting wind conditions.NTSB WPR24FA225Accident · 1 fatalClass 3 · FieldFinal reportGame Composites GB1 Gamebird · Irwin, IDThe pilot’s decision to perform a spin maneuver at an altitude that was insufficient to complete a successful recovery and subsequent failure to properly arrest the spin, which resulted in a secondary stall and an impact with terrain.NTSB WPR24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV-12IS · Scappoose, ORThe pilot’s failure to remove the seat belt used as a flight control lock from the right control stick before takeoff, which resulted in a loss of control, an aerodynamic stall, and a collision with terrain during takeoff. Contributing to the accident was the…NTSB CEN24LA246Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Helm, MSThe pilot’s failure to maintain control, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN24LA230Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Litchfield, MIThe student pilot’s loss of control and the flight instructor’s delayed remedial reaction which resulted in a spin.NTSB CEN24FA228Accident · 2 fatalClass 3 · FieldFinal reportCessna 421 · Steamboat Springs, COThe pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.NTSB WPR24FA196Accident · 2 fatalClass 3 · FieldFinal reportLockheed 12A · Chino, CAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall at an altitude insufficient for recovery. Contributing to the accident was the pilot’s failure to ensure that the airplane was…NTSB ERA24FA261Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Siler City, NCThe flight instructor’s failure to maintain airplane control during a low-speed, low-altitude left turn after encountering an undetermined issue during takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB CEN24FA215Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Clinton, MIThe flight instructor’s failure to maintain airplane control while maneuvering for a forced landing. Contributing to the accident was the student pilot’s or flight instructor’s inadvertent positioning of the fuel selector valve between the Left Tank and Off…NTSB ERA24LA256Accident · Minor injuriesClass 3 · LimitedFinal reportZenith 701 · Ocala, FLThe pilot’s failure to maintain aircraft control and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin during an attempted go-around.NTSB CEN24LA216Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Perryton, TXThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level turn, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB WPR24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Santa Ynez, CAThe pilot’s failure to maintain airspeed which resulted in exceedance of the critical angle of attack and an aerodynamic stall/spin, with insufficient altitude for recovery. The student pilot’s exceedance of the critical angle of attack which resulted in a…NTSB ANC24LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 207A · Bethel, AKThe pilot’s improper short-field takeoff procedure, which resulted in an aerodynamic stall and subsequent hard landing.NTSB ERA24LA229Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T-1(Menasco Special) · Salisbury, MDThe pilot’s exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.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 CEN24FA188Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Godley, TXThe student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.NTSB WPR24FA150Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-18-150 · Thurlow, MTThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, resulting in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s distraction by his cell phone use while…NTSB CEN24LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Midland, TXThe pilot’s failure to maintain airplane control during a go-around in a gusting crosswind, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot’s lack of system knowledge regarding the operation of the…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 ERA24LA191Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TBM 850 · Raleigh, NCThe pilot’s decision to continue an unstabilized approach, which resulted in a bounced landing, and his failure to maintain proper airspeed and climb attitude after aborting the landing, which led to the airplane exceeding its critical angle of attack and…NTSB CEN24FA164Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy FG · Spicewood, TXThe pilot’s failure to properly configure the airplane during a go-around in gusting wind conditions, and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA24LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150L · Sussex, NJThe student pilot’s failure to maintain airplane control during a go-around attempt in a gusting left crosswind, resulting in an aerodynamic stall and collision with terrain.NTSB ERA24FA176Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-301 · Knoxville, TNThe pilot’s decision to depart into an area of instrument meteorological and icing conditions, which resulted in loss of airplane control and a subsequent in-flight breakup.