NTSB investigations, 2009, FL

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

Cases per year

20082026
NTSB investigations, 2009, FL per year, 2008–2026: 135 cases
20086
20096
20106
20115
20127
20138
20146
20158
20168
20177
201811
201910
20208
20219
20222
20237
20248
20258
20265

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\" = 'FL' 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 ERA10CA079Accident · No injuriesData collectionFinal reportAir Gulfstream Airlines SX-300 · West Palm Beach, FLThe loss of directional control while landing for undetermined reasons.Nov 14, 2009 · N884 · Substantial damageNTSB ERA10CA054Accident · No injuriesData collectionFinal reportPiper PA32 · Jacksonvile, FLThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.Nov 7, 2009 · N100LW · Substantial damageNTSB ERA10LA009Accident · No injuriesLimited investigationFinal reportButler Aerostar · Brooksville, FLThe collapse of the nose landing gear during landing rollout for undetermined reasons.Oct 1, 2009 · N81FW · Substantial damageNTSB ERA09LA520Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arcadia, FLThe pilot's bounced takeoff roll, which resulted in a collapsed landing gear. Contributing to the accident was the airplane's overweight condition.Aug 27, 2009 · N40VS · Substantial damageNTSB ERA09LA471Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Sanford, FLThe fatigue cracking at the point the nose landing gear actuator attaches to the mount resulting in separation of the actuator and partial collapse of the nose landing gear. Contributing to the accident was the lack of specific inspection guidance for…Aug 16, 2009 · N548C · Substantial damageNTSB ERA09LA210Accident · No injuriesLimited investigationFinal reportCessna 310K · Ocala, FLThe right main landing gear collapse as a result of the pilot's improper flare during a previous landing. Contributing to the accident was the flight instructor's inadequate supervision.Mar 18, 2009 · N6901L · Substantial damage