NTSB investigations, 2017, AZ

7 cases where the sequence of events included Attempted remediation/recovery.

Cases per year

20082026
NTSB investigations, 2017, AZ per year, 2008–2026: 58 cases
20082
20092
20102
20111
20121
20133
20142
20154
20161
20177
201813
20197
20203
20211
20221
20232
20244
20252

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\" = '060' 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 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 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 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 GAA17CA370Accident · Minor injuriesData collectionFinal reportAero-Ace CE 1 · Cottonwood, AZThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Jun 26, 2017 · N473CQ · Substantial damageNTSB WPR17LA144Accident · No injuriesLimited investigationFinal reportCessna U206F · Page, AZThe failure of the throttle control cable due to fatigue and maintenance personnel’s failure to replace the cable at the last engine overhaul, which resulted in the pilots’ inability to control engine power and led to a precautionary landing during which the…Jun 23, 2017 · N71001 · Substantial damageNTSB GAA17CA108Accident · No injuriesData collectionFinal reportLarson Roger H RV-7 · Casa Grande, AZThe pilot’s inadvertent application of the autopilot during short final, which resulted in an aerodynamic stall and hard landing.Jan 1, 2017 · N5897R · Substantial damage