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 ERA12LA011Accident · 1 fatalLimited investigationFinal reportRivers William J KR-2 · Wytheville, VAThe pilot's failure to maintain control, which resulted in an aerodynamic stall/spin. Contributing to the accident was the pilot's lack of experience in the airplane make and model.NTSB ERA12FA008Accident · 1 fatalField investigationFinal reportAviat A-1 · Moyock, NCThe operation of the airplane by a non-certificated pilot, and his failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB CEN11CA667Accident · Minor injuriesData collectionFinal reportTompkins Tandem Rocket · Lemars, IAThe pilot's failure to maintain aircraft control while maneuvering.NTSB ERA11FA493Accident · 1 fatalField investigationFinal reportCessna 172M · Greenville, METhe pilot's failure to maintain adequate airspeed while manuevering at low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB CEN11FA645Accident · 2 fatalField investigationFinal reportRemos Aircraft Gmbh Flugzeugba GX · Noblesville, INThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude. Contributing was the pilot's decision to maneuver at an altitude below that required for congested areas, which did not afford an adequate margin for stall recovery.NTSB WPR11FA415Accident · Serious injuriesField investigationFinal reportCessna 172M · Santa Monica, CAThe student pilot’s misjudged approach and landing attempt. Contributing to the accident was a lack of airspeed due to a blocked pitot tube.NTSB ERA11LA459Accident · Serious injuriesLimited investigationFinal reportEvans Robert W SR Pegazair 100 · Maysville, NCThe student pilot's failure to maintain adequate airspeed during initial takeoff climb, which resulted in an aerodynamic stall.NTSB ERA11CA460Accident · No injuriesData collectionFinal reportMooney M20R · West Chester, PAThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB CEN11LA672Accident · Serious injuriesLimited investigationFinal reportPorbeck John M Slipstream Genesis · Bryan, TXThe pilot’s failure to maintain adequate airspeed and attitude during a turn toward downwind, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's limited experience in the experimental airplane.NTSB ERA11FA443Accident · 2 fatalField investigationFinal reportMaule M-7-235 · Warrenton, VAThe pilot's inadequate airspeed and excessive bank angle while maneuvering for landing, which resulted in an aerodynamic stall.NTSB CEN11LA546Accident · 2 fatalLimited investigationFinal reportReinboldt Richard A Challenger II · Reedsburg, WIThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB ERA11LA437Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Egg Harbor Township, NJThe pilot’s failure to maintain adequate airspeed while maneuvering near the ground, which resulted in an aerodynamic stall.NTSB WPR11LA361Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Perris, CAThe pilot’s failure to maintain airplane control and the resulting encounter with an aerodynamic stall. Also causal were the pilot’s inadequate preflight planning and preflight inspection, his failure to ensure the pitch trim was positioned correctly for…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 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 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 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 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 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 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 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 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 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 ERA11LA200Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Hollywood, FLA total loss of engine power for undetermined reasons.NTSB ERA11CA195Accident · Serious injuriesData collectionFinal reportBrown Narcisse A Christen Eagle II · Gainesville, FLThe pilot's failure to maintain airspeed while turning from base leg to final approach, which resulted in an aerodynamic stall and collision with the ground.