# NTSB investigations, AZ: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 12 · 572 cases

## Latest cases

- [NTSB WPR26LA331](https://openairdocs.org/ntsb/WPR26LA331.md): Filip Richard/Fakowee Avia Indus Thrp T211 SP E · Benson, AZ · Accident · Serious injuries · Class 4 · Limited · Investigation open · Sep 6, 2026 · N211RJ · Substantial damage
- [NTSB WPR26FA097](https://openairdocs.org/ntsb/WPR26FA097.md): Socata TB21 · Prescott, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 5, 2026 · N967WM · Destroyed
  > On 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…
- [NTSB WPR26LA045](https://openairdocs.org/ntsb/WPR26LA045.md): Piper PA-28-181 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 17, 2025 · N4402N · Substantial damage
  > On November 17, 2025, about 0830 mountain standard time, a Piper PA 28-181, N4402N, was substantially damaged when it was involved in an accident near Mesa, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…
- [NTSB WPR26LA025](https://openairdocs.org/ntsb/WPR26LA025.md): Piper PA 46-350P · Queen Creek, AZ · Accident · No injuries · Class 4 · Limited · Final report · Oct 20, 2025 · N699PG · Substantial damage
  > The 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.
- [NTSB WPR25FA240](https://openairdocs.org/ntsb/WPR25FA240.md): Beech 300 · Chinle, AZ · Accident · 4 fatal · Class 3 · Field · Preliminary report · Aug 5, 2025 · N534AW · Destroyed
  > On August 5, 2025, about 1245 mountain daylight time, a Beech 300, N534AW, was destroyed when it was involved in an accident near Chinle, Arizona. The pilot, co-pilot and two medical crew members were fatally injured. The airplane was operated as a Title 14…
- [NTSB WPR25LA136](https://openairdocs.org/ntsb/WPR25LA136.md): D'Apuzzo Senior Aero Sport · Phoenix, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 19, 2025 · N321WC · Substantial damage
  > On April 19, 2025, about 1106 Pacific daylight time, an experimental amateur built D'Apuzzo Senior Aero Sport, N321WC, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The pilot was not injured. The airplane was operated as…
- [NTSB OPS25LA025](https://openairdocs.org/ntsb/OPS25LA025.md): Boeing 737-823 · Goodyear, AZ · Incident · Class 4 · Limited · Investigation open · Feb 26, 2025 · N955NN · 2 aircraft · No damage
- [NTSB WPR25FA097](https://openairdocs.org/ntsb/WPR25FA097.md): Lancair 360 · Marana, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 19, 2025 · N3602M · 2 aircraft · Destroyed
  > On February 19, 2025, about 0828 mountain standard time, a Lancair 360 Mk II, N3602M, was destroyed, and a Cessna 172S, N463ER, sustained minor damage when they were involved in a mid-air collision near Marana Regional Airport (AVQ), Marana, Arizona. The…
- [NTSB WPR25LA099](https://openairdocs.org/ntsb/WPR25LA099.md): Cessna 140 · Salome, AZ · Accident · Minor injuries · Class 4 · Limited · Final report · Feb 9, 2025 · N4185N · Substantial damage
  > The total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection.
- [NTSB WPR25LA084](https://openairdocs.org/ntsb/WPR25LA084.md): Cessna P210N · Prescott, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 18, 2025 · N4626K · Substantial damage
  > On January 18, 2025, about 1210 Mountain standard time, a Cessna P210N, N4626K, sustained substantial damage when it was involved in an accident near Prescott, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…
- [NTSB WPR25LA023](https://openairdocs.org/ntsb/WPR25LA023.md): Cameron Balloons US A-275 · Wittmann, AZ · Accident · No injuries · Class 4 · Limited · Final report · Oct 17, 2024 · N275AZ · Substantial damage
  > The pilot’s failure to maintain clearance from a power line during an approach.
- [NTSB WPR24LA162](https://openairdocs.org/ntsb/WPR24LA162.md): Nelson Lawrence K 601 HDS · Somerton, AZ · Accident · No injuries · Class 4 · Limited · Final report · May 27, 2024 · N918LN · Substantial damage
  > The pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR24FA112](https://openairdocs.org/ntsb/WPR24FA112.md): Holmes William B AIR Creation Twin · Gila Bend, AZ · Accident · 1 fatal · Class 3 · Field · Final report · Mar 17, 2024 · N4425L · Substantial damage
  > The pilot’s loss of control and subsequent collision with a mesquite tree on approach to land.
- [NTSB WPR24LA042](https://openairdocs.org/ntsb/WPR24LA042.md): Cessna 182G · Casa Grande, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 26, 2023 · N2428R · Substantial damage
  > The loss of engine power during landing for undetermined reasons.
- [NTSB WPR23LA199](https://openairdocs.org/ntsb/WPR23LA199.md): Cessna 172S · Casa Grande, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 24, 2023 · N60372 · Substantial damage
  > An in-flight separation of the throttle linkage, which resulted in a loss of throttle control. Contributing to the accident was maintenance personnel’s failure to follow the maintenance manual inspection procedure for the throttle cable assembly.
- [NTSB WPR23LA162](https://openairdocs.org/ntsb/WPR23LA162.md): Cessna R182 · Grand Canyon, AZ · Accident · No injuries · Class 3 · Limited · Final report · Apr 19, 2023 · N4166C · Substantial damage
  > The airplane’s loss of engine power for undetermined reasons and the pilot’s exceedance of the airplane’s critical angle of attack and subsequent failure to maintain adequate airspeed, which resulted in an aerodynamic stall.
- [NTSB WPR23LA084](https://openairdocs.org/ntsb/WPR23LA084.md): Cessna TP206A · Maricopa, AZ · Accident · No injuries · Class 3 · Limited · Final report · Dec 8, 2022 · N30WL · Substantial damage
  > A total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s improper fuel management.
- [NTSB WPR23LA017](https://openairdocs.org/ntsb/WPR23LA017.md): Cessna 177RG · Mesa, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 18, 2022 · N747ML · Substantial damage
  > The failure of maintenance personnel to properly secure the fuel supply line to the fuel flow divider, which resulted in a fuel leak, fuel exhaustion, and a total loss of engine power.
- [NTSB WPR23LA013](https://openairdocs.org/ntsb/WPR23LA013.md): Piper PA-30 · Tucson, AZ · Accident · No injuries · Class 3 · Limited · Final report · Oct 15, 2022 · N7746Y · Substantial damage
  > The pilot’s loss of control during landing for reasons that could not be determined based on the available evidence.
- [NTSB WPR22FA215](https://openairdocs.org/ntsb/WPR22FA215.md): Beech E35 · Buckeye, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Jun 18, 2022 · N13AR · Destroyed
  > The 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…
- [NTSB ANC22FA030](https://openairdocs.org/ntsb/ANC22FA030.md): Robinson Helicopter R22 Beta · Gila Bend, AZ · Accident · 1 fatal · Class 3 · Field · Final report · Apr 15, 2022 · N7516G · Substantial damage
  > The student pilot’s failure to maintain control during the landing approach.
- [NTSB WPR22LA138](https://openairdocs.org/ntsb/WPR22LA138.md): Robinson Michael E Cozy Mark IV · Tucson, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 30, 2022 · N294MV · Substantial damage
  > The total loss of engine power during an approach due to clogged fuel filters, which resulted from an epoxide sealant used in manufacture of the airplane deteriorating and clogging the fuel filter.
- [NTSB WPR22LA105](https://openairdocs.org/ntsb/WPR22LA105.md): Shelton Joseph G S-7 · Buckeye, AZ · Accident · No injuries · Class 4 · Limited · Final report · Feb 19, 2022 · N242K · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land which resulted in an aerodynamic stall and hard landing.
- [NTSB WPR22FA067](https://openairdocs.org/ntsb/WPR22FA067.md): Vans RV6 · Show Low, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Dec 22, 2021 · N6000Z · Destroyed
  > The pilot’s exceedance of the airplane’s critical angle of attack following an aborted landing approach, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.
- [NTSB WPR22LA078](https://openairdocs.org/ntsb/WPR22LA078.md): Hughes 369D · Strawberry, AZ · Accident · No injuries · Class 4 · Limited · Final report · Dec 21, 2021 · N111AD · Substantial damage
  > The pilot’s failure to maintain clearance from a static wire during approach.
- [NTSB WPR22FA001](https://openairdocs.org/ntsb/WPR22FA001.md): Robinson Helicopter R22 · Chandler, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Oct 1, 2021 · N412TL · 2 aircraft · Substantial damage
  > The failure of the pilots onboard the airplane to see and avoid the helicopter while maneuvering in the traffic pattern, which resulted in a midair collision.
- [NTSB WPR21LA193](https://openairdocs.org/ntsb/WPR21LA193.md): Cessna 172R · Chandler, AZ · Accident · Serious injuries · Class 4 · Limited · Final report · May 11, 2021 · N47AF · Substantial damage
  > The pilot’s failure to locate the airport which resulted in an approach to a road and subsequent collision with powerlines during a go-around in low light conditions.
- [NTSB WPR21LA183](https://openairdocs.org/ntsb/WPR21LA183.md): MD Helicopters 369FF · Mesa, AZ · Accident · No injuries · Class 4 · Limited · Final report · May 5, 2021 · N6068S · Substantial damage
  > A tail rotor blade strike to an undetermined object while practicing approaches to unimproved terrain.
- [NTSB WPR21LA127](https://openairdocs.org/ntsb/WPR21LA127.md): Cessna 150E · Marana, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 27, 2021 · N6135T · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR21LA054](https://openairdocs.org/ntsb/WPR21LA054.md): General Atomics MQ-9 · Sierra Vista, AZ · Accident · Class 4 · Limited · Final report · Nov 13, 2020 · CBP233 · Destroyed
  > The pilot’s incorrect automated landing profile selection, which resulted in an impact with a runway trench. Contributing to the accident was the pilot receiving instruction's and instructor's failure to spot the incorrect landing profile selection during…
- [NTSB WPR21LA023](https://openairdocs.org/ntsb/WPR21LA023.md): Cessna 172 · Carefree, AZ · Accident · No injuries · Class 4 · Limited · Final report · Oct 24, 2020 · N7029T · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack while landing, which resulted in an aerodynamic stall.
- [NTSB WPR20LA291](https://openairdocs.org/ntsb/WPR20LA291.md): Cessna TU206 · Tusayan, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 28, 2020 · N3422L · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of contamination in the airplane’s fuel system.
- [NTSB WPR20LA177](https://openairdocs.org/ntsb/WPR20LA177.md): Zenair CH601 · Maricopa, AZ · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 10, 2020 · N6402X · Destroyed
  > The pilot’s loss of situational awareness and descent below pattern altitude during the landing approach, which resulted in collision with terrain at night.
- [NTSB WPR20LA176](https://openairdocs.org/ntsb/WPR20LA176.md): Vans RV4 · Safford, AZ · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 9, 2020 · N173CW · Substantial damage
  > A loss of pitch control during the landing approach due to a jammed elevator control system.
- [NTSB WPR20FA049](https://openairdocs.org/ntsb/WPR20FA049.md): Cessna 182 · Goodyear, AZ · Accident · 1 fatal · Class 3 · Field · Final report · Dec 22, 2019 · N3371U · Substantial damage
  > The pilot’s failure to maintain clearance from power lines due to his impairment from cannabis.
- [NTSB WPR20LA038](https://openairdocs.org/ntsb/WPR20LA038.md): Piper PA-34-200T · Phoenix, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 11, 2019 · N2822F · Substantial damage
  > The pilot’s mismanagement of the fuel onboard, which resulted in a loss of engine power due to fuel starvation. Contributing to the fuel starvation was the erroneous indications on the fuel gauges.
- [NTSB GAA19CA162](https://openairdocs.org/ntsb/GAA19CA162.md): Cessna 172 · Scottsdale, AZ · Accident · No injuries · Data collection · Final report · Mar 2, 2019 · N9404F · Substantial damage
  > The student pilot's failure to maintain the runway heading during a go-around with a crosswind, which resulted in the left main landing gear impacting a runway sign.
- [NTSB WPR19FA026](https://openairdocs.org/ntsb/WPR19FA026.md): Zenith CH601 · Overgaard, AZ · Accident · 2 fatal · Class 2 · Field · Final report · Nov 16, 2018 · N322JL · Substantial damage
  > The pilot’s failure to monitor the airport’s visual approach path indicator during the final approach to the upsloping runway, which resulted in a low approach path and impact with terrain.
- [NTSB WPR19FA007](https://openairdocs.org/ntsb/WPR19FA007.md): Cessna T240 · Payson, AZ · Accident · 2 fatal · Class 2 · Field · Final report · Oct 14, 2018 · N433CS · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin and a subsequent loss of control.
- [NTSB WPR18FA266](https://openairdocs.org/ntsb/WPR18FA266.md): Beech 33 · Cottonwood, AZ · Accident · 1 fatal · Class 2 · Field · Final report · Sep 17, 2018 · N2031D · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB DCA18CA289](https://openairdocs.org/ntsb/DCA18CA289.md): Boeing 737 · Phoenix, AZ · Accident · Serious injuries · Data collection · Final report · Sep 11, 2018 · N950NN · No damage
  > an inadvertent encounter with wake turbulence.
- [NTSB WPR18FA245](https://openairdocs.org/ntsb/WPR18FA245.md): Cessna P210 · Prescott, AZ · Accident · 1 fatal · Class 2 · Field · Final report · Aug 30, 2018 · N6500W · Destroyed
  > The pilot's misjudgment of distance and altitude from the runway and his subsequent failure to maintain an approach path that provided clearance from the terrain due to a visual illusion in dark night conditions.
- [NTSB WPR18FA229](https://openairdocs.org/ntsb/WPR18FA229.md): James E Causey Acroduster II · Phoenix, AZ · Accident · 2 fatal · Field investigation · Final report · Aug 20, 2018 · N787WM · Substantial damage
  > An exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.
- [NTSB GAA18CA234](https://openairdocs.org/ntsb/GAA18CA234.md): Piper PA28 · Wickenburg, AZ · Accident · No injuries · Data collection · Final report · Apr 25, 2018 · N922PA · Substantial damage
  > The student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.
- [NTSB WPR18LA121](https://openairdocs.org/ntsb/WPR18LA121.md): Airborne Windsports PTY XT-912-L · Peoria, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 15, 2018 · N107PW · Substantial damage
  > An inflight loss of control due to failure of the weight-shift-control aircraft's wing assembly.
- [NTSB GAA18CA193](https://openairdocs.org/ntsb/GAA18CA193.md): Piper PA28 · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Apr 1, 2018 · N297PA · Substantial damage
  > The student pilot’s improper selection of the flap setting during a go-around, and the flight instructor’s delayed remedial action, which resulted in an aerodynamic stall.
- [NTSB WPR18MA087](https://openairdocs.org/ntsb/WPR18MA087.md): Eurocopter EC130 · Peach Springs, AZ · Accident · 5 fatal · Class 3 · Major · Final report · Feb 11, 2018 · N155GC · Destroyed
  > A loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain during an approach to land in gusting, tailwind conditions in an area of potential downdrafts and turbulence.
- [NTSB WPR18CA028](https://openairdocs.org/ntsb/WPR18CA028.md): Still Michael J Titan T-51 · Chandler, AZ · Accident · No injuries · Data collection · Final report · Oct 28, 2017 · N651P · Substantial damage
  > The pilot's inadvertent contact with the engine control unit toggle switch during flight, which resulted in the engine shutting down.
- [NTSB WPR18LA014](https://openairdocs.org/ntsb/WPR18LA014.md): American AA 1A · Maricopa, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 21, 2017 · N9239L · Substantial damage
  > The pilot’s failure to see and avoid unmarked power lines during the approach to land.
- [NTSB WPR18LA003](https://openairdocs.org/ntsb/WPR18LA003.md): Borom Marcus P Long EZ · Tucson, AZ · Accident · No injuries · Class 3 · Limited · Final report · Oct 7, 2017 · N966EZ · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the controller's failure to provide adequate traffic information, issue necessary…

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=AZ&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=AZ

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.