NTSB investigations, 2010, CA

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

Cases per year

20082026
NTSB investigations, 2010, CA per year, 2008–2026: 135 cases
20088
200910
201011
20115
20125
20137
20147
20158
201610
201714
201812
20197
20205
20212
20224
20235
20245
20254
20266

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\") = 2010
    AND c.\"eventStateOrRegion\" = 'CA' 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 WPR11LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAFatigue cracking of the upper torque-link attach lugs on the left main landing gear strut, which resulted in separation of the left main landing gear during taxi.Dec 10, 2010 · N5800U · Substantial damageNTSB WPR11LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rialto, CAFatigue cracking of the left main landing gear leg, which resulted in a gear collapse during landing.Nov 27, 2010 · N5101X · Substantial damageNTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.Sep 2, 2010 · N522PC · Substantial damageNTSB WPR10LA349Accident · No injuriesLimited investigationFinal reportCessna 310K · El Monte, CAThe pilot’s failure to maintain directional control during the takeoff ground roll.Jul 14, 2010 · N6909L · Substantial damageNTSB WPR10LA271Accident · No injuriesLimited investigationFinal reportShaffer William C Quicksilver MX II SP · Visalia, CAThe pilot's inadequate compensation for the gusty crosswind conditions and failure to maintain runway alignment while landing.Jun 1, 2010 · N4399J · Substantial damageNTSB WPR10CA296Accident · No injuriesData collectionFinal reportCessna P210N · Petaluma, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll in gusty crosswind conditions.May 22, 2010 · N210SL · Substantial damageNTSB WPR10CA227Accident · No injuriesData collectionFinal reportCessna 182M · Angwin, CAThe pilot's inadequate compensation for the crosswind resulting in the loss of directional control during the landing roll.May 3, 2010 · N91603 · Substantial damageNTSB WPR10TA213Accident · No injuriesFinal reportCessna T206H · Fullerton, CAThe pilot’s inadequate compensation for the wind conditions during the landing flare and failure to maintain directional control on the ground.Apr 19, 2010 · N6045C · Substantial damageNTSB WPR10CA204Accident · No injuriesData collectionFinal reportMathis Melvin R Bushby Mustang II · Apple Valley, CAThe CFI's inability to overcome the improper control inputs of the private pilot, who was handling the flight controls, which resulted in their loss of directional control during landing.Apr 8, 2010 · N217AT · Substantial damageNTSB WPR10LA191Accident · No injuriesLimited investigationFinal reportBeech 58 · Santa Barbara, CAThe landing gear collapsing during the landing roll for undetermined reasons.Mar 22, 2010 · N580TC · Substantial damageNTSB WPR10LA173Accident · No injuriesLimited investigationFinal reportWilliams Yakovlev YAK 3UPW · Half Moon Bay, CAThe failure of left main landing gear actuator to lock in the down position due to low down-lock pressure as a result of a contaminated down-lock track and corroded down-lock balls.Mar 22, 2010 · N153U · Substantial damage