NTSB investigations, 2003, 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
Latest 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\") = 2003
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") = 2003 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 ANC04FA016Accident · 4 fatalField investigationFinal reportPiper J3C-65 · Peoria, AZThe inadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft and a subsequent midair collision. A factor associated with the accident was the airplane pilot's failure to determine that…NTSB LAX04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gilbert, AZthe pilot's failure to maintain control of the airplane during the landing touchdown in soft terrain. A contributing factor was the pilot's selection of unsuitable terrain for landing.NTSB LAX04LA069Accident · Serious injuriesLimited investigationFinal reportAllison KR-2 · Glendale, AZloss of engine power due to a loose carburetor jet. A contributing factor was the owner/operators failure to have a condition inspection performed on the aircraft.NTSB LAX04CA072Accident · No injuriesData collectionFinal reportPiper PA-18 · Prescott, AZthe failure of the pilot to maintain directional control of the tail wheel equipped airplane during landing, which resulted in a ground loop.NTSB LAX04LA247Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZthe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a pilot induced porpoise/oscillation.NTSB LAX04LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Nogales, AZThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB LAX04CA063Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Morenci, AZthe pilot's excessive landing flare, which resulted in an improper touchdown and hard landing.NTSB LAX04LA054Accident · No injuriesLimited investigationFinal reportCessna 172S · Wikieup, AZThe pilot's selection of an en route altitude that did not provide adequate terrain clearance, and resulted in the in-flight collision with terrain. The rising terrain and the blind/box canyon were contributing factors.NTSB LAX04TA052Accident · No injuriesFinal reportEurocopter France AS 350 B3 · Yuma, AZThe malfunction of the rotor drive system due to improper maintenance, which resulted in the uncoupling of the drive shaft during takeoff-initial climb. A factor associated with the accident is the undertorqued drive system bolts.NTSB LAX04LA053Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fountain Hills, AZThe flight instructor's delayed remedial action and inadequate altitude during a go-around following a simulated forced landing, which resulted in an in-flight collision with terrain.NTSB LAX04LA049Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZthe flight instructor's inadequate supervision of the flight and delayed remedial action, which resulted in a loss of directional control. The reason for the partial power loss in the left engine was not determined.NTSB LAX04CA048Accident · No injuriesData collectionFinal reportRobinson R22 · Chandler, AZthe student pilot's failure to maintain control of the helicopter while hovering. A factor to the accident was the student pilot's lack of experience.NTSB LAX04LA043Accident · No injuriesLimited investigationFinal reportCessna 208B · Phoenix, AZthe pilot's improper decision to taxi behind another airplane conducting an engine run-up, which resulted in a jet blast encounter.NTSB LAX04FA042Accident · 1 fatalField investigationFinal reportCessna 177RG · Blk Canyon City, AZa loss of engine power due to the failure of the single-drive dual magneto that resulted from inadequate lubrication of the breaker cam. Also causal was the improper maintenance by other maintenance personnel during a recent inspection, which should have…NTSB LAX04CA059Accident · No injuriesData collectionFinal reportCessna 172N · Winslow, AZthe pilot's misjudged landing flare, which resulted in a pilot induced porpoise oscillation and hard landing.NTSB LAX04CA036Accident · No injuriesData collectionFinal reportR. James Thorne Nieuport 12 · Chandler, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX04LA035Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B3 · Mesa, AZThe pilot's inadvertent activation of the hydraulic test switch, which resulted in a loss of the hydraulic system pressure, and his failure to maintain directional control.NTSB LAX04LA032Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Williams, AZa loss of engine power in the right engine due to fuel exhaustion, caused by the pilot's inadequate preflight inspection and failure to refuel the airplane. Also causal was his failure to feather the right propeller and to maintain directional control of the…NTSB LAX04LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mesa, AZthe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall. Also causal, was the pilot's inadequate preflight and failure to secure the right side of the engine cowling prior to departure.NTSB LAX04TA017Accident · No injuriesFinal reportMD Helicopter 900 · Fredonia, AZthe pilot's in-flight loss of control due to the fatigue fracture and separation of the force limiting control rod (an integral part of the anti-torque system), which resulted in the helicopter's uncommanded yaw/spin and subsequent collision with terrain.NTSB LAX04CA014Accident · Minor injuriesData collectionFinal reportMayfield RAF 2000 · Buckeye, AZthe pilot misjudged the landing flare.NTSB LAX04LA103Accident · No injuriesLimited investigationFinal reportMooney 20F · Scottsdale, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX04CA008Accident · No injuriesData collectionFinal reportVelocity XL · Casa Grande, AZthe pilot's misjudged landing flare and inadequate compensation for crosswind conditions, which resulted in his failure to maintain runway alignment.NTSB LAX03LA302Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Show Low, AZThe pilot-in-command's (CFI) selection of the wrong runway (downwind) for the approach and landing. The failure of the left engine to respond to throttle application for undetermined reasons during the go-around was also causal. The high density altitude was…NTSB LAX04CA003Accident · Minor injuriesData collectionFinal reportBalloon Works Firefly II · Phoenix, AZthe pilot's diverted attention that resulted in the inadequate handling of the burner during ground operations.NTSB LAX03LA295Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Phoenix, AZthe ground agent's inadequate visual lookout during push back, which resulted in his failure to maintain clearance between the airplanes.NTSB DEN03FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech F33A · Greer, AZThe airplane is missing for unknown reason.NTSB LAX03MA292Accident · 7 fatalClass 1 · MajorFinal reportAerospatiale AS350BA · GrandCanyonWest, AZThe pilot's disregard of safe flying procedures and misjudgment of the helicopter's proximity to terrain, which resulted in an in-flight collision with a canyon wall. Contributing to the accident was the failure of Sundance Helicopters and the Federal…NTSB LAX03CA296Accident · No injuriesData collectionFinal reportCessna 182K · Young, AZthe collision with a bull during takeoff.NTSB LAX03CA288Accident · No injuriesData collectionFinal reportCessna 172M · Tucson, AZthe pilot's improper flare. A contributing factor was the tailwind.NTSB LAX03LA275Accident · 2 fatalLimited investigationFinal reportBacon Questair #20 Venture · Carefree, AZThe pilot's misjudgment of speed/distance and his failure to do a go-around. Also causal was the pilot's failure to maintain directional control, and his delay aborting the landing.NTSB LAX03CA272Accident · No injuriesData collectionFinal reportCessna 182J · Marble Canyon, AZthe failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.NTSB LAX03LA260Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Saint Johns, AZThe failure of the exhaust valve on the number two engine cylinder, which resulted in a partial loss of engine power during the final approach to land, and an on ground collision with a ditch during the subsequent off-airport landing roll.NTSB LAX03CA261Accident · No injuriesData collectionFinal reportCessna 150C · Tucson, AZthe pilot's inadequate inflight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB LAX03LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Prescott, AZThe collapse of the right main gear during the landing roll for undetermined reasons.NTSB LAX03CA249Accident · No injuriesData collectionFinal reportCessna 180 · St. Johns, AZThe pilot's inadequate compensation for a crosswind condition that resulted in a loss of directional control and ground loop. The crosswind was a contributing factor.NTSB LAX03GA244Accident · 2 fatalFinal reportBell 206L-3 · Whiteriver, AZThe pilot's failure to maintain a minimum translational lift airspeed while maneuvering in high density altitude conditions at near maximum required torque and above the in ground effect hover altitude, that resulted in a loss of tail rotor effectiveness and…NTSB LAX03CA257Accident · No injuriesData collectionFinal reportLancair 235 · Page, AZThe pilot's misjudged landing flare, which resulted in a hard landing and his improper recovery from a bounced landing. Inadvertent entry into a porpoise pilot-induced oscillation, and high density altitude were contributing factors.NTSB LAX03LA240Accident · Minor injuriesLimited investigationFinal reportCessna 180C · Punkin Center, AZThe pilot's inadequate preflight planning and failure to attain adequate climb rate to ensure clearance from obstacles. The tailwind and high density altitude were factors.NTSB LAX03LA217Accident · Minor injuriesLimited investigationFinal reportRans S-10 Sakota/A · Paulden, AZa loss of engine power due to fuel starvation for undetermined reasons.NTSB LAX03LA235Accident · No injuriesLimited investigationFinal reportRobinson R44 · Happy Jack, AZthe partial loss of engine power due to an excessively lean mixture for undetermined reasons during cruise flight.NTSB LAX03LA231Accident · No injuriesLimited investigationFinal reportCessna 172S · Chandler, AZThe pilot's misjudged landing flare, improper recovery from a bounced landing and failure to maintain directional control, resulting in a runway sign collision.NTSB LAX03CA248Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student's misjudged landing flare and inadvertent entry into a porpoise pilot-induced oscillation.NTSB LAX03TA229Accident · No injuriesFinal reportSikorsky S-64E · Tucson, AZthe pilot's failure to maintain tail rotor clearance while hovering resulting in a tail rotor blade strike.NTSB LAX03LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe disengagement of the left control wheel from the control column, which was due to the attaching screw backing out of the nut plate. Also causal was the manufacturer's inadequate design of the installation and the improper length of the screw.NTSB LAX03LA225Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350BA · Temple Bar, AZthe pilot's failure to follow the published electrical system emergency procedures for a hot battery, and his misjudged landing flare during the terminal phase of the autorotation maneuver at low level.NTSB LAX03CA220Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Chandler, AZThe student's failure to maintain adequate main rotor rpm and his failure to relinquish the controls.NTSB LAX03CA219Accident · No injuriesData collectionFinal reportStinson 108-3 · St. Johns, AZthe pilot's inadequate compensation for the gusting and shifting wind conditions, which resulted in a failure to maintain directional control and a ground loop. The gusting and shifting wind conditions were factors in the accident.NTSB LAX03LA216Accident · Serious injuriesLimited investigationFinal reportCessna 210D · Carefree, AZfuel exhaustion due to a crack on the elbow fitting to the gascolator resulted in a fuel leak.NTSB LAX03CA215Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm, and, his improper use of the collective, throttle, and anti-torque controls during the attempted recovery. Factors in the accident were the pilot's failure to completely relinquish the controls, and the…