NTSB investigations, 2013, CA

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

Cases per year

20082026
NTSB investigations, 2013, 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\") = 2013
    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 WPR14LA051Accident · No injuriesLimited investigationFinal reportPiper PA 31P · Calexico, CAThe pilot’s failure to maintain the proper pitch attitude during the landing, which resulted in the nose landing gear contacting the surface hard and then separating from the airplane.Oct 12, 2013 · N14TG · Substantial damageNTSB WPR13CA413Accident · No injuriesData collectionFinal reportCessna T310R · San Luis Obispo, CAThe pilot's inadvertent action of retracting the landing gear instead of the flaps during the landing roll, which resulted in the right main landing gear collapsing.Sep 16, 2013 · N712SB · Substantial damageNTSB WPR13CA232Accident · No injuriesData collectionFinal reportCessna 195A · San Carlos, CAThe pilot’s failure to maintain directional control during the landing roll.May 16, 2013 · N4026A · Substantial damageNTSB WPR13LA238Accident · No injuriesLimited investigationFinal reportCessna 310R · Bakersfield, CAThe failure of the right main landing gear link assembly, which resulted in the right main landing gear collapsing during landing.May 8, 2013 · N6096C · Substantial damageNTSB WPR13LA214Accident · No injuriesLimited investigationFinal reportCessna 421A · Oakland, CAA failure of the left main landing gear pivot bolt in overstress during landing.May 1, 2013 · N216WA · Substantial damageNTSB WPR13CA168Accident · Serious injuriesData collectionFinal reportCessna 170 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll.Mar 21, 2013 · N3826V · Substantial damageNTSB WPR13LA112Accident · No injuriesLimited investigationFinal reportCessna 305A · Camarillo, CAA tailwheel vibration upon touchdown and the subsequent loss of directional control for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.Feb 2, 2013 · N342FS · Substantial damage