NTSB investigations, AZ
92 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 8 |
| 1984 | 6 |
| 1985 | 2 |
| 1986 | 8 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 3 |
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\" = 240)
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" = 240) 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 SEA07FA199Accident · 2 fatalField investigationFinal reportCessna 182S · New River, AZThe pilot's inadvertent VFR flight into IMC and his ensuing failure to maintain aircraft control while in cruise flight. Contributing factors were the cloudy weather and the dark night conditions.NTSB SEA07CA175Accident · No injuriesData collectionFinal reportBurkhart Grob G102 Std Astir III · Wickenburg, AZThe pilot's inadequate compensation for wind conditions which resulted in an inflight collision with a cactus tree while landing. The loss of thermal lift, tailwind, gusts, and tree were contributing factors to the accident.NTSB SEA07LA118Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Kayenta, AZThe overstress separation of both ruddervators during cruise flight. Contributing to the accident was the flight's encounter with turbulence.NTSB LAX07FA021Accident · 4 fatalField investigationFinal reportCirrus SR22 · Meadview, AZThe pilot's inadequate weather evaluation and continued flight into forecasted icing conditions. Contributing to the severity of the accident was the pilot's failure to follow proper operating procedures and deploy the CAPS when the airplane entered a spin.…NTSB LAX06LA247Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Flagstaff, AZthe pilot's inadequate preflight planning decision to take off under a low ceiling into an area of mountainous terrain that resulted in an encounter with lowering clouds and forced the pilot to land in unfavorable terrain.NTSB LAX06FA130Accident · 2 fatalField investigationFinal reportBeech F33A · Kingman, AZThe noninstrument rated pilot's cruise flight into instrument meteorological conditions, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent, and an in-flight collision with terrain. Factors associated with the…NTSB LAX06CA102Accident · No injuriesData collectionFinal reportCessna 182 · Black Canyon, AZthe pilot's encounter with downdraft at low altitude on short final approach to land.NTSB LAX06CA012Accident · Serious injuriesData collectionFinal reportAerostar RX-8 · Globe, AZthe pilot's encounter with a wind gust during landing.NTSB LAX05CA161Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus 2b · Peoria, AZthe glider pilot encountered a downdraft that forced him to land in rough terrain.NTSB LAX05LA080Accident · No injuriesLimited investigationFinal reportCessna T210N · Glendale, AZThe airplane was struck by lightning during the approach to land.NTSB LAX05FA045Accident · 1 fatalField investigationFinal reportCessna T310R · Flagstaff, AZThe pilot's decision to attempt flight into known adverse weather conditions beyond the capability of the airplane and his failure to ensure that the airplane's wings were free of ice and/or snow contamination that accumulated while the airplane was on the…NTSB LAX04LA087Accident · No injuriesLimited investigationFinal reportCessna 421C · Window Rock, AZthe pilot's failure to maintain adequate airspeed in the landing flare to compensate for airframe icing, which resulted in a premature stall and hard landing. The degraded aircraft performance due to airframe ice was a contributing factor.NTSB LAX03LA181Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-321 · Payson, AZThe flight's encounter with convectively induced turbulence associated with developing thunderstorms while the flight crew attempted to deviate around an area of adverse weather. The turbulence event occurred while the crew was attempting to maneuver around…NTSB LAX03LA168Accident · Serious injuriesLimited investigationFinal reportAero Commander 500B · Grand Canyon, AZthe pilot's encounter with a wind shear just after liftoff.NTSB LAX03FA069Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Flagstaff, AZthe pilot's failure to comply with his instrument clearance route instruction and to maintain his assigned altitude. A factor in the accident was the poor quality of radio communications due to the severance of underground fiber optic voice and data lines for…NTSB DEN03FA012Accident · 4 fatalField investigationFinal reportCessna 208B · Parks, AZthe pilot's improper in flight planning/decision making, his flight into known icing conditions, and his failure to maintain adequate airspeed which resulted in the inadvertent stall/spin and impact with terrain. Factors contributing to the accident were the…NTSB LAX02FA278Accident · 1 fatalField investigationFinal reportBeech A36 · Grand Canyon, AZthe pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed which resulted in an encounter with adverse weather conditions and the loss of control due to a stall. Contributing factors were thunderstorm related turbulence,…NTSB LAX01FA145Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Sierra Vista, AZthe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in an in-flight collision with mountainous terrain. Factors in the accident included the adverse weather conditions and the dusk lighting conditions.NTSB LAX00FA324Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Scottsdale, AZthe pilot's failure to maintain adequate terrain clearance during a cruise descent, which resulted in controlled flight into mountainous terrain during dark night conditions. Contributing factors were the rain, thuderstorm, and dust storm weather conditions,…NTSB LAX00LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly II · Phoenix, AZThe pilot's failure to use pibals or other on site wind determination devices, and his subsequent failure to detect adverse wind conditions prior to launch of the balloon.NTSB LAX00LA219Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mesa, AZthe failure of the pilot to maintain directional control in that he failed to properly position the ailerons during his landing roll. Gusty, crosswind conditions, from a direction and velocity that equaled the aircraft's maximum demonstrated crosswind…NTSB LAX99FA273Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 11 · Cave Creek, AZAn unforecast encounter with a low level microburst that resulted in a distortion of the balloon envelope, an excessive outflow of hot air (loss of lift), creating an excessive rate of descent that was beyond the performance capability of the balloon to…NTSB LAX99LA093Accident · Serious injuriesLimited investigationFinal reportAerostar RX-9 · Peoria, AZThe pilot's attempted flight in an area of forecasted high winds and his inadequate compensation for those wind conditions once encountered.NTSB LAX98LA155Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Holbrook, AZThe pilot's failure to maintain directional control during a go-around after encountering a gust of wind.NTSB LAX98LA059Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Safford, AZThe pilot's poor in-flight judgement and intentional flight into known adverse weather conditions. Related factors were, mountainous terrain, rain and fog.NTSB LAX97FA093Accident · 1 fatalField investigationFinal reportCessna R172K · Bagdad, AZcontinued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from terrain. Factors relating to the accident were: the high/mountainous terrain and adverse weather conditions.NTSB LAX97FA082Accident · Minor injuriesField investigationFinal reportFairchild SA227-AC · Bullhead City, AZfailure of the pilot(s) to use 'override' ignition as prescribed by checklist procedures during an encounter with icing conditions, which subsequently led to ice ingestion and dual engine flame-outs. Factors related to the accident were: the adverse weather…NTSB LAX96FA294Accident · 1 fatalField investigationFinal reportMooney M20K · Grand Canyon, AZdue to an in-flight loss of control resulting from a probable incapacitation for unknown reasons. The loss of control occurred while the aircraft was being flown in close proximity to a level 6 thunderstorm. The failure of the pilot to obtain current weather…NTSB LAX95LA183Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's inflight loss of control due to his delay in releasing the glider after the towed glider experienced an unplanned altitude gain on takeoff when it encountered a dust devil.NTSB LAX95LA094Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sedona, AZthe pilot's improper compensation for the prevailing wind conditions, and his improper remedial action by raising the flaps before applying the power. The downdraft was a factor.NTSB LAX95FA262Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Flagstaff, AZthe pilot's intentional flight into known adverse weather conditions, his misjudged evaluation of the weather, and his inexperience in actual instrument flying.NTSB LAX95LA036Accident · Serious injuriesLimited investigationFinal reportThunder and Colt TC-180 · Peoria, AZthe flight's encounter with unforecasted high winds which resulted in a hard landing.NTSB LAX94LA045Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Florence, AZthe pilot's poor inflight planning and decision making by continuing the flight into adverse weather conditions. Factors contributing to this accident were: not obtaining a preflight weather briefing, not following the airplane flight manuals, and exceeding…NTSB LAX94FA028Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Simon, AZThe pilot's improper planning/decision, and his allowing the airplane to exceed its design stress limits, which resulted in overload failure of the right outboard wind section and left horizontal stabilizer. Factors related to the accident were: the adverse…NTSB LAX93LA056Accident · 2 fatalLimited investigationFinal reportCessna 182K · Flagstaff, AZThe pilot's continued flight into instrument meteorological conditions and improper remedial action by descending into high terrain. Contributing to this accident were the prevailing cloud condition.NTSB LAX93LA027Accident · No injuriesLimited investigationFinal reportBeech 36TC · Sedona, AZThe pilot's poorly planned approach and delay in executing the appropriate remedial action. Contributing to this accident was the pilot's failure to maintain the proper glidepath and encountering a downdraft.NTSB LAX93LA022Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX7-77 · Sierra Vista, AZThe flight's encounter with unforecast unfavorable winds.NTSB LAX93LA008Accident · No injuriesLimited investigationFinal reportCessna R172K · Picacho, AZThe pilot's encounter with the unforecasted cyclonic wind.NTSB LAX92LA133Accident · Minor injuriesLimited investigationFinal reportHelio HST-550A · Salome, AZThe pilot's inadequate in-flight planning, improper altitude, and delaying the required remedial action to prevent the collision with the mountain. Contributing to the accident was the unfavorable wind and downdraft conditions.NTSB LAX91LA406Accident · Serious injuriesLimited investigationFinal reportCallair A-3 · Williams, AZThe pilot's encounter with a strong and gusty cross-wind which suddenly developed in the area and his subsequent loss of control. Factors which contributed to the accident were the pilot's inadequate airspeed and inability to adequately compensate for the…NTSB LAX91LA245Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Williams, AZThat the flight encountered windshear and that aircraft control was not possible.NTSB LAX91FA106Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Fredonia, AZThe pilot's inattention to the airspeed and subsequent loss of aircraft control after attempting VFR flight into adverse weather conditions. Contributing to the accident was the pilot's failure to recognize his limitations of his aircraft.NTSB LAX91FA045Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Show Low, AZThe pilot's improper in-flight planning/decision, which resulted in loss of engine power, due to induction system icing. Factors related to the accident were: the adverse weather condition and lack of a suitable area for a forced landing.NTSB LAX91LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe failure of the flight instructor to ensure that an adequate airspeed was maintained during the final approach for the existing wind conditions; to adequately supervise the conduct of the flight; and to arrest the rate of descent prior to touch down.NTSB LAX90FA331Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Flagstaff, AZVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude during the approach to land. Factors related to the accident were: darkness, the adverse weather conditions, and failure of…NTSB LAX90LA253Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Springerville, AZThe encounter with a downdraft beyond the climb capability of the aircraft.NTSB LAX90LA080Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Glendale, AZImproper planning/decision by the pilot. The unexpected high wind condition was a related factor.NTSB LAX90LA048Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Chandler, AZImproper planning/decision by the pilot. Factors related to the accident were: variable and high wind conditions.NTSB LAX89LA131Accident · Serious injuriesLimited investigationFinal reportAerostar Raven 560 · Tucson, AZBalloon entered into a severe down draft which resulted in a hard landing due to inadequate preparation and compensation for the conditions by the balloon pilot.NTSB LAX89LA104Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Phoenix, AZThe pilot displayed poor preflight planning and preparation by not properly evaluating the weather conditions.