NTSB investigations, TX
113 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' 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 GAA18CA413Accident · No injuriesData collectionFinal reportBeech T34 · Dallas, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB GAA18CA583Accident · No injuriesData collectionFinal reportPiper PA18 · Llano, TXThe pilot's receiving instruction’s improper landing flare and his failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB GAA18CA300Accident · No injuriesData collectionFinal reportCessna 150 · Killeen, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a maximum performance takeoff, which resulted in an aerodynamic stall. Also causal was the pilot’s failure to use the appropriate flap…NTSB CEN18FA147Accident · 2 fatalField investigationFinal reportNorth American SNJ 5 · Kingsville, TXThe pilot's failure to maintain airspeed during a steep turn after takeoff, resulting in an exceedance of the airplane's critical angle of attack and a subsequent accelerated stall at an altitude too low for recovery.NTSB CEN18LA114Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Odessa, TXThe pilot’s improper takeoff procedures and his failure to abort the takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB GAA18CA061Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Caldwell, TXThe pilot’s failure to maintain yaw control and the exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall/spin.NTSB CEN18LA019Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 502B · Olton, TXThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering during the aerial application flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB CEN17FA208Accident · 1 fatalField investigationFinal reportMichael S. Logan Kitfox · New Berlin, TXA total loss of engine power for reasons that could not be determined based on the available information, and the pilot's subsequent failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and experiencing…NTSB CEN17LA182Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Weatherford, TXThe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall/spin.NTSB CEN17FA084Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · San Antonio, TXThe pilot's uncoordinated flight control inputs and subsequent inadvertent cross-control aerodynamic stall in the airport traffic pattern that resulted in a loss of control and uncontrolled descent with insufficient altitude for recovery.NTSB CEN17FA080Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Wellington, TXThe pilot's improper decision to perform a steep turn at low altitude, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB CEN17FA005Accident · 1 fatalField investigationFinal reportBeech D95A · Hitchcock, TXThe flight instructor's loss of control during an aerodynamic stall demonstration, which resulted in an inadvertent spin from which he was unable to recover. Contributing to the accident was the flight instructor's lack of familiarity with the airplane's…NTSB CEN16FA261Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Houston, TXThe pilot's failure to maintain adequate airspeed after becoming distracted by the open baggage door while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at…NTSB CEN16LA208Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Ropesville, TXThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall while maneuvering.NTSB CEN16FA145Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Midlothian, TXThe flight instructor's inability to move the control stick after takeoff for undetermined reasons, which resulted in an exceedance of the airplane's critical angle of attack and inadvertent aerodynamic stall. The reason for the inability to move the control…NTSB CEN16FA094Accident · 1 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P92 Echo Super · Arcola, TXThe student pilot's loss of control after exceeding the airplane's critical angle-of-attack, which lead to a power-on, aerodynamic departure stall. Contributing to the accident was the flight instructor's inadequate oversight of the student pilot.NTSB GAA16CA076Accident · Minor injuriesData collectionFinal reportCessna 172 · Abilene, TXThe student pilot's abrupt control inputs during the flare, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's lack of over sight and delayed reaction while landing.NTSB CEN16LA007Accident · 1 fatalLimited investigationFinal reportRich Harry A Woodstock I · Decatur, TXThe pilot's failure to maintain adequate airspeed while turning from the downwind to the base leg of the pattern in gusting wind conditions, which resulted in the glider exceeding its critical angle-of-attack and entering an aerodynamic stall/spin at a low…NTSB CEN15FA427Accident · 1 fatalField investigationFinal reportCessna 182 · Lexington, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a climbing turn, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.NTSB CEN15FA422Accident · 2 fatalField investigationFinal reportPierce, Henry Bushby Mustang II · Granbury, TXThe pilot's exceedance of the airplane's critical angle of attack resulting in an aerodynamic stall and collision with terrain.NTSB GAA15CA188Accident · No injuriesData collectionFinal reportChampion 7GCAA · Kingsland, TXThe pilot's failure to maintain pitch attitude which resulted in an aerodynamic stall, hard landing and a loss of directional control.NTSB CEN15FA287Accident · 2 fatalField investigationFinal reportPiper PA 24-250 · Quinlan, TXThe pilot's failure to maintain control of the airplane following a loss of engine power during initial climb after takeoff, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall. Also causal was the pilot's…NTSB CEN15FA269Accident · 1 fatalField investigationFinal reportGrumman American Avn. AA-5 · Fredericksburg, TXThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the mechanic's…NTSB CEN15LA169Accident · Serious injuriesLimited investigationFinal reportHoke Bobby F Rans S 12 · Rusk, TXA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's failure to maintain control while maneuvering for a forced landing, which resulted in the airplane…NTSB CEN15FA136Accident · 1 fatalField investigationFinal reportCessna 441 · Argyle, TXThe pilot's failure to maintain adequate airspeed during the instrument approach in night instrument meteorological conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin at a low altitude.NTSB CEN15FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Odessa, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at an excessive bank angle at a low altitude, which resulted in an accelerated stall and spin with insufficient altitude for a recovery.NTSB CEN15FA056Accident · 1 fatalField investigationFinal reportAero Commander 500A · McDade, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack for reasons that could not be determined based on the available evidence, which resulted in an aerodynamic stall/spin. Contributing to the accident…NTSB CEN14FA438Accident · 2 fatalField investigationFinal reportCessna 414 · Bowie, TXThe pilot’s incapacitation in flight as the result of a an acute cardiac event, which resulted in a loss of control and collision with terrain.NTSB CEN14LA342Accident · Serious injuriesLimited investigationFinal reportSlaughter Mike CH601-HDS · Frankston, TXThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's decision to make a…NTSB CEN14FA325Accident · 1 fatalField investigationFinal reportDoyle James E Skybolt · Midlothian, TXThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in an inverted spin and subsequent collision with terrain.NTSB CEN14FA057Accident · 2 fatalField investigationFinal reportCessna 152 · Spring, TXThe flight instructor's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and subsequent loss of airplane control.NTSB CEN13LA369Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-15 · Navasota, TXAn inadvertent aerodynamic stall during the approach for landing.NTSB CEN13LA116Accident · Serious injuriesLimited investigationFinal reportSeguine Swift II · San Antonio, TXThe pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.NTSB CEN13LA034Accident · 2 fatalLimited investigationFinal reportUS Light Hornet · Mont Belvieu, TXThe pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.NTSB CEN12FA616Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Kingsland, TXThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power resulting from an engine intake valve that became stuck open. Contributing to the accident was the pilot’s decision to operate the airplane when a required maintenance…NTSB CEN12FA606Accident · Serious injuriesField investigationFinal reportCessna 421B · Fort Worth, TXThe pilot's failure to maintain airplane control on takeoff, which resulted in an inadvertent stall. Contributing to the accident were the unlatched nose cargo door, the pilot’s diverted attention, and the pilot's mental ability to handle the emergency…NTSB CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…NTSB CEN12CA026Accident · Serious injuriesData collectionFinal reportJantzen Evans VP · Terrell, TXThe pilot’s inadequate preflight planning, in that he did not determine whether the airplane’s climb performance would be sufficient to clear obstacles before initiating take off.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 CEN11CA342Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Spicewood, TXThe pilot's failure to maintain adequate airspeed during takeoff which resulted in an aerodynamic stall.NTSB CEN11CA287Accident · Minor injuriesData collectionFinal reportAir Tractor AT503 · Telephone, TXThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN11CA163Accident · Minor injuriesData collectionFinal reportMooney M20R · Cypress, TXThe student pilot’s delayed decision to execute a go-around.NTSB CEN11FA141Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Midlothian, TXThe engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.NTSB CEN11LA041Accident · 1 fatalLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXThe pilot’s failure to ensure adequate fuel on board and subsequent failure to maintain airplane control following an engine failure due to fuel exhaustion.NTSB CEN10CA541Accident · Minor injuriesData collectionFinal reportAerolite Bearcat · Mineola, TXFailure of the oil injection pump resulting in a total loss of engine power.NTSB CEN10FA448Accident · 2 fatalField investigationFinal reportAmerican Champion Aircraft Cor 7GCBC · Midlothian, TXThe flight instructor’s incapacitation due to preexisting but unrecognized coronary disease, and the student pilot’s distraction and inability to recover the airplane from a stall/spin at low altitude.NTSB CEN10CA347Accident · No injuriesData collectionFinal reportMooney M20F · Lubbock, TXThe student pilot's failure to maintain control during a go-around.NTSB CEN10FA277Accident · Serious injuriesField investigationFinal reportAveko Sro VL-3 LSA · Boyd, TX***This report was modified on November 15, 2012. Please see the docket for this accident to view the original report with revisions shown.*** The pilots’ failure to avoid and recover from the prohibited maneuver of aerodynamic spin during a training flight,…NTSB CEN10CA284Accident · No injuriesData collectionFinal reportPiper J3C-65 · Mount Pleasant, TXThe pilot's failure to maintain adequate airspeed while turning resulting in a stall.NTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.