NTSB investigations, 2015, TX

9 cases where the sequence of events included Aerodynamic stall/spin.

Cases per year

20082026
NTSB investigations, 2015, TX per year, 2008–2026: 113 cases
20086
20097
20107
20116
20125
20132
20145
20159
20165
20176
201810
20198
20208
20215
20227
20233
20249
20252
20263

Latest cases

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 year(c.\"eventDate\") = 2015
    AND 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.

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.Dec 10, 2015 · N9868Q · Substantial damageNTSB 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…Oct 11, 2015 · N21468 · Substantial damageNTSB 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.Sep 27, 2015 · N3921D · Substantial damageNTSB 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.Sep 25, 2015 · N929DS · DestroyedNTSB 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.Jul 15, 2015 · N8305V · Substantial damageNTSB 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…Jul 1, 2015 · N6168P · DestroyedNTSB 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…Jun 14, 2015 · N6552L · Substantial damageNTSB 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…Mar 7, 2015 · N154BH · Substantial damageNTSB 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.Feb 5, 2015 · N441TG · Substantial damage