NTSB investigations, 2009, TX

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

Cases per year

20082026
NTSB investigations, 2009, 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\") = 2009
    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 CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.Dec 25, 2009 · N9499X · Substantial damageNTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.Sep 11, 2009 · N2929N · Substantial damageNTSB CEN09CA457Accident · No injuriesData collectionFinal reportCessna 310 · Fort Worth, TXThe failure of the pivot pin in the side brace of the right main landing gear resulting in the gear collapse during taxi for undetermined reasons.Jul 10, 2009 · N3106L · Substantial damageNTSB CEN09CA394Accident · Minor injuriesData collectionFinal reportSidler Mike Rotorway · Waxahachie, TXThe pilot’s failure to control his rate of descent during autorotation, which required an aggressive recovery maneuver and resulted in a sudden loss of tail rotor effectiveness.Jun 27, 2009 · N1934 · Substantial damageNTSB CEN09CA315Accident · No injuriesData collectionFinal reportHolsclaw Francis E Starduster · Ranger, TXThe pilot's inability to maintain directional control due to the buckling of the right landing gear as a result of corrosion.May 23, 2009 · N42WT · Substantial damageNTSB CEN09CA253Accident · No injuriesData collectionFinal reportCessna 172N · Roanoke, TXThe partial loss of engine power due to a failure of the throttle control rod-end to carburetor arm hardware. A contributing factor was the pilot's decision to fly the airplane without a current annual inspection.May 8, 2009 · N172SV · Substantial damageNTSB CEN09CA268Accident · No injuriesData collectionFinal reportLuscombe 8 · Terrell, TXThe failure of the landing gear due to undetected corrosion.Apr 22, 2009 · N2330K · Substantial damageNTSB CEN09LA250Accident · Minor injuriesLimited investigationFinal reportJordan Don R Vans RV-6A · Arlington, TXA total loss of engine power due to the failure of both magnetos. Contributing to the accident was the lack of preventative maintenance/inspection of the magnetos.Apr 15, 2009 · N6DJ · Substantial damageNTSB CEN09CA226Accident · No injuriesData collectionFinal reportCessna 172A · Corsicana, TXThe pilot's improper flare.Mar 20, 2009 · N7326T · DestroyedNTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.Mar 2, 2009 · N2262D · Substantial damage