NTSB investigations, 2004, 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\") = 2004
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") = 2004 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 LAX05LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Phoenix, AZthe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control during landing.NTSB LAX05FA053Accident · 1 fatalField investigationFinal reportEurocopter AS-350-B3 · Apache Junction, AZA loss of control during the final approach to land for undetermined reasons.NTSB LAX05FA046Accident · 1 fatalField investigationFinal reportCessna T207A · Meadview, AZa loss of control due to the in-flight separation of the right elevator and elevator trim tab control surfaces. The precipitating reason for the elevator separation could not be resolved as related to the tab foam core issue with the available evidence.NTSB LAX05FA045Accident · 1 fatalField investigationFinal reportCessna T310R · Flagstaff, AZThe pilot's decision to attempt flight into known adverse weather conditions beyond the capability of the airplane and his failure to ensure that the airplane's wings were free of ice and/or snow contamination that accumulated while the airplane was on the…NTSB LAX05CA044Accident · Minor injuriesData collectionFinal reportCessna 150J · Amado, AZthe pilot's inaccurate fuel consumption calculations and failure to refuel the airplane at the intermediate stop, which resulted in fuel exhaustion.NTSB LAX05LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Prescott, AZthe pilot's failure to maintain directional control during landing rollout. A contributing factor in the accident was the pilot's unfamiliarity with the airplane.NTSB LAX05LA038Accident · No injuriesLimited investigationFinal reportBeech 99 · Phoenix, AZthe pilot's inadequate visual lookout and failure to maintain clearance from obstacles while taxing in a nonmovement area at night.NTSB LAX05FA035Accident · 3 fatalField investigationFinal reportCessna 337B · Drake, AZthe pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…NTSB LAX05FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Mesa, AZthe pilot's failure to obtain and maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall/spin.NTSB LAX05CA028Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe pilot's improper flare, which resulted in a hard landing. Contributing factors were his improper recovery from the subsequent bounced landing and pilot-induced oscillations.NTSB LAX05LA025Accident · No injuriesLimited investigationFinal reportEurocopter AS350B3 · Sierra Vista, AZAn inconsistency between the engines' two N2 sensor signals caused the fuel control to enter a fixed mode, which limited the power available. Contributing to the accident was the lack of altitude and airspeed available to give the pilot time to select a…NTSB LAX05LA027Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kingman, AZLanding gear extension system component failure resulting in a gear up landing.NTSB LAX05TA018Accident · Serious injuriesFinal reportHughes OH-6A · Tucson, AZThe loss of engine power due to a fatigue fracture of the PC line from the governor to fuel control, resulting from fretting damage induced by excessive vibration, which was due to the failure of maintenance personnel to install the proper bearings in the…NTSB LAX05LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mesa, AZthe student pilot's failure to maintain directional control of the airplane during a touch-and-go takeoff.NTSB LAX05LA009Accident · 1 fatalLimited investigationFinal reportBrackett And Peltz Kit Fox III · Aguila, AZthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall. The nature and scope of the problem reported by the pilot is undetermined.NTSB LAX05CA005Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Winslow, AZthe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.NTSB LAX05LA002Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Sedona, AZa loss of engine power due to the fatigue fracture of the number 7 cylinder exhaust rocker arm as a result of a grinding operation during manufacture.NTSB LAX05CA001Accident · No injuriesData collectionFinal reportCessna TU206A · Nogales, AZthe pilot's failure to remain on the designated taxiway surface, which resulted in the airplane's collision with the ditch. The dark lighting condition was a factor to the accident.NTSB LAX04LA328Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Flagstaff, AZthe pilot's improper leaning procedures and delayed decision to abort the takeoff when it became obvious that the engine was not developing full power. A factor in the accident was the pilot's decision to use a runway with a quartering tailwind.NTSB LAX04LA322Accident · 2 fatalLimited investigationFinal reportWolf Glassair IIS · Mesa, AZa partial loss of power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and a collision with terrain.NTSB LAX04LA333Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 900 · Mesa, AZfracture of a Tension-Torsion strap in the anti-torque fan due to progressive fiber failure of the composite strap material from compression and/or transverse shear stresses that occurred with repeated manipulation of the cockpit anti-torque control pedals…NTSB LAX04LA313Accident · 2 fatalLimited investigationFinal reportRedgate Europa Classic · Marble Canyon, AZan in-flight collision with terrain for undetermined reasons.NTSB LAX04CA310Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Maricopa, AZthe pilot's encounter with a dust devil during landing flare, which resulted in a hard touchdown.NTSB LAX04CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Williams, AZThe pilot's inadequate compensation for the wind condition and his failure to maintain directional/airplane control during landing rollout. Contributing factors were the gusty crosswind and the pilot's inadequate remedial action.NTSB LAX04LA305Accident · Serious injuriesLimited investigationFinal reportGibbs Kitfox IV · Payson, AZthe pilot's failure to maintain adequate airspeed, which resulted in a stall and subsequent collision with terrain. Contributing factors to the accident were the turbulence and the gusting wind conditions.NTSB LAX04FA304Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Prescott, AZThe failure of both pilots to maintain adequate clearance from each other while performing formation aerobatic maneuvers.NTSB LAX04CA296Accident · No injuriesData collectionFinal reportPilatus PC-12/45 · Show Low, AZthe collision with an elk during the landing roll. The dark night lighting conditions was a factor.NTSB LAX04CA303Accident · No injuriesData collectionFinal reportRockwell 112TC · Bullhead City, AZthe pilot's failure to extend the landing gear prior to landing. Factors in the accident were the pilot's failure to use a checklist and to verify that the gear were extended.NTSB LAX04CA289Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Scottsdale, AZthe pilot's misjudged flare, resulting in a stall and hard landing, and his failure to maintain directional control. The pilot's improper recovery from a bounced landing is a contributing factor.NTSB LAX04CA288Accident · No injuriesData collectionFinal reportCessna 172S · Chandler, AZthe student pilot's failure to abort the takeoff. A contributing factor was the pilot's failure to maintain directional control.NTSB LAX04CA286Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZthe pilot's failure to maintain directional control during the takeoff roll.NTSB LAX04LA261Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 B2 · Peach Springs, AZThe pilot's selection of downwind takeoff direction and improper use of the collective control prior to reaching translational lift, which resulted in a settling with power condition and a collision with the ground. Also causal was the pilot's failure to…NTSB LAX04LA254Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Scottsdale, AZInadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was caused by the improper installation and/or adjustment of the collective locking system, which…NTSB LAX04CA252Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Casa Grande, AZthe pilot misjudged the flare resulting in a bounced landing. Also causal was the pilot's inadequate recovery from the bounced landing resulting in a loss of directional control.NTSB LAX04LA285Accident · No injuriesLimited investigationFinal reportEurocopter France AS350B3 · Cibecue, AZthe pilot's failure to maintain a proper decent rate during the landing approach and misjudged landing flare, which resulted in a hard landing. A factor in the accident was the brownout conditions created by the dust cloud that interfered with the pilot's…NTSB LAX04CA250Accident · No injuriesData collectionFinal reportCessna 172S · Glendale, AZthe pilot's failure to maintain directional control of the airplane, which resulted in a veer off the runway and collision with terrain.NTSB LAX04LA266Accident · No injuriesLimited investigationFinal reportLancair LC-40-550FG · Show Low, AZthe pilot's failure to maintain directional control of the airplane during landing after encountering a dust devil.NTSB LAX04LA249Accident · 1 fatalLimited investigationFinal reportBell 206B · Mesa, AZthe pilot's failure to adequately clear the left skid of obstacles resulting in a dynamic rollover of the helicopter and collision with terrain. A factor in the accident was the dark nighttime lighting conditions.NTSB LAX04LA240Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's failure to maintain a proper pitch attitude during tow operations and his failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB LAX04LA232Accident · No injuriesLimited investigationFinal reportBeech S35 · Flagstaff, AZoil exhaustion due to a leak from the bottom oil drain line gasket and o-ring for the turbo charger.NTSB LAX04FA223Accident · 2 fatalField investigationFinal reportBoeing B75N1 · Mesa, AZthe pilot's failure to maintain an adequate airspeed while performing aerobatics that resulted in an inadvertent stall and spin.NTSB LAX04CA224Accident · No injuriesData collectionFinal reportCessna 177B · Grand Canyon, AZthe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of directional control.NTSB LAX04LA229Accident · No injuriesLimited investigationFinal reportSimmons BD-5 · Goodyear, AZThe overheating and failure of the number 4 connecting rod, which resulted in a total loss of engine power during descent.NTSB LAX04CA214Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's improper application of brakes during the landing roll, resulting in a nose over.NTSB LAX04LA213Accident · 4 fatalLimited investigationFinal reportBachman Lancair IV-P · Supai, AZthe loss of aircraft control while in cruise flight for undetermined reasons.NTSB LAX04LA211Accident · No injuriesLimited investigationFinal reportCessna T182T · Paulden, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed.NTSB LAX04CA209Accident · No injuriesData collectionFinal reportCessna 180 · Kingman, AZthe pilot under instruction's excessive and improper use of the rudder control during the landing roll and the flight instructor's inadequate supervision, which resulted in an inadvertent ground loop and nose over.NTSB LAX04FA207Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Wittmann, AZThe flight instructor's failure to maintain sufficient airspeed to avoid a stall/spin while maneuvering the airplane with a dual student.NTSB LAX04CA208Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe backhoe driver's failure to maintain visual lookout while maneuvering near a taxiway, which resulted in its collision with a taxiing airplane.NTSB LAX04CA200Accident · No injuriesData collectionFinal reportCessna 182K · Phoenix, AZthe pilot's inadequate flare, which resulted in a hard landing. Also causal was the pilot's inadequate recovery from a bounced landing, which resulted in an inadvertent porpoise and collision with a sign.