NTSB investigations, AZ
28 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1983 | 2 |
|---|---|
| 1986 | 2 |
| 1989 | 4 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 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\" = 430)
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" = 430) 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 LAX07IA191Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZAn out of rig/jammed door. Contributing to the incident was the operator's inadequate maintenance program and the airframe manufacturer's inadequate response to the issue.NTSB SEA07CA117Accident · No injuriesData collectionFinal reportCessna U206G · Glendale, AZThe pilot's failure to properly latch the door prior to takeoff.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 LAX05CA104Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Williams, AZthe pilot's improper ground handling procedure and failure to ensure the magnetos were off prior to movement of the propeller.NTSB LAX05LA094Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · Cave Creek, AZthe pilot's inadequate handling of the balloon during boarding resulting in a passenger falling and sustaining a serious injury.NTSB LAX04CA003Accident · Minor injuriesData collectionFinal reportBalloon Works Firefly II · Phoenix, AZthe pilot's diverted attention that resulted in the inadequate handling of the burner during ground operations.NTSB LAX03TA150Accident · Serious injuriesFinal reportHughes OH 6A · Pan Tak, AZThe pilot in command's failure to adequately secure loose cargo (a jacket), which resulted in the jacket colliding with the tail rotor during cruise flight, and the subsequent separation of the tail rotor and loss of flight control. A factor associated with…NTSB LAX02LA137Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Scottsdale, AZThe flight instructor's inadequate remedial action following the onset of ground resonance.NTSB LAX01LA086Accident · Minor injuriesLimited investigationFinal reportStorey MK 7 · Marana, AZThe pilot's inadequate preflight preparation with regards to runway choice, terrain, and performance capabilities of the airplane.NTSB LAX00FA213Accident · No injuriesField investigationFinal reportCessna 414A · Prescott Valley, AZThe pilot's physical impairment due to the cumulative effects of carbon monoxide from engine exhaust by-products, carbon monoxide from heavy tobacco use, and the loss of an undetermined amount of cabin pressurization. A factor in the loss of pressurization…NTSB LAX00LA156Accident · No injuriesLimited investigationFinal reportBell 407 · Grand Canyon, AZThe failure and subsequent disintegration of the oil cooler fan forward hanger bearing.NTSB LAX99IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Phoenix, AZThe failure of the ground handling personnel to properly secure the aft cargo door following the loading of the late arriving baggage. A factor in the incident was an intermittent cargo door warning light circuit due to contamination in the proximity switch…NTSB LAX98LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Page, AZFailure of the pilot to verify throttle position and/or obtain qualified assistance while hand propping the aircraft engine.NTSB LAX97LA133Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Sacaton, AZthe pilot's improper use of the collective by not maintaining rotor rpm during takeoff from a confined area.NTSB LAX97LA034Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Flagstaff, AZAn uncommanded main rotor blade to tail boom contact due to a 'blowback' phenomena after a successful preplanned autorotation by the pilot to a high density altitude airport with a test aircraft designed at a maximum gross weight.NTSB LAX95FA076Accident · 1 fatalField investigationFinal reportCessna 208B · Flagstaff, AZThe pilot's failure to properly configure the aircraft fuel system prior to takeoff, and his failure maintain an adequate terrain clearance altitude while maneuvering to return to the airport. Factors in the accident were the dark night lighting conditions,…NTSB LAX94LA333Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Phoenix, AZthe failure of the headset operator to adhere to established company safety procedures when he diverted his attention during pushback. A factor in the accident was the airline's failure to modify its ground handling procedures and equipment to eliminate the…NTSB LAX93LA366Accident · 1 fatalLimited investigationFinal reportCessna 182H · Flagstaff, AZthe pilot's sudden incapacation due to a fatal heart attack.NTSB LAX92LA147Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Phoenix, AZThe ground guide's failure to follow established procedures and his improper visual lookout by failing to remain clear of the nose gear during the push back operation.NTSB LAX90FA250Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Pleasant Valley, AZAn inadvertent spin after failure to maintain airspeed. Factors include inadequate preflight, and an improperly maintained lap belt.NTSB LAX90LA021Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2S7 · Phoenix, AZThe ground handler improperly crossing under the aircraft while it was moving.NTSB LAX89LA274Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Benson, AZThe pilot's failure to maintain adequate airspeed during an emergency descent and to properly flare the aircraft during landing. Contributing to the accident was the pilot's anxiousness in over-reacting to a situation and prematurely entering a power-off…NTSB LAX89LA328Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace 3201 · Bullhead City, AZThe deplaning passenger's failure to observe a raised and marked area in the passenger cabin floor exit aisle. Contributing factors to the accident were: darkness and the fuselage floor exit aisle was designed with a raised area which partially obstructed its…NTSB LAX89FA111Accident · 1 fatalField investigationFinal reportCessna 340A · Safford, AZThe pilot's poor judgement and the resultant hypoxia sustained in the unpressurized airplane. Factors were: the malfunctioning pressurization system and the pilot's decision to continue operation with that known discrepancy.NTSB LAX86LA357Accident · No injuriesLimited investigationFinal reportCessna 210N · Douglas, AZThe acft was found abandoned 25 miles west of Douglas, Arizona. A landing was made on a dirt road where the acft contacted a ditch and nosed over. The acft was reported stolen and the plt was not located. According to the local sheriff's office, traces of…NTSB LAX86LA228Accident · Minor injuriesLimited investigationFinal reportBeech A19 · Taylor, AZThe acft collided with wires after a loss of alt during the initial climb while on a night VFR flt. The plt indicated that it took 3/4 of the rwy to get airborne and the acft did not seem to climb with full pwr applied. The plt decided to return to the arpt…NTSB LAX83FUJ16Accident · Serious injuriesFinal reportSemco Challenger · Tucson, AZThe pilot was outside the basket when the balloon took off. He grabbed the deflation handle and the balloon carried him aloft. He fell from about 40 ft AGL onto his head and was seriously injured. The pilot reportedly was going to tether the balloon. During…NTSB LAX83LA250Accident · No injuriesLimited investigationFinal reportCessna 337B · Sedona, AZThe acft made a forced landing and collided with a pine tree after a takeoff with a tow bar attached to the nose gear. The pilot reported that he attached a tow bar to get the acft level to measure the oil quantity in the engine. After thepreflt inspection he…