Skip to content

NTSB investigations, AZ

16 cases where the defining event was Collision with terr/obj (non-CFIT).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
  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.

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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportBrunner Donald G Kitfox · Rock Crossing, AZAn encounter with a downdraft while maneuvering at a low altitude, which resulted in an impact with terrain.Mar 10, 2026 · N104DG · Substantial damage NTSB WPR26LA118Accident · Minor injuriesClass 4 · LimitedFinal reportLindstrand 260A · Casa Grande, AZThe hot air balloon’s encounter with downdraft wind conditions in mountainous terrain and subsequent impact with terrain.Mar 2, 2026 · N261RR · Substantial damage NTSB WPR26FA097Accident · 1 fatalClass 3 · FieldPreliminary reportSocata TB21 · Prescott, AZOn February 4, 2026, about 1950 mountain standard time, a Socata TB21, N967WM, was destroyed when it was involved in an accident near Prescott, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…Feb 5, 2026 · N967WM · Destroyed NTSB WPR26LA077Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150A · Coolidge, AZThe pilot's failure to maintain clearance from transmission wires. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.Jan 5, 2026 · N7235X · Substantial damage NTSB WPR26FA074Accident · 4 fatalClass 3 · FieldPreliminary reportMD Helicopters 369FF · Superior, AZOn January 2, 2026, at about 1100 mountain standard time, an MD Helicopters MD369FF helicopter, N3502P, was substantially damaged when it impacted a highline/slackline near Superior, Arizona. The pilot and three passengers were fatally injured. The helicopter…Jan 2, 2026 · N3502P · Substantial damage NTSB WPR26LA025Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Queen Creek, AZThe pilot’s improper runway alignment and failure to maintain clearance from powerlines. Contributing to the accident was sun glare, which obscured the pilot’s view of the runway.Oct 20, 2025 · N699PG · Substantial damage NTSB WPR26LA002Incident · No injuriesClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0958 mountain standard time, an Amazon.Com Services LLC, MK30, N791PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…Oct 1, 2025 · N791PA · Substantial damage NTSB WPR26LA001IncidentClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0949 mountain standard time, an Amazon.Com Services LLC, MK30, N579PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…Oct 1, 2025 · N579PA · Substantial damage NTSB WPR25LA123Accident · No injuriesClass 4 · LimitedFinal reportPark Roderic B Kitfox IV · Marana, AZThe pilot’s failure to maintain clearance from an obstacle while performing an off-airport landing.Mar 29, 2025 · N70265 · Substantial damage NTSB WPR25LA008Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-36-285 · Marana, AZOn October 8, 2024, about 0745 mountain standard time, a Piper PA-36-285, N9928P, was substantially damaged when it was involved in an accident near Marana, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Oct 8, 2024 · N9928P · Substantial damage NTSB DCA23LA290AccidentClass 4 · LimitedFinal reportGeneral Atomics MQ-9 Block 1 · Elgin, AZThe pilot’s loss of situational awareness, resulting in the UAS’s controlled flight into terrain.May 15, 2023 · N31EJ · Destroyed NTSB WPR22LA107Accident · No injuriesClass 4 · LimitedFinal reportRoss Jonathan RV-8 · Pinon, AZThe pilot's failure to maintain clearance from power lines during low-level flight.Feb 24, 2022 · N207RV · Substantial damage NTSB WPR21LA191Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic S A N-500 · Phoenix, AZThe pilot’s inability to maintain control after the balloon's encounter with an unexpected wind gust, which resulted in a collision with a tree.May 2, 2021 · N500UM · Minor damage NTSB WPR20FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Goodyear, AZThe pilot’s failure to maintain clearance from power lines due to his impairment from cannabis.Dec 22, 2019 · N3371U · Substantial damage NTSB LAX08CA199Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot's inadequate recovery from a bounced landing and failure to maintain directional control.Jun 25, 2008 · N4144P · Substantial damage NTSB SEA08LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe student pilot's delay in initiating the go-around, and the flight instructor's inadequate supervision of the flight and delayed remedial action. Contributing to the accident were the momentary failure of the engine to respond, the failure of both the…Mar 3, 2008 · N8400A · Substantial damage