NTSB investigations, AZ
83 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 5 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 8 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 4 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
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\" = 310)
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" = 310) 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 LAX08CA039Accident · No injuriesData collectionFinal reportCessna 310R · Phoenix, AZThe pilot's selection of a wrong taxi route, inadequate visual lookout, failure to maintain separation from ground obstacles, and excessive taxi speed.NTSB LAX07CA250Accident · No injuriesData collectionFinal reportCessna 182H · Page, AZthe pilot's failure to maintain clearance with obstructions while taxiing behind parked airplanes.NTSB LAX06CA139Accident · No injuriesData collectionFinal reportBeech G35 · Flagstaff, AZthe pilot's failure to maintain an adequate clearance with obstructions while taxiing.NTSB LAX06CA122Accident · No injuriesData collectionFinal reportCessna 172P · Sedona, AZThe pilot's failure to maintain an adequate clearance from obstructions and diverted attention while taxiing.NTSB LAX06CA083Accident · No injuriesData collectionFinal reportPiper J5 · Carefree, AZthe pilot's selection of unsuitable terrain for the precautionary landing and failure to avoid obstacles during the landing roll.NTSB LAX06LA009Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Phoenix, AZThe failure of the other flight crew to maintain an adequate clearance from obstructions while taxiing.NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.NTSB LAX05LA038Accident · No injuriesLimited investigationFinal reportBeech 99 · Phoenix, AZthe pilot's inadequate visual lookout and failure to maintain clearance from obstacles while taxing in a nonmovement area at night.NTSB LAX04CA296Accident · No injuriesData collectionFinal reportPilatus PC-12/45 · Show Low, AZthe collision with an elk during the landing roll. The dark night lighting conditions was a factor.NTSB LAX04CA208Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe backhoe driver's failure to maintain visual lookout while maneuvering near a taxiway, which resulted in its collision with a taxiing airplane.NTSB LAX03LA295Accident · No injuriesLimited investigationFinal reportde Havilland DH-8-202 · Phoenix, AZthe ground agent's inadequate visual lookout during push back, which resulted in his failure to maintain clearance between the airplanes.NTSB LAX03LA144Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bullhead City, AZThe pilot's misjudgment of distance resulting in the inadequate clearance between the wing tip and the fuel truck.NTSB LAX03LA099Accident · No injuriesLimited investigationFinal reportAerostar International S-71A · Scottsdale, AZthe pilot's inadequate in-flight decision to cross over four sets of power lines with the existence of a known low fuel state and lack of wind, and failure to maintain altitude/clearance from the power lines during the landing, which resulted in the envelope…NTSB LAX02LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodyear, AZThe student pilot's misjudgment of clearance and his failure to adhere to the flight school's policy/procedures for taxiing around obstructions.NTSB LAX02LA098Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Peoria, AZFailure of the cyclist to coordinate and communicate that he was on the active runway. A contributing factor was the sun glare encountered by the pilot on final approach.NTSB LAX02LA014Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Mesa, AZThe pilot's inadequate compensation for an existing crosswind condition, and failure to maintain directional control on the landing rollout.NTSB LAX01LA226Accident · No injuriesLimited investigationFinal reportMooney M20C · Tucson, AZThe airplane's collision with a perimeter roadway vehicular traffic sign due to the pilot's diverted attention and inadequate visual lookout while taxiing from landing. A contributing factor was the lack of sign conspicuity.NTSB LAX01LA175Accident · No injuriesLimited investigationFinal reportAviat A-1A · TontoNat.Forest, AZThe pilot's inadequate crosswind correction compensation during landing and his failure to maintain proper alignment with the usable runway. A contributing factor was the presence of bushes in proximity to the airstrip.NTSB LAX00LA268Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Payson, AZThe pilot's selection of an unsuitable takeoff area. Contributing factors were the high density altitude and proximity to vegetation.NTSB LAX00LA015Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Phoenix, AZThe airline's failure to fully review the obstruction clearances and revise the pushback procedures in an area of the ramp where new construction had impinged on the available ramp space. Also causal was the failure of the tug driver and the wing walkers to…NTSB LAX99LA298Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Prescott, AZThe pilot's failure to maintain an adequate clearance from ground obstructions during an off-airport landing. The pilot's inability to locate suitable thermal activity to remain aloft is a factor in the accident.NTSB LAX99LA322Accident · No injuriesLimited investigationFinal reportBoeing 757-2G7 · Phoenix, AZThe failure of the flight crew and the tug driver to verify that the aircraft was properly configured for pushback. Factors in the accident were the left wing walker's failure to notify the tug driver of his observations that the jet bridge was still in…NTSB LAX99LA178Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Clarkdale, AZThe pilot's selection of unsuitable terrain during a high wind condition. Contributing factors were the high winds and the tree.NTSB LAX99LA018Accident · No injuriesLimited investigationFinal reportBeech C90 · Sedona, AZThe instructor's failure to maintain runway alignment during the takeoff roll.NTSB LAX98LA190Accident · No injuriesLimited investigationFinal reportFones Z-MAX 1300 · Buckeye, AZthe failure of the pilot to maintain control of the aircraft during the landing approach, and his poor in-flight planning in making an off-airport landing at an unsuitable landing area.NTSB LAX98LA082Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Chinle, AZthe airport personnel's failure to provide an adequate perimeter barrier to prevent animals from entering the runway area. A factor in the accident was the dark night lighting conditions which hindered the pilot's ability to detect animals on the runway…NTSB LAX98LA070Accident · No injuriesLimited investigationFinal reportBritish Aerospace Jetstream 3101 · Phoenix, AZThe pilot's exercising poor judgement to continue to taxi under a covered T-hanger during nighttime conditions without proper clearance between the hanger and the aircraft.NTSB LAX97LA290Accident · No injuriesLimited investigationFinal reportCessna 185 · Buckeye, AZThe pilot's misjudgement of the clearance between the aircraft and the tree.NTSB LAX97LA264Accident · No injuriesLimited investigationFinal reportCessna A150L · Quartzsite, AZThe student pilot's decision to land the airplane on a residential street, where the airplane subsequently hit a sign during the landing roll. Factors related to the accident were the student pilot becoming lost/disoriented during his cross country flight and…NTSB LAX97LA191Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Payson, AZan animal (elk) on the runway. Factors associated with the accident included: darkness, the pilot's inability to see the animal in sufficient time to avoid a collision, and the lack of a taller fence around the airport.NTSB LAX97LA124Accident · Serious injuriesLimited investigationFinal reportAerostar RX7 · Tucson, AZfailure of the pilot to maintain safe altitude/clearance from another balloon, while landing in a crowded area.NTSB LAX96LA268Accident · No injuriesLimited investigationFinal reportMooney M20C · Payson, AZanimals on the runway. A factor was the dark night.NTSB LAX96LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Mohave Valley, AZthe failure of the pilot to assure that clearance was maintained while taxiing in proximity of buildings at an excessive taxi speed.NTSB LAX95LA276Accident · No injuriesLimited investigationFinal reportNorth American AT-6B · Glendale, AZThe failure of the pilot of the other aircraft to follow pre-briefed instructions and failure to see and avoid the preceding aircraft awaiting takeoff.NTSB LAX95LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Tucson, AZthe pilot's failure to maintain adequate clearance from a taxiway sign while taxiing clear of the runway.NTSB LAX95LA066Accident · No injuriesLimited investigationFinal reportCessna 207 · Fort Huachuca, AZThe failure of the radar and tower controllers to ensure that the pilot was aware of the runway status. Factors related to the accident were the downwind no-flap landing and the sunglare.NTSB LAX95LA012Accident · No injuriesLimited investigationFinal reportPitts S-2B · Chandler, AZthe pilot's failure to maintain proper alignment with the runway during landing rollout. A contributing factor was sun glare.NTSB LAX94LA365Accident · No injuriesLimited investigationFinal reportCessna 210L · Payson, AZAnimals on the runway.NTSB LAX94LA347Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZthe pilot's failure to properly secure the aircraft prior to a start attempt by handpropping.NTSB LAX94LA302Accident · No injuriesLimited investigationFinal reportCessna 421C · Polacca, AZthe pilot's attempt to make a 180-degree turn in soft sand at a speed which imposed side loading on the nose gear. Factors were the pilot's decision to continue the approach beyond the planned touchdown point, the effect of the runway surface on braking…NTSB LAX94LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Phoenix, AZthe pilot's failure to ensure that the magneto switch was in the off position prior to rotating the propeller by hand.NTSB LAX94LA179Accident · No injuriesLimited investigationFinal reportCessna 177RG · Sedona, AZthe pilot's inadequate compensation of the existing wind conditions, and failure to maintain directional control of the aircraft.NTSB LAX94LA140Accident · No injuriesLimited investigationFinal reportCessna 150 · Chandler, AZThe pilot's intentional swerve to avoid a large bird that flew toward the airplane during the landing roll.NTSB LAX93LA331Accident · Serious injuriesLimited investigationFinal reportUltimate 10-80 · Chandler, AZThe noncertificated pilot's failure to follow the prescribed VFR procedures and poor visual lookout. The other aircraft pilot's restricted visual lookout was a factor in this accident.NTSB LAX93FA316Accident · Serious injuriesField investigationFinal reportBell 206L1 · Tusayan, AZFailure of the pilot of N444CR to maintain adequate main rotor clearance from N38903, and the operator's failure to provide adequate or recommended safe helipad dimensions. A factor in the accident was the lack of visual reference to the rotating blades of…NTSB LAX93LA251Accident · No injuriesLimited investigationFinal reportAlon A2 · Goodyear, AZthe pilot's failure to maintain adequate obstruction clearance while taxiing. A factor in the accident was the pilot's attention being diverted by the movement of two trucks.NTSB LAX92LA248Accident · No injuriesLimited investigationFinal reportCessna 172L · Safford, AZThe airplane colliding with animals which ran on to the runway during the pilot's takeoff roll. A factor in this accident was the pilot not being able to take remedial action and avoid the animals.NTSB LAX92LA098Accident · No injuriesLimited investigationFinal reportMooney M20J · Bullhead City, AZThe pilot of the other aircraft inadvertently landing on the taxiway instead of the active runway.NTSB LAX91LA352Accident · No injuriesLimited investigationFinal reportCessna 210 · Chino Valley, AZThe failure of the pilot to maintain directional control. A factor in the accident was the slippery condition of the road surface being used as a runway.NTSB LAX91LA350Accident · No injuriesLimited investigationFinal reportCessna 402C · Grand Canyon, AZThe failure of the airport operator to develop animal control procedures for the airport property.