NTSB investigations, 2020, TX

9 cases where the sequence of events included Landing gear collapse.

Cases per year

20082026
NTSB investigations, 2020, TX per year, 2008–2026: 150 cases
200811
200910
201011
20119
20128
20136
201410
20155
201617
20177
201812
20196
20209
20213
20225
20236
20247
20255
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\" = '094' 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 CEN21LA108Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Fort Worth, TXA failure of the nose wheel landing strut for reasons that could not be determined based on available information.Nov 6, 2020 · N720TX · Substantial damageNTSB CEN21LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Edinburg, TXThe collapse of the airplane’s left main landing gear for a reason that could not be determined based upon the available evidence.Oct 30, 2020 · N76933 · Substantial damageNTSB CEN20CA212Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Corpus Cristi, TXThe pilot's failure to utilze the emergency landing gear extension procedure after a short-circuit within the normal landing gear system, which resulted in a landing gear collapse during landing.Jun 4, 2020 · N533K · Substantial damageNTSB CEN20LA185Accident · No injuriesClass 3 · LimitedFinal reportCessna 501 · Houston, TXThe malfunction of the left main landing gear down lock, which resulted in a gear collapse upon landing.May 20, 2020 · N501KM · Substantial damageNTSB CEN20LA175Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · San Antonio, TXThe failure of the left main landing gear upper drag leg arm due to substandard mechanical properties, which resulted in a collapse of the landing gear upon landing.May 9, 2020 · N31704 · Substantial damageNTSB CEN20CA154Accident · No injuriesData collectionFinal reportCessna 172 · Ft Worth, TXThe student pilot’s failure to maintain a stabilized approach and the flight instructor's delayed remedial action to initiate a go-around, which resulted in a runway overrun and impact with runway lights and fences.Apr 22, 2020 · N13005 · Substantial damageNTSB CEN20CA146Accident · Minor injuriesData collectionFinal reportPitts S2 · Fort Worth, TXThe pilot's inadequate preflight inspection of the fuel level, which resulted in a total loss of engine power due to fuel exhaustion.Apr 10, 2020 · N487J · Substantial damageNTSB CEN20CA129Accident · No injuriesData collectionFinal reportPiper PA18 · Canyon, TXThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch and the left main landing gear collapsing.Mar 20, 2020 · N4910P · Substantial damageNTSB CEN20CA105Accident · No injuriesData collectionFinal reportRaf SE5A · Kingsbury, TXThe pilot's failure to maintain a proper landing flare, which resulted in a hard, bounced landing, and his subsequent loss of directional control, which resulted in a ground loop.Feb 27, 2020 · N685SE · Substantial damage