NTSB investigations, 2006, AZ
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2006
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") = 2006 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 LAX07LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZa loss of engine power due to oil starvation to the number 3 cylinder crankpin and connecting rod bearing. The underlying cause of the oil starvation to the number 3 cylinder components could not be ascertained.NTSB LAX07FA062Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Young, AZThe pilot's failure to maintain terrain clearance during cruise flight while flying at night at an altitude to remain clear of clouds and icing conditions. Contributing to the accident were an inadequate weather evaluation, the clouds, icing conditions, and…NTSB SEA07LA036Accident · No injuriesLimited investigationFinal reportPiper PA 23-235 · Phoenix, AZThe landing gear collapsed for undetermined reasons while the aircraft was standing on the taxiway with the engines operating.NTSB LAX07LA055Accident · Serious injuriesLimited investigationFinal reportHigher Class Super Hornet · Chandler, AZA loss of aircraft control for undetermined reasons.NTSB LAX07LA045Accident · No injuriesLimited investigationFinal reportNanchang CJ-6A · Queen Creek, AZThe total loss of engine power resulting from the failure of the engine's air compressor due to a seized piston, which resulted in the stoppage of the oil pump, fuel pump, and tachometer generator, in addition to the compressor. The underlying reason for the…NTSB LAX07CA044Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Springerville, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing. A factor was the crosswind.NTSB LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.NTSB LAX07LA037Accident · 1 fatalLimited investigationFinal reportBeechcraft J35 · Flagstaff, AZThe pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.NTSB LAX07CA036Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Tucson, AZThe pilot's improper use of the spoilers during the landing flare, which resulted in a hard landing, and his inadequate bounced landing recovery technique.NTSB LAX07LA032Accident · 2 fatalLimited investigationFinal reportKolb MK III · Paulden, AZfailure of the pilot to maintain an adequate airspeed that led to a stall/spin.NTSB LAX07CA030Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Glendale, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX07CA028Accident · Minor injuriesData collectionFinal reportStrategie Ballloon Amazon · Page, AZThe pilot's failure to identify grass clippings in the balloon envelope during a preflight inspection, which resulted in the balloon catching fire in flight.NTSB LAX07LA025Accident · 2 fatalLimited investigationFinal reportOlson Vans RV-6 · Rio Verde, AZThe pilot's failure to maintain clearance from power lines while intentionally flying at a low altitude.NTSB LAX07LA027Accident · 2 fatalLimited investigationFinal reportAir Creations Tanarg 912 · Bisbee, AZThe pilot's failure to maintain clearance from the mountainous terrain.NTSB LAX07LA019Accident · No injuriesLimited investigationFinal reportCessna 310N · Lake Havasu Cit, AZthe pilot's failure to extend the landing gear prior to touchdown.NTSB LAX07FA021Accident · 4 fatalField investigationFinal reportCirrus SR22 · Meadview, AZThe pilot's inadequate weather evaluation and continued flight into forecasted icing conditions. Contributing to the severity of the accident was the pilot's failure to follow proper operating procedures and deploy the CAPS when the airplane entered a spin.…NTSB LAX07LA024Accident · No injuriesLimited investigationFinal reportCessna U206G · Willcox, AZThe pilot's misjudged flare and porpoising during landing.NTSB LAX07LA017Accident · 2 fatalLimited investigationFinal reportWilson Quicksilver Sport 2S · Buckeye, AZFailure of the pilot to maintain adequate clearance from obstacles.NTSB LAX07LA011Accident · Minor injuriesLimited investigationFinal reportMorrisey 2150A · Chandler, AZLoss of engine power during cruise flight due to a crack in the oil cooler and subsequent loss of engine oil.NTSB LAX07FA012Accident · 5 fatalField investigationFinal reportPiper PA-42 · Prescott, AZThe failure of the pilot following a jet aircraft to maintain adequate separation from the high velocity jet core exhaust. The separation of the T-tail upper section vertical stabilizer of the following aircraft due to contact with the high velocity jet core…NTSB LAX07CA010Accident · No injuriesData collectionFinal reportMonocoupe 110 Special · Chandler, AZthe failure of the forward left main landing gear attach point resulting in loss of control.NTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.NTSB LAX06CA299Accident · Minor injuriesData collectionFinal reportBeech 95-55 · Safford, AZThe pilot's inadequate in-flight planning/decision and inaccurate fuel consumption calculations, which led to fuel exhaustion and total loss of power to both engines.NTSB LAX06FA304Accident · 2 fatalField investigationFinal reportCessna 182K · Sedona, AZThe pilot's failure to maintain clearance from trees and terrain while maneuvering in mountainous/hilly terrain in a high density altitude environment.NTSB LAX06CA303Accident · No injuriesData collectionFinal reportCleberg Sportsman 2+2 GS-2 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX06CA295Accident · No injuriesData collectionFinal reportBeech A36 · Chandler, AZthe student's failure to establish a stabilized approach, which resulted in a bounced landing and a loss of directional control. Also causal was the flight instructor's inadequate supervision of the flight, delayed remedial action, and failure to verbally…NTSB LAX06CA286Accident · Serious injuriesData collectionFinal reportAgeton MXL Sport II · Marana, AZThe loss of engine power for undetermined reasons.NTSB LAX06FA283Accident · 3 fatalField investigationFinal reportCessna 337G · Prescott, AZA loss of power in the rear engine for undermined reasons. Contributing to the accident was the pilot's failure to promptly and correctly configure the airplane for single engine flight, and to maintain an adequate airspeed, which resulted in a stall mush.NTSB LAX06LA273Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Casa Grande, AZInternal damage to the stop electro valve which resulted in fuel starvation and subsequent loss of engine power during takeoff.NTSB LAX06LA270Accident · No injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G109 · Glendale, AZThe failure and separation of one propeller blade for undetermined reasons.NTSB LAX06LA266Accident · 1 fatalLimited investigationFinal reportSaloff Sonerai Iilt · Williams, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB LAX06LA257Accident · 1 fatalLimited investigationFinal reportRobinson R22 Beta · Tucson, AZThe pilot's failure to maintain adequate rotor rpm and adequate terrain clearance while maneuvering to reverse direction. Contributing factors were the high density altitude, that exceeded the helicopter's performance capability, and the rising mountainous…NTSB LAX06CA276Accident · No injuriesData collectionFinal reportInterstate S-1A · Buckeye, AZthe in-flight separation of the control stick. A contributing factor was the rough terrain for the forced landing, which resulted in a collapsed landing gear.NTSB LAX06LA247Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Flagstaff, AZthe pilot's inadequate preflight planning decision to take off under a low ceiling into an area of mountainous terrain that resulted in an encounter with lowering clouds and forced the pilot to land in unfavorable terrain.NTSB LAX06FA243Accident · 2 fatalField investigationFinal reportRaytheon G36 · Bullhead City, AZThe pilot's misjudged distance and speed that led to a long landing, and his inadequate recovery from a bounced landing, all due to the effects of impairment from alcohol consumption, which resulted in an in-flight collision with terrain during an aborted…NTSB LAX06LA240Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Show Low, AZthe pilot's failure to maintain directional control during landing.NTSB LAX06FA206Accident · 4 fatalField investigationFinal reportCessna 180 · Payson, AZThe pilot's failure to maintain clearance from the terrain during a low level flyby maneuver. A factor was glare from the sun and shadows created by the mountainous terrain.NTSB LAX06CA208Accident · No injuriesData collectionFinal reportCessna 210B · Flagstaff, AZThe pilot's misjudged flare and inadequate recovery from a bounced landing, which resulted in a hard landing and a porpoise.NTSB LAX06CA203Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2000 · Chandler, AZThe student pilot's failure to maintain directional control and the instructor's delayed remedial actions, which resulted in a collision with terrain during the initial takeoff climb. The instructor's inadequate supervision of the flight was also causal.NTSB LAX06FA200Accident · 2 fatalField investigationFinal reportCessna 152 · Peoria, AZthe failure of both the flight instructor and student pilot to regain control of the airplane in a timely manner during an intentional spin maneuver, resulting in a collision with terrain. A factor in the accident was the instructor's inadequate supervision…NTSB LAX06CA195Accident · No injuriesData collectionFinal reportWaco Classic YMF 5C · Holbrook, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the airplane during landing, which resulted in a ground loop.NTSB LAX06LA185Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries HK 36 TTC · Payson, AZpartial loss of engine power for undetermined reasons.NTSB LAX06LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Eagar, AZthe flight instructor's failure to attain and maintain the proper climb airspeed, which resulted in a stall/mush.NTSB LAX06CA181Accident · No injuriesData collectionFinal reportCessna 152 · Buckeye, AZthe pilot's failure to maintain directional control during landing.NTSB LAX06CA177Accident · No injuriesData collectionFinal reportCessna 150M · Tucson, AZthe failure of the student pilot to maintain directional control and the certified flight instructor's delayed remedial actions and inadequate supervision of the flight.NTSB LAX06LA164Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Show Low, AZthe collapse of the air intake duct resulted in a loss of engine power. A factor was the uneven terrain in the landing area.NTSB LAX06CA165Accident · Minor injuriesData collectionFinal reportCessna 150M · Green Valley, AZthe failure of the certified flight instructor to retract the flaps to the proper go-around setting and to attain/maintain an adequate airspeed, which led to a stall/mush.NTSB LAX06CA162Accident · No injuriesData collectionFinal reportBeech BE23 · Kingman, AZthe student pilot's failure to attain/maintain a proper glide path, which resulted in an encounter with wake turbulence and subsequent hard landing.NTSB LAX06LA158Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26D · Aguila, AZThe pilot's failure to maintain control of the glider during takeoff-initial climb, which resulted in a broken tow rope, a spiral, and an in-flight collision with terrain. A factor associated with the accident is the pilot's failure to correct the spiral.NTSB LAX06CA152Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Phoenix, AZthe failure of both pilots to maintain Vmc and directional control during a go-around. Also causal was an inoperative engine caused by flight instructor's failure to ensure that the fuel system was correctly configured for two engine operation by moving the…