NTSB investigations
1,530 cases where the sequence of events included 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 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."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 ERA12FA458Accident · 1 fatalField investigationFinal reportBeech A23 · Laytonsville, MDThe pilot’s failure to ensure that the fuel selector handle was correctly positioned, which resulted in an interruption of fuel to the engine and a loss of engine power during the takeoff, which necessitated a turn away from the trees at the end of the runway…NTSB ANC12CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tynoek, AKThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.NTSB WPR12FA295Accident · 2 fatalField investigationFinal reportTL Ultralight Sro Stingsport · Piru, CAThe pilot’s failure to recover from a stall, which resulted in a spin. Contributing to the accident was the instructor’s inadequate remedial action.NTSB CEN12LA408Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Griswold, IAThe pilot’s failure to maintain adequate airspeed during an attempted go-around, resulting in an aerodynamic stall.NTSB CEN12LA407Accident · Serious injuriesLimited investigationFinal reportFields Mike Hawk SSC · Evansville, INThe operation of an airplane by a non-certificated pilot, and the pilot's loss of control during takeoff, which resulted in an inadvertent stall and spin.NTSB WPR12FA280Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Kooskia, IDThe pilot's decision to attempt a takeoff with a gusty tailwind, which resulted in his loss of airplane control during the initial climb and an aerodynamic stall/spin.NTSB ANC12CA057Accident · No injuriesData collectionFinal reportChampion 7GCB · Tyonek, AKThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall while maneuvering.NTSB ERA12CA396Accident · No injuriesData collectionFinal reportCessna 150M · Gulf Shores, ALThe student pilot's improper flight control inputs and the flight instructor's delayed remedial action during the attempted go-around, which resulted in an aerodynamic stall.NTSB CEN12LA368Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Hooker, OKThe pilot’s loss of airplane control after a partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures, which resulted in an…NTSB CEN12LA345Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe first officer’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the final approach in known low-level windshear conditions, which resulted in an aerodynamic stall. Contributing to the accident…NTSB CEN12LA340Accident · 1 fatalLimited investigationFinal reportQuicksilver Sport II · Manchester, IAAn inadvertent aerodynamic stall while maneuvering at a low altitude.NTSB WPR12FA235Accident · 4 fatalField investigationFinal reportCirrus SR20 · Duck Creek Village, UTThe pilot's failure to maintain sufficient airspeed and airplane control while maneuvering a heavily loaded airplane over high mountainous terrain in a high density altitude environment. Contributing to the accident was the pilot’s lack of experience…NTSB CEN12LA330Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-27 · Ionia, MIThe pilot's failure to maintain a proper airspeed in gusting wind conditions, which resulted in an inadvertent stall while maneuvering at an altitude that did not provide a margin for recovery.NTSB WPR12LA231Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Silver City, IDThe pilot‘s failure to maintain airspeed while maneuvering in mountainous terrain with reduced visibility, which resulted in an aerodynamic stall.NTSB WPR12FA230Accident · 4 fatalField investigationFinal reportCessna 172S · St. George, UTThe pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…NTSB CEN12LA318Accident · Serious injuriesLimited investigationFinal reportAeros Ltd/Skyranger Skyranger II · Saline, MIThe pilot did not maintain proper control of the airplane while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB ERA12CA344Accident · No injuriesData collectionFinal reportCessna 170B · Winterville, NCThe pilot's excessive bank at low altitude, which resulted in an aerodynamic stall.NTSB ERA12CA352Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2CT · Duncansville, PAThe glider’s encounter with atmospheric lift conditions not sufficient to clear terrain, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to continue turning toward a ridgeline.NTSB ERA12CA341Accident · Minor injuriesData collectionFinal reportCzech Sport Aircraft A S Sportcruiser · Shirley, NYThe pilot's failure to maintain airplane control after the cockpit canopy opened during the takeoff climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB CEN12CA294Accident · Serious injuriesData collectionFinal reportBeckert Bruce A RV-6 · Au Gres, MIThe pilot’s low altitude maneuvering, which resulted in an inadvertent stall and subsequent impact with the water.NTSB ERA12FA326Accident · 1 fatalField investigationFinal reportGutierrez Pablino Hummel Bird · DeFuniak Springs, FLThe pilot's failure to maintain airplane control due to the airplane’s exceedence of its maximum gross weight and center of gravity’s most rearward limit and his lack of familiarity with the airplane make and model, which resulted in an aerodynamic stall and…NTSB ERA12CA322Accident · No injuriesData collectionFinal reportCessna 182N · Newport, VTThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall and hard landing.NTSB ERA12CA321Accident · Serious injuriesData collectionFinal reportEiriavion PIK 20D · Eagleville, TNThe glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in an aerodynamic stall.NTSB ERA12FA319Accident · 1 fatalField investigationFinal reportCessna 177B · Honesdale, PAThe pilot pitching the airplane to an excessive nose-up attitude during an aborted landing, which resulted in increased induced drag, diminished airspeed, and an aerodynamic stall/spin. Contributing to the accident was the pilot’s use of a sedating…NTSB CEN12CA263Accident · No injuriesData collectionFinal reportCampbell David Legacy · Durango, COThe pilot’s improper flare and subsequent aerodynamic stall, which resulted in a hard landing.NTSB ANC12CA034Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe student pilot did not maintain sufficient airspeed during a steep turn after takeoff, which resulted in an aerodynamic stall.NTSB ERA12LA305Accident · Serious injuriesLimited investigationFinal reportAviat A-1B · Sylacauga, ALThe pilot's attempt to take off with the carburetor heat in the hot position, which limited the airplane’s performance, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.NTSB ERA12FA303Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Anderson, SCThe pilot's failure to maintain control of the airplane during the aborted landing, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR12LA176Accident · Serious injuriesLimited investigationFinal reportSkykits USA Savannah ADV · Ookala, HIA loss of engine power during cruise 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 failure to avoid an…NTSB CEN12LA236Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T15 · Lakin, KSThe pilot did not maintain sufficient airspeed while maneuvering, which resulted in an aerodynamic stall at a low altitude.NTSB ERA12FA271Accident · 1 fatalField investigationFinal reportWejebe Jose CA8 -SF · Everglades City, FLThe pilot’s failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN12LA231Accident · Serious injuriesLimited investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Ann Arbor, MIThe student pilot's failure to maintain airplane control on takeoff, which resulted in an aerodynamic stall and collision with terrain.NTSB ANC12FA028Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKOperation of the airplane by a non-certificated pilot and his failure to maintain adequate airspeed and airplane control, which resulted in an aerodynamic stall.NTSB ERA12FA256Accident · 1 fatalField investigationFinal reportAnderson John H Avid Flyer MK 4 · Waxhaw, NCThe pilot's failure to maintain adequate airspeed during an attempted go-around, which resulted in a low-altitude aerodynamic stall.NTSB CEN12CA205Accident · Minor injuriesData collectionFinal reportFurru Donald Jeffrey Skyranger V MAX · Viola, ARThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…NTSB ERA12LA230Accident · Serious injuriesLimited investigationFinal reportSadler Terry A Merlin · Otisfield, METhe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was his lack of experience in the airplane make and model.NTSB WPR12FA123Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Brockton, MTThe pilot’s failure to maintain adequate airspeed and airplane control while maneuvering at a low altitude, which resulted in a stall and subsequent impact with terrain.NTSB ERA12FA196Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Melbourne, FLThe pilot's abrupt maneuver in response to a perceived traffic conflict, which resulted in an accelerated stall and a loss of airplane control at low altitude. Contributing to the accident was the air traffic controller's incomplete instructions, which…NTSB CEN12FA161Accident · 2 fatalField investigationFinal reportCessna 414A · Hayden, COThe pilot’s inadvertent stall during a missed approach. Contributing to the accident was the pilot’s operation of the airplane in forecasted icing conditions without using all of its anti-ice systems.NTSB ERA12FA175Accident · 1 fatalField investigationFinal reportCessna T182T · Lebanon, NHThe pilot’s failure to maintain airspeed during a return to the airport after takeoff, which resulted in an aerodynamic stall and loss of airplane control.NTSB ERA12LA171Accident · Serious injuriesLimited investigationFinal reportMoore Byron J Zealot · Minneola, FLThe pilot's failure to maintain adequate airspeed on the base leg for landing, which resulted in an aerodynamic stall and loss of airplane control.NTSB WPR12FA089Accident · 1 fatalField investigationFinal reportGarza Lancair IV-TP · Boise, IDA loss or commanded reduction of engine power during the initial climb for reasons that could not be determined because of postaccident impact damage and fire destruction to engine systems and components. Also causal were the pilot's failure to maintain…NTSB ERA12FA163Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Thomasville, PAThe pilot's failure to maintain airspeed during an approach in gusty crosswind conditions, which resulted in an inadvertent aerodynamic stall.NTSB ERA12FA161Accident · 1 fatalField investigationFinal reportCessna 340A · Ocala, FLThe pilot's failure to maintain adequate airspeed and altitude on final approach, resulting in an impact with terrain short of the airport.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 ERA12FA130Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Jacksonville, FLThe pilot's in-flight loss of control during climb after a banner pickup. Contributing to the accident was the pilot's impairment due to marijuana.NTSB ERA12FA123Accident · 1 fatalField investigationFinal reportAero Commander 560-F · Venice, FLThe pilot’s failure to maintain adequate airspeed during a single-engine approach, which resulted in an aerodynamic stall. Contributing to the accident was the total loss of power in the left engine due to a failed No. 2 connecting rod bearing.NTSB CEN12FA115Accident · 3 fatalField investigationFinal reportBeech 19A · McArthur, OHThe pilot’s failure to maintain airplane control during an attempted go-around.NTSB ERA12FA120Accident · 1 fatalField investigationFinal reportCessna 441 · Nashville, PAThe pilot's failure to maintain minimum control airspeed after a loss of power to the right engine, which resulted in an uncontrollable roll into an inadvertent stall/spin. Contributing to the accident was the failure of the airplane's right engine for…