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 ERA11LA411Accident · No injuriesLimited investigationFinal reportCessna 150M · Elizabethtown, KYA total loss of engine power for undetermined reasons.NTSB WPR11FA335Accident · 3 fatalField investigationFinal reportMooney M20C · Grace, IDThe pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern, which resulted in an aerodynamic stall.NTSB ANC11FA065Accident · 1 fatalField investigationFinal reportPiper PA-12 · Delta, AKThe pilot's decision to make a low-altitude turn back to the airport following a loss of engine power, which resulted in an aerodynamic stall and loss of control. Contributing to the severity of the pilot's injuries was the separation of the pilot's seat…NTSB WPR11CA338Accident · Serious injuriesData collectionFinal reportRolladen Schneider OHG LS-3-17 · Adelanto, CAThe pilot's incorrect use of the flap control pitch control recovery which resulted in an aerodynamic stall.NTSB CEN11FA480Accident · 1 fatalField investigationFinal reportTaylorcraft DCO-65 · Boyne City, MIThe pilot failed to maintain airplane control while maneuvering at low altitude, which resulted in a stall/spin and impact with the terrain.NTSB CEN11LA481Accident · Serious injuriesLimited investigationFinal reportDegraw Rhino II · Jackson, MIThe pilot did not maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall.NTSB WPR11CA322Accident · Minor injuriesData collectionFinal reportDova Aircraft Sro DV-1 Skylark · Placerville, CAThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB ERA11CA389Accident · Serious injuriesData collectionFinal reportBeech N35 · Geneseo, NYThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN11LA466Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-1 · Benton, KSThe pilot did not maintain sufficient airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and spin.NTSB WPR11LA317Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Bigfork, MTThe pilot’s failure to maintain adequate airspeed and his excessive control inputs during a simulated rope break while taking off, which resulted in an accelerated aerodynamic stall.NTSB WPR11FA316Accident · 4 fatalField investigationFinal reportMooney M20F · Watsonville, CAThe pilot's decision to take off toward a nearby low cloud layer and the subsequent turn, stall, and spin during the pilot’s attempt to avoid the cloud layer. Contributing to the accident was the pilot's failure to avoid the stall. His ability to avoid the…NTSB WPR11LA324Accident · Serious injuriesLimited investigationFinal reportM Squared Sprint 1000 · Heise, IDThe 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 accident airplane make and model.NTSB CEN11FA434Accident · 1 fatalField investigationFinal reportSchaffer Gary W Lancair · Yukon, OKThe pilot's use of an excessive bank angle while in the airport traffic pattern, which resulted in an accelerated stall. Contributing to the accident were the pilot’s lack of experience in the airplane and the pilot’s distracted attention to the rough running…NTSB CEN11CA453Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf 912 · Oconto, WIThe powered parachute pilot's decision to execute an in-flight full-flare which resulted in exceeding the angle of attack capabilities of the parachute wing, and subsequent inadvertent stall.NTSB CEN11FA431Accident · 2 fatalField investigationFinal reportBosonetto Thorp T-18 · Howell, MIThe pilot's failure to maintain airplane control and airspeed during final approach, which resulted in an aerodynamic stall/spin at a low altitude.NTSB ANC11FA055Accident · 1 fatalField investigationFinal reportCessna 150M · Beluga Lake, AKThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB WPR11LA287Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · St Johns, AZThe pilot did not attain and maintain an adequate airspeed during the takeoff initial climb, which resulted in an aerodynamic stall.NTSB ERA11FA360Accident · 1 fatalField investigationFinal reportClabaugh Robert R Barracuda · Andalusia, ALThe pilot did not maintain airspeed while maneuvering on approach for landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA11CA363Accident · Minor injuriesData collectionFinal reportCessna 150L · Winter Haven, FLThe certified flight instructor's failure to maintain control during the attempted go-around, which resulted in an aerodynamic stall.NTSB CEN11FA417Accident · 2 fatalField investigationFinal reportBeech A36 · Charlevoix, MIThe pilot's inadequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to not execute a missed approach in weather conditions below minimums.NTSB WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.NTSB ANC11CA052Accident · No injuriesData collectionFinal reportCessna 182H · Soldotna, AKThe pilot's failure to maintain pitch control resulting in an aerodynamic stall.NTSB ERA11FA348Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Guntersville, ALThe pilot's excessive pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to comply with weight and balance limitations.NTSB ERA11CA366Accident · No injuriesData collectionFinal reportChampion 7FC · Wellsville, PAThe pilot's failure to maintain adequate airspeed on final approach which resulted in an aerodynamic stall.NTSB CEN11LA405Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Faith, SDThe pilot's improper turn while maneuvering during an agricultural application flight, which resulted in an inadvertent aerodynamic stall at low altitude.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 ERA11FA332Accident · 2 fatalField investigationFinal reportCessna 152 · Vero Beach, FLThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent spin.NTSB WPR11FA248Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Astoria, ORThe student pilot’s failure to maintain adequate airspeed while maneuvering for landing, which resulted in a stall/spin. Contributing to the accident were the pilot's distraction and anxiety from a reported failure of the airplane's electrical system.NTSB CEN11LA373Accident · No injuriesLimited investigationFinal reportMooney M20R · Lake In The Hills, ILThe pilot's improper landing flare and recovery from a bounced landing, which resulted in a loss of control. Contributing to the accident was the certified flight instructor’s inadequate supervision.NTSB CEN11LA396Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Oak Ridge, LAThe flight instructor's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and subsequent impact with trees.NTSB ANC11FA037Accident · 5 fatalField investigationFinal reportCessna 180 · Chugiak, AKThe pilot's loss of control of the airplane during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in make and model, his lack of currency in FAA required takeoffs and landings, and his…NTSB WPR11LA234Accident · Minor injuriesLimited investigationFinal reportHoskins Zenith · Puyallup, WAThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the accident airplane.NTSB WPR11CA231Accident · No injuriesData collectionFinal reportLet L 33 Solo · Sparks, NVThe pilot’s failure to maintain an adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB CEN11LA352Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Athens, OHThe pilot's failure to maintain adequate airspeed in the flare which resulted in a stall and a hard landing.NTSB ERA11LA306Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Wurtsboro, NYThe pilot’s performance of aerobatic maneuvers at low altitude and his failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB CEN11CA342Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Spicewood, TXThe pilot's failure to maintain adequate airspeed during takeoff which resulted in an aerodynamic stall.NTSB CEN11CA362Accident · No injuriesData collectionFinal reportBeech B24R · Dowagiac, MIThe flight instructor's failure to maintain an appropriate glide path and airspeed during the landing approach, which resulted in an aerodynamic stall.NTSB CEN11LA332Accident · Serious injuriesLimited investigationFinal reportUnregistered Quicksilver MXL II · Crookston, MNThe pilot’s improper airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin at a low altitude.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 CEN11FA304Accident · 2 fatalField investigationFinal reportCubcrafters CC11-160 · Parker, COThe pilot’s excessive and unsafe maneuvering during gusty wind conditions, which resulted in an inadvertent stall-spin.NTSB WPR11LA202Accident · No injuriesLimited investigationFinal reportRans S-12 · Marana, AZThe pilot's failure to conduct an adequate preflight inspection, which resulted in a loss of engine coolant during climb due to an unsecured tank cap. Contributing to the accident was the pilot's failure to use available engine power to ensure a landing on an…NTSB CEN11FA285Accident · 1 fatalField investigationFinal reportHawker-Beechcraft E-55 · De Queen, ARThe pilot’s loss of control during takeoff for undetermined reasons.NTSB WPR11CA196Accident · No injuriesData collectionFinal reportCessna T188C · Palouse, WAThe pilot's inadequate evaluation of the wind conditions at takeoff and failure to maintain an adequate airspeed, which resulted in a stall and collision with terrain during the initial climb.NTSB CEN11CA287Accident · Minor injuriesData collectionFinal reportAir Tractor AT503 · Telephone, TXThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB ERA11LA240Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Richmond, VAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and subsequent impact with the ground.NTSB CEN11CA289Accident · Minor injuriesData collectionFinal reportRans S12 · Fort Collins, COThe pilot's inadvertent application of full right rudder during landing, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA11FA222Accident · 2 fatalField investigationFinal reportReplogle Lancair 360 · Chesapeake, VAThe pilot did not maintain airspeed following a loss of engine power, which resulted in an aerodynamic stall and spin. Contributing to the accident was the pilot's selection of the wrong fuel tank at takeoff, which resulted in fuel starvation and the total…NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB ERA11LA228Accident · Minor injuriesLimited investigationFinal reportHrosik Gene Aventura II · Crescent City, FLThe pilot's failure to maintain adequate airspeed during climb after takeoff, resulting in an aerodynamic stall.NTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.