NTSB investigations, 1997, 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
Latest 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\") = 1997
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") = 1997 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 LAX98FA064Accident · 1 fatalField investigationFinal reportPiper PA-11 · Willow Beach, AZThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB LAX98LA059Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Safford, AZThe pilot's poor in-flight judgement and intentional flight into known adverse weather conditions. Related factors were, mountainous terrain, rain and fog.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 LAX98LA041Accident · Minor injuriesLimited investigationFinal reportRans S91 · Phoenix, AZThe pilot's failure to maintain an adequate airspeed margin during the forced landing, which resulted in an inadvertent stall/mush.NTSB LAX98LA038Accident · 1 fatalLimited investigationFinal reportAdams Sonerai II · Kingman, AZThe complete loss of engine power for undetermined reasons. A factor in the accident was the rough nature of the landing site terrain.NTSB LAX98LA033Accident · Serious injuriesLimited investigationFinal reportWaco YMF-5 · Sedona, AZThe failure and separation of the propeller for undetermined reasons.NTSB LAX98LA028Accident · No injuriesLimited investigationFinal reportCessna 172N · Payson, AZThe pilot's selection of a downwind direction to land and his failure to compensate for the quartering tailwind condition.NTSB LAX98LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Prescott, AZThe student's inadvertent application of left brake during touchdown, and the instructor's inadequate supervision of the flight.NTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.NTSB LAX98FA013Accident · No injuriesField investigationFinal reportBeech 99-C99 · Meadview, AZThe pilot's inadequate in-flight decision, inadequate visual lookout, and his failure to maintain adequate obstacle clearance. Contributing was low altitude flight.NTSB LAX98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Temple Bar, AZthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the terrain condition (ditch) in the emergency landing area.NTSB LAX98LA004Accident · No injuriesLimited investigationFinal reportAmerican 8KCAB · Payson, AZDirectional control of the aircraft not maintained through the improper use of landing procedures/techniques. A factor in this accident was the pilot's training regarding the proper techniques to be used during landing.NTSB LAX98LA002Accident · No injuriesLimited investigationFinal reportBlackwell Midget Mustang · Glendale, AZThe pilot's inability to maintain directional control of the aircraft due to the deflation of the right main gear tire. Factors in this accident were the soft sand on the side of the runway and the left crosswind.NTSB LAX97LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZthe student pilot's failure to maintain directional control of the airplane and proper alignment with the runway during landing.NTSB LAX97LA318Accident · No injuriesLimited investigationFinal reportBeech A23A · Tucson, AZthe student pilot's improper recovery from a bounced landing, and failure to maintain adequate airspeed during an attempted go-around, which resulted in a stall and impact with the terrain (runway).NTSB LAX97LA312Accident · No injuriesLimited investigationFinal reportCessna T210J · Avra Valley, AZThe pilot became lost/disoriented during his taxiing into the ramp area. Factors in the accident were the lack of taxiway lights, the pilot's lack of familiarity with the layout of the airport, and the airport operator's failure to either identify the…NTSB LAX97LA306Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bullhead City, AZThe pilot's inadequate compensation for the crosswind,NTSB LAX97LA304Accident · Serious injuriesLimited investigationFinal reportWalton Velocity STD/FG · Chino Valley, AZa loss of engine power for undetermined reasons.NTSB LAX97LA295Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe pilot's inadequate recovery from a bounced landing.NTSB LAX97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZThe student's failure to maintain directional control due to excessive use of the rudder, and the instructor's delayed remedial action.NTSB LAX97LA293Accident · No injuriesLimited investigationFinal reportCessna 188 · Eloy, AZThe pilot's improper recovery from a bounced landing and his failure to maintain directional control due to inadequate rudder use.NTSB LAX97LA290Accident · No injuriesLimited investigationFinal reportCessna 185 · Buckeye, AZThe pilot's misjudgement of the clearance between the aircraft and the tree.NTSB LAX97LA287Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Marana, AZThe pilot's in-flight planning/decision to continue his flight after striking a fence, and his inability to attain the proper climb rate, which subsequently led to the in-flight collision with the transmission power line.NTSB LAX97LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · San Manuel, AZThe student pilot's improper recovery from a bounced landing, and failure to maintain directional control of the aircraft. A factor related to the accident was the pilot's fatigue from improper rest the evening before the flight.NTSB LAX97LA277Accident · No injuriesLimited investigationFinal reportCessna 310 · Mesa, AZinadequate maintenance inspection of the landing gear system, following a prior incident, due to the mechanic's failure to follow the service manual instructions.NTSB LAX97LA271Accident · No injuriesLimited investigationFinal reportMiller S-1 · Cottonwood, AZThe inadequate strength and braking capability of the landing gear and wheel brakes, and the builder's attempt to adapt motorcycle parts to an aircraft application. A factor in this accident was the pilot's lack of familiarity with this experimental aircraft.NTSB LAX97LA266Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Buckeye, AZThe total oil exhaustion of the engine due to the inadequate maintenance installation of the oil cooler lines by the owner/mechanic.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 LAX97LA264Accident · No injuriesLimited investigationFinal reportCessna A150L · Quartzsite, AZThe student pilot's decision to land the airplane on a residential street, where the airplane subsequently hit a sign during the landing roll. Factors related to the accident were the student pilot becoming lost/disoriented during his cross country flight and…NTSB LAX97LA261Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Sedona, AZA partial loss of engine power due to a loose rocker arm adjustment nut on the number 6 cylinder. The loose adjustment nut was due to inadequate maintenance adjustment performed by the engine manufacturer.NTSB LAX97LA260Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Chandler, AZThe CFI's failure to recognize and correct for a vortex ring state, and his improper use of the flight controls, which resulted in the loss of control and uncontrolled descent.NTSB LAX97LA247Accident · No injuriesLimited investigationFinal reportSikorsky S-58T · Page, AZan engine failure resulting from the fracture of two power turbine blades, which had been previously subjected to a hot or hung start.NTSB LAX97LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gila Bend, AZthe pilot's failure to verify the fuel quantity prior to departure, and his failure to perform sufficient en route fuel consumption calculations during the cross-country flight.NTSB LAX97LA268Accident · No injuriesLimited investigationFinal reportCessna 172 · Goodyear, AZThe pilot's inadequate compensation for the existing crosswind condition, and his resultant failure to maintain directional control of the aircraft during the landing flare.NTSB LAX97LA238Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Prescott, AZThe pilot's improper placement of the unmarked fuel selector valve to off which resulted in fuel starvation. A factor in the accident was the pilot's lack of total experience in this model aircraft.NTSB LAX97LA229Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Page, AZThe pilot's inadequate compensation for crosswind gusts and his failure to maintain directional control.NTSB LAX97LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Rimrock, AZFuel starvation due to the pilot's failure to monitor the fuel level in the right tank, and to select a tank containing fuel during the approach and landing in accordance with the checklist.NTSB LAX97LA256Accident · No injuriesLimited investigationFinal reportCessna 150F · Casa Grande, AZFailure of the student pilot to maintain directional control.NTSB LAX97LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe dual student's premature rotation and failure to attain/maintain an adequate airspeed, which lead to a stall/mush and loss of control in-flight, and the flight instructor's inadequate supervision of the flight. A factor in this accident was the flight…NTSB LAX97LA208Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Salome, AZthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the aircraft. The gusty crosswind condition was a related factor.NTSB LAX97GA198Accident · 2 fatalFinal reportBeech 95-B55 · San Carlos, AZThe pilot's failure to maintain an adequate airspeed while maneuvering, which led to an inadvertent stall/spin.NTSB LAX97LA221Accident · No injuriesLimited investigationFinal reportStaudaucher S300D · Chandler, AZThe owner/pilot's decision to use automotive hardware, which had not been heat treated, and the practice of adding aluminum plates to the trailing edge of the aileron without rebalancing the flight controls, which resulted in the separation of the aileron at…NTSB LAX97LA197Accident · 1 fatalLimited investigationFinal reportRotorway 162F · Phoenix, AZthe owner/builder incorrectly installed the tail rotor drive pulley mounting scissors, overtorqued the pivot belts, did not perform the required maintenance lubrication of the pivot belts, and failed to perform adequate visual maintenance checks of these…NTSB LAX97LA191Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Payson, AZan animal (elk) on the runway. Factors associated with the accident included: darkness, the pilot's inability to see the animal in sufficient time to avoid a collision, and the lack of a taller fence around the airport.NTSB LAX97LA183Accident · No injuriesLimited investigationFinal reportNorth American Navion NA-1 · Morristown, AZfailure to replace an old and abraded oil feedline hose which led to its rupture and the in-flight loss of engine oil pressure. A related factor was the pilot's misjudgment of distance-to-go versus altitude remaining during the subsequent forced landing.NTSB LAX97LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T-34 · Tonopah, AZthe failure of the power turbine due to an overtemperature condition created by an improperly adjusted fuel control. A factor in the accident was the tripped circuit breaker which prevented the wing lights from operating during the forced night landing.NTSB LAX97LA174Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Peoria, AZfailure of the student pilot to maintain proper runway alignment and wing tip clearance from high vegetation beside the runway during landing, and the flight instructor's inadequate supervision of the flight. High vegetation on the runway shoulder was a…NTSB LAX97IA170Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Tucson, AZan undetermined failure in the #1 (left) engine turbine assembly, which resulted in a fracture of the first stage nozzle guide vane (NGV) and subsequent damage to the turbine blades.NTSB LAX97LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZthe pilot's encounter with crosswind gusts beyond the performance capability of the aircraft. A lack of crosswind limit information published in the Cessna 172N Pilot's Operating Handbook for landing and taxiing operations is a factor in the accident.NTSB LAX97LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Tucson, AZThe partial blockage of the No. 2 cylinder injection line/nozzle by a transient contaminant, which induced an excessively lean mixture in that cylinder, and the subsequent overheating of the cylinder and intake valve. The engine power loss was due to the open…