NTSB investigations, 2015, AZ

6 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2015, AZ per year, 2008–2026: 153 cases
200818
200914
201012
201112
201213
20136
20147
20156
20167
201710
201810
20197
20206
202110
20225
20235
20244
20251

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\" = '240' 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 GAA16CA003Accident · Minor injuriesData collectionFinal reportBushmaster Super Bushmaster · Marble Canyon, AZThe pilot's failure to maintain descent rate durring the landing resulting in collision with terrain.Oct 4, 2015 · C-FIIB · Substantial damageNTSB GAA15CA233Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Prescott, AZThe flight instructor's decision to turn the helicopter downwind during a hover taxi which resulted in an uncontrolled descent and impact with terrain.Aug 18, 2015 · N5VH · Substantial damageNTSB WPR15FA125Accident · 1 fatalField investigationFinal reportBAE Systems MK-67 Hawk · Yuma, AZThe pilot’s initiation of an early rotation during takeoff, which led to an aerodynamic stall and loss of airplane control. Contributing to the accident were the pilot's use of nose up pitch trim and the operator's policy to use nose-up pitch trim during…Mar 11, 2015 · N506XX · Substantial damageNTSB GAA15CA003Accident · No injuriesData collectionFinal reportSchupp Edward W SKY Ranger II · San Manuel, AZThe pilot's failure to maintain directional control during landing.Mar 7, 2015 · N132ES · Substantial damageNTSB WPR15LA099Accident · No injuriesLimited investigationFinal reportBeech A36TC · Flagstaff, AZThe pilot's improper landing flare and loss of airplane control, which resulted in a hard landing and the subsequent failure of the nose landing gear.Jan 18, 2015 · N3685W · Substantial damageNTSB WPR15CA073Accident · Minor injuriesData collectionFinal reportCessna 140 · Yuma, AZThe pilot's failure to compensate for crosswind conditions during takeoff, which resulted in the loss of directional control and collision with terrain.Jan 1, 2015 · N2841N · Substantial damage