# NTSB investigations, AZ: Initial climb

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 · 580 cases

## Latest cases

- [NTSB WPR26FA281](https://openairdocs.org/ntsb/WPR26FA281.md): Piper PA-28-180 · Chandler, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 29, 2026 · N9062J · Destroyed
  > On July 28, 2026, about 1949 mountain standard time, a Piper PA-28-180, N9062J, was destroyed when it was involved in an accident near Chandler, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…
- [NTSB WPR26LA258](https://openairdocs.org/ntsb/WPR26LA258.md): Remos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 12, 2026 · N126GX · Substantial damage
  > On July 12, 2026, at 1018 mountain standard time, a Remos GX airplane, N126GX, was substantially damaged when it was involved in an accident near Glendale, Arizona. The flight instructor and student pilot were uninjured. The airplane was operated as a Title…
- [NTSB WPR26LA245](https://openairdocs.org/ntsb/WPR26LA245.md): Piper PA-28-140 · Salome, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 5, 2026 · N3995K · Substantial damage
  > On July 5, 2026, at about 0825 Pacific daylight time, a Piper PA-28-140, N3995K, was substantially damaged when it was involved in an accident near Salome, Arizona. The pilot and passenger were uninjured. The airplane was operating as a Title 14 Code of…
- [NTSB WPR26FA119](https://openairdocs.org/ntsb/WPR26FA119.md): Piper PA-28-140 · Phoenix, AZ · Accident · Serious injuries · Class 3 · Field · Preliminary report · Mar 4, 2026 · N7744T · Substantial damage
  > On March 4, 2026, about 0721 mountain standard time, a Piper PA-28-140, N7744T, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor was seriously injured, and the student pilot and one person on the…
- [NTSB ANC26LA016](https://openairdocs.org/ntsb/ANC26LA016.md): Cessna 177B · Rocky Junction, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 22, 2026 · N12984 · Substantial damage
  > On February 21, 2026, 1746 Mountain standard time, a Cessna 177B airplane, N12984, was substantially damaged when it was involved in an accident near Rocky Junction, Arizona. The pilot and passenger sustain minor injuries. The airplane was operated as a Title…
- [NTSB WPR26LA078](https://openairdocs.org/ntsb/WPR26LA078.md): Beech K35 · Prescott, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 7, 2026 · N6010E · Substantial damage
  > On January 7, 2026, at about 0809 mountain standard time, a Beech K35, N6010E, was substantially damaged when it was involved in an accident near Prescott, Arizona. The pilot and flight instructor were not injured. The airplane was operated as a Title 14 Code…
- [NTSB WPR25LA170](https://openairdocs.org/ntsb/WPR25LA170.md): Cessna 150M · Phoenix, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 6, 2025 · N45659 · Substantial damage
  > On June 6, 2025, about 0530 mountain standard time, a Cessna 150M, N45659, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane was operated as a…
- [NTSB WPR24LA146](https://openairdocs.org/ntsb/WPR24LA146.md): Robert Sterling 4P · Lake Havasu City, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · May 9, 2024 · N78GP · Substantial damage
  > A loss of engine power during initial climb due to fuel vapor lock. Contributing to the accident was the incorrect installation of the ancillary fuel supply system components.
- [NTSB WPR24LA130](https://openairdocs.org/ntsb/WPR24LA130.md): James E Davidson JR Rans S-7S Courier · Benson, AZ · Accident · No injuries · Class 3 · Limited · Final report · Apr 22, 2024 · N599YY · Substantial damage
  > The pilot’s unintentional use of a winter-blend fuel that was susceptible to vaporization, which resulted in fuel starvation and a loss of engine power due to vapor lock. Contributing to the accident was the airplane’s undersized fuel lines, which limited the…
- [NTSB WPR24FA053](https://openairdocs.org/ntsb/WPR24FA053.md): Beauchamp Norm Kitfox · Eloy, AZ · Accident · 1 fatal · Class 3 · Field · Final report · Dec 8, 2023 · N66180 · Destroyed
  > The separation of a propeller blade during the initial climb due to insufficient blade retention forces. Contributing to the accident was the propeller blade retention design, manufacturing defects that prevented the propeller from achieving adequate grip…
- [NTSB WPR24FA052](https://openairdocs.org/ntsb/WPR24FA052.md): Remos Remos GX · Taylor, AZ · Accident · Serious injuries · Class 3 · Field · Final report · Dec 6, 2023 · N449RA · Substantial damage
  > The pilot’s decision to attempt takeoff with frost covering the airplane’s wings, which led to an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB WPR24LA038](https://openairdocs.org/ntsb/WPR24LA038.md): Beech 95 · Yuma, AZ · Accident · No injuries · Class 3 · Limited · Final report · Nov 18, 2023 · N2024C · Substantial damage
  > Aeroelastic flutter of the rudder control surface during the takeoff initial climb for reasons that could not be determined based on the available evidence, which resulted in the fracture of the rudder trim control rod end in flight.
- [NTSB WPR24FA014](https://openairdocs.org/ntsb/WPR24FA014.md): Piper PA-28-140 · Williams, AZ · Accident · 3 fatal · Class 3 · Field · Final report · Oct 17, 2023 · N6192J · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed and exceedance of the airplane’s critical angle of attack during initial climb after takeoff, resulting in an aerodynamic stall. Contributing was the pilot’s inadequate preflight airplane performance…
- [NTSB WPR24LA012](https://openairdocs.org/ntsb/WPR24LA012.md): Piper PA-46-310P · Chandler, AZ · Accident · No injuries · Class 3 · Limited · Final report · Oct 11, 2023 · N4380D · Substantial damage
  > The pilot’s failure to adequately confirm the fuel quantity before departure, resulting in fuel exhaustion and a partial loss of engine power.
- [NTSB WPR23LA201](https://openairdocs.org/ntsb/WPR23LA201.md): Cessna 177B · Tucson, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · May 24, 2023 · N34713 · Substantial damage
  > A partial loss of engine power due to restricted fuel flow resulting from foreign object debris in the fuel flow transducer.
- [NTSB WPR23LA160](https://openairdocs.org/ntsb/WPR23LA160.md): Remos Remos GX · Glendale, AZ · Accident · No injuries · Class 3 · Limited · Final report · Apr 18, 2023 · N21GX · Substantial damage
  > A total loss of engine power caused by fatigue cracking and fracture of the crankshaft. Contributing to the accident was the operator’s failure to properly maintain the airplane.
- [NTSB WPR22LA341](https://openairdocs.org/ntsb/WPR22LA341.md): Cessna 750 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Final report · Sep 7, 2022 · N15TZ · Substantial damage
  > The pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…
- [NTSB WPR22FA188](https://openairdocs.org/ntsb/WPR22FA188.md): Cessna 172F · Show Low, AZ · Accident · 2 fatal · Class 3 · Field · Final report · May 26, 2022 · N5532R · Substantial damage
  > The pilot’s improper leaning of the engine during an extended period of time, which caused an exhaust valve to become stuck and led to the partial loss of engine power during the accident flight. Contributing to the accident was the pilot’s decision to…
- [NTSB WPR22LA186](https://openairdocs.org/ntsb/WPR22LA186.md): Cessna P172D · Prescott, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · May 22, 2022 · N8540X · Substantial damage
  > The loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR21LA118](https://openairdocs.org/ntsb/WPR21LA118.md): American AA-1B · St Johns, AZ · Accident · No injuries · Class 4 · Limited · Final report · Feb 24, 2021 · N30JL · Substantial damage
  > The pilot’s decision to operate with a demonstrated crosswind velocity above the airplane’s performance capabilities which resulted in a loss of airplane control and collision with terrain.
- [NTSB WPR20CA205](https://openairdocs.org/ntsb/WPR20CA205.md): Beech 23 · Sedona, AZ · Accident · No injuries · Class 4 · Data collection · Final report · Jul 5, 2020 · N8868M · Substantial damage
  > The pilot's inability to maintain a climb after an attempted takeoff in high density altitude conditions, which resulted in a forced landing on a road and subsequent landing gear collapse.
- [NTSB WPR20LA022](https://openairdocs.org/ntsb/WPR20LA022.md): Cessna 150 · Red Rock, AZ · Accident · No injuries · Class 3 · Limited · Final report · Nov 13, 2019 · N704QJ · Substantial damage
  > A total loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s improper use of carburetor heat.
- [NTSB WPR19LA167](https://openairdocs.org/ntsb/WPR19LA167.md): Mooney M20V · Phoenix, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 11, 2019 · N576CM · Substantial damage
  > The partial loss of engine power during cruise flight for reasons that could not be determined with the available evidence.
- [NTSB WPR19LA128](https://openairdocs.org/ntsb/WPR19LA128.md): Beech 35 · Sedona, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 1, 2019 · N6864Q · Substantial damage
  > The partial loss of engine power due to deteriorated O-rings in the throttle metering assembly. Contributing to the accident was non-compliance with the manufacturer's recommended throttle metering assembly overhaul schedule.
- [NTSB GAA19CA060](https://openairdocs.org/ntsb/GAA19CA060.md): Beech 36 · Williams, AZ · Accident · Minor injuries · Data collection · Final report · Nov 14, 2018 · N264PC · Substantial damage
  > The pilot's failure to attain a sufficient climb rate during initial climb in high-density altitude conditions with the airplane near its forward center of gravity and maximum gross weight limits, which resulted in an impact with trees.
- [NTSB WPR18LA263](https://openairdocs.org/ntsb/WPR18LA263.md): Cessna A185 · Bullhead City, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 15, 2018 · N573BV · Substantial damage
  > The pilot’s diverted attention during takeoff initial climb, which resulted in a collision with rising terrain.
- [NTSB WPR18LA262](https://openairdocs.org/ntsb/WPR18LA262.md): Cessna 172 · St. Johns, AZ · Accident · Serious injuries · Limited investigation · Final report · Sep 15, 2018 · N734FT · Substantial damage
  > The pilot's inadequate preflight planning before takeoff in the high density altitude conditions, which resulted in the airplane being unable to maintain sufficient airspeed to continue to climb.
- [NTSB GAA18CA313](https://openairdocs.org/ntsb/GAA18CA313.md): Cessna 172 · Payson, AZ · Accident · No injuries · Data collection · Final report · May 30, 2018 · N780JA · Substantial damage
  > The pilot’s failure to maintain yaw control during a short-field takeoff in high-density altitude conditions.
- [NTSB WPR18LA158](https://openairdocs.org/ntsb/WPR18LA158.md): Rhoads Autogyro MTO Sport · San Manuel, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 21, 2018 · N574BR · Substantial damage
  > The fracture of the propeller hub due to corrosion pitting along the propeller blade root seat, which led to cracking that was propagated due to high-cycle fatigue.
- [NTSB WPR18FA119](https://openairdocs.org/ntsb/WPR18FA119.md): Piper PA 24-260 · Scottsdale, AZ · Accident · 6 fatal · Field investigation · Final report · Apr 10, 2018 · N9456P · Destroyed
  > The flight instructor's failure to maintain airplane control during the initial climb as a result of the airplane being loaded above its maximum gross weight and beyond its aft center of gravity limits. Contributing to the accident was a degraded engine power…
- [NTSB WPR17LA175](https://openairdocs.org/ntsb/WPR17LA175.md): Grumman AA1 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2017 · N6216L · Substantial damage
  > The partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…
- [NTSB WPR17LA121](https://openairdocs.org/ntsb/WPR17LA121.md): Bob Frederick Titan T-51 · Goodyear, AZ · Accident · No injuries · Limited investigation · Final report · Jun 4, 2017 · N51FB · Substantial damage
  > Failure of the propeller speed reduction gearbox input drive gear during the airplane’s initial climb for reasons that could not be determined due to extensive damage.
- [NTSB WPR17FA057](https://openairdocs.org/ntsb/WPR17FA057.md): Beech 300 · Tucson, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 23, 2017 · N385KA · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment by the effects of a combination of psychoactive substances.
- [NTSB WPR17LA015](https://openairdocs.org/ntsb/WPR17LA015.md): Ryan W Gross Arion Lighting · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Oct 22, 2016 · N235SC · Substantial damage
  > The pilot's failure to maintain airplane control during takeoff/initial climb due to his inexperience in the airplane make and model and his refusal to obtain training in the airplane.
- [NTSB WPR16LA106](https://openairdocs.org/ntsb/WPR16LA106.md): Boeing B75N1 · Winslow, AZ · Accident · No injuries · Limited investigation · Final report · May 12, 2016 · N56200 · Substantial damage
  > The partial loss of engine power during takeoff initial climb in high-density altitude conditions for reasons that could not be determined because a postaccident examination of the airplane and engine revealed no anomalies.
- [NTSB WPR16LA088](https://openairdocs.org/ntsb/WPR16LA088.md): Thomas D. Parkes Lancair ES · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Mar 10, 2016 · N44AZ · Substantial damage
  > A partial loss of engine power due to an over-temperature event, which thermally damaged the blade tips of the turbocharger wheel and resulted in a slowing or stoppage in the rotation of the turbocharger.
- [NTSB WPR16LA080](https://openairdocs.org/ntsb/WPR16LA080.md): North Wing Apache · Queen Creek, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 5, 2016 · N242WT · Substantial damage
  > A loss of control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the noncertificated pilot’s lack of experience in the…
- [NTSB WPR16LA057](https://openairdocs.org/ntsb/WPR16LA057.md): Enstrom 280 · Phoenix, AZ · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 2016 · N133AB · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR16LA043](https://openairdocs.org/ntsb/WPR16LA043.md): Aerostar Acft Corp Of Texas M20F · Nogales, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 26, 2015 · N6811V · Substantial damage
  > The airplane’s impact with a hillside shortly after takeoff for reasons that could not be determined.
- [NTSB WPR15FA144](https://openairdocs.org/ntsb/WPR15FA144.md): Schempp-Hirth Standard Cirrus · Prescott Valley, AZ · Accident · 1 fatal · Field investigation · Final report · Apr 11, 2015 · N352D · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack during the initial climb after a ground-tow launch, which resulted in an aerodynamic stall/spin.
- [NTSB WPR15LA130](https://openairdocs.org/ntsb/WPR15LA130.md): Vans RV6A · Green Valley, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 21, 2015 · N811KM · Substantial damage
  > The total loss of engine power during initial climb due to the disconnection of both fuel pump power wires.
- [NTSB WPR15LA038](https://openairdocs.org/ntsb/WPR15LA038.md): Cessna 210B · Bullhead City, AZ · Accident · No injuries · Limited investigation · Final report · Nov 8, 2014 · N9578X · Substantial damage
  > The failure of the landing gear actuator housing during landing for reasons that could not be determined based on the available evidence.
- [NTSB WPR15LA015](https://openairdocs.org/ntsb/WPR15LA015.md): Piper PA28 151 · Bullhead City, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 2014 · N56873 · Substantial damage
  > A partial loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR14CA350](https://openairdocs.org/ntsb/WPR14CA350.md): Schweizer SGS 1 34 · Marana, AZ · Accident · Minor injuries · Data collection · Final report · Aug 19, 2014 · N7628 · Substantial damage
  > The pilot's failure to ensure the canopy was locked during the pre-takeoff inspection which led to the canopy opening in flight and the pilot's failure to maintain aircraft control during the subsequent landing.
- [NTSB WPR14LA242](https://openairdocs.org/ntsb/WPR14LA242.md): Adams Dragonfly · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Jun 12, 2014 · N85TL · Substantial damage
  > A partial loss of engine power due to a reduction in the No. 3 cylinder’s compression as a result of the exhaust valve not having consistent uniform contact with the cylinder head valve seat.
- [NTSB WPR14FA194](https://openairdocs.org/ntsb/WPR14FA194.md): Aero Commander 500 S · Fort Huachuca, AZ · Accident · 1 fatal · Field investigation · Final report · May 17, 2014 · N40TC · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…
- [NTSB WPR14FA181](https://openairdocs.org/ntsb/WPR14FA181.md): Aero Tek Zuni · Aguila, AZ · Accident · 1 fatal · Field investigation · Final report · May 3, 2014 · N22DA · Substantial damage
  > The pilot's inability to maintain control of the glider after the tow cable separated prematurely due to an incomplete engagement of the cable in the control tow release system due to a missing spring.
- [NTSB WPR14FA111](https://openairdocs.org/ntsb/WPR14FA111.md): Piper PA 28-181 · Phoenix, AZ · Accident · Serious injuries · Field investigation · Final report · Feb 4, 2014 · N312PA · Substantial damage
  > The student pilot’s inadvertent positioning of the fuel selector in an intermediate position, which resulted in a loss of engine power due to fuel starvation.
- [NTSB WPR13CA330](https://openairdocs.org/ntsb/WPR13CA330.md): Kincaid Wade Dakota Hawk · San Simon, AZ · Accident · Serious injuries · Data collection · Final report · Jul 14, 2013 · N544WK · Substantial damage
  > The pilot's failure to maintain clearance from power lines during takeoff from an open field.
- [NTSB WPR13FA244](https://openairdocs.org/ntsb/WPR13FA244.md): Raytheon A36 · Mountainaire, AZ · Accident · 2 fatal · Field investigation · Final report · May 28, 2013 · N999PK · Destroyed
  > The 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…

Next page: https://openairdocs.org/ntsb-phases/350/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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/350/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.