NTSB investigations, 2007, AZ
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2007
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") = 2007 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 LAX08CA041Accident · Minor injuriesData collectionFinal reportFound Acft FBA-2C2 · Holbrook, AZThe pilot's failure to maintain directional control during landing rollout, which resulted in an inadvertent ground loop.NTSB LAX08CA040Accident · No injuriesData collectionFinal reportEldredge Aircamper SDE · Sahuarita, AZThe pilot's failure to maintain adequate airspeed. A contributing factor was the pilot's distraction due to the presence of an automobile, which appeared to encroach upon the runway environment.NTSB LAX08CA039Accident · No injuriesData collectionFinal reportCessna 310R · Phoenix, AZThe pilot's selection of a wrong taxi route, inadequate visual lookout, failure to maintain separation from ground obstacles, and excessive taxi speed.NTSB LAX08CA033Accident · Minor injuriesData collectionFinal reportSenft/Anderson/salmon C-5 · Tucson, AZa total loss of engine power due to the failure of the number 3 articulating rod.NTSB DEN08IA033Incident · No injuriesIncident investigationFinal reportBoeing 737-832 · Phoenix, AZDelamination of the right outboard tire tread during the takeoff roll due to underinflation and/or overloading during use in service.NTSB SEA08LA038Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Yuma, AZFatigue fracture of the control rotor blade spar and failure of maintenance personnel to follow maintenance directives.NTSB LAX08CA031Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-20-C1 · Mesa, AZthe student pilot's failure to maintain the proper glide path and misjudged flare, which resulted in a hard landing.NTSB SEA08CA027Accident · No injuriesData collectionFinal reportEurocopter France EC 130 B4 · Meadview, AZThe downward flexing of the standing helicopter's main rotor blades and subsequent impact with its tail boom as a result of another helicopter's rotor blade's vortices. .NTSB SEA08CA026Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Sedona, AZThe pilot's inadequate compensation for the wind condition, which resulted in his failure to maintain directional control during takeoff. Factors associated with the accident included the gusty crosswind condition and the taxiway sign.NTSB SEA08LA066Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Benson, AZThe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to avoid a stall. Contributing to the accident was a variable tailwind.NTSB LAX08CA030Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Overgaard, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB SEA08LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe failure of the solo student pilot operating the other airplane to maintain clearance while taxiing for takeoff.NTSB LAX08CA011Accident · No injuriesData collectionFinal reportMaule M-5-235-C · Mesa, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX08CA010Accident · No injuriesData collectionFinal reportCessna 172R · Glendale, AZthe student pilot's improper bounced landing recovery technique, improper use of the flight controls, and the instructor's inadequate supervision of the flight.NTSB LAX08LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Prescott, AZThe failure of maintenance personnel to detect fatigue cracks in the number 3 exhaust rocker arm, which lead to a partial loss of engine power.NTSB LAX08LA005Accident · No injuriesLimited investigationFinal reportCessna 150D · Strawberry, AZThe loss of engine power for an undetermined reason.NTSB SEA08LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Green Valley, AZThe loss of engine power due to the separation of the number three cylinder exhaust rocker arm.NTSB LAX07LA281Accident · Minor injuriesLimited investigationFinal reportEurocopter France EC 130 B4 · Meadview, AZCollision with a bird during cruise flight.NTSB SEA07CA273Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Chandler, AZThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were the downdraft, the uneven terrain, and the flight instructor's delayed…NTSB SEA07CA265Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Flagstaff, AZThe pilot's failure to attain an adequate airspeed, which resulted in a forced landing off the end of the runway. A contributing factor to the accident was the gusting wind.NTSB SEA07LA252Accident · No injuriesLimited investigationFinal reportKearney Pulsar XP · Cottonwood, AZThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07CA262Accident · No injuriesData collectionFinal reportWessel Vortex · Mesa, AZFailure of the muffler's mounting strap and subsequent loss of engine power due to propeller blade separation during cruise flight. A contributing factor was the unsuitable terrain for a forced landing.NTSB SEA07CA244Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Salome, AZThe pilot's inadequate compensation for the tailwind condition and failure to maintain directional control during the takeoff roll/run, which resulted in a ground loop.NTSB SEA07IA237Incident · No injuriesIncident investigationFinal reportRaytheon Cobra · Whetstone, AZThe student pilot's failure to follow proper procedures, specifically not verifying that the mode switch was in the automatic position before changing the pilot address, which resulted in a loss of aircraft control. Contributing to the accident was the flight…NTSB LAX07CA250Accident · No injuriesData collectionFinal reportCessna 182H · Page, AZthe pilot's failure to maintain clearance with obstructions while taxiing behind parked airplanes.NTSB SEA07CA233Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Tucson, AZThe student pilot's failure to maintain rotor RPM during landing approach, and the delayed remedial action by the flight instructor. A contributing factor was the high density altitude weather condition.NTSB LAX07MA231Accident · 4 fatalClass 1 · MajorFinal reportEurocopter AS350-B2 · Phoenix, AZBoth pilots' failure to see and avoid the other helicopter. Contributing to this failure was the pilots' responsibility to perform reporting and visual tracking duties to support their station's ENG operation. Contributing to the accident was the lack of…NTSB LAX07CA226Accident · No injuriesData collectionFinal reportBeech C23 · Taylor, AZthe student pilot's misjudged landing flare and inadequate recovery from a bounced landing that resulted in a hard landing and a loss of directional control.NTSB SEA07FA199Accident · 2 fatalField investigationFinal reportCessna 182S · New River, AZThe pilot's inadvertent VFR flight into IMC and his ensuing failure to maintain aircraft control while in cruise flight. Contributing factors were the cloudy weather and the dark night conditions.NTSB LAX07CA205Accident · Minor injuriesData collectionFinal reportSaunders Stiletto · Quartzsite, AZFuel exhaustion due to the pilot's inadequate preflight inspection during which he failed to insure security of the fuel tank's cap.NTSB LAX07CA203Accident · Serious injuriesData collectionFinal reportRajhamsa Xair · Pima, AZThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional airplane control during landing rollout.NTSB LAX07LA197Accident · Minor injuriesLimited investigationFinal reportEvenson Roger J Vans RV-9A · Tucson, AZthe loss of engine power during takeoff-initial climb, which resulted from the owner/builder's improper adjustment of the supercharger waste gate valve, that resulted in the failure of the waste gate servo motor.NTSB SEA07CA180Accident · No injuriesData collectionFinal reportRobinson R22 · Tucson, AZThe certified flight instructor's inadequate supervision of the practice autorotation. Contributing factors included the terrain drop off and the failure of the pilot undergoing instruction to maintain adequate rotor rpm.NTSB SEA07LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Flagstaff, AZThe loss of engine power during cruise flight due to fuel exhaustion, as a result of the pilot's failure to refuel and inadequate preflight planning.NTSB SEA07LA160Accident · No injuriesLimited investigationFinal reportCessna 182D · Phoenix, AZThe loss of engine power due to the intake manifold disconnection to the engine's cylinders on the left side.NTSB SEA07CA175Accident · No injuriesData collectionFinal reportBurkhart Grob G102 Std Astir III · Wickenburg, AZThe pilot's inadequate compensation for wind conditions which resulted in an inflight collision with a cactus tree while landing. The loss of thermal lift, tailwind, gusts, and tree were contributing factors to the accident.NTSB LAX07IA191Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZAn out of rig/jammed door. Contributing to the incident was the operator's inadequate maintenance program and the airframe manufacturer's inadequate response to the issue.NTSB LAX07CA182Accident · No injuriesData collectionFinal reportCessna 340A · Chandler, AZfuel starvation due to the pilot's failure to adequately manage and monitor his fuel supply.NTSB LAX07LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Winslow, AZLoss of engine power for undetermined reasons.NTSB LAX07LA167Accident · 1 fatalLimited investigationFinal reportSheely Rans S-12XL · Pinetop, AZthe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with terrain.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 LAX07CA161Accident · No injuriesData collectionFinal reportAeronca 11AC · Glendale, AZThe private pilot's unstabilized approach and failure to maintain directional control during the landing roll, which resulted in a ground loop. Also causal was the instructor's inadequate supervision and failure to take remedial action.NTSB LAX07LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZA loss of engine power while maneuvering due to a broken exhaust valve. Contributing to the accident was the rough terrain.NTSB LAX07CA171Accident · No injuriesData collectionFinal reportCessna 172S · Payson, AZThe pilot's inadequate in-flight planning/decision, excessive airspeed on final approach, and failure to execute a go-around resulting in a misjudged flare and hard landing.NTSB SEA07LA118Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Kayenta, AZThe overstress separation of both ruddervators during cruise flight. Contributing to the accident was the flight's encounter with turbulence.NTSB LAX07LA137Accident · No injuriesLimited investigationFinal reportRiesland Fly Baby 1 · Grand Canyon, AZThe pilot's failure to maintain clearance from a fence during landing.NTSB LAX07CA144Accident · No injuriesData collectionFinal reportGadbois Apex Cross 5 · Show Low, AZthe pilot's inadequate in-flight fuel consumption calculations and failure to divert to an alternate airport, which resulted in a loss of engine power due to fuel exhaustion.NTSB LAX07CA139Accident · No injuriesData collectionFinal reportCessna T206H · Grand Canyon, AZThe pilot's misjudged landing flare, which resulted in a bounced landing and a porpoise.NTSB SEA07CA109Accident · Minor injuriesData collectionFinal reportCessna 172I · Peach Springs, AZThe pilot's failure to adequately compensate for the gusty wind condition encountered on final approach, resulting in a loss of control and an in-flight collision with a dirt berm. A contributing factor was the gusty wind condition.NTSB LAX07LA130Accident · 3 fatalLimited investigationFinal reportBeech 35-B33 · Sedona, AZThe pilot's inadequate compensation for the high wind conditions and wind shear encounter on final approach, that led to a failure to maintain an adequate airspeed and a stall.