# NTSB investigations, AZ: Enroute 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 21 · 1,009 cases ## Latest cases - [NTSB WPR26FA301](https://openairdocs.org/ntsb/WPR26FA301.md): New Glasair Sportsman 2 Plus 2 · Pine, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 11, 2026 · N202AZ · Destroyed > On 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… - [NTSB WPR26LA236](https://openairdocs.org/ntsb/WPR26LA236.md): Beech S35 · Dome, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 25, 2026 · N6040F · Substantial damage > On June 25, 2026, about 1125 mountain standard time, a Beech S35, N6040F, sustained substantial damage when it was involved in an accident near Dome, Arizona. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA191](https://openairdocs.org/ntsb/WPR26LA191.md): Bigham Jack L Marquart M 5 Charger · Tucson, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · May 15, 2026 · N987JB · Substantial damage > On May 15, 2026, about 1500 mountain standard time, an experimental amateur built Marquart M5 Charger was substantially damaged when it was involved in an accident near Tucson, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code… - [NTSB WPR26LA190](https://openairdocs.org/ntsb/WPR26LA190.md): Piper PA-28-140 · Chandler, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · May 15, 2026 · N8714N · Substantial damage > On May 14, 2026, at 2043 mountain standard time, a Piper PA-28, N8714N, was substantially damaged when it was involved in an accident near Chandler, Arizona. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26LA153](https://openairdocs.org/ntsb/WPR26LA153.md): Republic RC-3 · Phoenix, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 12, 2026 · N6518K · Substantial damage > On April 12, 2026, about 1423 mountain standard time, a Republic RC-3 airplane, N6518K, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The pilot and two passengers were not injured. The amphibious airplane was operated as… - [NTSB WPR26LA126](https://openairdocs.org/ntsb/WPR26LA126.md): Cirrus Design SR20 · Redington, AZ · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 10, 2026 · N619AV · Substantial damage > The pilot’s improper decision to continue the flight into icing conditions, which resulted in the accumulation of airframe icing and a subsequent aerodynamic stall. - [NTSB WPR26LA118](https://openairdocs.org/ntsb/WPR26LA118.md): Lindstrand 260A · Casa Grande, AZ · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 2, 2026 · N261RR · Substantial damage > The hot air balloon’s encounter with downdraft wind conditions in mountainous terrain and subsequent impact with terrain. - [NTSB CEN26FA109](https://openairdocs.org/ntsb/CEN26FA109.md): Robert G Elves Tarragon (Tarr) · Shawmut, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 6, 2026 · N35RR · Substantial damage > On February 6, 2026, at 1532 mountain standard time, a Tarragon airplane, N35RR, was substantially damaged when it was involved in an accident near Shawmut, Arizona. The pilot was fatally injured and the passenger received serious injuries. The airplane was… - [NTSB WPR26LA022](https://openairdocs.org/ntsb/WPR26LA022.md): Flight Design Ctsw · Casa Grande, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 17, 2025 · N531CT · Substantial damage > On October 17, 2025, about 13:20 mountain standard time, a Flight Design GMBH CTSW, N531CT, was substantially damaged when it was involved in an accident near Casa Grande, Arizona. The pilot received minor injuries. The airplane was operated as a Title 14… - [NTSB WPR26LA002](https://openairdocs.org/ntsb/WPR26LA002.md): Amazon.Com Services MK30 · Tolleson, AZ · Incident · No injuries · Class 3 · Limited · Preliminary report · Oct 1, 2025 · N791PA · Substantial damage > On 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… - [NTSB WPR26LA001](https://openairdocs.org/ntsb/WPR26LA001.md): Amazon.Com Services MK30 · Tolleson, AZ · Incident · Class 3 · Limited · Preliminary report · Oct 1, 2025 · N579PA · Substantial damage > On 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… - [NTSB WPR25LA305](https://openairdocs.org/ntsb/WPR25LA305.md): Cessna 150F · Lake Havasu City, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 26, 2025 · N8171S · Substantial damage > On September 26, 2025, at about 0915 mountain standard time, a Cessna 150F, N8171S, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane… - [NTSB WPR25LA291](https://openairdocs.org/ntsb/WPR25LA291.md): Pipistrel D O O Alpha Trainer · Wittman, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 25, 2025 · N246EA · Substantial damage > On September 25, 2025, at about 0653 mountain daylight time, a Pipistrel D O O Alpha Trainer, N246EA, was substantially damaged when it was involved in an accident near Wittman, Arizona. The two pilots on board received minor injuries. The airplane was… - [NTSB WPR25LA265](https://openairdocs.org/ntsb/WPR25LA265.md): Cessna 120 · Taylor, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 24, 2025 · N3151N · Substantial damage > On August 24, 2025, about 0711 mountain daylight time, a Cessna 120, N3151N, was substantially damaged when it was involved in an accident near Taylor, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR25LA218](https://openairdocs.org/ntsb/WPR25LA218.md): Cessna 425 · Round Rock, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 17, 2025 · N425D · Substantial damage > On July 17, 2025, about 1600 mountain daylight time, a Cessna 425, N425D, was substantially damaged when it was involved in an accident near Round Rock, Arizona. The pilot receiving instruction and the flight instructor were not injured. The airplane was… - [NTSB WPR25LA217](https://openairdocs.org/ntsb/WPR25LA217.md): Cessna TR182 · Tuba City, AZ · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 17, 2025 · N182KC · Substantial damage > On July 17, 2025, about 1447 mountain standard time, a Cessna TR182, N182KC, was substantially damaged when it was involved in an accident near Tuba City, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN25FA212](https://openairdocs.org/ntsb/CEN25FA212.md): Cessna A150L · Three Points, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 18, 2025 · N6436F · Substantial damage > On 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… - [NTSB WPR25LA131](https://openairdocs.org/ntsb/WPR25LA131.md): Piper PA-32-260 · Green Valley, AZ · Accident · No injuries · Class 3 · Limited · Final report · Apr 13, 2025 · N3797W · Substantial damage > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. - [NTSB WPR25LA135](https://openairdocs.org/ntsb/WPR25LA135.md): Martin Uav Vbat · Douglas, AZ · Accident · No injuries · Class 4 · Limited · Final report · Apr 8, 2025 · N443VA · Substantial damage > The malfunction of the throttle servo which resulted in the complete loss of engine power. - [NTSB WPR25LA094](https://openairdocs.org/ntsb/WPR25LA094.md): Cessna T210R · Flagstaff, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Feb 16, 2025 · N105DF · Substantial damage > On February 16, 2025, about 1445 mountain standard time, a Cessna T210R, N105DF, was substantially damaged when it was involved in an accident near Flagstaff, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR25LA070](https://openairdocs.org/ntsb/WPR25LA070.md): Vans RV-7A · Gila Bend, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 22, 2024 · N1FB · Substantial damage > A disconnection of the mixture control linkage during flight, which resulted in fuel starvation and a total loss of engine power. Contributing was the inadequate inspection of the mixture control arm attachment hardware. - [NTSB WPR25LA065](https://openairdocs.org/ntsb/WPR25LA065.md): Piper PA-24-250 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Final report · Dec 19, 2024 · N7833P · Substantial damage > The pilot’s improper fuel tank selection during takeoff, which resulted in a total loss of engine power due to fuel starvation. - [NTSB WPR25LA040](https://openairdocs.org/ntsb/WPR25LA040.md): Cessna 172I · Mayer, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 17, 2024 · N8390L · Substantial damage > The accumulation of carburetor ice, which resulted in a loss of engine power and a subsequent forced landing. - [NTSB WPR25LA030](https://openairdocs.org/ntsb/WPR25LA030.md): Piper PA-32-300 · Prescott Valley, AZ · Accident · No injuries · Class 3 · Limited · Final report · Oct 31, 2024 · N154DC · Substantial damage > Separation of the No. 3 engine cylinder due to a loss of torque on the cylinder base nuts, which resulted in a loss of engine power and in-flight fire. Contributing to the accident was maintenance personnel’s failure to ensure the engine case and cylinder… - [NTSB WPR24LA305](https://openairdocs.org/ntsb/WPR24LA305.md): Mooney M20F · Cottonwood, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 8, 2024 · N9628M · Substantial damage > The pilot’s evasive maneuver to avoid birds while on final approach at a low altitude, which resulted in the airplane colliding with a tree. - [NTSB WPR24LA194](https://openairdocs.org/ntsb/WPR24LA194.md): Cessna 150M · Roll, AZ · Accident · No injuries · Class 3 · Limited · Final report · Jun 11, 2024 · N3156V · Substantial damage > The failure of the No. 2 intake valve due to inadequate seating, which resulted from valve guide-to-seat misalignment and associated wear. - [NTSB WPR24LA159](https://openairdocs.org/ntsb/WPR24LA159.md): Nanchang China CJ-6A · Peoria, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 21, 2024 · N4182C · Substantial damage > The partial loss of engine power during cruise flight due to the improper installation of the master connecting rod main bushing set screws, which backed off and allowed the main bushing to shift, resulting in scoring damage on the crankshaft that led to the… - [NTSB ANC24LA027](https://openairdocs.org/ntsb/ANC24LA027.md): Piper PA-28-151 · Marana, AZ · Accident · No injuries · Class 3 · Limited · Final report · Apr 19, 2024 · N4399X · Substantial damage > A total loss of engine power due to a failure of the No. 4 cylinder piston boss. - [NTSB WPR24LA084](https://openairdocs.org/ntsb/WPR24LA084.md): Cessna 172P · Goodyear, AZ · Accident · No injuries · Class 3 · Limited · Final report · Feb 10, 2024 · N52436 · Substantial damage > Bearing degradation that increased clearances between the bearing and crankshaft journal surfaces, resulting in fatigue cracks and the subsequent failure of the No. 3 connecting rod and a total loss of engine power. Contributing to the accident was the… - [NTSB WPR24LA076](https://openairdocs.org/ntsb/WPR24LA076.md): Piper PA-28-181 · Colorado City, AZ · Accident · No injuries · Class 3 · Limited · Final report · Jan 13, 2024 · N2886X · Substantial damage > The loss of engine power due to the failure of the No. 2 piston pin plug, which resulted in oil starvation and subsequent failure of the No. 3 connecting rod. Contributing to the accident was the inadequate engine inspections by maintenance personnel. - [NTSB WPR24FA054](https://openairdocs.org/ntsb/WPR24FA054.md): Beech A36 · Topock, AZ · Accident · 1 fatal · Class 3 · Field · Final report · Dec 10, 2023 · N4171S · Substantial damage > The failure of the No. 4 connecting rod due to oil starvation, which resulted in a loss of engine power, inflight fire, and a subsequent off-airport emergency landing on rough desert terrain. Contributing to the accident was the pilot’s decision to attempt a… - [NTSB WPR24LA051](https://openairdocs.org/ntsb/WPR24LA051.md): Piper PA-28-180 · Mesa, AZ · Accident · No injuries · Class 4 · Limited · Final report · Dec 5, 2023 · N9166J · Substantial damage > A failure of the engine cowling right side latch pin and fasteners, which resulted in the partial separation of the engine cowling during flight. - [NTSB WPR23LA306](https://openairdocs.org/ntsb/WPR23LA306.md): Boeing CH-46E · Springerville, AZ · Accident · No injuries · Class 3 · Limited · Final report · Aug 5, 2023 · N461WY · Destroyed > The flight crew’s misidentification of a No. 2 torque sensing system signal conditioner malfunction when both engines were performing normally, which resulted in their attempt to execute a single-engine steep approach and landing without sufficient engine… - [NTSB WPR23LA241](https://openairdocs.org/ntsb/WPR23LA241.md): Cessna 172K · Marana, AZ · Accident · No injuries · Class 3 · Limited · Final report · Jun 23, 2023 · N84385 · Substantial damage > A total loss of engine power due to fuel exhaustion. - [NTSB DCA23LA290](https://openairdocs.org/ntsb/DCA23LA290.md): General Atomics MQ-9 Block 1 · Elgin, AZ · Accident · Class 4 · Limited · Final report · May 15, 2023 · N31EJ · Destroyed > The pilot’s loss of situational awareness, resulting in the UAS’s controlled flight into terrain. - [NTSB WPR23LA167](https://openairdocs.org/ntsb/WPR23LA167.md): Gates Learjet 35A · Page, AZ · Occurrence · No injuries · Class 3 · Limited · Final report · Apr 24, 2023 · N135SH · No damage > The fueler’s inadvertent addition of diesel exhaust fluid (DEF) to the FSII reservoir on the fuel truck, and its subsequent mixture with the JET A that was used to fuel the airplane, resulting in a total loss of power to the right engine and a partial loss of… - [NTSB WPR23LA129](https://openairdocs.org/ntsb/WPR23LA129.md): Navion Navion A · Mesa, AZ · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 17, 2023 · N610 · 2 aircraft · Substantial damage > The pilot of the Ryan Navion’s failure to maintain visual sight of and clearance from another airplane during a formation flight, which resulted in a mid-air collision. - [NTSB WPR23LA125](https://openairdocs.org/ntsb/WPR23LA125.md): Rockwell International AC 690A · Bullhead City, AZ · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 7, 2023 · N4PZ · Substantial damage > The pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion, a total loss of engine power and subsequent impact with terrain. - [NTSB WPR23LA060](https://openairdocs.org/ntsb/WPR23LA060.md): Cessna 177 · Willow Spring, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 27, 2022 · N2994X · Substantial damage > The airplane’s loss of engine power for undetermined reasons. - [NTSB WPR23LA051](https://openairdocs.org/ntsb/WPR23LA051.md): Cosmos Phase II · Lake Havasu, AZ · Accident · No injuries · Class 4 · Limited · Final report · Nov 26, 2022 · N254DW · Substantial damage > The pilot’s inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain. - [NTSB WPR23LA031](https://openairdocs.org/ntsb/WPR23LA031.md): Cessna 150G · Star Valley, AZ · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 11, 2022 · N3131J · Substantial damage > The failure of the No. 1 cylinder exhaust or intake valve which resulted in the partial loss of engine power and subsequent impact with terrain. - [NTSB WPR23LA006](https://openairdocs.org/ntsb/WPR23LA006.md): Bell 47G2 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Final report · Oct 1, 2022 · N24067 · Substantial damage > A total loss of engine power due to fuel exhaustion. - [NTSB WPR22FA348](https://openairdocs.org/ntsb/WPR22FA348.md): Trom Wayne Vans RV6A · Aztec, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Sep 16, 2022 · N646RV · Destroyed > The 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… - [NTSB WPR22FA345](https://openairdocs.org/ntsb/WPR22FA345.md): Piper PA46 · Seligman, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Sep 13, 2022 · N43605 · Substantial damage > The student pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup. - [NTSB WPR22FA303](https://openairdocs.org/ntsb/WPR22FA303.md): Cessna T207A · Page, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Aug 13, 2022 · N9582M · Substantial damage > The total loss of engine power for undetermined reasons during low altitude cruise flight, which resulted in a water ditching. Contributing to the severity of the accident was the pilot’s failure to extend the flaps during the ditching, which increased the… - [NTSB WPR22LA165](https://openairdocs.org/ntsb/WPR22LA165.md): Cessna 182G · Eloy, AZ · Accident · Class 4 · Limited · Final report · Apr 25, 2022 · N3694U · Substantial damage > The unoccupied airplanes exceedance of the critical angle of attack which resulted in a stall, subsequent inverted spin, and impact with terrain. - [NTSB WPR22FA094](https://openairdocs.org/ntsb/WPR22FA094.md): Dassault Mirage F1 CR · Glendale, AZ · Accident · Minor injuries · Class 3 · Field · Final report · Feb 10, 2022 · N633AX · Destroyed > A loss of engine power due to fuel exhaustion as result of the failure of maintenance personnel to ensure the airplane was serviced with the correct amount of fuel, the failure of maintenance personnel and the pilot to adequately check the airplane’s… - [NTSB WPR22LA081](https://openairdocs.org/ntsb/WPR22LA081.md): Piper PA-28 · Scottsdale, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 18, 2022 · N5276W · Substantial damage > A loss of engine power due to oil exhaustion. - [NTSB WPR22FA073](https://openairdocs.org/ntsb/WPR22FA073.md): Mooney M20C · Marana, AZ · Accident · 1 fatal · Class 3 · Field · Final report · Dec 31, 2021 · N6796N · Substantial damage > The pilot’s loss of airplane control due to spatial disorientation after entering instrument meteorological conditions. Contributing to the accident was the pilot’s impairment due to use of methamphetamine before the flight. - [NTSB WPR22LA035](https://openairdocs.org/ntsb/WPR22LA035.md): Sonex Waiex B · Laveen Village, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 15, 2021 · N535D · Substantial damage > Failure of the rocker swivel assembly due to either wear or corrosion, which resulted in a loss of engine power. Next page: https://openairdocs.org/ntsb-phases/400/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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/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.