NTSB investigations, 2019, TX

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

Cases per year

20082026
NTSB investigations, 2019, 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\") = 2019
    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 CEN20TA025Accident · No injuriesClass 3Final reportPiper PA34 · Mount Pleasant, TXThe pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.Nov 25, 2019 · N15412 · Substantial damageNTSB GAA19CA566Accident · No injuriesData collectionFinal reportCessna 152 · Denton, TXThe student pilot's improper landing flare, which resulted in a hard, bounced landing and a nose landing gear collapse.Sep 18, 2019 · N93069 · Substantial damageNTSB CEN19LA302Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · La Grange, TXThe pilot's improper flare, which resulted in a hard landing.Sep 2, 2019 · N212BS · Substantial damageNTSB CEN19LA246Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA227 · El Paso, TXFailure of the left main landing gear to fully extend due to a lack of hydraulic fluid and during emergency extension procedures, which resulted in the collapse of the landing gear during landing and the subsequent runway excursion and collision with a sign.Jul 27, 2019 · N681TR · Substantial damageNTSB GAA19CA140Accident · No injuriesData collectionFinal reportPiper PA24 · Slaton, TXThe student pilot's complacency, which led to his improper crosswind correction and subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground collision.Feb 12, 2019 · N9184P · Substantial damageNTSB CEN19TA073Accident · Serious injuriesFinal reportBeech A36 · Fort Worth, TXThe pilot's improper fuel management, which resulted in fuel starvation and a loss of engine power.Jan 27, 2019 · N36PS · Substantial damage