NTSB investigations, AZ

12 cases where NTSB found Ceiling/visibility/precip.

Cases per year

20082026
NTSB investigations, AZ per year, 2008–2026: 12 cases
20082
20093
20101
20111
20121
20141
20151
20171
20221

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 c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030350'))
  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 WPR22FA345Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46 · Seligman, AZThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup.Sep 13, 2022 · N43605 · Substantial damageNTSB WPR17FA045Accident · 4 fatalField investigationFinal reportCessna T210K · Payson, AZThe non-instrument-rated pilot's improper decisions to begin and to continue a flight under visual flight rules into instrument meteorological conditions, which resulted in controlled flight into terrain.Jan 2, 2017 · N272EF · DestroyedNTSB WPR15FA072Accident · 2 fatalField investigationFinal reportBell 206 · Benson, AZThe pilot’s continued visual flight into instrument meteorological conditions which resulted in an inflight collision with terrain. Contributing to the accident was the pilot’s inadequate preflight planning, during which he failed to identify forecasted…Jan 1, 2015 · N57AW · DestroyedNTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.Apr 26, 2014 · N911EX · DestroyedNTSB WPR12FA091Accident · 2 fatalField investigationFinal reportCessna T206H · Show Low, AZThe pilot’s encounter with low clouds/low visibility conditions during the initial climb, which resulted in spatial disorientation and loss of airplane control.Feb 4, 2012 · N445GH · Substantial damageNTSB WPR12FA031Accident · 3 fatalField investigationFinal reportCessna 182Q · Lake Havasu City, AZThe pilot's continued cruise flight into cloudy conditions at night, which resulted in a loss of airplane control due to spatial disorientation.Nov 7, 2011 · N4701N · Substantial damageNTSB WPR10FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot’s decision to take off in marginal visual flight rules conditions, which resulted in an encounter with low clouds, and the pilot's failure to maintain clearance from wires while maneuvering in the traffic pattern for landing.Jan 28, 2010 · N293PA · Substantial damageNTSB WPR10FA005Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Black Canyon City, AZThe pilot's decision to continue VFR flight into instrument meteorological weather conditions which resulted in controlled flight into terrain. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.Oct 4, 2009 · N7471P · Substantial damageNTSB WPR09LA125Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · Cave Creek, AZThe pilot's misjudged landing flare. Contributing to the accident was the brownout condition created by the dust cloud that interfered with the pilot's perception of proximity to the ground, and the glare interference from the parked fire vehicles headlights…Feb 23, 2009 · N353P · Substantial damageNTSB WPR09FA096Accident · 2 fatalField investigationFinal reportCessna 205 · Flagstaff, AZThe pilot's loss of situational awareness and failure to maintain clearance from hilly terrain while flying in an area of a low cloud ceiling. Contributing to the accident was the pilot's decision to continue flight due to a self-induced pressure.Jan 23, 2009 · N8298Z · Substantial damageNTSB LAX08LA198Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Ash Fork, AZThe pilot's spatial disorientation resulting in his failure to detect and compensate for an unintentional descent during a go-around. Contributing to the accident were the pilot's inadequate choice of landing approach, reduced visibility from brownout…Jun 27, 2008 · N586AE · Substantial damageNTSB SEA08LA082Accident · Serious injuriesLimited investigationFinal reportRaytheon 1900D · Kayenta, AZThe flight crew's failure to execute a missed approach, which resulted in a runway excursion after landing. Contributing to the accident were the inoperative lights, weather conditions below published approach minimums, and the slush contaminated runway.Feb 22, 2008 · N305PC · Substantial damage