NTSB investigations, 2009, CA

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

Cases per year

20082026
NTSB investigations, 2009, 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\") = 2009
    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 WPR09CA434Accident · No injuriesData collectionFinal reportCessna 195 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.Sep 5, 2009 · N1508D · Substantial damageNTSB WPR09CA440Accident · No injuriesData collectionFinal reportUniversal Globe GC-1 · Pacoima, CAThe pilot's failure to maintain directional control during the landing roll.Sep 4, 2009 · N2345B · Substantial damageNTSB WPR09CA430Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear strut.Aug 31, 2009 · N5155B · Substantial damageNTSB WPR09CA429Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR · San Diego, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.Aug 30, 2009 · N4418 · Substantial damageNTSB WPR09CA352Accident · No injuriesData collectionFinal reportCessna T210N · Corona, CAThe pilot's inadequate flare during touchdown, which resulted in a hard landing.Jul 7, 2009 · N5287A · Substantial damageNTSB WPR09CA319Accident · No injuriesData collectionFinal reportCessna LC-126C · Lincoln, CAA fatigue crack in the left main landing gear strut resulting in the collapse of the strut during the landing roll.Jun 30, 2009 · N1064D · Substantial damageNTSB WPR09LA290Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Columbia, CAThe failure of the left main landing gear drag link as a result of overstress fracture. Contributing to the accident was maintenance personnel's failure to detect a small crack in the left main landing gear drag link during the most recent annual inspection.Jun 11, 2009 · N6561N · Substantial damageNTSB WPR09LA242Accident · No injuriesLimited investigationFinal reportCessna 182M · Madera, CAThe pilot’s failure to maintain directional control of the airplane throughout the landing.May 9, 2009 · N71165 · Substantial damageNTSB WPR09LA204Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Los Angeles, CAThe pilot's inadequate compensation for the crosswinds and failure to maintain directional control during the landing roll.Apr 16, 2009 · N9219E · Substantial damageNTSB WPR09CA095Accident · No injuriesData collectionFinal reportDickson Vans RV-8 · El Monte, CAThe pilot's failure to maintain directional control during landing.Jan 21, 2009 · N396JD · Substantial damage