NTSB investigations, AZ
75 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 6 |
| 2010 | 7 |
| 2011 | 2 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 7 |
| 2015 | 6 |
| 2016 | 9 |
| 2017 | 1 |
| 2018 | 5 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 1 |
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\", '05000000'))
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", '05000000')) 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 WPR23LA107Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH-58A · Yuma, AZA total loss of engine power for reasons that could not be determined.NTSB WPR23LA013Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Tucson, AZThe pilot’s loss of control during landing for reasons that could not be determined based on the available evidence.NTSB ANC22FA030Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Gila Bend, AZThe student pilot’s failure to maintain control during the landing approach.NTSB WPR21FA175Accident · 2 fatalClass 3 · FieldFinal reportSwearingen SA226-T(B) · Winslow, AZThe loss of engine power to the right engine for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane.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 WPR20LA109Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker 800XP · Scottsdale, AZThe pilot’s inability to maintain directional control during landing for undetermined reasons, which resulted in a runway excursion.NTSB WPR20CA080Accident · No injuriesClass 4 · Data collectionFinal reportMerwin Kitfox · Goodyear, AZThe tail wheel mechanism detachment for reasons that could not be determined due to the lack of available evidence which resulted in the loss of directional control on landing.NTSB WPR20LA040Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV 6 · Pima, AZA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA20CA039Accident · No injuriesData collectionFinal reportZenair CH 701 · Safford, AZThe in-flight separation of a propeller blade for reasons that could not be determined based on the available evidence, which resulted in an off-airport landing on soft sand and the separation of main landing gear. Contributing to the accident was the pilot’s…NTSB WPR19LA140Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Red Rock, AZA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19TA037Accident · Minor injuriesClass 3Final reportScottish Series 100 MDL 101 · Lake Pleasant, AZImpact with a lake for undetermined reasons.NTSB WPR18LA197Accident · No injuriesClass 3 · LimitedFinal reportBeech 90 · Tolani Lake, AZAn autopilot deviation during climb for undetermined reasons, which resulted in an in-flight upset and loss of airplane control. Contributing to the accident was the pilot’s failure to adequately monitor flight systems due to a distraction.NTSB WPR18LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Aguila, AZA total loss of engine power due to pre-ignition/detonation for reasons that could not be determined based on available information.NTSB WPR18LA152Accident · No injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Heli 369FF · Wikieup, AZA vibration of the helicopter for reasons that could not be determined based on the available information, which resulted in a forced landing and the main rotor contacting the tailboom.NTSB ANC18LA034Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman TBM-3 · Fort Apache, AZA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR17LA148Accident · No injuriesLimited investigationFinal reportCharles J Norris Arion Lightning · New River, AZA partial loss of engine power for reasons that could not be determined due to a lack of available evidence.NTSB WPR17LA038Accident · No injuriesLimited investigationFinal reportCessna 182A · Safford, AZThe total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.NTSB WPR17LA020Accident · No injuriesLimited investigationFinal reportPiper PA 28-235 · Taylor, AZA total loss of engine power for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.NTSB WPR16LA179Accident · No injuriesClass 3 · LimitedFinal reportMccluskey Challenger II · Bisbee, AZA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR16FA158Accident · 1 fatalField investigationFinal reportPiper PA 34-200T · Flagstaff, AZA departure flight path that consisted of several unexplained turns during the initial climbout, and terminated in a high-speed descent and ground impact. The reason(s) for the turns and descent could not be determined due to lack of definitive evidence.NTSB WPR16FA112Accident · 2 fatalField investigationFinal reportNorth American AT 6 · Mesa, AZThe pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.NTSB WPR16LA106Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Winslow, AZThe partial loss of engine power during takeoff initial climb in high-density altitude conditions for reasons that could not be determined because a postaccident examination of the airplane and engine revealed no anomalies.NTSB WPR16LA080Accident · Serious injuriesLimited investigationFinal reportNorth Wing Apache · Queen Creek, AZA loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the noncertificated pilot’s lack of experience in the…NTSB WPR16LA079Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Fountain Hills, AZA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA057Accident · Minor injuriesLimited investigationFinal reportEnstrom 280 · Phoenix, AZA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR16LA043Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar Acft Corp Of Texas M20F · Nogales, AZThe airplane’s impact with a hillside shortly after takeoff for reasons that could not be determined.NTSB WPR15LA254Accident · Minor injuriesLimited investigationFinal reportRaudenbush Ernie Lancair Super ES · Winkelman, AZA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB WPR15LA183Accident · No injuriesLimited investigationFinal reportBeech E33A · Tucson, AZA loss of left braking action for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal operation, which resulted in a loss of…NTSB WPR15LA179Accident · No injuriesLimited investigationFinal reportBurr Express 2000 RG · Glendale, AZA collapse of the left main landing gear for reasons that could not be determined based on the available information.NTSB WPR15LA139Accident · No injuriesLimited investigationFinal reportBeech H35 · Tucson, AZA partial loss of engine power during initial takeoff climb for reasons that could not be determined because postaccident examination revealed no evidence of a mechanical anomaly that would have precluded normal operation.NTSB WPR15LA131Accident · Serious injuriesLimited investigationFinal reportMccurry Charles P F 1 Rocket · Sedona, AZThe partial loss of engine power during final approach for reasons that could not be determined during postaccident examination of the engine.NTSB WPR15LA052Accident · Minor injuriesLimited investigationFinal reportNanchang CJ-6 · Mesa, AZThe total loss of engine power during takeoff following a touch-and-go landing for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR15LA048Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Somerton, AZA loss of airplane control for reasons that could not be determined based on available evidence.NTSB WPR15LA038Accident · No injuriesLimited investigationFinal reportCessna 210B · Bullhead City, AZThe failure of the landing gear actuator housing during landing for reasons that could not be determined based on the available evidence.NTSB WPR15IA035Incident · No injuriesIncident investigationFinal reportNorth American P51 - D · Mesa, AZThe failure of the left main landing gear to extend, which resulted in a gear-up landing. The reason for the left main landing gear’s failure to operate normally could not be determined because postincident examination of the landing gear system did not…NTSB WPR15LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA28 151 · Bullhead City, AZA partial loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR14FA194Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Fort Huachuca, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…NTSB WPR14FA186Accident · 1 fatalField investigationFinal reportCessna T207A · Page, AZThe pilot’s inability to maintain aircraft control due to a partial loss of engine power and an encounter with downdrafts and gusting crosswinds while on final approach to the runway. The reason for the partial loss of engine power could not be determined…NTSB WPR13LA408Accident · No injuriesLimited investigationFinal reportCessna 182A · Casa Grande, AZA loss of engine power during final approach for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB WPR13CA348Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZA substantially damaged firewall that occurred during an unknown phase of flight for reasons that could not be determined.NTSB WPR13LA266Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Grand Canyon, AZA loss of throttle control movement during a practice autorotation that was planned to terminate with a power recovery for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal…NTSB WPR13LA161Accident · No injuriesLimited investigationFinal reportOwens Velocity 173 · Maricopa, AZA loss of engine power for reasons that could not be determined because postaccident examination of the throttle body revealed no anomalies that would have precluded normal operation.NTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.NTSB WPR13CA092Accident · No injuriesData collectionFinal reportHeinz Rans S-4 Coyote · Lake Pleasant, AZA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.NTSB WPR13LA078Accident · No injuriesLimited investigationFinal reportCessna 210A · Chandler, AZA loss of engine power during takeoff climb for reasons that could not be determined because postaccident examination and testing of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR13LA034Accident · No injuriesLimited investigationFinal reportJeffair Barracuda · Payson, AZThe failure of the landing gear to remain extended during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13FA017Accident · 1 fatalField investigationFinal reportCessna 182P · Yucca, AZThe pilot’s failure to take corrective action to avoid terrain during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA408Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZA total loss of engine power during descent for reasons that could not be determined because postaccident engine examinations and testing revealed no evidence of an anomaly that would have precluded normal operation.NTSB WPR12FA326Accident · 3 fatalField investigationFinal reportBeech B60 · Sedona, AZThe airplane’s failure to rotate and the pilot’s failure to reject the takeoff, which resulted in a runway overrun for reasons that could not be undetermined because postaccident examination of the airplane and engines did not reveal any malfunctions or…NTSB WPR12LA247Accident · No injuriesLimited investigationFinal reportPiper PA28R · Peoria, AZA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.