NTSB investigations, AZ
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 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 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 WPR26LA022Accident · Minor injuriesClass 3 · LimitedPreliminary reportFlight Design Ctsw · Casa Grande, AZOn October 17, 2025, about 13:20 mountain standard time, a Flight Design GMBH CTSW, N531CT, was substantially damaged when it was involved in an accident near Casa Grande, Arizona. The pilot received minor injuries. The airplane was operated as a Title 14…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 WPR26LA002Incident · No injuriesClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0958 mountain standard time, an Amazon.Com Services LLC, MK30, N791PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…NTSB WPR26LA001IncidentClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0949 mountain standard time, an Amazon.Com Services LLC, MK30, N579PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…NTSB WPR25LA305Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150F · Lake Havasu City, AZOn September 26, 2025, at about 0915 mountain standard time, a Cessna 150F, N8171S, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane…NTSB WPR25LA291Accident · Minor injuriesClass 3 · LimitedPreliminary reportPipistrel D O O Alpha Trainer · Wittman, AZOn September 25, 2025, at about 0653 mountain daylight time, a Pipistrel D O O Alpha Trainer, N246EA, was substantially damaged when it was involved in an accident near Wittman, Arizona. The two pilots on board received minor injuries. The airplane was…NTSB WPR25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Lake Havasu City, AZThe pilot’s failure to extend the landing gear before landing due to distraction and failure to conduct the before landing checklist.NTSB WPR25LA265Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 120 · Taylor, AZOn August 24, 2025, about 0711 mountain daylight time, a Cessna 120, N3151N, was substantially damaged when it was involved in an accident near Taylor, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25FA253Accident · 1 fatalClass 3 · FieldPreliminary reportPitts S-1T · Goodyear, AZOn August 12, 2025, about 1019 mountain standard time, a Pitts S-1T, N51HC, was substantially damaged when it was involved in an accident near Goodyear, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA248Accident · Minor injuriesClass 3 · LimitedPreliminary reportDe Havilland DHC-6-300 · Whitmore, AZOn August 9, 2025, about 1240 Pacific daylight time, a De Havilland DHC-6-300, N189GC, was substantially damaged when it was involved in an accident near Whitmore, Arizona. Six passengers sustained minor injuries, and the captain, first officer and remaining…NTSB WPR25FA240Accident · 4 fatalClass 3 · FieldPreliminary reportBeech 300 · Chinle, AZOn August 5, 2025, about 1245 mountain daylight time, a Beech 300, N534AW, was destroyed when it was involved in an accident near Chinle, Arizona. The pilot, co-pilot and two medical crew members were fatally injured. The airplane was operated as a Title 14…NTSB WPR25LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 182L · Tucson Estates, AZThe pilot’s inability to stop the airplane on the runway during a rejected takeoff for undetermined reasons, which resulted in the airplane’s impact with a ditch.NTSB WPR25LA218Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 425 · Round Rock, AZOn July 17, 2025, about 1600 mountain daylight time, a Cessna 425, N425D, was substantially damaged when it was involved in an accident near Round Rock, Arizona. The pilot receiving instruction and the flight instructor were not injured. The airplane was…NTSB WPR25LA217Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna TR182 · Tuba City, AZOn July 17, 2025, about 1447 mountain standard time, a Cessna TR182, N182KC, was substantially damaged when it was involved in an accident near Tuba City, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…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 CEN25FA212Accident · 2 fatalClass 3 · FieldPreliminary reportCessna A150L · Three Points, AZOn June 18, 2025, about 0922 mountain standard time, a Cessna A150L airplane, N6436F, was substantially damaged when it was involved in an accident near Three Points, Arizona. The student pilot and flight instructor were fatally injured. The airplane was…NTSB DCA25LA230Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Phoenix, AZThe abrupt application of brakes during taxi, which resulted in a sudden stop and caused a flight attendant to sustain a serious injury.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 WPR25LA170Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150M · Phoenix, AZOn June 6, 2025, about 0530 mountain standard time, a Cessna 150M, N45659, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane was operated as a…NTSB WPR25LA164Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Tucson Estates, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR25LA148Accident · No injuriesClass 3 · LimitedPreliminary reportRutan LONG-EZE · Tucson, AZOn May 1, 2025, about 1030 mountain standard time, an experimental amateur-built Long EZE, N433EZ, was substantially damaged when it was involved in an accident near Tucson, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA136Accident · No injuriesClass 3 · LimitedPreliminary reportD'Apuzzo Senior Aero Sport · Phoenix, AZOn April 19, 2025, about 1106 Pacific daylight time, an experimental amateur built D'Apuzzo Senior Aero Sport, N321WC, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The pilot was not injured. The airplane was operated as…NTSB WPR25LA131Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-260 · Green Valley, AZThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR25LA129Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 170A · Maricopa, AZOn April 10, 2025, at 1207 mountain standard time, a Cessna 170A, N1371D, sustained substantial damage when it was involved in an accident near Maricopa, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA135Accident · No injuriesClass 4 · LimitedFinal reportMartin Uav Vbat · Douglas, AZThe malfunction of the throttle servo which resulted in the complete loss of engine power.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 OPS25LA025IncidentClass 4 · LimitedInvestigation openBoeing 737-823 · Goodyear, AZNTSB 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 WPR25FA097Accident · 2 fatalClass 3 · FieldPreliminary reportLancair 360 · Marana, AZOn February 19, 2025, about 0828 mountain standard time, a Lancair 360 Mk II, N3602M, was destroyed, and a Cessna 172S, N463ER, sustained minor damage when they were involved in a mid-air collision near Marana Regional Airport (AVQ), Marana, Arizona. The…NTSB WPR25LA094Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210R · Flagstaff, AZOn February 16, 2025, about 1445 mountain standard time, a Cessna T210R, N105DF, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25FA088Accident · 1 fatalClass 2 · FieldPreliminary reportGates Learjet 35A · Scottsdale, AZOn February 10, 2025, about 1438 mountain standard time, a Gates Learjet 35A, was substantially damaged when it was involved in an accident near Scottsdale, Arizona. The captain was fatally injured, the first officer (FO) and one passenger were seriously…NTSB WPR25LA099Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Salome, AZThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection.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 WPR25LA084Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · Prescott, AZOn January 18, 2025, about 1210 Mountain standard time, a Cessna P210N, N4626K, sustained substantial damage when it was involved in an accident near Prescott, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…NTSB WPR25LA070Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV-7A · Gila Bend, AZA disconnection of the mixture control linkage during flight, which resulted in fuel starvation and a total loss of engine power. Contributing was the inadequate inspection of the mixture control arm attachment hardware.NTSB WPR25LA065Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-24-250 · Mesa, AZOn December 19, 2024, about 1515 mountain standard time, a Piper PA-24-250, N7833P, was involved in an accident near Mesa, Arizona. The pilot and pilot-rated passenger were not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB WPR25LA057Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Glendale, AZThe pilot's failure to maintain directional control during the landing roll. .NTSB WPR25LA052Accident · No injuriesClass 3 · LimitedPreliminary reportBeech 35-33 · Willcox, AZOn December 1, 2024, about 1300 mountain standard time, a Beech 35-33, N109V, was substantially damaged when it was involved in an accident near Willcox, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR25LA049Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SF50 · Mesa, AZThe pilot’s improper landing gear selection during the takeoff roll and failure to maintain airplane control during a rejected takeoff, which resulted in abnormal contact with the runway and a collapse of the nose landing gear.NTSB WPR25LA044Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Show Low, AZThe pilot’s failure to maintain directional control during the takeoff.NTSB WPR25LA042Accident · No injuriesClass 4 · LimitedFinal reportRemos GX · Prescott, AZThe Remos pilot’s failure to maintain clearance from another airplane while taxiing, which resulted in a ground collision.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 WPR25FA031Accident · 5 fatalClass 3 · FieldPreliminary reportHonda HA420 · Mesa, AZOn November 5, 2024, at 1639 mountain daylight time, a Honda HA-420, N57HP, was destroyed when it was involved in an accident near Mesa, AZ. The pilot and three passengers were fatally injured, one passenger was seriously injured, and the single occupant of…