NTSB investigations, AZ

212 cases where the sequence of events included Loss of control on ground.

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\" = '230' 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 GAA17CA516Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 NG · Goodyear, AZThe student pilot’s improper landing flare and subsequent failure to maintain directional control during the landing roll.Sep 2, 2017 · N910XD · Substantial damageNTSB GAA17CA487Accident · No injuriesData collectionFinal reportPiper PA28 · Chandler, AZThe student pilot's failure to maintain directional control during landing.Aug 14, 2017 · N915PA · Substantial damageNTSB WPR17LA141Accident · No injuriesLimited investigationFinal reportVickers Supermaine Ltd · Marana, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.Jul 4, 2017 · N5TF · Substantial damageNTSB GAA17CA380Accident · No injuriesData collectionFinal reportCessna 172 · Tucson, AZThe pilot’s failure to maintain pitch and yaw control during the landing roll in crosswind conditions.Jul 2, 2017 · N4482L · Substantial damageNTSB GAA17CA292Accident · Minor injuriesData collectionFinal reportAirtime Cygnet · Casa Grande, AZThe flight instructor's failure to maintain directional control during takeoff in gusting crosswind conditions.May 21, 2017 · N168AT · Substantial damageNTSB GAA17CA290Accident · No injuriesData collectionFinal reportCessna 190 · Prescott, AZThe pilot’s use of excessive speed during a right turn from the runway to the taxiway, which resulted in a loss of directional control.May 4, 2017 · N4498C · Substantial damageNTSB GAA17CA214Accident · Minor injuriesData collectionFinal reportRonald J Bender Baking Duce · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll after encountering a dirt devil.Apr 1, 2017 · N9898R · Substantial damageNTSB WPR17LA030Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Scottsdale, AZThe pilot’s loss of directional control during the landing roll, which resulted in the runway excursion onto the rock-covered runway safety area.Dec 1, 2016 · N9175N · Substantial damageNTSB GAA16CA461Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Sedona, AZThe pilot’s failure to maintain directional control during the landing in gusting wind conditions, which resulted in a runway excursion.Aug 30, 2016 · N114LC · Substantial damageNTSB GAA16CA404Accident · No injuriesData collectionFinal reportCessna 177 · Wickenburg, AZThe pilot's incorrect balked landing procedure, which resulted in an uncontrolled descent, hard landing, a runway excursion, and nose gear collapse.Jul 29, 2016 · N34867 · Substantial damageNTSB GAA16CA318Accident · No injuriesData collectionFinal reportEurocopter EC120 · Ajo, AZThe pilot's decision to exit the helicopter with the engine and rotors turning and the selection of unsuitable terrain for a landing, which resulted in a roll over.Jun 13, 2016 · N372HS · Substantial damageNTSB GAA16CA190Accident · No injuriesData collectionFinal reportMonocoupe 110 · Chandler, AZThe pilot's incorrect installation of the tailwheel steering bungee, which resulted in a runway excursion and airplane nose over.Apr 12, 2016 · N501W · Substantial damageNTSB GAA16CA152Accident · No injuriesData collectionFinal reportCessna 140 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a ground loop, and a collision with an airport sign.Mar 13, 2016 · N89939 · Substantial damageNTSB GAA16CA079Accident · No injuriesData collectionFinal reportMcmichael Elmer L Lancair 360 · Rimrock, AZThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and a left main landing gear collapse.Dec 13, 2015 · N113LM · Substantial damageNTSB GAA16CA043Accident · No injuriesData collectionFinal reportCessna 182 · Douglas Bisbee, AZThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion, left main landing gear collapse, and a collision with terrain.Nov 2, 2015 · N1706R · Substantial damageNTSB GAA16CA035Accident · No injuriesData collectionFinal reportBrandon Evans Gyroplane · Buckeye, AZThe student pilot's incorrect control input during takeoff which resulted in a runaway excursion and impact with terrain.Oct 24, 2015 · N166BE · Substantial damageNTSB GAA15CA271Accident · No injuriesData collectionFinal reportCessna 305A · Show Low, AZThe pilot's failure to maintain directional control during landing in quartering tailwind conditions, which resulted in a runway excursion and a right main landing gear collapse.Sep 23, 2015 · N5207G · Substantial damageNTSB GAA15CA249Accident · No injuriesData collectionFinal reportStinson L 5E · Tucson, AZThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and a collision with an object.Aug 20, 2015 · N944LB · Substantial damageNTSB GAA15LA225Accident · Serious injuriesLimited investigationFinal reportUltramagic N250 - NO Series · Peoria, AZThe pilot's failure to ensure that the passengers remained secure in the basket during deflation after landing, which resulted in a passenger falling out of the basket and sustaining a serious injury when a wind gust caught the envelope and tipped the basket…Jul 31, 2015 · N57EX · No damageNTSB WPR15LA132Accident · No injuriesLimited investigationFinal reportBeech B23 · Flagstaff, AZThe pilot's failure to maintain directional control during landing.Mar 22, 2015 · N7628R · Substantial damageNTSB WPR15CA078Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Sedona, AZThe pilot's loss of directional control during the landing roll.Jan 4, 2015 · N3811M · Substantial damageNTSB WPR15CA018Accident · No injuriesData collectionFinal reportCessna 172 - R · Lake Havasu, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with terrain.Oct 23, 2014 · N1590W · Substantial damageNTSB WPR15CA004Accident · Minor injuriesData collectionFinal reportCessna 172S · Sedona, AZThe pilot's failure to maintain airplane control during the landing roll out.Oct 5, 2014 · N2179L · Substantial damageNTSB WPR14CA390Accident · No injuriesData collectionFinal reportWilliam M Oprendek Pitts S1S · Sedona, AZFailure of the tailwheel steering assembly during maneuvering flight, which resulted in a loss of directional control during the landing roll.Sep 25, 2014 · N93DB · Substantial damageNTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.Jul 21, 2014 · N3997Z · Substantial damageNTSB WPR14CA289Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll.Jul 11, 2014 · N83447 · Substantial damageNTSB WPR14CA224Accident · No injuriesData collectionFinal reportMeyers MAC 145 · La Cholla, AZThe pilot's overcorrection to a wind gust, which resulted in a loss of directional control and runway veeroff.May 29, 2014 · N34374 · Substantial damageNTSB WPR14FA195Accident · 1 fatalField investigationFinal reportAmerican Eurocopter AS350B3 · Peach Springs, AZThe pilot’s decision to exit the helicopter while it was running and his failure to properly secure the flight controls with the engine operating at flight idle before exiting the helicopter.May 18, 2014 · N840PA · Substantial damageNTSB WPR14CA202Accident · No injuriesData collectionFinal reportPiper J3C 65 · Tucson, AZThe pilot's failure to maintain directional control during the landing roll.May 16, 2014 · N92090 · Substantial damageNTSB WPR14CA151Accident · No injuriesData collectionFinal reportAviat A 1B · Eloy, AZThe pilot's failure to maintain directional control during takeoff.Mar 29, 2014 · N33HY · Substantial damageNTSB WPR14CA140Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Coolidge, AZThe pilot's failure to maintain directional control during landing.Mar 20, 2014 · N4106G · Substantial damageNTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.Feb 15, 2014 · N738BH · Substantial damageNTSB WPR14CA090Accident · No injuriesData collectionFinal reportCessna 140 · Marana, AZThe pilot did not maintain directional control during the landing roll out when the right brake did not release completely after he applied, then released brake pressure, which resulted in a ground loop. Contributing to the accident was the taxi speed.Jan 4, 2014 · N76463 · Substantial damageNTSB WPR14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Carefree, AZThe failure of the left brake master cylinder seal, which rendered the left brake inoperative during landing.Nov 7, 2013 · N60TM · Substantial damageNTSB WPR14CA021Accident · No injuriesData collectionFinal reportPiper PA28 - 160 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collison with a runway sign.Oct 19, 2013 · N5184W · Substantial damageNTSB WPR14CA015Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Rio Verde, AZThe pilot's failure to maintain directional control during the takeoff roll on a rough and rutted surface.Oct 12, 2013 · N40WY · Substantial damageNTSB WPR13LA351Accident · Minor injuriesLimited investigationFinal reportStribling RV4 · San Manuel, AZThe pilot’s loss of directional control during takeoff with a tailwind, which resulted in a runway excursion.Jul 31, 2013 · N70AC · Substantial damageNTSB WPR13LA237Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chandler, AZThe failure of the alternator and/or battery, which prevented the operation of the landing gear extension system and resulted in the nose landing gear collapsing during the landing roll.May 19, 2013 · N8197W · Substantial damageNTSB WPR13CA202Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Mesa, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Apr 19, 2013 · N924JS · Substantial damageNTSB WPR13LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Phoenix, AZThe student pilot's excessive directional control inputs during the takeoff roll and the flight instructor's delayed and ineffective corrective actions, which resulted in the loss of airplane control.Apr 4, 2013 · N2166K · Substantial damageNTSB WPR13CA162Accident · No injuriesData collectionFinal reportBoeing B75N1 · Mesa, AZThe pilot’s failure to maintain directional control during the landing roll.Mar 19, 2013 · N47964 · Substantial damageNTSB WPR12CA438Accident · No injuriesData collectionFinal reportCessna 150 · St Johns, AZThe pilot's failure to maintain directional control during landing in gusty crosswind conditions.Sep 25, 2012 · N5892E · Substantial damageNTSB WPR12CA412Accident · No injuriesData collectionFinal reportGrob-Werke G 120A · Mobile, AZThe student pilot’s failure to maintain directional control of the airplane during the takeoff roll and the subsequent aborted takeoff in a gusting crosswind.Sep 10, 2012 · N863AF · Substantial damageNTSB WPR12CA372Accident · No injuriesData collectionFinal reportBoeing B75N1 · Mesa, AZThe pilot's failure to maintain directional control while landing in a crosswind.Aug 18, 2012 · N47964 · Substantial damageNTSB WPR12CA287Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Paulden, AZThe pilot’s failure to maintain directional control during the landing roll.Jun 27, 2012 · N43087 · Substantial damageNTSB WPR12IA296Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Deer Valley, AZThe pilot's failure to maintain directional control during taxi due to excessive taxi speed.Jun 17, 2012 · N552PG · Minor damageNTSB WPR12CA232Accident · No injuriesData collectionFinal reportCessna 172S · Page, AZThe pilot's failure to maintain directional control during the landing flare.May 27, 2012 · N21718 · Substantial damageNTSB WPR12LA211Accident · No injuriesLimited investigationFinal reportBeech F33A · Mobile, AZThe student pilot's failure to maintain directional control during takeoff.May 13, 2012 · N5521A · Substantial damageNTSB WPR12CA196Accident · No injuriesData collectionFinal reportCessna 195 · Heber-Overgaard, AZThe pilot's loss of directional control during takeoff roll upon encountering a wind gust.May 5, 2012 · N3442V · Substantial damageNTSB WPR12CA187Accident · No injuriesData collectionFinal reportGlass Roy L RV-6 · Coolidge, AZThe pilot’s loss of directional control during landing.Apr 27, 2012 · N164RG · Substantial damage