NTSB investigations, AZ

151 cases where the sequence of events included Runway excursion.

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\" = '300' 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 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 WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.Jul 28, 2012 · N8100B · Substantial damageNTSB WPR12FA326Accident · 3 fatalField investigationFinal reportBeech B60 · Sedona, AZThe airplane’s failure to rotate and the pilot’s failure to reject the takeoff, which resulted in a runway overrun for reasons that could not be undetermined because postaccident examination of the airplane and engines did not reveal any malfunctions or…Jul 26, 2012 · N880LY · DestroyedNTSB WPR12FA297Accident · Serious injuriesField investigationFinal reportMooney M20L · Scottsdale, AZThe pilot's failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action. Contributing to the accident were the pilot’s improper landing flare, which resulted in a bounced landing, and his premature flap…Jul 9, 2012 · N137MP · Substantial damageNTSB WPR12LA247Accident · No injuriesLimited investigationFinal reportPiper PA28R · Peoria, AZA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 29, 2012 · N963WW · 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 WPR12LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · San Manuel, AZThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.Apr 13, 2012 · N3583K · 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 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 WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.Jul 27, 2011 · N671T · 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 WPR11LA313Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Flagstaff, AZFatigue failure of an engine mount attachment foot, which resulted in collapse of the nose landing gear during landing. Contributing to the accident was the failure of the owner/operator to adhere to the manufacturer's suggested engine mount inspection…Jun 26, 2011 · N9246M · 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 WPR11FA236Accident · Serious injuriesField investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Sedona, AZThe pilots’ unstabilized approach and excessive airspeed during approach, which resulted in an insufficient landing distance to stop the airplane before overrunning the runway.May 25, 2011 · N224MD · 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 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 WPR11CA124Accident · No injuriesData collectionFinal reportCessna 182D · Quartzsite, AZThe pilot's inadequate compensation for the wind and subsequent loss of directional control, which resulted in a runway excursion and collision with a parked aircraft.Feb 6, 2011 · N8859X · 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 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 WPR11CA026Accident · No injuriesData collectionFinal reportCessna 340A · Camp Verde, AZThe pilot's misjudged approach and failure to attain the correct touchdown point, which resulted in a runway overrun.Oct 23, 2010 · N630PL · Substantial damageNTSB WPR11CA024Accident · No injuriesData collectionFinal reportCessna 185 · Fort Thomas, AZThe airplane's encounter with a dust devil during landing rollout, which resulted in the pilot not being able to maintain directional control.Oct 22, 2010 · N5011X · 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 WPR10LA413Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZAn increase in engine rpm and vibration, which resulted in an aborted takeoff and runway excursion. The reason for the increased engine rpm and vibration could not be determined because of postaccident fire damage.Aug 19, 2010 · N6607Q · 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 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 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 WPR10CA081Accident · No injuriesData collectionFinal reportCessna 182P · Payson, AZThe pilot's improper landing flare, which resulted in a hard landing.Dec 11, 2009 · N11PG · 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 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 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 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 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 WPR09CA054Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe failure of the student pilot to maintain directional control during takeoff.Dec 5, 2008 · N268ML · Substantial damageNTSB WPR09LA029Accident · No injuriesLimited investigationFinal reportCessna 421C · Mesa, AZThe failure of the hydraulic landing gear extension systems due to a ruptured line.Oct 30, 2008 · N421PC · Substantial damageNTSB SEA08CA189Accident · No injuriesData collectionFinal reportAeros Venture · Maricopa, AZThe pilot's selection of unsuitable terrain for a precautionary landing and subsequent takeoff attempt, and his misjudging of the required takeoff distance. The soft terrain was a factor.Aug 17, 2008 · N707TN · 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 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 damage