NTSB investigations, 2017, AZ

23 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2017, AZ per year, 2008–2026: 347 cases
200838
200933
201024
201125
201224
201315
201427
201517
201624
201723
201822
201928
202010
20217
20226
20233
20247
20258
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\") = 2017
    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\" = '470' 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 WPR18LA044Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-200T · Glendale, AZThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the fatigue of the left main landing gear assembly.Dec 5, 2017 · N47536 · Substantial damageNTSB WPR18LA037Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC41 550FG · Oro Valley, AZThe inadequate cooling time between repeated heavy braking applications, which resulted in the brakes overheating and a subsequent brake fire during the aborted takeoff sequence.Nov 27, 2017 · N2526C · Substantial damageNTSB GAA18CA059Accident · No injuriesData collectionFinal reportMooney M20 · Tucson, AZThe pilot’s inadequate preflight and in-flight fuel management, which resulted in an intermittent loss of engine power due to fuel starvation.Nov 26, 2017 · N6002Q · Substantial damageNTSB WPR18LA030Accident · No injuriesLimited investigationFinal reportVanderark RV-10 · Sun Lakes, AZThe fatigue fractures of the upper and lower alternator attachment bolts, which decreased the common drive belt tension and resulted in the subsequent in-flight separation of an alternator drive belt, the overheating of the engine, and the subsequent total…Nov 12, 2017 · N917VA · Substantial damageNTSB WPR18LA031Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Page, AZThe pilot's failure to maintain pitch control of the helicopter while transitioning from a hover to forward flight.Nov 11, 2017 · N744BS · Substantial damageNTSB WPR18LA014Accident · Serious injuriesClass 3 · LimitedFinal reportAmerican AA 1A · Maricopa, AZThe pilot’s failure to see and avoid unmarked power lines during the approach to land.Oct 21, 2017 · N9239L · Substantial damageNTSB WPR18FA011Accident · 1 fatalField investigationFinal reportPeterson Lancair Legacy · Bowie, AZAn in-flight loss of control due to a bird strike.Oct 19, 2017 · N259L · Substantial damageNTSB WPR18LA006Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ 6 · Buckeye, AZThe failure of the fuel pump’s diaphragm which resulted in fuel system contamination from air and or oil and caused the engine to lose power.Oct 9, 2017 · N8NW · Substantial damageNTSB WPR17FA213Accident · 2 fatalField investigationFinal reportCessna 172L · Perkinsville, AZThe pilot's decision to fly into a canyon during wind conditions conducive to turbulence and downdrafts, and his subsequent loss of aircraft control while maneuvering in the canyon. Contributing to the accident was the pilot's limited canyon flying experience.Sep 22, 2017 · N7070Q · DestroyedNTSB WPR17LA207Accident · No injuriesLimited investigationFinal reportCessna 208B · Sedona, AZThe pilot's failure to maintain clearance from a light pole while taxiing.Sep 16, 2017 · N786WW · Substantial damageNTSB GAA17CA516Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 NG · Goodyear, AZThe student pilot’s improper landing flare and subsequent failure to maintain directional control during the landing roll.Sep 2, 2017 · N910XD · Substantial damageNTSB WPR17LA175Accident · Serious injuriesLimited investigationFinal reportGrumman AA1 · Phoenix, AZThe partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…Aug 1, 2017 · N6216L · Substantial damageNTSB WPR17FA155Accident · 2 fatalField investigationFinal reportEvolution 19 Lancair Evolution · Mesa, AZThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent stall/spin. Contributing to the accident was the pilot's distraction due to a failure…Jul 17, 2017 · N571JM · Substantial damageNTSB WPR17LA141Accident · No injuriesLimited investigationFinal reportVickers Supermaine Ltd · Marana, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.Jul 4, 2017 · N5TF · Substantial damageNTSB GAA17CA370Accident · Minor injuriesData collectionFinal reportAero-Ace CE 1 · Cottonwood, AZThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Jun 26, 2017 · N473CQ · Substantial damageNTSB WPR17LA144Accident · No injuriesLimited investigationFinal reportCessna U206F · Page, AZThe failure of the throttle control cable due to fatigue and maintenance personnel’s failure to replace the cable at the last engine overhaul, which resulted in the pilots’ inability to control engine power and led to a precautionary landing during which the…Jun 23, 2017 · N71001 · Substantial damageNTSB GAA17CA318Accident · Minor injuriesData collectionFinal reportCessna 172 · Payson, AZThe pilot’s inadequate preflight planning that did not account for high-density altitude conditions and his subsequent attempted go-around in conditions that prevented the airplane from attaining a positive climb rate and resulted in its subsequent descent…Jun 4, 2017 · N50526 · DestroyedNTSB GAA17CA292Accident · Minor injuriesData collectionFinal reportAirtime Cygnet · Casa Grande, AZThe flight instructor's failure to maintain directional control during takeoff in gusting crosswind conditions.May 21, 2017 · N168AT · Substantial damageNTSB GAA17CA189Accident · No injuriesData collectionFinal reportPiper PA 28 · Gila Bend, AZThe flight instructor’s failure to review the notices to airmen related to the airport, which resulted in his landing on a closed runway and the airplane striking runway closed markers.Mar 12, 2017 · N288PA · Substantial damageNTSB GAA17CA166Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe flight instructor’s incorrect control inputs while taking off with a known quartering tailwind, which resulted in a loss of directional control and runway excursion.Feb 27, 2017 · N309PA · Substantial damageNTSB WPR17LA068Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Holbrook, AZThe pilot’s failure to compensate for a loss of effective translational lift while turning from an upwind to a downwind condition at a low altitude and low airspeed, which resulted in a loss of helicopter control.Feb 18, 2017 · N7095A · Substantial damageNTSB GAA17CA126Accident · No injuriesData collectionFinal reportPiper PA32R · Fort Mohave, AZThe pilot's failure to extend the landing gear for landing.Jan 26, 2017 · N6885F · Substantial damageNTSB WPR17FA057Accident · 2 fatalField investigationFinal reportBeech 300 · Tucson, AZThe pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.Jan 23, 2017 · N385KA · Destroyed