NTSB investigations, AZ

347 cases where the sequence of events included Collision with terr/obj (non-CFIT).

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\" = '470' 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 WPR09LA251Accident · No injuriesLimited investigationFinal reportErcoupe 415C · San Manuel, AZA loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and impact with terrain.May 15, 2009 · N2339H · 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 WPR09CA224Accident · No injuriesData collectionFinal reportRobinson R44 · Cottonwood, AZThe pilot's inadequate visual lookout and failure to maintain clearance from wires.May 3, 2009 · N441CB · Substantial damageNTSB WPR09LA221Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Bullhead City, AZThe pilot's inadequate compensation for the gusting crosswinds and his failure to maintain directional control during landing.Apr 8, 2009 · N3224Q · Substantial damageNTSB WPR09LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's failure to achieve the proper touchdown point during a full-stop landing attempt. Contributing to the accident were the pilot's failure to ensure that the aircraft was properly configured for landing, his not initiating a go-around, and a…Mar 28, 2009 · N97467 · Substantial damageNTSB WPR09LA160Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.Mar 20, 2009 · N90764 · 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 WPR09CA106Accident · No injuriesData collectionFinal reportGrumman AA-5 · Payson, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control. Contributing to the accident was the crosswind condition.Feb 1, 2009 · N5423L · Substantial damageNTSB WPR09CA099Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bisbee, AZThe student pilot's failure to maintain directional control during takeoff and the flight instructor's inadequate supervision of the flight and delay in remedial action.Jan 24, 2009 · N5117L · 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 WPR09FA038Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Sedona, AZThe partial loss of engine power while maneuvering for undetermined reasons.Nov 13, 2008 · N3929W · DestroyedNTSB 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 SEA08CA181Accident · No injuriesData collectionFinal reportEberle Pitts S1S · Show Low, AZThe pilot failed to maintain directional control during landing. Contributing to the accident was the pilot's limited experience in the airplane.Aug 17, 2008 · N39124 · Substantial damageNTSB SEA08CA180Accident · No injuriesData collectionFinal reportCessna 177 · Glendale, AZThe loss of engine power due to vapor lock. Contributing to the accident was the high atmospheric temperature.Aug 17, 2008 · N29304 · Substantial damageNTSB SEA08LA179Accident · 1 fatalLimited investigationFinal reportCessna 177 · St. Johns, AZThe failure of both pilots to abort the takeoff when a suitable climb rate could not be attained. Contributing to the accident was the reduction of available power due to the camshaft lobe and lifter corrosion/wear, the high density altitude, and the CFI’s…Aug 16, 2008 · N3487T · Substantial damageNTSB LAX08CA252Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe student pilot's misjudged altitude and distance, and failure to attain the proper touchdown point, that led to a landing overrun.Aug 1, 2008 · N757PS · Substantial damageNTSB LAX08CA257Accident · No injuriesData collectionFinal reportCessna 150M · Phoenix, AZThe student pilot's failure to maintain directional control during a touch-and-go landing.Jul 28, 2008 · N704JD · 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 DEN08MA116Accident · 7 fatalMajor investigationFinal reportBell 407 · Flagstaff, AZBoth helicopter pilots’ failure to see and avoid the other helicopter on approach to the helipad. Contributing to the accident were the failure of N407GA’s pilot to follow flight arrival route guidelines, and the failure of N407MJ’s pilot to follow…Jun 29, 2008 · N407GA · 2 aircraft · DestroyedNTSB LAX08CA199Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot's inadequate recovery from a bounced landing and failure to maintain directional control.Jun 25, 2008 · N4144P · Substantial damageNTSB LAX08CA180Accident · No injuriesData collectionFinal reportCessna 207 · Page, AZThe pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the crosswind weather conditions and the high density altitude conditions.Jun 10, 2008 · N9100D · Substantial damageNTSB LAX08CA166Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Kykotsmovi, AZFuel exhaustion due to the pilot's inadequate preflight planning and failure to ensure that adequate fuel was onboard to complete the flight.Jun 7, 2008 · N9276T · Substantial damageNTSB SEA08LA149Accident · 1 fatalLimited investigationFinal reportVan Heeswyk Lightning · Marana, AZThe insufficient clamping force resulting in a fatigue fracture of the propeller extension attachment bolts and subsequent separation of the propeller assembly in flight. Contributing to the accident was the pilot's failure to maintain sufficient airspeed to…Jun 1, 2008 · N62JV · Substantial damageNTSB LAX08CA155Accident · No injuriesData collectionFinal reportCessna 172N · Sells, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain proper runway alignment.May 26, 2008 · N2857E · 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 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 damageNTSB SEA08LA100Accident · No injuriesLimited investigationFinal reportCessna 182A · Buckeye, AZA loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.Mar 30, 2008 · N5931B · Substantial damageNTSB LAX08CA111Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Grand Canyon, AZThe pilot's inadequate compensation for the wind conditions and delay in aborting the takeoff. Contributing to the accident were wind gusts and a crosswind.Mar 30, 2008 · N5521J · Substantial damageNTSB SEA08CA099Accident · No injuriesData collectionFinal reportBeechcraft 35-C33A · Prescott, AZFuel starvation due to the pilot's improper preflight and failure to select a tank containing fuel before takeoff.Mar 29, 2008 · N4833J · Substantial damageNTSB SEA08CA097Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Phoenix, AZThe pilot's failure to maintain directional control of the airplane during landing.Mar 28, 2008 · N963WW · Substantial damageNTSB LAX08LA078Accident · 1 fatalLimited investigationFinal reportJenkins RV-7A · Winslow, AZThe pilot's failure to maintain an adequate airspeed that resulted in a stall/spin.Mar 18, 2008 · N742MJ · Substantial damageNTSB LAX08LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mesa, AZA partial loss of engine power for undetermined reasons.Mar 18, 2008 · N19521 · Substantial damageNTSB LAX08CA076Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was the crosswind condition.Mar 15, 2008 · N416PA · Substantial damageNTSB SEA08LA089Accident · No injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH 2000 · Scottsdale, AZThe loss of engine power for undetermined reasons. Contributing to the accident were the sign and a vehicle.Mar 10, 2008 · N8500B · Substantial damageNTSB SEA08LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe student pilot's delay in initiating the go-around, and the flight instructor's inadequate supervision of the flight and delayed remedial action. Contributing to the accident were the momentary failure of the engine to respond, the failure of both the…Mar 3, 2008 · N8400A · Substantial damageNTSB LAX08CA072Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Tucson, AZThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.Mar 2, 2008 · N22TE · Substantial damageNTSB SEA08LA082Accident · Serious injuriesLimited investigationFinal reportRaytheon 1900D · Kayenta, AZThe flight crew's failure to execute a missed approach, which resulted in a runway excursion after landing. Contributing to the accident were the inoperative lights, weather conditions below published approach minimums, and the slush contaminated runway.Feb 22, 2008 · N305PC · Substantial damageNTSB SEA08LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Carefree, AZThe collapse of the landing gear during landing rollout for undetermined reasons.Feb 10, 2008 · N4796K · Substantial damageNTSB LAX08CA057Accident · No injuriesData collectionFinal reportRobinson R44 II · Bullhead City, AZThe pilot's misjudged landing flare, inadequate bounced landing recovery, and failure to maintain directional control during a bounced landing that resulted in the tail rotor blades colliding with a hangar. Contributing to the accident was the burned out…Feb 3, 2008 · N44NV · Substantial damageNTSB LAX08LA050Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper · Green Valley, AZAn in-flight loss of control and an uncontrolled descent into terrain for undetermined reasons.Jan 19, 2008 · N614LF · Substantial damage