NTSB investigations, AZ
23 cases where NTSB found Aircraft structures.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2023 | 2 |
| 2025 | 1 |
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\", '0103'))
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", '0103')) 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 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 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 WPR24LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · Yuma, AZAeroelastic flutter of the rudder control surface during the takeoff initial climb for reasons that could not be determined based on the available evidence, which resulted in the fracture of the rudder trim control rod end in flight.NTSB WPR21FA266Accident · 2 fatalClass 3 · FieldFinal reportBeech C90 · Wikieup, AZThe failure and separation of the left wing’s outboard section due to a fatigue crack in the lower spar cap. Contributing to the accident was the operator’s decision to repair the wing spar instead of replacing it as recommended by the aircraft manufacturer.…NTSB WPR21LA142Accident · No injuriesClass 3 · LimitedFinal reportDavis Dan B Lancair Evolution · Phoenix, AZA malfunction of the main cabin door latching mechanism for reasons that could not be determined based on the available information.NTSB WPR21LA037Accident · No injuriesClass 3 · LimitedFinal reportRemos Aircraft Gmbh Flugzeugbau GX · Glendale, AZThe material overstress failure of the airframe’s aluminum carry-through of the main landing gear.NTSB WPR20LA130Accident · 1 fatalClass 3 · LimitedFinal reportBell UH 1H · Mesa, AZAn in-flight separation of the tail rotor gearbox from the airframe due to fatigue failure of the gearbox attachment studs, resulting in a loss of directional control and subsequent ground impact. Contributing to the accident were 1) the improper application…NTSB WPR20LA004Accident · Minor injuriesClass 3 · LimitedFinal reportGlaser Dirks DG500 · Marana, AZThe pilots’ exceedance of the glider’s never-exceed speed (VNE) during recovery from an intentional aerobatic maneuver, which resulted in a failure of the right-wing air brake control drive, asymmetrical air brake deployment, and a subsequent hard landing.NTSB WPR18LA121Accident · Minor injuriesClass 3 · LimitedFinal reportAirborne Windsports PTY XT-912-L · Peoria, AZAn inflight loss of control due to failure of the weight-shift-control aircraft's wing assembly.NTSB GAA18LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Mesa, AZA coyote strike and the subsequent operation of the airplane, which led to internal composite wing structure damage.NTSB WPR17FA134Accident · 2 fatalField investigationFinal reportJordan John RV7 · Arlington, AZThe inflight overstress separation of the vertical stabilizer and rudder during flight which resulted in the pilot's inability to maintain airplane control. Contributing to the accident was an inflight collision with a bird.NTSB GAA17CA344Accident · No injuriesData collectionFinal reportEurocopter EC130 · Peach Springs, AZThe ground crewman’s failure to hold onto the passenger door while the main rotor was still rotating, which resulted in the door separating from the helicopter and damaging the main rotor.NTSB WPR16FA183Accident · Serious injuriesField investigationFinal reportCessna 182P · Gilbert, AZAn inadvertent explosion of pyrotechnics, which were contained in a box that had been installed on the airplane's left main landing gear assembly spring leg which resulted in shrapnel striking the airplane's left wing and breaching the left wing fuel tank,…NTSB DCA16CA197Accident · No injuriesData collectionFinal reportFacebook UK Aquila · Yuma, AZa structural failure of the wing as a result of exceeding the airspeed envelope due to wind gusts which were beyond the capabilities of the autopilot. Contributing to the accident was an insufficient amount of drag to track the glideslope in the presence of…NTSB WPR15IA244Incident · No injuriesIncident investigationFinal reportQuest Kodiac 100 · Page, AZThe pilot's inadvertent failure to engage the seat in the locked position before takeoff, which resulted in the seat sliding back during the takeoff roll and a subsequent loss of directional control. Contributing to the incident was the seat locking…NTSB WPR14CA350Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 34 · Marana, AZThe pilot's failure to ensure the canopy was locked during the pre-takeoff inspection which led to the canopy opening in flight and the pilot's failure to maintain aircraft control during the subsequent landing.NTSB WPR12LA442Accident · 1 fatalLimited investigationFinal reportAir Creation Tanarg · Safford, AZThe pilot’s failure to maintain airplane control while maneuvering in high wind conditions and his failure to adjust the trim appropriately. Contributing to the accident was the airplane’s nonstandard modified wing configuration.NTSB WPR12FA297Accident · Serious injuriesField investigationFinal reportMooney M20L · Scottsdale, AZThe pilot's failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action. Contributing to the accident were the pilot’s improper landing flare, which resulted in a bounced landing, and his premature flap…NTSB DCA11MA039Accident · Minor injuriesMajor investigationFinal reportBoeing 737 · Yuma, AZthe improper installation of the fuselage crown skin panel at the S-4L lap joint during the manufacturing process, which resulted in multiple site damage fatigue cracking and eventual failure of the lower skin panel. Contributing to the injuries was flight…NTSB WPR11LA169Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Mesa, AZThe pilot's attempt to correct a landing float by adding power, followed by his premature attempt to climb the airplane out of ground effect during a balked landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure…NTSB WPR10LA161Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9 118 · Phoenix, AZThe pilot’s improper preflight inspection of the balloon’s rapid deflation system, which resulted in its inhibited functionality during landing.NTSB WPR09LA075Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Casa Grande, AZThe pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.NTSB SEA08LA101Accident · Minor injuriesLimited investigationFinal reportJihlavan KP 5 ASA · Marana, AZThe pilot's failure to maintain an airspeed above stalling speed (Vs) during an emergency landing after takeoff. Contributing to the accident was an inadequate preflight inspection, and the airplane's canopy coming partially open shortly after takeoff.