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 CEN20FA034Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Flower Pot, AZThe noninstrument-rated pilot’s decision to initiate and continue the visual flight rules flight into an area of forecast instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of airplane control. Contributing was…Dec 8, 2019 · N5557Q · DestroyedNTSB WPR20LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Red Rock, AZA total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s improper use of carburetor heat.Nov 13, 2019 · N704QJ · Substantial damageNTSB GAA20CA039Accident · No injuriesData collectionFinal reportZenair CH 701 · Safford, AZThe in-flight separation of a propeller blade for reasons that could not be determined based on the available evidence, which resulted in an off-airport landing on soft sand and the separation of main landing gear. Contributing to the accident was the pilot’s…Oct 20, 2019 · N3784A · Substantial damageNTSB GAA20CA036Accident · No injuriesData collectionFinal reportTitan Titan Tornado II · Marble Canyon, AZThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with sand hummocks.Oct 18, 2019 · N49PD · Substantial damageNTSB GAA20CA045Accident · No injuriesData collectionFinal reportAeropro CZ A220 · Buckeye, AZThe pilot's failure to maintain directional control during an aborted landing with a crosswind, which resulted in tailwheel impacting vegetation and the left main landing gear collapsing.Oct 14, 2019 · N441B · Substantial damageNTSB GAA19CA582Accident · No injuriesData collectionFinal reportDiamond DA 40 · Mesa, AZThe pilot's decision to abort a go-around with insufficient runway remaining to safely stop the airplane, which resulted in a loss of control, runway excursion and impact with a concrete barrier.Sep 28, 2019 · N4119S · Substantial damageNTSB GAA19CA546Accident · No injuriesData collectionFinal reportMooney M20M · Chandler, AZThe pilot's improper pitch control during takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor's failure to take remedial action.Sep 14, 2019 · N1085W · Substantial damageNTSB GAA19CA542Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's failure to maintain directional control during an aborted takeoff, which resulted in a runway excursion and impact with runway signs while attempting to maneuver back onto the runway.Sep 12, 2019 · N796WW · Substantial damageNTSB GAA19CA511Accident · No injuriesData collectionFinal reportPiper PA28 · Cottonwood, AZThe student pilot's improper pitch and lateral control during a soft-field takeoff, which resulted in impact with terrain. Contributing to the accident was the student pilot's failure to relinquish control of the airplane to the instructor.Aug 25, 2019 · N8619W · Substantial damageNTSB GAA19CA483Accident · Serious injuriesData collectionFinal reportSchleicher ASW 24 · Paulden, AZThe pilot's distraction due to the environment, his failure to lower the landing gear, and his subsequent failure to maintain directional control while landing the glider, which resulted in impact with a utility box.Aug 4, 2019 · N37T · Substantial damageNTSB GAA19CA445Accident · No injuriesData collectionFinal reportCessna 170 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the right wing striking the ground.Jul 19, 2019 · N3276A · Substantial damageNTSB GAA19CA424Accident · No injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.Jul 16, 2019 · N1079M · Substantial damageNTSB GAA19CA375Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's improper landing flare and failure to maintain the runway heading, which resulted in the loss of airplane control, and the flight instructor's delayed remedial action during a go-around with a crosswind, which resulted in a bounced landing…Jun 28, 2019 · N606JA · Substantial damageNTSB WPR19LA167Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20V · Phoenix, AZThe partial loss of engine power during cruise flight for reasons that could not be determined with the available evidence.Jun 11, 2019 · N576CM · Substantial damageNTSB GAA19CA312Accident · No injuriesData collectionFinal reportCessna 172 · Nogalas, AZThe student pilot's failure to maintain adequate clearance from a parked fuel truck. Contributing to the accident were the student’s failure to follow company policy and the flight instructor’s delayed remedial action.May 23, 2019 · N273EB · Substantial damageNTSB WPR19LA144Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Gila Bend, AZThe pilot's failure to configure the landing gear in a timely manner before landing, which resulted in a propeller strike.May 13, 2019 · N4992J · Substantial damageNTSB GAA19CA253Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · Gila Bend, AZThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a ditch.Apr 26, 2019 · N67823 · Substantial damageNTSB GAA19CA220Accident · No injuriesData collectionFinal reportCessna 172 · Prescott, AZThe student pilot's failure to maintain clearance from a fence post during taxi operations.Apr 23, 2019 · N1897V · Substantial damageNTSB GAA19CA225Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe pilot's improper rudder inputs and failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway sign.Apr 20, 2019 · N6023V · Substantial damageNTSB GAA19CA212Accident · Minor injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe pilot's failure to maintain lateral control during landing and his exceedance of the airplane’s critical angle of attack during the subsequent aborted landing, which resulted in an aerodynamic stall.Apr 17, 2019 · N425PA · Substantial damageNTSB GAA19CA162Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe student pilot's failure to maintain the runway heading during a go-around with a crosswind, which resulted in the left main landing gear impacting a runway sign.Mar 2, 2019 · N9404F · Substantial damageNTSB GAA19CA133Accident · No injuriesData collectionFinal reportDenney Kitfox IV Speedster · Page, AZThe pilot's failure to maintain lateral control during the landing flare, which resulted in the left wing striking a tree.Feb 8, 2019 · N995BW · Substantial damageNTSB WPR19TA061Accident · Serious injuriesClass 3Final reportBell 206 · Yuma, AZThe pilot's failure to maintain clearance from power transmission wires while flying at low altitude in nighttime conditions.Jan 12, 2019 · N88HC · Substantial damageNTSB GAA19CA127Accident · Serious injuriesData collectionFinal reportLuscombe 8 · Casa Grande, AZThe pilot's failure to maintain yaw control and his exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.Jan 5, 2019 · N71155 · Substantial damageNTSB GAA19CA112Accident · No injuriesData collectionFinal reportZlin Savage · Prescott, AZThe pilot's failure to maintain directional control during the landing roll with a tailwind.Jan 3, 2019 · N808JD · Substantial damageNTSB GAA19CA102Accident · No injuriesData collectionFinal reportBeech 36 · Sedona, AZThe pilot's failure to maintain the proper airspeed during landing, which resulted in the airplane landing too fast and too far down the runway to safely stop it.Dec 19, 2018 · N636M · Substantial damageNTSB GAA19CA084Accident · Serious injuriesData collectionFinal reportPiper PA28 · Casa Grande, AZThe student pilot's failure to maintain a proper glidepath during the approach, which resulted in impact with a fence and terrain.Nov 28, 2018 · N5668W · Substantial damageNTSB GAA19CA072Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Benson, AZThe pilot's overcorrection during the landing, which resulted in a loss of directional control.Nov 23, 2018 · N50340 · Substantial damageNTSB WPR19FA007Accident · 2 fatalClass 2 · FieldFinal reportCessna T240 · Payson, AZThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin and a subsequent loss of control.Oct 14, 2018 · N433CS · DestroyedNTSB WPR18LA262Accident · Serious injuriesLimited investigationFinal reportCessna 172 · St. Johns, AZThe pilot's inadequate preflight planning before takeoff in the high density altitude conditions, which resulted in the airplane being unable to maintain sufficient airspeed to continue to climb.Sep 15, 2018 · N734FT · Substantial damageNTSB WPR18LA250Accident · No injuriesLimited investigationFinal reportStoddard Hamilton Glasair Super IIS · Yuma, AZA total loss of engine power as a result of the detachment of the throttle linkage from the throttle arm of the fuel injector servo due to an insufficiently tightened and secured bolt and the subsequent inadequate maintenance inspection.Aug 27, 2018 · N8162H · Substantial damageNTSB WPR18FA229Accident · 2 fatalField investigationFinal reportJames E Causey Acroduster II · Phoenix, AZAn exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.Aug 20, 2018 · N787WM · Substantial damageNTSB WPR18FA228Accident · 2 fatalClass 3 · FieldFinal reportPietenpol Aircamper · Camp Verde, AZLoss of control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical anomalies that would have precluded normal operation.Aug 18, 2018 · N88HK · Substantial damageNTSB WPR18FA178Accident · 1 fatalClass 2 · FieldFinal reportSchempp-Hirth Standard Cirrus · Aguila, AZThe pilot's exceedance of the glider's critical angle of attack while attempting a thermal climb at low altitude, which resulted in an aerodynamic stall/spin at an altitude that precluded recovery.Jun 23, 2018 · N7880 · Substantial damageNTSB WPR18LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Aguila, AZA total loss of engine power due to pre-ignition/detonation for reasons that could not be determined based on available information.Jun 19, 2018 · N764CT · DestroyedNTSB GAA18CA312Accident · No injuriesData collectionFinal reportPiper PA 46 · Prescott, AZThe pilot’s improper fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.May 30, 2018 · N148ME · Substantial damageNTSB GAA18CA274Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to maintain directional control during the landing roll in tailwind conditions.May 10, 2018 · N430PA · Substantial damageNTSB GAA18CA272Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Mesa, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.May 10, 2018 · N82XC · Substantial damageNTSB ANC18LA034Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman TBM-3 · Fort Apache, AZA partial loss of engine power for reasons that could not be determined based on the available information.May 6, 2018 · N337VT · DestroyedNTSB GAA18CA234Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.Apr 25, 2018 · N922PA · Substantial damageNTSB GAA18CA227Accident · No injuriesData collectionFinal reportIrvin Stephen D Rutan Long E Z · Tucson, AZThe pilot’s excessive ground speed and loss of directional control while exiting the taxiway.Apr 22, 2018 · N8714S · Substantial damageNTSB WPR18FA119Accident · 6 fatalField investigationFinal reportPiper PA 24-260 · Scottsdale, AZThe flight instructor's failure to maintain airplane control during the initial climb as a result of the airplane being loaded above its maximum gross weight and beyond its aft center of gravity limits. Contributing to the accident was a degraded engine power…Apr 10, 2018 · N9456P · DestroyedNTSB GAA18CA193Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe student pilot’s improper selection of the flap setting during a go-around, and the flight instructor’s delayed remedial action, which resulted in an aerodynamic stall.Apr 1, 2018 · N297PA · Substantial damageNTSB GAA18CA189Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Gila Bend, AZThe pilot’s failure to properly set the parking brake, which resulted in an impact with a pole.Mar 30, 2018 · N53SL · Substantial damageNTSB WPR18MA087Accident · 5 fatalClass 3 · MajorFinal reportEurocopter EC130 · Peach Springs, AZA loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain during an approach to land in gusting, tailwind conditions in an area of potential downdrafts and turbulence.Feb 11, 2018 · N155GC · DestroyedNTSB WPR18LA071Accident · Serious injuriesClass 3 · LimitedFinal reportSix Chuter Spirit · Marana, AZThe noncertificated pilots’ failure to maintain an adequate visual lookout, which resulted in a midair collision.Jan 19, 2018 · UNREG · 2 aircraft · Substantial damageNTSB GAA18CA109Accident · No injuriesData collectionFinal reportBeech B60 · Scottsdale, AZThe pilot’s improper brake application during landing, which resulted in a tire blowout and a loss of directional control.Jan 16, 2018 · CFESG · Substantial damageNTSB WPR18LA044Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-200T · Glendale, AZThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the fatigue of the left main landing gear assembly.Dec 5, 2017 · N47536 · Substantial damageNTSB WPR18LA037Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC41 550FG · Oro Valley, AZThe inadequate cooling time between repeated heavy braking applications, which resulted in the brakes overheating and a subsequent brake fire during the aborted takeoff sequence.Nov 27, 2017 · N2526C · Substantial damageNTSB GAA18CA059Accident · No injuriesData collectionFinal reportMooney M20 · Tucson, AZThe pilot’s inadequate preflight and in-flight fuel management, which resulted in an intermittent loss of engine power due to fuel starvation.Nov 26, 2017 · N6002Q · Substantial damage