NTSB investigations, 2002, 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 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\") = 2002
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") = 2002 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 LAX03LA055Accident · 1 fatalLimited investigationFinal reportLipscomb Lancair 235 · Payson, AZthe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in an inadvertent stall/spin. A contributing factor in the accident was the pilot's lack of familiarity with the airplane.NTSB LAX03FA054Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Dolan Springs, AZthe pilot's inadequate visual lookout and failure to maintain clearance from power lines. A factor was the pilot's decision to conduct cruise flight at a low altitude.NTSB LAX03LA050Accident · No injuriesLimited investigationFinal reportAnderson Rotorway Exec 162F · Phoenix, AZThe separation of the exhaust valve stem in the number 1 cylinder, which resulted in a partial loss of engine power during the landing flare and a hard landing.NTSB LAX03LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Scottsdale, AZThe pilot's inadequate preflight inspection and failure to refuel the airplane resulting in a loss of engine power due to fuel starvation.NTSB LAX03LA042Accident · No injuriesLimited investigationFinal reportCessna 170B · Mobile, AZthe pilot's improper compensation for the crosswind conditions at touchdown and failure to maintain proper alignment of the tail wheel equipped airplane during landing, which resulted in a ground loop. The crosswind was a contributory factor.NTSB LAX03LA034Accident · Minor injuriesLimited investigationFinal reportCessna T210 L · Williams, AZAn in-flight fire for undetermined reasons.NTSB ANC03LA015Accident · 1 fatalLimited investigationFinal reportBell 206B · Kingman, AZThe pilot's failure to maintain altitude/clearance from obstacles during cruise flight, which resulted in the helicopter striking a transmission line, and subsequently the ground.NTSB LAX03LA030Accident · No injuriesLimited investigationFinal reportCessna 182T · Scottsdale, AZThe pilot's failure to apply adequate crosswind compensation, which resulted in a loss of directional control. Factors were the crosswind and the pilot's lack of experience in the make and model of airplane.NTSB LAX03LA027Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS350B · Kingman, AZthe pilot's inadequate visual lookout and failure to maintain adequate clearance from transmission wires while performing low altitude operations.NTSB DEN03FA012Accident · 4 fatalField investigationFinal reportCessna 208B · Parks, AZthe pilot's improper in flight planning/decision making, his flight into known icing conditions, and his failure to maintain adequate airspeed which resulted in the inadvertent stall/spin and impact with terrain. Factors contributing to the accident were the…NTSB LAX03LA021Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Chandler, AZThe pilot's failure to maintain directional control.NTSB LAX03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Queen Creek, AZa loss of engine power for undetermined reasons.NTSB LAX03LA011Accident · No injuriesLimited investigationFinal reportRotorway 162F · Tucson, AZthe failure of the secondary drive shaft.NTSB LAX03FA005Accident · 1 fatalField investigationFinal reportGrumman AA-5A · Phoenix, AZfailure of the lubricating system resulting in a total loss of engine power and an off airport forced landing.NTSB LAX03LA002Accident · No injuriesLimited investigationFinal reportKline KSE5A · Sedona, AZthe pilot's failure to compensate for the wind conditions resulting in a loss of directional control during the takeoff roll. A contributing factor was the pilot's incorrect installation of the left wheel, which resulted in a locked left wheel when the brakes…NTSB LAX02LA290Accident · No injuriesLimited investigationFinal reportCessna 172G · Vail, AZThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB LAX02FA285Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Tucson, AZthe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude, which resulted in a stall spin.NTSB LAX02LA284Accident · No injuriesLimited investigationFinal reportSiemens Rotorway Exec 162 F · Overgaard, AZThe pilot's failure to check the wind direction prior to practicing autorotations, and his misjudged flare maneuver. The tailwind was a factor.NTSB LAX02FA281Accident · Minor injuriesField investigationFinal reportAerospatiale AS350BA · Peach Springs, AZthe pilot's failure to maintain an adequate airspeed and main rotor rpm during the landing approach as prescribed in the hydraulic pump failure emergency procedures found in the rotorcraft flight manual, thus resulting in a loss of control of the aircraft and…NTSB LAX02FA278Accident · 1 fatalField investigationFinal reportBeech A36 · Grand Canyon, AZthe pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed which resulted in an encounter with adverse weather conditions and the loss of control due to a stall. Contributing factors were thunderstorm related turbulence,…NTSB LAX02LA277Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus-B · Peoria, AZThe pilot's abrupt maneuver, which resulted in an inadvertent stall.NTSB LAX02LA274Accident · No injuriesLimited investigationFinal reportCessna 172I · Tucson, AZthe certified flight instructor's failure to maintain an adequate distance from a jet during taxi. A factor was the local/ground controller's failure to issue a safety alert or cautionary advisory to the pilot with regards to the jet blast of the departing…NTSB LAX02FA266Accident · Serious injuriesField investigationFinal reportAirbus Industrie A320-231 · Phoenix, AZThe captain's failure to maintain directional control and his inadvertent application of asymmetrical engine thrust while attempting to move the #1 thrust lever out of reverse. A factor in the accident was the crew's inadequate coordination and crew resource…NTSB LAX02FA259Accident · No injuriesField investigationFinal reportCessna 172N · Mesa, AZAn electrical fire of unknown origin centered near the circuit breaker/throttle area of the instrument panel.NTSB LAX02LA254Accident · Minor injuriesLimited investigationFinal reportWaco YPF-7 · Dewey, AZThe loss of engine power due to a flooded carburetor. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX02LA250Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Casa Grande, AZThe partial loss of engine power for undetermined reasons.NTSB LAX02LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · St. Johns, AZthe pilot's selection of the wrong runway for the existing crosswind condition and his subsequent inadequate compensation for the winds, which led to a failure to maintain directional control and a ground loop.NTSB LAX02LA240Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · San Manuel, AZthe pilot's failure to maintain adequate airspeed while maneuvering in a box canyon, which resulted in a stall/mush. A factor in the accident was downdraft conditions that led to an uncontrolled decent.NTSB LAX02LA239Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZthe student pilot's failure to maintain adequate main rotor rpm, the CFI's delayed remedial action and inadequate supervision of the flight, resulting in a hard landing. Wind gusts and the high density altitude were factors in the accident.NTSB LAX02LA241Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZthe pilot of the other airplane'ss use of an excessive taxi speed and too close of a spacing interval to the Cessna 152, which resulted in an on-ground collision when the Cessna 152 abruptly stopped.NTSB LAX02LA236Accident · No injuriesLimited investigationFinal reportCessna TR182 · Yuma, AZthe pilot's failure to properly verify that the landing gear was in the down and locked position.NTSB LAX02LA230Accident · Serious injuriesLimited investigationFinal reportViolet Dragonfly · Tucson, AZThe pilot's loss of control resulting from his improperly planned approach and an inadvertent encounter with wake turbulence.NTSB LAX02LA233Accident · No injuriesLimited investigationFinal reportBeech S35 · St. Johns, AZThe pilot's failure to maintain airplane control following an encounter with a wind gust.NTSB LAX02LA224Accident · No injuriesLimited investigationFinal reportMcConnell Lancair 320 · Sedona, AZthe pilot's inadequate compensation for a right, quartering tailwind during landing resulting in a loss of aircraft control and dragging a wing during the landing flare.NTSB LAX02LA223Accident · 1 fatalLimited investigationFinal reportSteen SE-1 · Tucson, AZthe loss of engine power during takeoff for undetermined reasons.NTSB LAX02LA222Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Mesa, AZthe pilot's inadequate compensation for the crosswind conditions, and failure to maintain an appropriate airspeed for the gusts, which resulted in a hard landing.NTSB LAX02LA219Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Show Low, AZthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB LAX02FA210Accident · 1 fatalField investigationFinal reportBeech C35 · Chambers, AZThe pilot's loss of airplane control after falling asleep due to fatigue, which resulted in a structural failure of the airframe during a high speed descent after the design stress limits of the aircraft were exceeded.NTSB LAX02LA204Accident · No injuriesLimited investigationFinal reportBeech V35A · Cottonwood, AZThe loss of engine power as a result of the failure of the #1 lower connecting rod bolt due to fatigue.NTSB LAX02LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Saint Johns, AZthe pilot's inadequate compensation for wind conditions resulting in a loss of directional control and collision with terrain. Related factors were the wind gusts, crosswind and soft terrain.NTSB LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.NTSB LAX02LA206Accident · No injuriesLimited investigationFinal reportBeech BE76 · Prescott, AZThe student pilot's decision to abort the takeoff with insufficient runway remaining, resulting in a runway overrun and collision with a berm. A factor was the cabin door opening during the takeoff roll.NTSB LAX02FA191Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Rio Rico, AZa loss of engine power in the left engine for undetermined reasons, and the failure of the flying pilot to maintain an adequate single engine minimum control airspeed and aircraft control. Also causal was the decision of all three of the pilots to continue…NTSB LAX02FA188Accident · 2 fatalField investigationFinal reportFisher Celebrity · Chandler, AZfailure of the wing spars and the in-flight separation of the aircraft wing due to the builder's inadequate manufacture of this experimental aircraft. Also causal was the current owner/pilot's continued flight with known mechanical discrepancies.NTSB LAX02LA194Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's inadequate recovery from a bounced landing.NTSB LAX02LA181Accident · No injuriesLimited investigationFinal reportCessna 182P · Roosevelt, AZFailure of the pilot to maintain aircraft control during the landing rollout after making a precautionary landing precipitated by an electrical system failure.NTSB LAX02LA178Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Meadview, AZthe pilot's failure to maintain distance and altitude during landing approach, resulting in the helicopter striking the ground during approach.NTSB LAX02LA170Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kingman, AZthe CFI's failure to obtain/maintain an adequate airspeed during an attempted go-around, which resulted in a stall/mush condition. The high density altitude, tailwind, inadequate supervision, and overgross weight condition were factors.NTSB MIA02FA098Accident · 1 fatalField investigationFinal reportGrob G120A · Mobile, AZThe failure of the pilot to maintain altitude clearance with the terrain.NTSB LAX02LA171Accident · No injuriesLimited investigationFinal reportCessna 206 · Mohave Valley, AZthe pilot's failure to maintain directional control.