NTSB investigations, AZ
16 cases where the first occurrence was “Midair collision”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 270)
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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 270) 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 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 LAX04FA304Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Prescott, AZThe failure of both pilots to maintain adequate clearance from each other while performing formation aerobatic maneuvers.NTSB ANC04FA016Accident · 4 fatalField investigationFinal reportPiper J3C-65 · Peoria, AZThe inadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft and a subsequent midair collision. A factor associated with the accident was the airplane pilot's failure to determine that…NTSB LAX03FA066Accident · 2 fatalField investigationFinal reportCessna 182H · Parker, AZfailure of both pilot's to see and avoid one another while maneuvering in the traffic pattern. A factor in the accident was the inability of the Cessna pilot to communicate on the CTAF frequency due to the limitations of his radios.NTSB LAX02FA110Accident · 1 fatalField investigationFinal reportPilatus UV-20A · Marana, AZthe failure of both pilots to maintain an adequate visual lookout. The failure of the Pilatus pilot to report his proper position was a factor.NTSB LAX99LA204Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesa, AZThe failure of the tower (local) air traffic controller to issue a landing sequence to the climbing, high wing Cessna 172 aircraft, and, the controller's failure to maintain visual separation between the two aircraft on downwind leg.NTSB LAX99FA036Accident · 2 fatalField investigationFinal reportCessna 172P · Scottsdale, AZthe failure of the solo student pilot in the other aircraft to acquire and maintain separation from this aircraft, which was departing the airport traffic pattern and had been issued as traffic by the local controller. Also causal was the failure of the pilot…NTSB LAX94FA383Accident · 1 fatalField investigationFinal reportMcdonnell Douglas 520N · Mesa, AZFailure of the chase helicopter pilot to maintain clearance from the lead helicopter during a night approach to land. Possible factors relating to the accident were: darkness, and inadequate radio coordination between flight crews of the two helicopters.NTSB LAX92LA157Accident · No injuriesLimited investigationFinal reportCessna 172 · Prescott, AZThe other airplane's flight instructor's poor supervision of the flight; the other airplane's flight instructor's and dual student's misidentification of the airplane the student pilot was following and the other airplane's flight instructor's and dual…NTSB LAX91LA120Accident · No injuriesLimited investigationFinal reportBoeing A75 · Marana, AZThe failure of the pilot in the trailing airplane to maintain clearance from the lead airplane.NTSB LAX89FA318Accident · No injuriesField investigationFinal reportCessna 152 · Chandler, AZThe failure of the pilot's of both aircraft to maintain adequate visual outlook for other aircraft.NTSB LAX89FA120Accident · 4 fatalField investigationFinal reportCessna 170B · Casa Grande, AZThe pilot in command's performance of aerobatic maneuvers, while flying in formation, and his failure to maintain proper clearance.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 LAX86LA034Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Chandler, AZDuring a dual instructional flight the CFI stated that he was looking for traffic while monitoring his student's performance. The CFI failed to observe that an acft was ahead of him in the traffic pattern. That acft was at a lower altitude & was on short…NTSB LAX85FA202Accident · 2 fatalField investigationFinal reportCessna 172M · Camp Verde, AZBoth acft involved in the collision were part of a 4-plane formation flt en route to a group fly-in. N6439R was seen to change positions several times during the flt while the other acft remained stable. Reports from witnesses say that N6439R made 'close…NTSB LAX82AA106Accident · 6 fatalFinal reportBoeing KC-135A · Glendale, AZThe USAF KC-135 was on an IFR flt plan & executing a tacan 3L apch to luke afb. The AA-1 had departed sky harbour arpt &had been released by phoenix trsa. The AA-1 was heading westerly in airspace designated as a special traffic area & was required to have…