NTSB investigations, AZ

153 cases where the sequence of events included Loss of control in flight.

Cases, newest first

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR11LA305Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Nogales, AZThe pilot did not maintain airplane control during the initial climb.Jul 5, 2011 · N51010 · Substantial damageNTSB WPR11LA287Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · St Johns, AZThe pilot did not attain and maintain an adequate airspeed during the takeoff initial climb, which resulted in an aerodynamic stall.Jun 26, 2011 · N2725V · Substantial damageNTSB WPR11LA277Accident · Serious injuriesLimited investigationFinal reportBell 212 · Mesa, AZThe pilot's failure to maintain helicopter control while in a low hover.Jun 21, 2011 · N49678 · DestroyedNTSB WPR11CA298Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe flight instructor's delayed remedial action and failure to maintain lateral control.Jun 16, 2011 · N434K · Substantial damageNTSB WPR11LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Payson, AZThe pilot's decision to conduct a touch-and-go arrival during his first flight to a high elevation airport, which resulted in an improper mixture adjustment and a partial loss of engine power for the takeoff and attempted climbout.Apr 16, 2011 · N1835U · Substantial damageNTSB WPR11CA197Accident · No injuriesData collectionFinal reportXtremeair Sbach 342 · Springerville, AZThe pilot's failure to properly secure loose objects in the cockpit area which resulted in a personal locator beacon becoming lodged in the elevator control torque tubes, restricting flight control movement.Apr 4, 2011 · N142WP · Substantial damageNTSB WPR11LA169Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Mesa, AZThe pilot's attempt to correct a landing float by adding power, followed by his premature attempt to climb the airplane out of ground effect during a balked landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's failure…Mar 19, 2011 · N329SM · Substantial damageNTSB WPR11GA115Accident · 1 fatalFinal reportMcdonnell Douglas Heli 369FF · Marana, AZAn inadvertent tail rotor strike during an attempted pinnacle landing, which resulted in the pilot's loss of control of the helicopter. Inhospitable terrain/topography contributed to the severity of the accident.Jan 31, 2011 · N530RL · Substantial damageNTSB WPR11CA112Accident · Minor injuriesData collectionFinal reportHarvey Patten Rans S-6ES · Buckeye, AZA disconnection of the elevator control linkage due to incorrect installation or maintenance, which was due to the retaining nut backing off the bolt and allowing the bolt to fall out.Jan 28, 2011 · N8053R · Substantial damageNTSB WPR11LA080Accident · Serious injuriesLimited investigationFinal reportSchaefer Kitfox 4 · Glendale, AZThe pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…Dec 23, 2010 · N95FT · Substantial damageNTSB WPR11LA069Accident · 1 fatalLimited investigationFinal reportSabre Trike · Peoria, AZAn in-flight loss of control for undetermined reasons.Dec 2, 2010 · N765MH · Substantial damageNTSB WPR10FA435Accident · 1 fatalField investigationFinal reportRemos Remos G-3/600 · Tucson, AZThe pilot's failure to maintain airplane control while maneuvering at a low altitude.Aug 28, 2010 · N268RA · Substantial damageNTSB WPR10LA429Accident · 2 fatalLimited investigationFinal reportFinney Thorp T-18 · Willcox, AZThe pilot’s failure to maintain sufficient airspeed during a steep turn and at a low altitude in the traffic pattern, which resulted in an aerodynamic stall.Aug 26, 2010 · N467JF · Substantial damageNTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.Aug 13, 2010 · N9761L · Substantial damageNTSB WPR10FA383Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Phoenix, AZThe pilot‘s failure to maintain airspeed and airplane control during a turn from the base leg to final approach due to his diverted attention.Aug 4, 2010 · N146CK · Substantial damageNTSB WPR10LA258Accident · 1 fatalLimited investigationFinal reportRice GN-1 AIR Campier · Paulden, AZThe pilot's loss of airplane control for undetermined reasons while on final approach to land.May 24, 2010 · N129JR · Substantial damageNTSB WPR10CA233Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lake Havasu City, AZThe student pilot's failure to maintain aircraft control during a go-around, resulting in a stall/mush.May 8, 2010 · N918JR · Substantial damageNTSB WPR10FA228Accident · 1 fatalField investigationFinal reportCessna U206G · Yuma, AZThe pilot's loss of situational awareness and failure to maintain aircraft control while maneuvering at low altitude. Contributing to the accident was glare from the rising sun.May 6, 2010 · N756WN · Substantial damageNTSB WPR10CA172Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe flight instructor's failure to attain and maintain adequate airspeed while demonstrating a soft-field takeoff.Mar 21, 2010 · N428PA · Substantial damageNTSB WPR10LA156Accident · 1 fatalLimited investigationFinal reportNorth American P51D · Chandler, AZThe pilot’s improper flare, resulting in a bounced landing, stall, and loss of directional control.Mar 11, 2010 · N514NH · Substantial damageNTSB WPR10CA153Accident · No injuriesData collectionFinal reportAviat A-1C-200 · St. Johns, AZThe pilot's inadequate compensation for the crosswind gusts and failure to maintain proper runway alignment during takeoff.Mar 7, 2010 · N134DD · Substantial damageNTSB WPR10LA046Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350BA · Globe, AZThe pilot receiving instruction’s failure to maintain adequate airspeed or control of the helicopter during a simulated hydraulic failure maneuver, which resulted in a hard landing. Contributing to the accident was the flight instructor’s delayed remedial…Nov 5, 2009 · N617LH · Substantial damageNTSB WPR10LA010Accident · 1 fatalLimited investigationFinal reportCruz SE5A Replica · Phoenix, AZThe pilot's failure to maintain airspeed during initial climb, which resulted in a stall/spin and impact with the ground.Oct 9, 2009 · N3944U · Substantial damageNTSB WPR09FA464Accident · No injuriesField investigationFinal reportEurocopter AS 350 B3 · Tucson, AZThe loss of directional control for undetermined reasons.Sep 25, 2009 · N103LN · Substantial damageNTSB WPR09FA400Accident · 2 fatalField investigationFinal reportPiper PA-24 · Prescott, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering to return to the runway at a high density altitude, which resulted in an aerodynamic stall.Aug 17, 2009 · N6304P · Substantial damageNTSB WPR09CA387Accident · No injuriesData collectionFinal reportBeech 35 · St. Johns, AZThe pilot’s inadequate compensation for the crosswind gust and failure to maintain directional control of the airplane during the takeoff. Contributing to the accident was the gusty crosswind weather conditions.Aug 5, 2009 · N4577V · Substantial damageNTSB WPR09LA384Accident · 1 fatalLimited investigationFinal reportBoeing E75 · Happy Jack, AZThe pilot's failure to maintain airspeed while maneuvering which resulted in an inadvertent stall/spin. Contributing to the accident was the high density altitude.Aug 4, 2009 · N5195N · Substantial damageNTSB WPR09CA366Accident · Minor injuriesData collectionFinal reportRans S-12 XL Airaile · Marana, AZThe pilot's failure to maintain directional control during takeoff.Jul 24, 2009 · N350KB · Substantial damageNTSB WPR09LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Tucson, AZThe pilot’s failure to maintain directional and lateral aircraft control during takeoff. Contributing to the accident was the partial loss of left engine power for undetermined reasons.Jul 3, 2009 · N7657Y · Substantial damageNTSB WPR09FA309Accident · 4 fatalField investigationFinal reportBeech B95 · Holbrook, AZThe pilot’s decision to depart when ill and his failure to maintain control of the airplane during a return to the airport, likely because of his physical illness and drug impairment.Jun 25, 2009 · N912T · Substantial damageNTSB WPR09LA308Accident · 2 fatalLimited investigationFinal reportMayo RV-6A · Cottonwood, AZThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.Jun 23, 2009 · N413RV · Substantial damageNTSB WPR09LA263Accident · 2 fatalLimited investigationFinal reportLanham Lancair IV · Seligman, AZThe pilot's loss of airplane control during en route descent while operating in known icing conditions.May 23, 2009 · N144L · Substantial damageNTSB WPR09CA231Accident · Serious injuriesData collectionFinal reportFuhrmann-Super Emeraude Stretched · Peach Springs, AZThe airplane's encounter with turbulence after takeoff, which resulted in an uncontrolled descent and collision with terrain.May 8, 2009 · N11LF · Substantial damageNTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.Mar 30, 2009 · N74815 · Substantial damageNTSB WPR09LA153Accident · 1 fatalLimited investigationFinal reportHowes RV-6 · Paulden, AZA total loss of engine power due to oil starvation as a result of a leak from the inadequate weld repair of a high-pressure oil line. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering that resulted in a stall during an…Mar 19, 2009 · N6383W · Substantial damageNTSB WPR09FA062Accident · 1 fatalField investigationFinal reportDiamond DA 20-C1 · Alamo Lake State Park, AZThe pilot's failure to maintain control during the performance of a maneuver and his failure to recover from the subsequent aerodynamic stall and spin.Dec 20, 2008 · N4196M · Substantial damageNTSB WPR09CA031Accident · No injuriesData collectionFinal reportPiper PA-22-135 · San Manuel, AZThe pilot's failure to maintain lateral aircraft control that resulted in collision with terrain during landing.Nov 2, 2008 · N2468A · Substantial damageNTSB WPR09CA003Accident · No injuriesData collectionFinal reportBeech 76 · Eloy, AZThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident were the crosswind wind conditions and terrain induced turbulence.Oct 4, 2008 · N6013X · Substantial damageNTSB SEA08CA208Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Flagstaff, AZThe pilot's decision to attempt a takeoff in a high density altitude high gross weight condition that exceeded the takeoff performance capability of the helicopter. The pilot's failure to maintain adequate rotor rpm was also causal. Contributing factors were…Sep 24, 2008 · N926EL · Substantial damageNTSB DEN08IA160IncidentIncident investigationFinal reportRaytheon Cobra · Whetstone, AZA total off of engine power resulting from an overheated piston, and the pilot's subsequent failure to send a proper command to the UAS. Contributing to the accident was the operation of the engine at high power for an extended period with a lean fuel setting.Sep 24, 2008 · N602RN · DestroyedNTSB SEA08FA187Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Springerville, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff in high density altitude conditions that resulted in an aerodynamic stall.Aug 20, 2008 · N5316L · Substantial damageNTSB LAX08LA231Accident · 1 fatalLimited investigationFinal reportNichols Rans S-14 · Benson, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering for landing, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot's impairment from recent marijuana use.Jul 18, 2008 · N923GN · Substantial damageNTSB LAX08CA147Accident · No injuriesData collectionFinal reportBeech B-23 · Bagdad, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain runway alignment. Contributing factors were the gusty crosswind weather conditions and the rocky terrain adjacent to the runway.May 17, 2008 · N4026T · Substantial damageNTSB LAX08FA134Accident · 2 fatalField investigationFinal reportExtra Flugzeugproduktions-GMBH EA-300/L · Queen Creek, AZThe loss of aircraft control due to an undetermined rudder malfunction.May 9, 2008 · N133EE · Substantial damageNTSB LAX08CA126Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta II · Prescott, AZThe instructor's inadequate supervision and delayed remedial action that resulted in ground contact and a rollover.May 2, 2008 · N331MD · Substantial damageNTSB LAX08FA122Accident · 3 fatalField investigationFinal reportCarlton M. Cadwell Lancair IV-P · Mesa, AZThe pilot's failure to maintain an adequate airspeed during climb out resulting in an aerodynamic stall/spin.Apr 23, 2008 · N25CL · DestroyedNTSB SEA08CA109Accident · No injuriesData collectionFinal reportPiper J3C-65 · Bisbee, AZThe pilot's failure to obtain/maintain sufficient airspeed after takeoff, which resulted in a stall/mush condition.Apr 8, 2008 · N3228N · Substantial damageNTSB SEA08CA107Accident · No injuriesData collectionFinal reportCessna 152 · Tucson, AZThe pilot's inadequate compensation for the gusty wind condition, which resulted in a loss of control and impact with terrain while landing. A contributing factor was the gusty wind condition.Apr 7, 2008 · N5259B · Substantial damageNTSB LAX08FA092Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Benson, AZThe pilot's misjudged speed and altitude during approach that led to a long landing and his subsequent failure to maintain control during an attempted go-around. Contributing to the accident were the dark night, the pilot's low total night flight experience,…Apr 3, 2008 · N20480 · Substantial damageNTSB SEA08LA101Accident · Minor injuriesLimited investigationFinal reportJihlavan KP 5 ASA · Marana, AZThe pilot's failure to maintain an airspeed above stalling speed (Vs) during an emergency landing after takeoff. Contributing to the accident was an inadequate preflight inspection, and the airplane's canopy coming partially open shortly after takeoff.Mar 31, 2008 · N31KP · Substantial damage