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

19632026
NTSB investigations, 1997, AZ per year, 1963–2026: 5,130 cases
19631
1964130
1965107
1966128
1967138
1968114
1969115
1970102
1971128
1972101
1973105
1974101
1975121
1976105
1977123
1978149
1979130
1980114
1981132
1982123
1983114
198484
198578
198677
198776
198861
198979
199068
199186
199288
199368
199465
199573
199668
199771
199854
199964
200061
200163
200276
200393
200472
200581
200677
200766
200873
200974
201063
201167
201261
201354
201462
201542
201640
201750
201860
201947
202036
202144
202253
202343
202441
202545
202645

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.

NTSB LAX98FA064Accident · 1 fatalField investigationFinal reportPiper PA-11 · Willow Beach, AZThe pilot's failure to maintain control of the aircraft for undetermined reasons.Dec 30, 1997 · N5532H · DestroyedNTSB 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.Dec 20, 1997 · N2965L · DestroyedNTSB 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.Dec 3, 1997 · N301JL · DestroyedNTSB 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.Nov 22, 1997 · N9291T · Substantial damageNTSB 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.Nov 16, 1997 · N27KF · DestroyedNTSB LAX98LA033Accident · Serious injuriesLimited investigationFinal reportWaco YMF-5 · Sedona, AZThe failure and separation of the propeller for undetermined reasons.Nov 8, 1997 · N369DP · DestroyedNTSB 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.Nov 2, 1997 · N6585D · Substantial damageNTSB 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.Oct 28, 1997 · N49788 · Substantial damageNTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.Oct 18, 1997 · N7583 · Substantial damageNTSB 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.Oct 15, 1997 · N227AV · Substantial damageNTSB 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.Oct 13, 1997 · N71VL · Substantial damageNTSB 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.Oct 4, 1997 · N69BP · Substantial damageNTSB 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.Oct 2, 1997 · N32JB · Substantial damageNTSB 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.Sep 13, 1997 · N56474 · Substantial damageNTSB 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).Sep 8, 1997 · N2339W · DestroyedNTSB 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…Aug 29, 1997 · N2280R · Substantial damageNTSB LAX97LA306Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bullhead City, AZThe pilot's inadequate compensation for the crosswind,Aug 27, 1997 · N7586S · Substantial damageNTSB LAX97LA304Accident · Serious injuriesLimited investigationFinal reportWalton Velocity STD/FG · Chino Valley, AZa loss of engine power for undetermined reasons.Aug 25, 1997 · N7VX · Substantial damageNTSB LAX97LA295Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe pilot's inadequate recovery from a bounced landing.Aug 19, 1997 · N3266E · Substantial damageNTSB 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.Aug 18, 1997 · N57528 · Substantial damageNTSB 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.Aug 15, 1997 · N9957J · Substantial damageNTSB LAX97LA290Accident · No injuriesLimited investigationFinal reportCessna 185 · Buckeye, AZThe pilot's misjudgement of the clearance between the aircraft and the tree.Aug 14, 1997 · N1023F · Substantial damageNTSB 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.Aug 13, 1997 · N3607B · DestroyedNTSB 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.Aug 12, 1997 · N757CS · Substantial damageNTSB 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.Aug 9, 1997 · N8139M · Substantial damageNTSB 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.Aug 4, 1997 · N22RM · Substantial damageNTSB 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.Jul 31, 1997 · N4667J · Substantial damageNTSB 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.Jul 28, 1997 · N3339N · DestroyedNTSB 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…Jul 26, 1997 · N9903G · Substantial damageNTSB 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.Jul 26, 1997 · N369BP · Substantial damageNTSB 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.Jul 25, 1997 · N4008D · DestroyedNTSB 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.Jul 18, 1997 · N47B · Substantial damageNTSB 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.Jul 12, 1997 · N4594B · Substantial damageNTSB 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.Jul 4, 1997 · N7359A · Substantial damageNTSB 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.Jul 4, 1997 · N70EC · Substantial damageNTSB LAX97LA229Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Page, AZThe pilot's inadequate compensation for crosswind gusts and his failure to maintain directional control.Jul 1, 1997 · N7764D · Substantial damageNTSB 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.Jun 29, 1997 · N5158U · Substantial damageNTSB LAX97LA256Accident · No injuriesLimited investigationFinal reportCessna 150F · Casa Grande, AZFailure of the student pilot to maintain directional control.Jun 28, 1997 · N6634F · Substantial damageNTSB 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…Jun 24, 1997 · N96736 · Substantial damageNTSB 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.Jun 12, 1997 · N5653C · Substantial damageNTSB 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.Jun 3, 1997 · N8KB · DestroyedNTSB 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…May 31, 1997 · N540DH · Substantial damageNTSB 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…May 31, 1997 · N176BT · DestroyedNTSB 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.May 27, 1997 · N757HE · Substantial damageNTSB 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.May 18, 1997 · N8551H · Substantial damageNTSB 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.May 8, 1997 · N4011G · Substantial damageNTSB 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…May 2, 1997 · N931BG · Substantial damageNTSB 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.Apr 28, 1997 · N470AA · Minor damageNTSB 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.Apr 24, 1997 · N733PM · Substantial damageNTSB 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…Apr 18, 1997 · N2847F · Substantial damage