NTSB investigations, 2005, 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\") = 2005
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") = 2005 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 LAX06CA052Accident · No injuriesData collectionFinal reportBeech C23 · Holbrook, AZThe student pilot's abrupt flare and failure to maintain airspeed, which resulted in a stall. The flight instructor's inadequate supervision of the flight was also causal.NTSB LAX06LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Tucson, AZthe separation of the mixture cable at the carburetor control arm, which resulted in a loss of power, and maintenance personnel's inadequate inspection of the airplane during the last annual inspection.NTSB LAX06LA041Accident · 2 fatalLimited investigationFinal reportTingle Special · Tucson, AZThe pilot's excessive use of power during takeoff, which resulted in an inadvertent torque roll shortly after lift off. Also causal was the pilot's failure to abort the takeoff when directional control could not be maintained during the takeoff roll.NTSB LAX06CA042Accident · Minor injuriesData collectionFinal reportCessna A185E · Show Low, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control, which resulted in a ground loop.NTSB LAX06CA037Accident · Serious injuriesData collectionFinal reportHopkins Rutan VariViggen · Aguila, AZthe pilot's failure to maintain an adequate airspeed during landing approach, which resulted in an inadvertent stall. A contributing factor was the pilot's lack of experience in the accident airplane.NTSB LAX06LA034Accident · No injuriesLimited investigationFinal reportBeech H35 · Kingman, AZa touchdown with the gear partially extended. A factor in the accident was an inoperative landing gear warning horn.NTSB LAX06CA033Accident · No injuriesData collectionFinal reportRotorway 162F · Chandler, AZa loss of engine power due to fuel contamination (rust, water) as a result of the pilot's inadequate preflight planning preparation.NTSB LAX06LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Mesa, AZthe failure of the flap motor fuse that rendered the flaps inoperable during a critical phase of flight. Factors in the accident were the lack of suitable terrain to perform an emergency landing and the owner's use of nonapproved fuses for the flap motor…NTSB LAX06CA026Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Payson, AZa loss of engine power due to fuel exhaustion, which was caused by the pilot's inadequate preflight and in-flight planning, his inadequate fuel consumption calculations, and his failure to divert to an alternate airport before the fuel situation became…NTSB LAX06CA027Accident · No injuriesData collectionFinal reportLee Kolb Mark III Classic · Tucson, AZthe fatigue failure of the attachment that secured the horizontal stabilizer to the fuselage.NTSB LAX06CA020Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Prescott, AZThe nose landing gear collapsing during the landing roll for undetermined reasons.NTSB LAX06LA016Accident · 1 fatalLimited investigationFinal reportNord 3202 · Casa Grande, AZthe pilot's failure to maintain airspeed during a low-altitude evasive maneuver away from another airplane, which resulted in a stall and uncontrolled descent.NTSB LAX06LA006Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R-22 Beta II · Eagar, AZThe pilots' inadequate in-flight planning, which led the helicopter toward rising terrain in excess of the performance capability of the helicopter. Contributing factors were the high density altitude, and the rapidly rising terrain.NTSB LAX06LA009Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Phoenix, AZThe failure of the other flight crew to maintain an adequate clearance from obstructions while taxiing.NTSB LAX06CA012Accident · Serious injuriesData collectionFinal reportAerostar RX-8 · Globe, AZthe pilot's encounter with a wind gust during landing.NTSB LAX06CA003Accident · No injuriesData collectionFinal reportAerospatiale AS350B · Grand Canyon, AZthe pilot's failure to maintain control of the helicopter during landing in gusty wind conditions, which resulted in a hard landing and ground resonance.NTSB LAX06CA001Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Tucson, AZthe student pilot's failure to maintain adequate airspeed and rotor rpm during a practice autorotation, and the instructor's failure to adequately monitor the maneuver, which resulted in a hard landing and roll over.NTSB LAX05LA305Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Bisbee, AZthe pilot's failure to lean the mixture in accordance with the pilot operating handbook specified procedures, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush…NTSB LAX05CA302Accident · No injuriesData collectionFinal reportCessna 172S · Show Low, AZthe pilot's selection of a downwind runway for landing and his inadequate compensation for the strong and gusty quartering tail wind conditions, which resulted in a tail strike during landing.NTSB LAX05CA295Accident · Minor injuriesData collectionFinal reportRicardo Lopez RAF 2000 Gtxse · Wickenburg, AZthe pilot's failure to obtain and maintain an adequate airspeed and rotor speed during takeoff.NTSB LAX05CA294Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Peoria, AZthe pilot's encounter with obstacles and unsuitable terrain in the landing area during the pilot's attempted precautionary landing. A factor in the accident was the loose wing root gap seal fairing.NTSB LAX05CA299Accident · No injuriesData collectionFinal reportCessna 172S · San Manuel, AZThe pilot's misjudged flare during a touch-and-go landing.NTSB LAX05LA286Accident · 1 fatalLimited investigationFinal reportCessna 172 · Yuma, AZthe pilot's failure to maintain an adequate airspeed on short final, which resulted in an inadvertent stall.NTSB LAX05LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Oro Valley, AZa loss of engine power due to the pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion. Contributing to the accident was the inaccuracy of the cockpit fuel gages which read 1/4 tank when empty.NTSB LAX05CA260Accident · No injuriesData collectionFinal reportMaule M-4-220C · Tucson, AZthe pilot's failure to maintain directional control.NTSB LAX05LA254Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Tucson, AZThe pilot's inadvertent retraction of the landing gear during the landing rollout.NTSB LAX05CA256Accident · No injuriesData collectionFinal reportLuscombe 8A · Benson, AZthe non-certificated pilot's failure to maintain directional control during the landing roll.NTSB LAX05LA244Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Globe, AZThe fatigue failure of the compressor turbine stator vane, the liberation of vane material into the compressor turbine, and the total loss of engine power. Also causal was the operator's failure to inspect the compressor turbine vane during fuel nozzle checks.NTSB LAX05LA236Accident · No injuriesLimited investigationFinal reportSergent Great Lakes 2T1A · Phoenix, AZthe pilot's failure to maintain directional control on landing roll, which resulted in a ground loop and nose over of the airplane.NTSB LAX05CA232Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Mesa, AZthe improper use of the throttle and antitorque pedal by the pilot undergoing instruction, and the inadequate supervision of the flight by the certified flight instructor.NTSB LAX05CA233Accident · Minor injuriesData collectionFinal reportCessna 170B · Prescott, AZthe pilot's misjudged flare, and excessive use of the elevator control, which resulted in a failure to maintain adequate airspeed and a stall/mush.NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.NTSB LAX05TA226Accident · Minor injuriesFinal reportAyres S2R-G10 · Wickenburg, AZthe partial loss of engine power for undetermined reasons.NTSB LAX05LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZthe pilot's misjudged distance and altitude, which resulted in an undershoot and collision with a airport boundary fence short of the runway. A factor in the accident was the pilot's lack of familiarity flying the airplane at a high gross weight with a center…NTSB LAX05LA220Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Prescott, AZthe pilot's failure to maintain directional control during the landing rollout.NTSB LAX05LA215Accident · Minor injuriesLimited investigationFinal reportBeech BE76 · Glendale, AZthe flight instructor's decision to attempt a single engine go-around with multiple aircraft system failures, and his improper in-flight decision to pass up one airport for landing and continue the flight to the home base airport with known mechanical…NTSB LAX05LA210Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Phoenix, AZthe pilot's delay in executing a timely go-around and failure to raise the flaps, which resulted in a collision with terrain.NTSB LAX05CA211Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Phoenix, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB LAX05LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Happy Jack, AZThe fracture/separation of an engine intake valve during cruise flight, which resulted in a partial loss of engine power and a forced landing.NTSB LAX05LA203Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Marble Canyon, AZthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around, which resulted in a stall.NTSB LAX05CA195Accident · No injuriesData collectionFinal reportBoeing A75N-1 · Paulden, AZthe pilot's inadequate compensation for wind conditions, and his failure to maintain airspeed which resulted in a stall mush and collision with objects.NTSB LAX05GA192Accident · Serious injuriesFinal reportEurocopter AS 350 B2 · Bisbee, AZthe pilot's failure to maintain an adequate forward airspeed, which resulted in an in-flight loss of control due to a loss of tail rotor effectiveness, while operating near the out of ground effect hover capability of the helicopter. Contributing factors to…NTSB LAX05CA185Accident · No injuriesData collectionFinal reportRobinson R44 · Sedona, AZthe pilot's improperly planned approach and misjudged distance/speed. A factor was the high density altitude.NTSB LAX05LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZThe student pilot's improper flare that induced a porpoise, which resulted in the overload failure of the nose wheel assembly.NTSB LAX05CA177Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Scottsdale, AZthe student pilot's inadvertent retraction of the landing gear, and the flight instructor's inadequate supervision of the flight.NTSB LAX05CA181Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Tucson, AZthe improper flare by an undetermined crewmember, which resulted in a hard landing.NTSB LAX05LA170Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Glendale, AZthe pilot's misjudged landing flare that resulted in a stall and hard landing.NTSB LAX05LA168Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Seligman, AZthe pilot's fuel system mismanagement that led to a fuel starvation induced loss of power in the left engine. Also causal was the pilot's improper use of the emergency landing gear extension system.NTSB LAX05CA161Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus 2b · Peoria, AZthe glider pilot encountered a downdraft that forced him to land in rough terrain.NTSB LAX05LA160Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot-in-command's failure to properly lean the mixture, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush condition while departing during high density…