NTSB investigations, 2017, AZ

10 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2017, AZ per year, 2008–2026: 151 cases
20087
200911
20109
201116
201210
20138
20148
201513
20168
201710
201815
20199
20207
20212
20226
20243
20255
20264

Latest cases

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 year(c.\"eventDate\") = 2017
    AND 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 GAA18CA091Accident · No injuriesData collectionFinal reportAviat A-1 · Phoenix, AZThe pilot’s failure to maintain directional control of the airplane during the landing.Dec 19, 2017 · N33HY · Substantial damageNTSB GAA18CA056Accident · No injuriesData collectionFinal reportBuehlmann Peter Kitfox Model 4 1200 · Overgaard, AZThe pilot’s failure to maintain directional control during the landing roll.Nov 23, 2017 · N234PB · Substantial damageNTSB GAA18CA049Accident · Minor injuriesData collectionFinal reportJohn Roscoe Autogyro Cavalon · Casa Grande, AZThe pilot’s improper landing flare, which resulted in loss of directional control and a subsequent runway excursion.Nov 19, 2017 · N953LS · DestroyedNTSB 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 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 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 GAA17CA166Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe flight instructor’s incorrect control inputs while taking off with a known quartering tailwind, which resulted in a loss of directional control and runway excursion.Feb 27, 2017 · N309PA · Substantial damageNTSB GAA17CA126Accident · No injuriesData collectionFinal reportPiper PA32R · Fort Mohave, AZThe pilot's failure to extend the landing gear for landing.Jan 26, 2017 · N6885F · Substantial damageNTSB WPR17LA053Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Buckeye, AZThe pilot's failure to maintain directional control of the airplane during the landing roll.Jan 14, 2017 · N6366B · Substantial damage