NTSB investigations, AZ
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 WPR15CA044Accident · Serious injuriesData collectionFinal reportUltramagic N-250 · Wittman, AZThe pilot's failure to maintain control of the balloon when the wind unexpectedly increased which resulted in a collision with trees during the landing.NTSB WPR15CA043Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe certified flight instructor's failure to maintain helicopter control during the autorotation which resulted in a hard landing and subsequent roll over.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 WPR15CA033Accident · No injuriesData collectionFinal reportBeech A35 · Havasu City, AZLoss of engine power due to fuel starvation as a result of the pilot's failure to properly operate the fuel selector valve.NTSB WPR15TA027Accident · Serious injuriesFinal reportEurocopter AS 350 · Bisbee, AZFailure of maintenance personnel to ensure adequate torque of a pneumatic control pipe (P2) fitting, which resulted in a loss of engine power during low altitude flight maneuvers.NTSB WPR15LA020Accident · Serious injuriesLimited investigationFinal reportWinston W Walker Thunder Mustang · Globe, AZThe separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…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 WPR15CA026Accident · No injuriesData collectionFinal reportRockwell 690B · Mesa, AZThe failure of the nose gear tire, which resulted in the vibration of the nose landing gear and subsequent fire to the tire and forward section of the fuselage structure.NTSB WPR15CA018Accident · No injuriesData collectionFinal reportCessna 172 - R · Lake Havasu, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.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 WPR15CA004Accident · Minor injuriesData collectionFinal reportCessna 172S · Sedona, AZThe pilot's failure to maintain airplane control during the landing roll out.NTSB WPR14CA390Accident · No injuriesData collectionFinal reportWilliam M Oprendek Pitts S1S · Sedona, AZFailure of the tailwheel steering assembly during maneuvering flight, which resulted in a loss of directional control during the landing roll.NTSB WPR14CA396Accident · Minor injuriesData collectionFinal reportUltramagic N250 - NO Series · Phoenix, AZThe pilot's failure to maintain aircraft control while landing in downdraft and gusting wind conditions which resulted in striking trees and a subsequent hard landing.NTSB WPR14LA374Accident · No injuriesLimited investigationFinal reportBell 206 · Tombstone, AZA partial loss of engine power during cruise flight due to loose “B” nut fittings and a bent tube as a result of maintenance personnel’s inadequate inspection of the nuts during the most recent inspection.NTSB WPR14LA371Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Buckeye, AZA partial loss of engine power due to water contamination of the fuel.NTSB WPR14LA368Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Mesa, AZThe failure of the right main landing gear (MLG) transmission mounting bracket coupled with the differential rigging of the two landing gear cables, which prevented the right MLG from moving to the down-and-locked position before landing.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 WPR14LA343Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Rimrock, AZThe pilot's failure to maintain control of the airplane during the landing roll on a wet sloping runway and his decision to go around before the airplane was configured for takeoff.NTSB WPR14FA302Accident · 2 fatalField investigationFinal reportCessna 172K · Littlefield, AZThe pilot's failure to maintain airplane control when the airplane encountered high gusting wind while conducting low altitude flight in a narrow canyon, which resulted in an inflight collision with terrain.NTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.NTSB WPR14FA303Accident · 4 fatalField investigationFinal reportCessna 182L · Sedona, AZThe pilot’s failure to maintain adequate airspeed and his exceedance the airplane’s critical angle-of attack while maneuvering through a canyon in high-density altitude conditions at low altitude, which resulted in an aerodynamic stall.NTSB WPR14CA289Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll.NTSB WPR14TA278Accident · No injuriesFinal reportRockwell International 500 S · Willcox, AZThe pilot’s failure to compensate for tailwind conditions and maintain directional control during landing, which resulted in a runway excursion.NTSB WPR14CA376Accident · No injuriesData collectionFinal reportCessna 182K · Mesa, AZThe student pilot's inadequate landing flare which resulted in a loss of aircraft control and hard landing.NTSB WPR14CA266Accident · No injuriesData collectionFinal reportLuscombe 8A · Tucson, AZThe student pilot's use of excessive brakes during taxi, which resulted in a loss of aircraft control.NTSB WPR14CA259Accident · No injuriesData collectionFinal reportBeech A23 24 · Sedona, AZThe pilot's inadequate flare and failure to maintain directional control during the aborted landing.NTSB WPR14FA262Accident · 2 fatalField investigationFinal reportMooney M20B · Page, AZThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a canyon in high-density altitude conditions.NTSB WPR14CA260Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Scottsdale, AZThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB WPR14LA242Accident · No injuriesLimited investigationFinal reportAdams Dragonfly · Mesa, AZA partial loss of engine power due to a reduction in the No. 3 cylinder’s compression as a result of the exhaust valve not having consistent uniform contact with the cylinder head valve seat.NTSB WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…NTSB WPR14LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Page, AZThe pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.NTSB WPR14CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe inadvertent activation of the engine's mixture control during cruise flight by the pilot undergoing instruction, which resulted in a total loss of engine power. Contributing to the accident was the flight instructor's inadequate monitoring of the pilot's…NTSB WPR14CA216Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · San Manuel, AZThe pilot's failure to maintain an adequate obstacle clearance altitude from phone wires while performing low-level operations.NTSB WPR14CA224Accident · No injuriesData collectionFinal reportMeyers MAC 145 · La Cholla, AZThe pilot's overcorrection to a wind gust, which resulted in a loss of directional control and runway veeroff.NTSB WPR14LA199Accident · No injuriesLimited investigationFinal reportBeech H35 · Parker, AZThe improperly attached fuel line and cracked fuel diaphragm due to unknown personnel’s inadequate maintenance, which resulted in the loss of engine power during cruise flight and the subsequent forced landing onto rough terrain.NTSB WPR14CA274Accident · No injuriesData collectionFinal reportCessna 172 - R · Buckeye, AZThe pilot's improper landing flare, which resulted in a hard landing.NTSB WPR14FA195Accident · 1 fatalField investigationFinal reportAmerican Eurocopter AS350B3 · Peach Springs, AZThe pilot’s decision to exit the helicopter while it was running and his failure to properly secure the flight controls with the engine operating at flight idle before exiting the helicopter.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 WPR14CA202Accident · No injuriesData collectionFinal reportPiper J3C 65 · Tucson, AZThe pilot's failure to maintain directional control during the landing roll.NTSB WPR14CA193Accident · No injuriesData collectionFinal reportKalman George Lancair 360 · Grand Canyon, AZThe pilot's inadequate flare, which resulted in a hard landing.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 WPR14FA181Accident · 1 fatalField investigationFinal reportAero Tek Zuni · Aguila, AZThe pilot's inability to maintain control of the glider after the tow cable separated prematurely due to an incomplete engagement of the cable in the control tow release system due to a missing spring.NTSB 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.NTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…NTSB WPR14CA168Accident · Minor injuriesData collectionFinal reportLinstrand 240A · Mayer, AZThe balloon's encounter with unexpected increased wind, which resulted in a hard landing on rough terrain.NTSB WPR14CA151Accident · No injuriesData collectionFinal reportAviat A 1B · Eloy, AZThe pilot's failure to maintain directional control during takeoff.NTSB WPR14CA156Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Mesa, AZThe student pilot's excessive speed during taxi which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate monitoring of the remaining runway length available during the landing roll.NTSB WPR14CA140Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Coolidge, AZThe pilot's failure to maintain directional control during landing.NTSB WPR14CA143Accident · No injuriesData collectionFinal reportGrumman TMB-3E · Glendale, AZThe pilot inadvertently raised the landing gear lever rather than the adjacent flap level while exiting the runway which resulted in the retraction of the left main landing gear.NTSB WPR14LA119Accident · 1 fatalLimited investigationFinal reportSabrena Dragonfly · Maricopa, AZThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in the airplane exceeding its critical angle of attack and subsequently experiencing an aerodynamic stall and spin at a low altitude.