Major NTSB investigations, AZ
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1977 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2011 | 2 |
| 2018 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') 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 WPR25FA088Accident · 1 fatalClass 2 · FieldPreliminary reportGates Learjet 35A · Scottsdale, AZOn February 10, 2025, about 1438 mountain standard time, a Gates Learjet 35A, was substantially damaged when it was involved in an accident near Scottsdale, Arizona. The captain was fatally injured, the first officer (FO) and one passenger were seriously…NTSB WPR18MA087Accident · 5 fatalClass 3 · MajorFinal reportEurocopter EC130 · Peach Springs, AZA 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 WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…NTSB DCA11MA039Accident · Minor injuriesMajor investigationFinal reportBoeing 737 · Yuma, AZthe improper installation of the fuselage crown skin panel at the S-4L lap joint during the manufacturing process, which resulted in multiple site damage fatigue cracking and eventual failure of the lower skin panel. Contributing to the injuries was flight…NTSB DEN08MA116Accident · 7 fatalMajor investigationFinal reportBell 407 · Flagstaff, AZBoth helicopter pilots’ failure to see and avoid the other helicopter on approach to the helipad. Contributing to the accident were the failure of N407GA’s pilot to follow flight arrival route guidelines, and the failure of N407MJ’s pilot to follow…NTSB LAX07MA231Accident · 4 fatalClass 1 · MajorFinal reportEurocopter AS350-B2 · Phoenix, AZBoth pilots' failure to see and avoid the other helicopter. Contributing to this failure was the pilots' responsibility to perform reporting and visual tracking duties to support their station's ENG operation. Contributing to the accident was the lack of…NTSB CHI06MA121Accident · No injuriesMajor investigationFinal reportGeneral Atomics Predator B · Nogales, AZThe pilot's failure to use checklist procedures when switching operational control from PPO-1 to PPO-2, which resulted in the fuel valve inadvertently being shut off and the subsequent total loss of engine power, and lack of a flight instructor in the GCS, as…NTSB LAX03MA292Accident · 7 fatalClass 1 · MajorFinal reportAerospatiale AS350BA · GrandCanyonWest, AZThe pilot's disregard of safe flying procedures and misjudgment of the helicopter's proximity to terrain, which resulted in an in-flight collision with a canyon wall. Contributing to the accident was the failure of Sundance Helicopters and the Federal…NTSB LAX01MA272Accident · 6 fatalMajor investigationFinal reportEurocopter AS350-B2 · Meadview, AZThe pilot’s loss of control of the helicopter for undetermined reasons.NTSB DCA95MA019Accident · 8 fatalMajor investigationFinal reportPiper PA-31-350 · Tusayan, AZa loss of power on one engine for an undetermined reason(s), and the pilot's improper decision to return to the departure airport for landing which neccessitated maneuvering over increasingly higher terrain. Factors in the accident were: the high gusting…NTSB DCA92MA040Accident · 10 fatalMajor investigationFinal reportCessna 402C · Meadview, AZFailure of the pilot to follow the emergency procedure (engine failure after takeoff) and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were failure (disengagement) of the…NTSB DCA90MA055Accident · 1 fatalMajor investigationFinal reportBoeing 707-321B · Marana, AZImproper preflight planning/preparation by the pilot, and his failure to use a checklist. Factors related to the accident were: the faa's inadequate surveillance of the operation, the faa's insufficient standards/requirements, the pilot's operation of the…NTSB DCA89MA076Accident · 10 fatalClass 1 · MajorFinal reportde Havilland DHC-6-300 · Grand Canyon, AZImproper pilot techniques and crew coordination during the landing attempt, bounce, and attempted go-around.NTSB DCA86AA028Accident · 25 fatalFinal reportde Havilland DHC-6-300 · Grand Canyon, AZAt about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the…NTSB DCA83AA034Accident · 10 fatalFinal reportPiper PA-31-350 · Peach Springs, AZThe acft departed las vegas, NV as the 2nd of 5 acft on a scheduled grand canyon sight-seeing flt. The 1st portion of the flt was over the las vegas strip area & lake mead & was uneventful. However, wx conditions precluded the plt from continuing over the…NTSB LAX77AA048Accident · No injuriesClosedBoeing 727 · Tucson, AZNTSB DEN72ID048Incident · No injuriesClosedDouglas DC-10 · Tucson, AZNTSB LAX71AL066Accident · 12 fatalClosedDehavilland 104-7X · Coolidge, AZ