NTSB investigations, 2013, AZ

6 cases where the sequence of events included Collision during takeoff/land.

Cases per year

20092026
NTSB investigations, 2013, AZ per year, 2009–2026: 44 cases
20093
20102
20111
20121
20136
20141
20153
20161
20171
20184
20192
20202
20216
20224
20232
20242
20251
20262

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\") = 2013
    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\" = '490' 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 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 WPR13CA424Accident · Minor injuriesData collectionFinal reportRobinson R44 - II · Flagstaff, AZThe pilot's failure to maintain rotor rpm while landing in a gusty wind at a high density altitude.Sep 25, 2013 · N190SH · Substantial damageNTSB WPR13CA330Accident · Serious injuriesData collectionFinal reportKincaid Wade Dakota Hawk · San Simon, AZThe pilot's failure to maintain clearance from power lines during takeoff from an open field.Jul 14, 2013 · N544WK · Substantial damageNTSB WPR13FA244Accident · 2 fatalField investigationFinal reportRaytheon A36 · Mountainaire, AZThe pilot's inability to maintain a climb after departure in high-density altitude conditions, which resulted in a collision with trees and terrain. Contributing to the accident were the pilot's decision not to track the four-lane highway just beyond the…May 28, 2013 · N999PK · DestroyedNTSB WPR13LA134Accident · No injuriesLimited investigationFinal reportBlumer Challenger II Spec · Peoria, AZA cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach.Feb 26, 2013 · N107BW · Substantial damageNTSB WPR13LA135Accident · Serious injuriesLimited investigationFinal reportSummit II · Quartzsite, AZThe noncertificated pilot’s failure to maintain aircraft control after encountering shifting wind, which resulted in collision with a windsock.Feb 25, 2013 · N8028X · Substantial damage