NTSB investigations, 2015, AZ

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

Cases per year

20082026
NTSB investigations, 2015, AZ per year, 2008–2026: 85 cases
20084
20093
20105
20118
20122
20135
20147
20156
20163
20173
201812
20193
20204
20213
20224
20232
20244
20253
20264

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\") = 2015
    AND c.\"eventStateOrRegion\" = 'AZ' 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 GAA16CA079Accident · No injuriesData collectionFinal reportMcmichael Elmer L Lancair 360 · Rimrock, AZThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and a left main landing gear collapse.Dec 13, 2015 · N113LM · Substantial damageNTSB WPR16LA015Accident · No injuriesLimited investigationFinal reportCessna 310J · Tucson, AZThe insufficient right main landing gear (MLG) down-lock tension due to maintenance personnel's failure to perform a rigging procedure during the airplane's most recent inspection, which resulted in the right MLG collapsing during landing.Oct 10, 2015 · N3123L · Substantial damageNTSB WPR15IA252Incident · No injuriesIncident investigationFinal reportCirrus SR22 · Scottsdale, AZThe failure of the nose landing gear due to unanticipated fatigue loads.Aug 27, 2015 · N915TD · Minor damageNTSB WPR15LA209Accident · No injuriesLimited investigationFinal reportMooney M 20G · Phoenix, AZThe pilots' failure to apply carburetor heat during the approach for landing, which resulted in a total loss of engine power due to carburetor icing.Jul 10, 2015 · N9152V · Substantial damageNTSB GAA15CA187Accident · No injuriesData collectionFinal reportHier James A Long EZ · Show Low, AZThe right main landing gear leg fracture, which resulted in the landing gear wheel separation and a runway excursion.Jun 26, 2015 · N793H · Substantial damageNTSB WPR15LA179Accident · No injuriesLimited investigationFinal reportBurr Express 2000 RG · Glendale, AZA collapse of the left main landing gear for reasons that could not be determined based on the available information.May 29, 2015 · N44508 · Substantial damage