NTSB investigations, AZ
224 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 22 |
|---|---|
| 2009 | 19 |
| 2010 | 13 |
| 2011 | 16 |
| 2012 | 14 |
| 2013 | 9 |
| 2014 | 17 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 11 |
| 2018 | 16 |
| 2019 | 14 |
| 2020 | 6 |
| 2021 | 14 |
| 2022 | 4 |
| 2023 | 11 |
| 2024 | 9 |
| 2025 | 6 |
| 2026 | 6 |
Where
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\", '0303'))
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.
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", '0303')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DCA26LA285Accident · No injuriesClass 4 · LimitedFinal reportLeigh Aerosystems E100 · Douglas, AZDegraded engine and propeller performance during hot and high-density altitude operations, which resulted in a high descent rate and subsequent hard landing.NTSB WPR26LA187Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sedona, AZThe pilot’s inability to maintain directional control due to a plastic foreign object jammed in the rudder pedals, while landing with a gusting left crosswind.NTSB WPR26LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Redington, AZThe pilot’s improper decision to continue the flight into icing conditions, which resulted in the accumulation of airframe icing and a subsequent aerodynamic stall.NTSB WPR26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportBrunner Donald G Kitfox · Rock Crossing, AZAn encounter with a downdraft while maneuvering at a low altitude, which resulted in an impact with terrain.NTSB WPR26LA118Accident · Minor injuriesClass 4 · LimitedFinal reportLindstrand 260A · Casa Grande, AZThe hot air balloon’s encounter with downdraft wind conditions in mountainous terrain and subsequent impact with terrain.NTSB WPR26LA077Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150A · Coolidge, AZThe pilot's failure to maintain clearance from transmission wires. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.NTSB WPR26LA025Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Queen Creek, AZThe pilot’s improper runway alignment and failure to maintain clearance from powerlines. Contributing to the accident was sun glare, which obscured the pilot’s view of the runway.NTSB WPR26LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 185C · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll with a left crosswind.NTSB WPR25LA206Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Page, AZThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR25LA187Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Kayenta, AZThe pilots’ failure to maintain airplane control during takeoff in gusting crosswind conditions, which resulted in a runway excursion.NTSB ANC25LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Flagstaff, AZThe pilot’s failure to maintain directional control during takeoff in variable and gusty wind, which resulted in a ground loop.NTSB WPR25LA107Accident · No injuriesClass 4 · LimitedFinal reportCessna T207A · Tusayan, AZAn encounter with wind gusts, which resulted in a loss of control and a collapse of the nose landing gear.NTSB WPR25LA057Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Glendale, AZThe pilot's failure to maintain directional control during the landing roll. .NTSB WPR25LA044Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Show Low, AZThe pilot’s failure to maintain directional control during the takeoff.NTSB WPR25LA040Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172I · Mayer, AZThe accumulation of carburetor ice, which resulted in a loss of engine power and a subsequent forced landing.NTSB WPR25LA032Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Prescott, AZThe flight instructor’s failure to maintain clearance from a fence during taxi. Contributing to the accident was the low light conditions and obstacles adjacent to the deice bay.NTSB WPR24LA243Accident · No injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Cottonwood, AZThe pilot’s low-speed, high-power maneuvering in high density altitude and near maximum gross weight, which resulted in an uncommanded right yaw due to a loss of tail rotor effectiveness and a subsequent hard landing.NTSB WPR24FA185Accident · 1 fatalClass 3 · FieldFinal reportRans S-12XL Airaile · Picacho Peak, AZThe pilot’s decision to conduct a low-altitude flight in mountainous terrain and his subsequent loss of airplane control after encountering mechanical turbulence, which resulted in an impact with the terrain.NTSB ANC24LA028Accident · No injuriesClass 4 · LimitedFinal reportTeam Rocket F1 · Payson, AZThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB ANC24LA030Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during takeoff in gusting wind conditions, which resulted in collision with an object.NTSB WPR24LA116Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Coolidge, AZThe student pilot’s improper landing flare, which resulted in a hard landing in gusty wind conditions. Contributing, was the failure of the flight instructor to intervene in a timely manner.NTSB WPR24FA052Accident · Serious injuriesClass 3 · FieldFinal reportRemos Remos GX · Taylor, AZThe pilot’s decision to attempt takeoff with frost covering the airplane’s wings, which led to an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB WPR24LA044Accident · No injuriesClass 4 · LimitedFinal reportTheodore C Kalman ELA Eclipse 10 · Yuma, AZThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB WPR24FA014Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Williams, AZThe pilot’s failure to maintain sufficient airspeed and exceedance of the airplane’s critical angle of attack during initial climb after takeoff, resulting in an aerodynamic stall. Contributing was the pilot’s inadequate preflight airplane performance…NTSB WPR24LA006Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-300 · Phoenix, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR23LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Marble Canyon, AZThe pilot’s loss of airplane control after an encounter with windshear during takeoff which resulted in collision with terrain.NTSB WPR23LA334Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Prescott, AZThe pilot-in-command’s inadequate preflight planning for the high density altitude and relative humidity conditions and his failure to recognize the need to reject the takeoff, allowing the student pilot to execute an abnormally long takeoff roll and apply…NTSB WPR23FA223Accident · 2 fatalClass 3 · FieldFinal reportCompagnie Daher TB 30 Epsilon · Apache Junction, AZThe pilot’s controlled flight into the mountainous terrain due to diminished depth perception as a result of the shadowing effect from the sun’s position. Contributing to the accident was the decision by all three pilots to fly low altitude around the…NTSB WPR23LA207Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Kingman, AZThe failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.NTSB WPR23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Queen Creek, AZThe airplane’s encounter with a dust devil after landing, which resulted in a loss of directional control.NTSB WPR23LA182Accident · No injuriesClass 4 · LimitedFinal reportSchempp-Hirth DISCUS-2B · Marana, AZThe pilot’s improper landing flare, which resulted in a hard bounced landing in a dust devil.NTSB WPR23LA132Accident · No injuriesClass 4 · LimitedFinal reportFay David Velocity Elite · Bullhead City, AZThe student pilot’s improper landing during crosswind conditions and the flight instructor’s failure to take remedial action, which resulted in a loss of control.NTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…NTSB WPR23LA015Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Prescott, AZThe pilot’s loss of directional control during landing with a wind gust, which resulted in a runway excursion and nose over.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.NTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.NTSB WPR22FA073Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Marana, AZThe pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions. Contributing to the accident was the pilot’s impairment due to use of methamphetamine before the flight.NTSB WPR22FA067Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Show Low, AZThe pilot’s exceedance of the airplane’s critical angle of attack following an aborted landing approach, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.NTSB WPR22LA066Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons U S A-315 · Phoenix, AZThe pilot’s inability to maintain balloon control during a high wind landing, which resulted in a serious passenger injury.NTSB WPR21LA341Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Camp Verde, AZThe pilot's inadequate preflight performance calculations which resulted in an aborted takeoff and collision with trees.NTSB WPR21FA227Accident · 1 fatalClass 3 · FieldFinal reportCovey Tri Quickie · Gila Bend, AZThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the reduced airplane performance due to high density…NTSB WPR21LA207Accident · No injuriesClass 4 · LimitedFinal reportCessna TU206 · Phoenix, AZThe pilot's failure to maintain directional control after an encounter with a windshear during the landing roll, which resulted in a runway excursion.NTSB WPR21LA193Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172R · Chandler, AZThe pilot’s failure to locate the airport which resulted in an approach to a road and subsequent collision with powerlines during a go-around in low light conditions.NTSB WPR21LA191Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic S A N-500 · Phoenix, AZThe pilot’s inability to maintain control after the balloon's encounter with an unexpected wind gust, which resulted in a collision with a tree.NTSB WPR21LA177Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182J · Sedona, AZThe pilot’s failure to maintain directional control during landing with a crosswind, which resulted in a collision with a fuel truck and a parked airplane.NTSB WPR21LA168Accident · No injuriesClass 4 · LimitedFinal reportDavis Donald M Bushby Mustang II · Maricopa, AZThe pilot’s failure to maintain airplane control during takeoff with a quartering right tailwind.NTSB WPR21LA166Accident · 2 fatalClass 3 · LimitedFinal reportCessna 140 · Williams, AZThe pilot’s loss of control due to spatial disorientation shortly after takeoff in night visual meteorological conditions.NTSB WPR21LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Marana, AZThe student pilot’s improper flare which resulted in a bounced, hard landing and loss of control in a gusting crosswind.NTSB WPR21LA113Accident · No injuriesClass 4 · LimitedFinal reportCubcrafter CCK-1865 · Quartzite, AZThe pilot’s failure to maintain airplane control during takeoff while operating in gusting wind conditions, which resulted in a collision with a cactus and the subsequent impact with terrain.NTSB WPR21LA093Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Queen Creek, AZThe pilot's uncoordinated flight control inputs while entering a hover, which lead to a loss of aircraft control which resulted in the left skid making contact with the ground, causing the helicopter to roll on its side.