NTSB investigations, 1990, AZ
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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
| 1963 | 1 |
|---|---|
| 1964 | 130 |
| 1965 | 107 |
| 1966 | 128 |
| 1967 | 138 |
| 1968 | 114 |
| 1969 | 115 |
| 1970 | 102 |
| 1971 | 128 |
| 1972 | 101 |
| 1973 | 105 |
| 1974 | 101 |
| 1975 | 121 |
| 1976 | 105 |
| 1977 | 123 |
| 1978 | 149 |
| 1979 | 130 |
| 1980 | 114 |
| 1981 | 132 |
| 1982 | 123 |
| 1983 | 114 |
| 1984 | 84 |
| 1985 | 78 |
| 1986 | 77 |
| 1987 | 76 |
| 1988 | 61 |
| 1989 | 79 |
| 1990 | 68 |
| 1991 | 86 |
| 1992 | 88 |
| 1993 | 68 |
| 1994 | 65 |
| 1995 | 73 |
| 1996 | 68 |
| 1997 | 71 |
| 1998 | 54 |
| 1999 | 64 |
| 2000 | 61 |
| 2001 | 63 |
| 2002 | 76 |
| 2003 | 93 |
| 2004 | 72 |
| 2005 | 81 |
| 2006 | 77 |
| 2007 | 66 |
| 2008 | 73 |
| 2009 | 74 |
| 2010 | 63 |
| 2011 | 67 |
| 2012 | 61 |
| 2013 | 54 |
| 2014 | 62 |
| 2015 | 42 |
| 2016 | 40 |
| 2017 | 50 |
| 2018 | 60 |
| 2019 | 47 |
| 2020 | 36 |
| 2021 | 44 |
| 2022 | 53 |
| 2023 | 43 |
| 2024 | 41 |
| 2025 | 45 |
| 2026 | 45 |
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 year(c.\"eventDate\") = 1990
AND c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 1990 AND c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA' 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 LAX91LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZBoth pilots used poor visual lookout procedures.NTSB LAX91LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Sierra Vista, AZLoss of engine power due to carburetor ice from improper use of the carburetor heat control.NTSB LAX91LA053Accident · 2 fatalLimited investigationFinal reportCessna T210N · Douglas, AZAn inflight loss of control of the airplane due to the pilot's physical impairment from the consumption of alcohol. A factor which contributed to the accident was an inoperative vacuum system.NTSB LAX91FA059Accident · 1 fatalField investigationFinal reportCessna 182C · Globe, AZThe pilot's failure to conduct a weather evaluation prior to flight and his attempt to conduct his flight under visual flight rules into instrument meteorological conditions. Low ceilings along his flight route and self induced pressure to reach his…NTSB LAX91LA049Accident · No injuriesLimited investigationFinal reportCessna 150 · Tucson, AZOne or more of the F-16 pilot's improper use of throttles before being cleared for take off.NTSB LAX91LA048Accident · No injuriesLimited investigationFinal reportCessna T-206 · Tonto Basin, AZThe failure of a connecting rod in the engine.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 LAX91LA038Accident · Serious injuriesLimited investigationFinal reportAerostar S-77A · Phoenix, AZStrength degradation of the kevlar suspension cables, due to previous heat damage. Factors related to the accident were: failure of the quick release line to release, and susceptibility of kevlar suspension cables to heat.NTSB LAX91LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Young, AZThe pilot selected the wrong runway and attempted to land with a tailwind.NTSB LAX91FA040Accident · 2 fatalField investigationFinal reportBeech S-35 · Kingman, AZProper altitude not maintained. Contributing to the accident was: the lack of supplemental oxygen on board the aircraft, pilot fatigue, improper use of the auto pilot, and pilot complacency.NTSB LAX91LA033Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Tuba City, AZFailure of the piston rings which reduced the available engine power, and the pilot's continued operation of his airplane with a known engine deficiency during the relatively high density altitude conditions.NTSB LAX91DUJ03Accident · No injuriesFinal reportAir Tractor AT-302 · Somerton, AZThe failure of the number 3 exhaust valve which led to an engine failure and subsequent crash landing.NTSB LAX91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Prescott, AZThe failure of the main landing gear trunion attach fitting for undetermined reasons.NTSB LAX91LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Portal, AZFailure of the pilot to maintain proper altitude.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 LAX91LA017Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Mobile, AZA fuel flow interruption due to a fuel system seal fragment becoming lodged in the fuel control unit and the manufacturer's inadequate quality control procedures.NTSB LAX91DUJ02Accident · No injuriesFinal reportJoe L. Harr SE-5A · Camp Verde, AZThe pilot's inadvertent shut-off of the fuel supply to the engine shortly after takeoff.NTSB LAX91DUJ01Accident · Serious injuriesFinal reportJoseph W. Hillbrand Sonerai IIL · Maricopa, AZAn engine failure due to improper fuel.NTSB LAX91LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Kearny, AZThe pilot executing a left turn at an altitude insufficient to clear a corn field located in close proximity to the departure runway.NTSB LAX91FA001Accident · 1 fatalField investigationFinal reportMooney M20K · Flagstaff, AZThe pilot's decision to operate the aircraft with a known discrepancy; inadequate maintenance procedures; and the pilot's inflight loss of control due to smoke and fumes in the cockpit.NTSB LAX90LA338Accident · Serious injuriesLimited investigationFinal reportMooney M-20-M · Flagstaff, AZEngine failure due to a ruptured fuel pump diaphragm. A factor in the accident was the unsuitable nature of the terrain to make a forced landing.NTSB LAX90LA342Accident · No injuriesLimited investigationFinal reportPiper J-3C-115 · Wickenburg, AZThe pilot's failure to maintain directional control.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 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 LAX90DUJ08Accident · Serious injuriesFinal reportRockwell S-2R · Yuma, AZFailure of the pilot to select a cruise altitude which would ensure adequate clearance from obstructions. A factor in the accident was the dark night which inhibited the pilot's ability to see the obstruction.NTSB LAX90FA320Accident · 2 fatalField investigationFinal reportCessna A152 · Tucson, AZFailure of the pilot to recover from a spin. Factors related to the accident were: the pilot's failure to assure there was adequate altitude to recover from an inadvertent or intentional spin, and his lack of recent expereince in the type of operation.NTSB LAX90LA302Accident · No injuriesLimited investigationFinal reportPiper PA38 · Chandler, AZThe student pilot's loss of control during takeoff. His inexperience in the aircraft and improper use of the flight controls were factors in the accident.NTSB LAX90DUJ09Accident · 1 fatalFinal reportStits SA6B · Tucson, AZThe failure of the pilot to maintain aircraft control.NTSB LAX90DUJ06Accident · 2 fatalFinal reportChristen/Walter Christen Eagle II · Marana, AZThe loss of control by the pilot.NTSB LAX90LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Tucson, AZThe pilot to maintain proper pitch attitude and airspeed to avoid an aerodynamic stall.NTSB LAX90DUJ07Accident · Minor injuriesFinal reportWarkentin KR-2 · Page, AZThe pilot's inadvertent deactivation of the fuel selector when he actuated the foot operated main landing gear.NTSB LAX90LA275Accident · No injuriesLimited investigationFinal reportRobinson R22B · Scottsdale, AZThe pilot's improper aircraft handling at a low altitude which resulted in a rate of descent that could not be arrested prior to colliding with the ground.NTSB LAX90LA344Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZThe pilot's failure to maintain adequate distance from a MD-80'S jet exhaust.NTSB LAX90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZThe failure of the pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's improper use of the airplane brakes.NTSB LAX90LA253Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Springerville, AZThe encounter with a downdraft beyond the climb capability of the aircraft.NTSB LAX90FA252Accident · 3 fatalField investigationFinal reportCessna T210N · Pinon, AZFailure of the pilot to attain the proper touchdown point during the landing, her delay in initiating a go-around (aborted landing), and her failure to remain clear of power lines on rising terrain during the aborted landing. Factors related to the accident…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 LAX90T#A08Accident · No injuriesClass 3Final reportBell 206B · San Carlos, AZNTSB LAX90FA235Accident · 3 fatalField investigationFinal reportCessna 177 · Lake Havasu, AZThe pilot's inflight loss of control due to failure to maintain adequate airspeed. Contributing to the accident was the high density altitude, overweight airplane, and the pilot's alcohol level.NTSB LAX90LA254Accident · No injuriesLimited investigationFinal reportCessna T207A · Grand Canyon, AZThe pilot's misjudgement of clearance from a parked aircraft while taxiing.NTSB LAX90LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Show Low, AZThe pilot improperly used the flight controls and failed to maintain directional control.NTSB LAX90LA158Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Phoenix, AZThe pilot failed to maintain control of the airplane.NTSB LAX90LA215Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Marble Canyon, AZInadequate compensation for wind conditions by the pilot and his delay in attempting a go-around. Factors related to the accident were: the surrounding terrain, unfavorable weather conditions, the pilot's failure to attain the proper touchdown point, and…NTSB LAX90LA198Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Glendale, AZFuel exhaustion. Resulting from the pilot's failure to perform refueling.NTSB LAX90LA197Accident · Minor injuriesLimited investigationFinal reportMooney M20A · Apache Junction, AZFailure of the pilot in command to properly manage the aircraft fuel quantity gauge indication and failure to complete the proper emergency procedure by switching fuel tanks. Contributing to the accident was improper maintenance performed by the pilot which…NTSB LAX90FA202Accident · No injuriesField investigationFinal reportRobinson R22B · Payson, AZControl interference which the CFI encountered during landing flare. Contributing factors related to the student not understanding communications from the CFI, the unclear language and the operator's inadequate certification of the airman.NTSB LAX90LA193Accident · Minor injuriesLimited investigationFinal reportCessna 310G · Sedona, AZThe pilot selected the wrong runway, and proper touch down point was not attained.NTSB LAX90LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe failure of the student pilot to maintain an appropriate airspeed during the attempted go-around.NTSB LAX90LA175Accident · No injuriesLimited investigationFinal reportPiper PA23-160 · Flagstaff, AZThe failure of the pilot to maintain directional control and to feather the propeller. A factor was erratic power from the left engine due to the jamming of the fuel selector valve in an intermediate position.NTSB LAX90LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mesa, AZThe pilot-in-command's failure to maintain safe airspeed and inadvertent stall. Contributing to the accident was the pilot's misjudging fuel supply.