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 WPR12LA444Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot's inadequate flare and compensation for gusting wind conditions, which resulted in a bounced landing.Apr 26, 2012 · N320ME · Substantial damageNTSB WPR12CA175Accident · No injuriesData collectionFinal reportLuscombe 8E · Winslow, AZThe pilot did not maintain directional control during the landing roll.Apr 16, 2012 · N25E · Substantial damageNTSB WPR12CA171Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's inadequate compensation for a crosswind during takeoff, which resulted in a loss of directional control.Apr 12, 2012 · N17304 · Substantial damageNTSB WPR12CA151Accident · No injuriesData collectionFinal reportLake LA-4-200 · Lake Havasu City, AZThe pilot did not maintain directional control during a water touchdown.Apr 1, 2012 · N32LB · Substantial damageNTSB WPR12CA150Accident · No injuriesData collectionFinal reportArado-Flugzeugwerke FW190 A-5 · Casa Grande, AZThe pilot did not maintain directional control of the airplane during the landing roll.Mar 30, 2012 · N190DK · Substantial damageNTSB WPR12LA135Accident · Minor injuriesLimited investigationFinal reportCook Smith AVN Replica SU · St. Johns, AZThe pilots’ failure to maintain directional control when the right brake locked up during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Mar 13, 2012 · N712AZ · Substantial damageNTSB WPR12LA076Accident · No injuriesLimited investigationFinal reportPiper PA28 · Phoenix, AZThe pilot’s inability to maintain directional control during the landing roll for reasons that could not be determined because impact damage precluded determination of the preaccident functionality of the braking and steering systems.Jan 6, 2012 · N4175V · Substantial damageNTSB WPR12LA074Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic WT9 · Glendale, AZThe pilot did not shut down the engine upon recognizing a brake malfunction. Contributing to the accident was the airplane's brake malfunction for undetermined reasons.Jan 6, 2012 · N247DY · Substantial damageNTSB WPR12CA038Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student pilot's inadequate directional control during takeoff.Nov 12, 2011 · N24350 · Substantial damageNTSB WPR12CA033Accident · No injuriesData collectionFinal reportCasler Scott CX-4 · San Carlos, AZThe pilot's inadequate directional control during takeoff.Nov 9, 2011 · N5089Q · Substantial damageNTSB WPR11CA466Accident · Minor injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe pilot’s failure to maintain directional control during the landing rollout.Sep 26, 2011 · N169ME · Substantial damageNTSB WPR11LA444Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Show Low, AZThe pilot’s failure to maintain directional control during the landing, which resulted in a ground loop.Sep 10, 2011 · N40625 · Substantial damageNTSB WPR11CA440Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll.Sep 8, 2011 · N5275S · Substantial damageNTSB WPR11CA446Accident · No injuriesData collectionFinal reportCessna 182A · Prescott, AZThe pilot's failure to maintain directional control while taxiing.Aug 20, 2011 · N3723D · Substantial damageNTSB WPR11CA328Accident · No injuriesData collectionFinal reportTaylorcraft F-22 · Payson, AZThe pilot's selection of a wrong runway to practice touch-and-go takeoffs and landings.Jul 14, 2011 · N191TC · Substantial damageNTSB WPR11CA312Accident · No injuriesData collectionFinal reportCessna 150G · Mesa, AZThe pilot's failure to maintain directional control during the go around.Jul 6, 2011 · N2878S · Substantial damageNTSB WPR11CA301Accident · No injuriesData collectionFinal reportCessna A185F · Page, AZThe pilot's decision to take off with a gusty quartering tailwind.Jun 30, 2011 · N80293 · Substantial damageNTSB WPR11CA264Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the helicopter during taxi, resulting in a loss of tail rotor effectiveness and a subsequent hard landing.Jun 18, 2011 · N334DC · Substantial damageNTSB WPR11CA237Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Sedona, AZThe pilot's failure to maintain directional control on the landing roll out. Contributing to the accident was the pilot's decision to attempt a landing in crosswind conditions that exceeded the maximum demonstrated capability of the airplane.May 26, 2011 · N7792P · Substantial damageNTSB WPR11CA224Accident · No injuriesData collectionFinal reportMaule M7 · Mammoth, AZThe pilot's failure to maintain clearance from a tree during the landing roll.May 16, 2011 · N1048T · Substantial damageNTSB WPR11CA219Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Scottsdale, AZThe pilot's failure to maintain directional control during the takeoff roll.May 8, 2011 · N636EV · Substantial damageNTSB WPR11LA211Accident · No injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's inadequate directional control during the landing roll.Apr 27, 2011 · N4072F · Substantial damageNTSB WPR11CA212Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZThe pilot’s failure to maintain directional control during the landing roll.Apr 27, 2011 · N9683P · Substantial damageNTSB WPR11CA178Accident · No injuriesData collectionFinal reportCirrus SR22 · Winslow, AZThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.Mar 31, 2011 · N957CD · Substantial damageNTSB WPR11CA162Accident · No injuriesData collectionFinal reportCessna 180 · Pine, AZThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with terrain.Mar 10, 2011 · N9330C · Substantial damageNTSB WPR11CA106Accident · No injuriesData collectionFinal reportCessna 180 · Prescott, AZThe pilot's loss of airplane control during the landing roll.Jan 25, 2011 · N2229C · Substantial damageNTSB WPR11FA093Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Phoenix, AZThe pilot did not maintain directional control during the landing roll. Contributing to the accident was low nosewheel tire pressure.Jan 9, 2011 · N5365D · Substantial damageNTSB WPR11CA097Accident · No injuriesData collectionFinal reportCessna 180 · Flagstaff, AZThe pilot's failure to maintain directional control during landing that resulted in a ground loop.Dec 31, 2010 · N67F · Substantial damageNTSB WPR11LA044Accident · No injuriesLimited investigationFinal reportPiper PA30 · Tucson, AZThe pilot's impairment by an undiagnosed medical condition, which resulted in a loss of directional control and subsequent collision with a building during the landing roll. Contributing to the accident was the pilot's decision to fly when he was not feeling…Nov 10, 2010 · N628R · Substantial damageNTSB WPR11CA033Accident · No injuriesData collectionFinal reportMedway Raven · Benson, AZThe pilot's inadequate evaluation of the runway condition and failure to maintain directional control during takeoff.Oct 27, 2010 · N75784 · Substantial damageNTSB WPR10CA471Accident · No injuriesData collectionFinal reportCessna 195 · Prescott, AZThe pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion.Sep 26, 2010 · N1558D · Substantial damageNTSB WPR10CA342Accident · No injuriesData collectionFinal reportPiper PA32RT · Sedona, AZThe pilot’s failure to maintain runway alignment during approach and subsequent loss of directional control during landing.Jul 10, 2010 · N36402 · Substantial damageNTSB WPR10LA312Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Parker, AZThe pilot's failure to maintain directional control while landing with a crosswind.Jun 23, 2010 · N432PB · Substantial damageNTSB WPR10CA282Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Chandler, AZThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.May 31, 2010 · N6075L · Substantial damageNTSB WPR10CA177Accident · No injuriesData collectionFinal reportCessna 170 · Kingman, AZThe pilot’s failure to maintain directional control during landing rollout. Contributing to the accident was flight control interference by the passenger.Mar 24, 2010 · N4200V · Substantial damageNTSB WPR10CA170Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Phoenix, AZThe student pilot's inadequate compensation for the quartering tailwind during landing and the flight instructor's delay in taking remedial action.Mar 18, 2010 · N8830D · Substantial damageNTSB WPR10CA143Accident · No injuriesData collectionFinal reportNorth American AT-6C · Mesa, AZThe pilot's inadequate compensation for the crosswind and failure to maintain directional control of the airplane during landing.Feb 20, 2010 · N76BZ · Substantial damageNTSB WPR10CA064Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe pilot's failure to maintain control of the helicopter.Nov 23, 2009 · N177PA · Substantial damageNTSB WPR10CA061Accident · Minor injuriesData collectionFinal reportBoeing A75N1 · Deer Valley, AZThe pilot's failure to maintain directional control.Nov 21, 2009 · N56099 · Substantial damageNTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.Oct 24, 2009 · N83281 · Substantial damageNTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.Oct 10, 2009 · N51302 · Substantial damageNTSB WPR10LA004Accident · No injuriesLimited investigationFinal reportCessna 172A · Payson, AZThe stress corrosion cracking of the nose gear landing fork, which resulted in the fork's failure during landing.Oct 3, 2009 · N7810T · Substantial damageNTSB WPR09CA410Accident · No injuriesData collectionFinal reportPiper PA28 · Glendale, AZThe student pilot's failure to maintain directional control during the landing roll.Aug 21, 2009 · N424PA · Substantial damageNTSB WPR09CA406Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.Aug 19, 2009 · N4177L · Substantial damageNTSB WPR09CA257Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control on the landing roll out.May 20, 2009 · N1591A · Substantial damageNTSB WPR09CA266Accident · No injuriesData collectionFinal reportCessna 172S · Flagstaff, AZThe student pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control during landing.May 17, 2009 · N541ER · Substantial damageNTSB WPR09CA265Accident · No injuriesData collectionFinal reportBoeing E75 · Cottonwood, AZThe pilot's inadequate compensation for the crosswinds during the landing roll.May 17, 2009 · N4787V · Substantial damageNTSB WPR09CA210Accident · No injuriesData collectionFinal reportCessna 172E · Tucson, AZThe pilot’s inadequate compensation for the gusting crosswinds.Apr 22, 2009 · N3880S · 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 WPR09CA127Accident · No injuriesData collectionFinal reportCub Crafters PA-18-150 · Buckeye, AZThe pilot's failure to maintain directional control.Feb 23, 2009 · N324A · Substantial damage