NTSB investigations, 2014, AZ

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

Cases per year

20082026
NTSB investigations, 2014, 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\") = 2014
    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 WPR15LA038Accident · No injuriesLimited investigationFinal reportCessna 210B · Bullhead City, AZThe failure of the landing gear actuator housing during landing for reasons that could not be determined based on the available evidence.Nov 8, 2014 · N9578X · Substantial damageNTSB WPR15CA004Accident · Minor injuriesData collectionFinal reportCessna 172S · Sedona, AZThe pilot's failure to maintain airplane control during the landing roll out.Oct 5, 2014 · N2179L · Substantial damageNTSB WPR14LA368Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Mesa, AZThe failure of the right main landing gear (MLG) transmission mounting bracket coupled with the differential rigging of the two landing gear cables, which prevented the right MLG from moving to the down-and-locked position before landing.Sep 6, 2014 · N5966P · Substantial damageNTSB WPR14CA260Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Scottsdale, AZThe pilot's inadequate flare and failure to maintain aircraft control during landing.Jun 20, 2014 · N928PA · Substantial damageNTSB WPR14CA202Accident · No injuriesData collectionFinal reportPiper J3C 65 · Tucson, AZThe pilot's failure to maintain directional control during the landing roll.May 16, 2014 · N92090 · Substantial damageNTSB WPR14CA143Accident · No injuriesData collectionFinal reportGrumman TMB-3E · Glendale, AZThe pilot inadvertently raised the landing gear lever rather than the adjacent flap level while exiting the runway which resulted in the retraction of the left main landing gear.Mar 17, 2014 · N53503 · Substantial damageNTSB WPR14CA109Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Willcox, AZThe pilot's decision to land off airport on unsuitable terrain that resulted in a collision with hidden objects.Jan 26, 2014 · N9683P · Substantial damage