NTSB investigations, AZ
510 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2008 | 38 |
|---|---|
| 2009 | 41 |
| 2010 | 29 |
| 2011 | 35 |
| 2012 | 42 |
| 2013 | 25 |
| 2014 | 34 |
| 2015 | 20 |
| 2016 | 20 |
| 2017 | 26 |
| 2018 | 36 |
| 2019 | 29 |
| 2020 | 19 |
| 2021 | 23 |
| 2022 | 30 |
| 2023 | 25 |
| 2024 | 17 |
| 2025 | 12 |
| 2026 | 9 |
Where
Open the mapLatest 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\", '0106'))
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", '0106')) 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 WPR26LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna A150L · Superior, AZThe pilot's failure to retract the flaps during takeoff following a touch-and-go landing, which resulted in degraded climb performance and an impact with an object during an off-field landing.NTSB WPR26LA138Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Mesa, AZThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB WPR26LA134Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage CUB-S · Young, AZThe pilot’s failure to maintain adequate clearance from trees during landing.NTSB WPR26LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Cottonwood, AZThe pilot’s improper flare, which resulted in a hard landing.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 WPR26LA122Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182M · Flagstaff, AZMaintenance personnel’s decision to conduct an engine run at takeoff power in front of an active taxiway, and their failure to notify ATC, which resulted in the accident pilot’s loss of control during taxi due to an encounter with a jet blast.NTSB WPR26LA113Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZThe solo student pilot's improper landing flare and subsequent improper recovery from a bounced landing.NTSB WPR26LA028Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Phoenix, AZA worn tailwheel steering mechanism, which resulted in a locked tailwheel and a ground loop during a landing roll.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 WPR26LA007Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Gila Bend, AZThe pilot’s improper throttle input and failure to maintain aircraft control during landing.NTSB WPR25LA209Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Colorado City, AZThe pilot’s exceedance of the airplane’s never-exceed speed (VNE) during maneuvering, which resulted in the in-flight separation of the left flaperon.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 WPR25LA189Accident · No injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · San Luis, AZThe pilot receiving instruction’s failure to properly recover the helicopter during an autorotative landing and the instructor pilot’s failure to intervene, which resulted in a hard landing.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 WPR25LA164Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Tucson Estates, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR25LA123Accident · No injuriesClass 4 · LimitedFinal reportPark Roderic B Kitfox IV · Marana, AZThe pilot’s failure to maintain clearance from an obstacle while performing an off-airport landing.NTSB WPR25LA105Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Cottonwood, AZThe pilot undergoing instructions’ loss of aircraft control during landing, and the flight instructor’s failure to promptly intervene.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 WPR25LA030Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Prescott Valley, AZSeparation of the No. 3 engine cylinder due to a loss of torque on the cylinder base nuts, which resulted in a loss of engine power and in-flight fire. Contributing to the accident was maintenance personnel’s failure to ensure the engine case and cylinder…NTSB WPR25LA009Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Mesa, AZThe pilot receiving instruction’s failure to maintain airspeed during landing and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB WPR24LA297Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Saint Johns, AZThe pilot’s improper landing flare that resulted in a hard landing.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 WPR24LA183Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Maricopa, AZThe flight instructor’s unstabilized approach during an autorotation that resulted in hard landing.NTSB WPR24LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Prescott, AZThe student pilot’s failure to maintain directional control during landing following an aborted takeoff which resulted in a runway excursion and impact with a ditch.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 WPR24LA118Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL18 · Phoenix, AZThe pilot’s failure to maintain directional control during the landing roll.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 WPR24LA108Accident · No injuriesClass 4 · LimitedFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Maricopa, AZThe pilot’s failure to maintain pitch control, which resulted in abnormal contact with the runway.NTSB WPR24LA097Accident · No injuriesClass 4 · LimitedFinal reportMark G Ellingson Kitfox IV · Mesa, AZThe pilot’s failure to maintain directional control during landing.NTSB WPR24LA077Accident · Minor injuriesClass 4 · LimitedFinal reportDennis Smith Eclipse 10 · Yuma, AZThe pilot’s decision to takeoff with low rotor RPM and his subsequent loss of control.NTSB WPR24LA061Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Prescott, AZLoss of directional control during landing due to an improperly constructed and maintained tailwheel locking assembly.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 WPR24LA028Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Mesa, AZThe pilot’s failure to maintain a proper autorotation profile during deceleration that resulted in the tail rotor assembly impacting the ground.NTSB WPR24LA029Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar International RX 8 · Page, AZA hard landing after both burner pilot lights extinguished during the landing approach for undetermined reasons. Contributing to the accident was the pilot's inability to relight the burner pilot lights.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 WPR24LA015Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Mesa, AZThe flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR24LA006Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-300 · Phoenix, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR23LA348Accident · No injuriesClass 3 · LimitedFinal reportChampion 7KCAB · Benson, AZThe pilots’ failure to maintain control of the aircraft during takeoff.NTSB WPR23LA340Accident · No injuriesClass 3 · LimitedFinal reportRutan Long-EZ · Bullhead City, AZThe pilot’s improper flair resulting 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…