NTSB investigations, AZ
123 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 15 |
|---|---|
| 1983 | 9 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 5 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 12 |
| 1992 | 10 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 1 |
| 2005 | 4 |
| 2006 | 6 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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 c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 LAX07FA160Accident · 2 fatalField investigationFinal reportDiamond Aircraft Industries DA 40 · Lake Pleasant, AZThe pilot's failure to maintain sufficient altitude above the surface of water during an intentional buzzing maneuver. Contributing to the accident was the nighttime lighting environment.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 LAX07LA027Accident · 2 fatalLimited investigationFinal reportAir Creations Tanarg 912 · Bisbee, AZThe pilot's failure to maintain clearance from the mountainous terrain.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 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 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 DEN06FA028Accident · 1 fatalField investigationFinal reportCessna 182D · Heber, AZthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors included the pilot's lack of night flying experience and the dark night.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 LAX05LA135Accident · 1 fatalLimited investigationFinal reportCameron Balloons A-210 · Marana, AZthe failure of the flying pilot to attain a proper climb rate and maintain an adequate clearance from rising terrain. Also causal was the commercial pilot's inadequate supervision of the flight and his delayed remedial action.NTSB LAX05LA086Accident · Minor injuriesLimited investigationFinal reportAustin Pitts Special · Coolidge, AZthe pilot's failure to maintain an adequate altitude from the airport surface when performing an intentional low altitude flyby maneuver.NTSB LAX04LA313Accident · 2 fatalLimited investigationFinal reportRedgate Europa Classic · Marble Canyon, AZan in-flight collision with terrain for undetermined reasons.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 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 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 LAX03LA188Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Maricopa, AZThe pilot's failure to maintain clearance/altitude from terrain during an aerial application, which resulted in an in-flight collision with terrain. A factor associated with the accident is the pilot's diverted attention while resetting a circuit breaker.NTSB LAX03FA076Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Scottsdale, AZthe pilot's failure to maintain an adequate altitude clearance from mountainous terrain. Contributing factors were dark night conditions, mountainous terrain, and the pilot's diverted attention.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 MIA02FA098Accident · 1 fatalField investigationFinal reportGrob G120A · Mobile, AZThe failure of the pilot to maintain altitude clearance with the terrain.NTSB LAX02FA166Accident · 2 fatalField investigationFinal reportSocata TB-21 · New River, AZthe pilot's failure to maintain an adequate terrain clearance altitude during a cruise descent that resulted in controlled flight into terrain (CFIT). Factors in the accident were the rising mountainous terrain, the dark nighttime lighting condition, and the…NTSB LAX02LA111Accident · Serious injuriesLimited investigationFinal reportAvian Magnum IX · Sedona, AZThe pilot's decision to continue the landing approach after encountering a high wind condition. A factor in the accident was the pilot's decision to use the trees to try and slow the balloon's ground speed.NTSB LAX02LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Prescott, AZThe pilot's inadequate removal of snow and ice from the surfaces of the airplane before takeoff.NTSB LAX01FA279Accident · 2 fatalField investigationFinal reportBeech F-33A · Mobile, AZThe flying pilot's initiation of an intentional maneuver at an altitude inadequate to maintain terrain clearance. Low altitude flight was a contributing factor.NTSB LAX00FA346Accident · 2 fatalField investigationFinal reportCessna 182G · Tuba City, AZthe pilot's inadvertent descent into terrain on the downwind leg for landing. Contributing to the accident was the dark night and sparse population.NTSB LAX00FA207Accident · 2 fatalField investigationFinal reportCessna 172RG · Prescott, AZThe flight instructor's delayed remedial action, and his failure to correct an inappropriate descent during maneuvering flight, while engaged in commercial flight training maneuvers.NTSB LAX00LA033Accident · Serious injuriesLimited investigationFinal reportRaven RX-7 · Phoenix, AZThe pilot's delay in initiating a climb and his subsequent failure to attain and maintain clearance from mountainous terrain.NTSB LAX99LA223Accident · Serious injuriesLimited investigationFinal reportDevor MXL II · Tonopah, AZThe failure of the uncertificated pilot to maintain control of the aircraft.NTSB LAX99LA154Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Lake Mary, AZThe pilot's intentional buzzing and misjudged altitude/clearance with the nearby rising terrain. Contributing factors were the high density, the airplane's high gross weight, and the pilot's improper in-flight decisions.NTSB LAX99FA080Accident · 2 fatalField investigationFinal reportNorth American T-6G-NA · New River, AZThe pilot's delayed recovery after an intentional stall/spin of 3 to 4 rotations. A factor was the pilot's inadequate entry altitude for the intended maneuver.NTSB LAX98LA207Accident · Serious injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Skull Valley, AZThe pilot's failure to maintain control of the aircraft while maneuvering at a low altitude.NTSB LAX98LA195Accident · 1 fatalLimited investigationFinal reportBlackmore RV-4 · Sedona, AZThe pilot's attempt to perform aerobatics with insufficient terrain clearance altitude available to complete the maneuver. A factor was high density altitude.NTSB LAX98FA050Accident · 2 fatalField investigationFinal reportMooney M20J · Sedona, AZthe failure of the pilot to maintain adequate terrain clearance during the climb. Contributing factors were dark night conditions, mountainous/hilly terrain, and mountain wave weather conditions.NTSB LAX97FA259Accident · 2 fatalField investigationFinal reportPiper J3C-85 · Bullhead City, AZimproper judgement of the pilot by intentionally performing low level maneuvers, and his misjudgment of a level-off over water.NTSB LAX97LA155Accident · No injuriesLimited investigationFinal reportGordon Price Ultimate 10-300S · Yuma, AZthe pilot's failure to maintain adequate vertical clearance from the runway, while flying inverted. Factors relating to the accident were: the light conditions at dusk, and the pilot's lack of visual ques due to the light conditions.NTSB LAX97LA041Accident · No injuriesLimited investigationFinal reportBeech F33A · Marana, AZimproper planning/decision by the flight instructor (CFI), which resulted in his failure to recover from a descent during demonstration of a simulated (engine-out) emergency procedure.NTSB LAX97FA003Accident · 4 fatalField investigationFinal reportCessna 172RG · Grand Canyon, AZthe pilot's inadequate preflight planning and preparation, which resulted in an inability to outclimb rising/wooded terrain after takeoff. Factors relating to the accident were: failure of the pilot to ensure that the aircraft's gross weight was not exceed…NTSB LAX96FA339Accident · 1 fatalField investigationFinal reportCessna T207A · Littlefield, AZThe pilot's failure to maintain clearance with terrain during descent for undetermined reasons. Contributing factors were the dark night and mountainous terrain.NTSB LAX96LA230Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Oracle, AZthe pilot's improper decision to turn toward rising terrain, without releasing or jettisoning the load of fire retardant, while maneuvering at slow airspeed, which resulted in a stall/mush and collision with the terrain. Factors relating to the accident were:…NTSB LAX96FA114Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · New River, AZfailure of the pilot to maintain proper altitude/clearance above the terrain, while performing an aerobatic maneuver.NTSB LAX95LA293Accident · No injuriesLimited investigationFinal reportPitts S-2B · Phoenix, AZThe inadequate supervision by the instructor pilot by allowing the trainee to initiate a late go-around from a simulated forced landing.NTSB LAX95LA285Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-B · Peoria, AZthe pilot's improper inflight decision to attempt a tail wind landing to a short runway.NTSB LAX95FA173Accident · 4 fatalField investigationFinal reportCessna 182P · Jerome, AZthe pilot's improper in-flight decision to continue the daytime flight into known adverse weather conditions at an inadequate altitude to clear mountainous terrain.NTSB LAX95LA087Accident · 1 fatalLimited investigationFinal reportStevens S-8 · Tucson, AZThe pilot's failure to maintain adequate control of the airplane to avoid a collision with the ground.NTSB LAX94FA171Accident · 2 fatalField investigationFinal reportCessna 206 · Show Low, AZthe pilot's intentional VFR flight into known adverse IMC weather conditions. Inadequate preflight planning, dark night operations, and weather conditions that included low ceilings and mountain obscuration were factors in the accident.NTSB LAX94LA160Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marana, AZThe pilot's delayed pullout from a vertical aerobatic maneuver for undetermined reasons.NTSB LAX94FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Sedona, AZthe pilot's decision to continue VFR at an improper altitude into mountainous terrain at night and the inadvertent encounter with clouds along the route. Self-induced pressure due to a low fuel state contributed to the accident.NTSB LAX93LA225Accident · 1 fatalLimited investigationFinal reportCessna 172N · Page, AZthe pilot's selection of an inadequate cruise altitude. A factor in the accident was the high winds and turbulence in the vicinity of the cliffs.NTSB LAX93LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilots inadequate compensation for the existing wind conditions and his delay in executing a go around. A factor in the accident was the pilot's lack of total experience.NTSB LAX93LA100Accident · 1 fatalLimited investigationFinal reportWohlers Steen Skybolt · Fountain Hills, AZThe pilot's initiation of a low level aerobatic maneuver at an altitude insufficient to ensure adequate terrain clearance.NTSB LAX93LA043Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Camp Verde, AZThe pilots intentional maneuvering flight at a altitude inadequate to ensure terrain clearance.