NTSB investigations, 2008, AZ
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 per year
| 1963 | 1 |
|---|---|
| 1964 | 130 |
| 1965 | 107 |
| 1966 | 128 |
| 1967 | 138 |
| 1968 | 114 |
| 1969 | 115 |
| 1970 | 102 |
| 1971 | 128 |
| 1972 | 101 |
| 1973 | 105 |
| 1974 | 101 |
| 1975 | 121 |
| 1976 | 105 |
| 1977 | 123 |
| 1978 | 149 |
| 1979 | 130 |
| 1980 | 114 |
| 1981 | 132 |
| 1982 | 123 |
| 1983 | 114 |
| 1984 | 84 |
| 1985 | 78 |
| 1986 | 77 |
| 1987 | 76 |
| 1988 | 61 |
| 1989 | 79 |
| 1990 | 68 |
| 1991 | 86 |
| 1992 | 88 |
| 1993 | 68 |
| 1994 | 65 |
| 1995 | 73 |
| 1996 | 68 |
| 1997 | 71 |
| 1998 | 54 |
| 1999 | 64 |
| 2000 | 61 |
| 2001 | 63 |
| 2002 | 76 |
| 2003 | 93 |
| 2004 | 72 |
| 2005 | 81 |
| 2006 | 77 |
| 2007 | 66 |
| 2008 | 73 |
| 2009 | 74 |
| 2010 | 63 |
| 2011 | 67 |
| 2012 | 61 |
| 2013 | 54 |
| 2014 | 62 |
| 2015 | 42 |
| 2016 | 40 |
| 2017 | 50 |
| 2018 | 60 |
| 2019 | 47 |
| 2020 | 36 |
| 2021 | 44 |
| 2022 | 53 |
| 2023 | 43 |
| 2024 | 41 |
| 2025 | 45 |
| 2026 | 45 |
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 year(c.\"eventDate\") = 2008
AND 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 year(c."eventDate") = 2008 AND 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 WPR09FA062Accident · 1 fatalField investigationFinal reportDiamond DA 20-C1 · Alamo Lake State Park, AZThe pilot's failure to maintain control during the performance of a maneuver and his failure to recover from the subsequent aerodynamic stall and spin.NTSB WPR09CA054Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe failure of the student pilot to maintain directional control during takeoff.NTSB WPR09CA053Accident · No injuriesData collectionFinal reportCessna 172 · Sedona, AZThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB WPR09FA038Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Sedona, AZThe partial loss of engine power while maneuvering for undetermined reasons.NTSB DCA09FA009Accident · No injuriesField investigationFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZthe failure of the pilot to timely flare the aircraft to the appropriate attitude, likely associated with the different sight picture after switching cameras, resulting in a bounced landing; and the evaluator pilot’s lack of timely recognition and…NTSB WPR09CA031Accident · No injuriesData collectionFinal reportPiper PA-22-135 · San Manuel, AZThe pilot's failure to maintain lateral aircraft control that resulted in collision with terrain during landing.NTSB WPR09LA029Accident · No injuriesLimited investigationFinal reportCessna 421C · Mesa, AZThe failure of the hydraulic landing gear extension systems due to a ruptured line.NTSB WPR09LA024Accident · No injuriesLimited investigationFinal reportHolm Michael J Kitfox IV 1200 · Glendale, AZThe Kitfox's pilot's failure to ascertain if the intersection he approached was clear of conflicting traffic and the controller's failure to provide pertinent traffic advisories to both pilots. Contributing to the accident was the reduced visibility from the…NTSB WPR09LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Coolidge, AZA total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB DCA09FA004Accident · No injuriesField investigationFinal reportAirbus 320 · Phoenix, AZThe failure of the flightcrew to arrest an excessive sink rate during the flare for landing.NTSB WPR09CA017Accident · No injuriesData collectionFinal reportPiper L-4 · Buckeye, AZAnother airplanes total loss of wheel brakes while taxing which resulted in the pilot of the other aircraft colliding with a standing aircraft. Contributing to the accident was the other airplanes low brake hydraulic fluid.NTSB WPR09TA012Accident · 1 fatalFinal reportBell 407 · Sedona, AZThe paramedic's failure to monitor and maintain clearance from the rotating main rotor blades after exiting the helicopter.NTSB WPR09CA008Accident · No injuriesData collectionFinal reportBell 47J-2A · Florence, AZThe pilot’s inadequate compensation for a wind shift encountered during the landing approach, which resulted in a hard landing and rollover. Contributing to the accident was the encounter with the wind shift.NTSB WPR09CA003Accident · No injuriesData collectionFinal reportBeech 76 · Eloy, AZThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident were the crosswind wind conditions and terrain induced turbulence.NTSB SEA08CA208Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Flagstaff, AZThe pilot's decision to attempt a takeoff in a high density altitude high gross weight condition that exceeded the takeoff performance capability of the helicopter. The pilot's failure to maintain adequate rotor rpm was also causal. Contributing factors were…NTSB DEN08IA160IncidentIncident investigationFinal reportRaytheon Cobra · Whetstone, AZA total off of engine power resulting from an overheated piston, and the pilot's subsequent failure to send a proper command to the UAS. Contributing to the accident was the operation of the engine at high power for an extended period with a lean fuel setting.NTSB LAX08CA298Accident · Minor injuriesData collectionFinal reportRobinson R22B · Prescott, AZThe student pilot's failure to maintain adequate main rotor rpm and the instructor's inadequate supervision and delayed remedial action.NTSB SEA08FA187Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Springerville, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.NTSB LAX08CA270Accident · No injuriesData collectionFinal reportCessna 182Q · Mesa, AZThe pilot's failure to maintain directional control during landing.NTSB LAX08LA269Accident · No injuriesLimited investigationFinal reportCessna TU206F · Glendale, AZA loose fuel line fitting that resulted in a partial loss of engine power during the initial takeoff climb. Contributing to the accident was inadequate maintenance installation of the fitting.NTSB SEA08CA189Accident · No injuriesData collectionFinal reportAeros Venture · Maricopa, AZThe pilot's selection of unsuitable terrain for a precautionary landing and subsequent takeoff attempt, and his misjudging of the required takeoff distance. The soft terrain was a factor.NTSB SEA08CA181Accident · No injuriesData collectionFinal reportEberle Pitts S1S · Show Low, AZThe pilot failed to maintain directional control during landing. Contributing to the accident was the pilot's limited experience in the airplane.NTSB SEA08CA180Accident · No injuriesData collectionFinal reportCessna 177 · Glendale, AZThe loss of engine power due to vapor lock. Contributing to the accident was the high atmospheric temperature.NTSB SEA08LA179Accident · 1 fatalLimited investigationFinal reportCessna 177 · St. Johns, AZThe failure of both pilots to abort the takeoff when a suitable climb rate could not be attained. Contributing to the accident was the reduction of available power due to the camshaft lobe and lifter corrosion/wear, the high density altitude, and the CFI’s…NTSB LAX08FA267Accident · 1 fatalField investigationFinal reportCessna TR182 · Sahuarita, AZThe pilot’s failure to maintain clearance from mountainous terrain while maneuvering at low altitude for undetermined reasons.NTSB LAX08CA294Accident · No injuriesData collectionFinal reportAir Creation Clipper 912 · Glendale, AZThe airplane's encounter with a dust devil.NTSB LAX08CA252Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe student pilot's misjudged altitude and distance, and failure to attain the proper touchdown point, that led to a landing overrun.NTSB LAX08CA257Accident · No injuriesData collectionFinal reportCessna 150M · Phoenix, AZThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB LAX08LA231Accident · 1 fatalLimited investigationFinal reportNichols Rans S-14 · Benson, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot's impairment from recent marijuana use.NTSB DEN08MA116Accident · 7 fatalMajor investigationFinal reportBell 407 · Flagstaff, AZBoth helicopter pilots’ failure to see and avoid the other helicopter on approach to the helipad. Contributing to the accident were the failure of N407GA’s pilot to follow flight arrival route guidelines, and the failure of N407MJ’s pilot to follow…NTSB LAX08LA198Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Ash Fork, AZThe pilot's spatial disorientation resulting in his failure to detect and compensate for an unintentional descent during a go-around. Contributing to the accident were the pilot's inadequate choice of landing approach, reduced visibility from brownout…NTSB ENG08IA051Incident · No injuriesIncident investigationFinal reportBoeing 737 · Phoenix (PHX), AZThe failure of the MLG was due to cracking in the cylinder wall resulting from a fatigue mechanism which initiated at, and near the inner diameter (ID) surface, with propagation through the wall toward the outer diameter(OD) surface. Crack initiation was due…NTSB LAX08CA199Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot's inadequate recovery from a bounced landing and failure to maintain directional control.NTSB LAX08CA180Accident · No injuriesData collectionFinal reportCessna 207 · Page, AZThe pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the crosswind weather conditions and the high density altitude conditions.NTSB LAX08CA166Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Kykotsmovi, AZFuel exhaustion due to the pilot's inadequate preflight planning and failure to ensure that adequate fuel was onboard to complete the flight.NTSB SEA08LA149Accident · 1 fatalLimited investigationFinal reportVan Heeswyk Lightning · Marana, AZThe insufficient clamping force resulting in a fatigue fracture of the propeller extension attachment bolts and subsequent separation of the propeller assembly in flight. Contributing to the accident was the pilot's failure to maintain sufficient airspeed to…NTSB LAX08CA155Accident · No injuriesData collectionFinal reportCessna 172N · Sells, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain proper runway alignment.NTSB SEA08LA137Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Tolani Lake, AZAn in-flight collision with terrain for undetermined reasons.NTSB LAX08LA153Accident · No injuriesLimited investigationFinal reportCessna P210N · Peach Springs, AZA loss of engine power due to induced catastrophic internal failure of the engine as a result of the displacement and rotation of the number 2 main bearing that resulted in a fatigue fracture of the crankshaft.NTSB LAX08CA147Accident · No injuriesData collectionFinal reportBeech B-23 · Bagdad, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain runway alignment. Contributing factors were the gusty crosswind weather conditions and the rocky terrain adjacent to the runway.NTSB LAX08CA136Accident · Minor injuriesData collectionFinal reportA. Schleicher ASW 27-18 · Peoria, AZThe pilot's misjudged distance and altitude while on final approach to land. A factor contributing to the accident was a downdraft.NTSB LAX08FA134Accident · 2 fatalField investigationFinal reportExtra Flugzeugproduktions-GMBH EA-300/L · Queen Creek, AZThe loss of aircraft control due to an undetermined rudder malfunction.NTSB LAX08CA132Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.NTSB LAX08LA127Accident · No injuriesLimited investigationFinal reportCessna 182H · Prescott, AZA loss of engine power from fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB SEA08LA119Accident · Serious injuriesLimited investigationFinal reportCameron Balloons C-100 · Phoenix, AZThe pilot's inadequate weather evaluation during the landing approach. Contributing to the accident were windshear and rocky terrain.NTSB LAX08CA126Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta II · Prescott, AZThe instructor's inadequate supervision and delayed remedial action that resulted in ground contact and a rollover.NTSB LAX08FA122Accident · 3 fatalField investigationFinal reportCarlton M. Cadwell Lancair IV-P · Mesa, AZThe pilot's failure to maintain an adequate airspeed during climb out resulting in an aerodynamic stall/spin.NTSB LAX08LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Holbrook, AZA total loss of engine power due to fuel starvation as a result of the pilot's fuel system mismanagement and incorrect positioning of the fuel selector valves.NTSB LAX08CA112Accident · Serious injuriesData collectionFinal reportUltramagic N-250 · Buckeye, AZThe passenger's failure to hear and follow the pilot's instructions to get down in the bottom of the balloon basket before the high wind landing. A contributing factor was the high wind condition.NTSB LAX08LA098Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Kingman, AZA total loss of engine power during cruise flight due to an undetermined catastrophic internal engine failure.