Fatal NTSB investigations, AZ

10 cases where the sequence of events included Unknown or undetermined.

Cases per year

20082026
Fatal NTSB investigations, AZ per year, 2008–2026: 10 cases
20081
20141
20161
20181
20222
20241
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 c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' 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 WPR26FA301Accident · 2 fatalClass 3 · FieldPreliminary reportNew Glasair Sportsman 2 Plus 2 · Pine, AZOn August 10, 2026, at about 1835 mountain daylight time, an experimental amateur built Glasair Sportsman 2 Plus 2 airplane, N202AZ, was destroyed when it was involved in an accident near Pine, Arizona. The pilot and passenger were fatally injured. The…Aug 11, 2026 · N202AZ · DestroyedNTSB WPR26FA098Accident · 2 fatalClass 3 · FieldPreliminary reportBell 407 · Flagstaff, AZOn February 4, 2026, at 2216 mountain standard time, a Bell 407 helicopter, N56AZ, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and tactical flight officer (TFO) were fatally injured. The helicopter was…Feb 5, 2026 · N56AZ · DestroyedNTSB CEN25FA212Accident · 2 fatalClass 3 · FieldPreliminary reportCessna A150L · Three Points, AZOn June 18, 2025, about 0922 mountain standard time, a Cessna A150L airplane, N6436F, was substantially damaged when it was involved in an accident near Three Points, Arizona. The student pilot and flight instructor were fatally injured. The airplane was…Jun 18, 2025 · N6436F · Substantial damageNTSB WPR25FA031Accident · 5 fatalClass 3 · FieldPreliminary reportHonda HA420 · Mesa, AZOn November 5, 2024, at 1639 mountain daylight time, a Honda HA-420, N57HP, was destroyed when it was involved in an accident near Mesa, AZ. The pilot and three passengers were fatally injured, one passenger was seriously injured, and the single occupant of…Nov 5, 2024 · N57HP · DestroyedNTSB WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…Sep 16, 2022 · N646RV · DestroyedNTSB WPR22FA215Accident · 2 fatalClass 3 · FieldFinal reportBeech E35 · Buckeye, AZThe pilots’ failure to climb and complete a normal traffic pattern after making a low approach and their failure to extend the flaps for reasons that could not be determined, and the flight instructor’s failure to ensure adequate airspeed and bank control…Jun 18, 2022 · N13AR · DestroyedNTSB WPR18FA228Accident · 2 fatalClass 3 · FieldFinal reportPietenpol Aircamper · Camp Verde, AZLoss of control for reasons that could not be determined because postaccident examination of the airframe and engine revealed no mechanical anomalies that would have precluded normal operation.Aug 18, 2018 · N88HK · Substantial damageNTSB WPR16FA158Accident · 1 fatalField investigationFinal reportPiper PA 34-200T · Flagstaff, AZA departure flight path that consisted of several unexplained turns during the initial climbout, and terminated in a high-speed descent and ground impact. The reason(s) for the turns and descent could not be determined due to lack of definitive evidence.Aug 3, 2016 · N82806 · DestroyedNTSB WPR15LA048Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Somerton, AZA loss of airplane control for reasons that could not be determined based on available evidence.Nov 30, 2014 · N946TR · DestroyedNTSB SEA08LA137Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Tolani Lake, AZAn in-flight collision with terrain for undetermined reasons.May 25, 2008 · N6290F · Substantial damage