NTSB investigations
866 cases where the defining event was Aerodynamic stall/spin.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '241') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '241') 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 WPR23FA247Accident · 1 fatalClass 3 · FieldFinal reportCessna 172N · Murrieta, CAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the loss of control was the pilot’s sudden retraction of the flaps.NTSB ERA23FA280Accident · 5 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · North Myrtle Beach, SCThe pilot’s loss of control during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s operation of the airplane above its maximum gross weight and near its aft center of gravity limit,…NTSB ANC23LA048Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-210C · Prospect Creek, AKThe pilot’s exceedance of the airplane’s critical angle of attack on climbout, which resulted in a loss of control and impact with trees.NTSB WPR23LA242Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe premature retraction of the flaps by the student pilot, while just above the airplane’s stall speed. Contributing to the accident was the flight instructor’s inadequate supervision and failure to regain aircraft control from the student pilot.NTSB CEN23LA331Accident · Minor injuriesClass 4 · LimitedFinal reportDavid Brown/U Balldin/T Morgan Zenith Stol CH701 · Arnaudville, LAThe pilot’s failure to maintain airspeed resulting in exceeding the airplane’s critical angle of attack and an aerodynamic stall. The low altitude at which the flight was conducted contributed to the outcome.NTSB CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN23LA254Accident · Serious injuriesClass 3 · LimitedFinal reportLet L-23 Super Blanik · Gregory, MIThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack, leading to an aerodynamic stall during the off-field landing.NTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.NTSB ERA23FA260Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Colonial Beach, VAThe pilot’s failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB WPR23LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Prescott, AZThe pilot’s improper landing flare, which resulted in an aerodynamic stall. Contributing to the accident was his delayed decision to initiate a go-around.NTSB CEN23LA216Accident · No injuriesClass 4 · LimitedFinal reportRemos G-3/600 · Sugar Grove, ILThe student pilot’s improper flight control inputs and the flight instructor’s delayed remedial action during takeoff, which resulted in a runway excursion and impact with terrain.NTSB WPR23FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna T182T · Albany, WYThe pilot’s decision to conduct flight into an area of icing in an airplane that was prohibited from such conditions, which resulted in exceedance of the airplane’s critical angle of attack, an aerodynamic stall/spin, and the pilot’s spatial disorientation…NTSB WPR23FA173Accident · 3 fatalClass 3 · FieldFinal reportBeech A36 · Big Bear, CAThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed on short final while operating in adverse wind conditions, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.NTSB WPR23LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna T337G · Upland, CAThe pilot’s failure to properly flare the airplane, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to fly a nonstandard traffic pattern, which resulted in an unstable approach.NTSB ERA23LA207Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26E · Wake Forest, NCThe student pilot’s failure to maintain airspeed during the landing approach, which resulted in an exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a loss of control.NTSB ERA23LA196Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Gilford, NHThe pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with the runway.NTSB ERA23LA195Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Spatz RV-14A · Fallston, MDThe pilot’s failure to discontinue an unstabilized approach, resulting in an aerodynamic stall and collision with terrain.NTSB ERA23FA185Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Sebastian, FLThe pilot’s failure to maintain airplane control during recovery from a bounced landing, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN23LA128Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac 601XL · La Veta, COThe pilot’s decision to fly the airplane in which he had no experience in strong, gusting wind, which resulted his failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB WPR23FA110Accident · 2 fatalClass 3 · FieldFinal reportWillman Loren LOREN'S Aircam · Grass Valley, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB ANC23LA009Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 77 · Lihue, HIThe airplane’s exceedance of its critical angle of attack after encountering a downdraft during departure, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN23LA061Accident · Minor injuriesClass 3 · LimitedFinal reportOrlican S R O M-8 Eagle · St. Louis, MOThe pilot’s failure to maintain adequate airspeed/angle-of-attack during the landing approach, which resulted in an aerodynamic stall and hard landing.NTSB WPR23LA018Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-60 · Herlong, NVThe pilot's failure to maintain adequate separation during a formation flight, which resulted in an encounter with wake turbulence, an aerodynamic stall, and collision with terrain.NTSB ERA23LA020Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100 · New Smyrna Beach, FLThe pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight.NTSB ERA23LA010Accident · Serious injuriesClass 4 · LimitedFinal reportGreen L/Gilner D RV-4 · Rowlesburg, WVThe pilot's failure to maintain an appropriate airspeed/angle-of-attack during the landing approach, which resulted in an aerodynamic stall, and impact with terrain.NTSB ERA23FA008Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newport News, VAThe flight instructor’s failure to monitor the student pilot on takeoff and her delayed remedial action to stop him from exceeding the airplane’s critical angle of attack, which resulted in a low altitude aerodynamic stall from which she was unable to recover.NTSB CEN23LA007Accident · No injuriesClass 4 · LimitedFinal reportWaszak Arthur B Wittman Tailwind W10 · Waldron, ARThe pilot’s failure to maintain adequate airspeed during the landing resulting in an inadvertent aerodynamic stall and hard landing.NTSB ERA22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Winterville, NCThe student pilot’s improper recovery from a bounced landing. A factor in the accident was the instructor’s delayed remedial action which resulted in an inability to recover the airplane from an aerodynamic stall.NTSB ERA22FA426Accident · 2 fatalClass 3 · FieldFinal reportChampion Aeronca 7AC · Bridgeton, NJThe pilot's exceedance of the airplane’s critical angle of attack shortly after takeoff, which resulted in an aerodynamic stall, loss of control, and impact with terrain.NTSB GAA22WA284AccidentClass 5 · ForeignPiper PA 46-350P · Glisy, FranceNTSB GAA22WA295AccidentClass 5 · ForeignKodiak 100 · Rendsburg-Schachtholm, GermanyNTSB WPR22FA332Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Galt, CAThe certified flight instructor's failure to maintain control of the airplane and inadequate supervision of the flight, which resulted in an aerodynamic stall/spin from which he could not recover.NTSB ANC22LA072Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Point MacKenzie, AKThe pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.NTSB ERA22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportSutphin John E Rans S-12 · Hilliard, FLThe pilot’s failure to maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA22LA393Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Bennington, VTThe pilot’s failure to maintain airspeed during a go-around, resulting in an aerodynamic stall, loss of control, and collision with terrain.NTSB ERA22FA391Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7AC · Jacksboro, TNThe pilot's exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control.NTSB ERA22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Cynthiana, KYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to land with approaching convective activity.NTSB ANC22LA063Accident · Serious injuriesClass 4 · LimitedFinal reportDe Havilland DHC2 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in the wing exceeding its critical angle of attack, a loss of control and impact with the water.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 ERA22LA332Accident · Serious injuriesClass 4 · LimitedFinal reportWhitten Robinson Aventura II · Meritt Island, FLThe pilot’s failure to maintain control of the airplane during final approach to land, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and collision with a fence and terrain.NTSB CEN22LA321Accident · 2 fatalClass 3 · LimitedFinal reportJust Highlander · Bennington, OKThe pilot’s exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall and loss of control.NTSB CEN22LA325Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 305A · Mc Kinney, TXThe failure of the pilot to maintain adequate airspeed during landing resulting in an inadvertent aerodynamic stall.NTSB ERA22LA305Accident · No injuriesClass 4 · LimitedFinal reportDuffy Russell A Slingshot · Shirley, NYThe pilot’s failure to maintain adequate airspeed during landing leading to an aerodynamic stall and subsequent impact with the ground.NTSB ANC22LA052Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cordova, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR22FA240Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Boulder City, NVThe failure of the pilot to maintain control of the airplane by exceeding the airplane’s critical angle of attack while maneuvering in a turning climb at a low altitude, which resulted in an aerodynamic stall and spin from which the pilot was unable to…NTSB WPR22FA239Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Lind, WAThe pilot's exceedance of the airplane's critical angle of attack during a steep turn, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR22FA235Accident · 1 fatalClass 3 · FieldFinal reportBeech V35B · Vancouver, WAThe pilot’s decision to execute a steep turn to final approach, which resulted in an exceedance of the airplane’s critical angle of attack and an accelerated stall. Contributing to the accident was the improper positioning on base leg and the pilot’s…NTSB WPR22FA227Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · Mendon, UTThe flight instructor’s failure to recover from a developed spin, which resulted in impact with terrain. Contributing to the accident was the flight instructor’s decision to enter the maneuver below the operator’s altitude limitation.NTSB CEN22LA279Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Yoder, KSThe pilot's encounter with sinking air conditions that resulted in a loss of lift and a subsequent loss of control.