NTSB investigations, 2020, TX

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

Cases per year

20082026
NTSB investigations, 2020, 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\") = 2020
    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 CEN21LA096Accident · 2 fatalClass 3 · LimitedFinal reportExpress CT · Grand Prairie, TXThe pilot’s loss of airplane control during the departure turn, which resulted in an aerodynamic stall and impact with terrain.Dec 21, 2020 · N772BM · DestroyedNTSB CEN21LA088Accident · 2 fatalClass 3 · LimitedFinal reportRans S12XL · Port Isabel, TXAn exceedance of the airplane’s critical angle of attack and aerodynamic stall following a loss of engine power during an unknown phase of flight, which resulted in an impact with terrain.Dec 16, 2020 · N449JP · Substantial damageNTSB CEN20LA421Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Lago Vista, TXThe pilot’s mismanagement of the fuel system which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to maintain airspeed which resulted in the airplane exceeding its critical angle of attack…Sep 28, 2020 · N104RK · Substantial damageNTSB CEN20LA417Accident · 2 fatalClass 3 · LimitedFinal reportQuicksilver Mxii · Killeen, TXA total loss of engine power due to cold seizure for a reason that could not be determined, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.Sep 24, 2020 · N9045Z · Substantial damageNTSB CEN20CA396Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA46 · Jacksonville, TXThe student pilot’s failure to maintain control of the airplane during the landing approach and the exceedance of the airplane’s critical angle of attack at low altitude resulting in an aerodynamic stall. Contributing was the instructor pilot’s failure to…Sep 16, 2020 · N972DD · Substantial damageNTSB CEN20LA339Accident · Serious injuriesClass 3 · LimitedFinal reportCzech Sport Sportcruiser · Gober, TXThe student pilot’s improper recovery from a power-off stall. Contributing to the accident was the flight instructor’s failure to properly monitor the student pilot during the stall recovery.Aug 14, 2020 · N467SC · Substantial damageNTSB CEN20LA132Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Waxahachie, TXThe partial loss of engine power due to water and contaminants in the fuel, due to the pilot’s inadequate preflight inspection, and the pilot’s decision to conduct a steep turn at low altitude to return to the runway rather than land straight ahead, which…Mar 25, 2020 · N5553C · Substantial damageNTSB CEN20FA076Accident · 1 fatalClass 3 · FieldFinal reportBeech 33 · Granbury, TXThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and loss of control.Feb 8, 2020 · N6665U · Substantial damage