NTSB investigations: Continental IO-520 series, AZ
167 cases on aircraft whose registry engine model is Continental IO-520 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases, newest first
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 LAX99LA094Accident · No injuriesLimited investigationFinal reportBeech F33 · Prescott, AZA total loss of engine power for undetermined reasons.NTSB LAX99LA021Accident · No injuriesLimited investigationFinal reportCessna 185E · Tucson, AZFailure of the pilot to properly secure the seat which subsequently slid back on the takeoff roll and lead to the pilot's loss of aircraft control.NTSB LAX98LA132Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30A · Prescott, AZThe pilot's failure to attain directional control after swerving off the runway and impacting a ditch.NTSB LAX97LA312Accident · No injuriesLimited investigationFinal reportCessna T210J · Avra Valley, AZThe pilot became lost/disoriented during his taxiing into the ramp area. Factors in the accident were the lack of taxiway lights, the pilot's lack of familiarity with the layout of the airport, and the airport operator's failure to either identify the…NTSB LAX97LA290Accident · No injuriesLimited investigationFinal reportCessna 185 · Buckeye, AZThe pilot's misjudgement of the clearance between the aircraft and the tree.NTSB LAX97LA041Accident · No injuriesLimited investigationFinal reportBeech F33A · Marana, AZimproper planning/decision by the flight instructor (CFI), which resulted in his failure to recover from a descent during demonstration of a simulated (engine-out) emergency procedure.NTSB LAX96LA307Accident · No injuriesLimited investigationFinal reportCessna A185F · Casa Grande, AZthe student pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop. Factors relating to the accident were: the student pilot's inadequate training and lack of certification (endorsement).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 LAX94LA365Accident · No injuriesLimited investigationFinal reportCessna 210L · Payson, AZAnimals on the runway.NTSB LAX94FA171Accident · 2 fatalField investigationFinal reportCessna 206 · Show Low, AZthe pilot's intentional VFR flight into known adverse IMC weather conditions. Inadequate preflight planning, dark night operations, and weather conditions that included low ceilings and mountain obscuration were factors in the accident.NTSB LAX94T#A02Accident · No injuriesClass 3Final reportCessna C206 · Chinle, AZNTSB LAX93LA252Accident · No injuriesLimited investigationFinal reportCessna 210L · Douglas, AZThe pilot's premature retraction of the landing gear and flaps at a critical time in the takeoff initial climb and his failure to attain an adequate climb airspeed which resulted in an inadvertent stall/mush condition. A factor in the accident was the high…NTSB LAX93FA186Accident · 2 fatalField investigationFinal reportBeech 58 · Tucson, AZThe pilots improper preflight inspection, his failure to compeltely secure the aft utility door, and his failure to reconfigure the trim tabs to a takeoff setting. The utility door's sudden opening just after rotation and the effect of the nose up trim…NTSB LAX93LA036Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Phoenix, AZThe dual students premature retraction of the landing gear during the takeoff portion of a touch and go, and, the inadequate supervision of the flight by the instructor pilot. Factors which contributed to the accident were the deactivation of the landing gear…NTSB LAX92LA341Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sedona, AZThe failure of the fixed base operator to properly conduct an annual inspection and inadequate compliance with the airworthiness directive. Contributing to this accident was the total failure of the main landing gear trunion due to fatigue.NTSB LAX92LA273Accident · No injuriesLimited investigationFinal reportCessna U206E · Mayer, AZThe failure of the engine due to the slippage of the number 2 main bearing and the resultant oil starvation failure of the number 2 connecting rod. The number 2 main bearing slippage was caused by the failure of the pilot/owner to overhaul the engine in a…NTSB LAX91LA258Accident · No injuriesLimited investigationFinal reportBeech F33A · Mobile, AZThe failure of the pilot of the other aircraft to exit the runway onto the taxiway at a speed sufficient to stop prior to colliding with the stopped aircraft.NTSB LAX91LA187Accident · No injuriesLimited investigationFinal reportBeech F33A · Goodyear, AZThe pilot's failure to ensure that the airplane's landing gear was extended by the passenger who he was allowing fly the airplane. A contributing factor related to the pilot's inadequate supervision of the passenger.NTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.NTSB LAX90LA147Accident · No injuriesLimited investigationFinal reportBeech F-33A · Goodyear, AZThe pilot's failure to follow directives and his misjudgement of distance. Contributing to the accident was the airport management's failure to ensure that the building did not pose a hazard.NTSB LAX89DUJ01Accident · Serious injuriesFinal reportCessna A188A · Casa Grande, AZDuring aerial application flight, the aircraft collided with a high-tension static wire and subsequently with the ground. Post-impact fire ensued. The pilot stated he misjudged his approach to the field and did not see the wire.NTSB LAX89FA001Accident · 1 fatalField investigationFinal reportBeech B23 · Scottsdale, AZThe pilot's mismanagement of fuel. Contributing to the accident was the inadequate lighting of the fuel selector valve.NTSB LAX88FA101Accident · 2 fatalField investigationFinal reportCessna U206F · Lk Havasu City, AZPilot's decision to continue flight in forecast marginal VFR conditions in mountainous terrain. Contributing to this accident was the failure of the pilot to obtain an aviation weather briefing and his lack of recurrent training.NTSB LAX87LA164Accident · No injuriesLimited investigationFinal reportBeech S35 · Tucson, AZThe aircraft door came open during the initial climb after takeoff because it was not properly closed and locked. The pilot raised the landing gear. Thereafter, because of slow acceleration, he elected to land on the remaining runway. He moved the landing…NTSB LAX87LA145Accident · No injuriesLimited investigationFinal reportCessna U206A · Williams, AZDuring a crosswind turn, shortly after takeoff, the pilot noticed that the fuel pressure gauge was registering a loss of fuel pressure and the engine was experiencing a smooth loss of power. The pilot said that he turned on the emergency boost pump and…NTSB LAX87FA200Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Flagstaff, AZThe plt & his wife desired to return to their Flagstaff, AZ, home following a weekend at stockton, CA., & they departed sck in VFR weather conditions. The weather at the destination arpt had been below VFR minimums all morning & it was forecast to remain poor…NTSB LAX85LA348Accident · No injuriesLimited investigationFinal reportCessna A188B · Willcox, AZOn August 15, 1985, a Cessna 180 lost eng pwr due to fuel exhaustion and collided with the ground during an aerial applicaion maneuver. The acft sustained substantial damage but the pilot was not injured. The plt stated that he should have checked the fuel…NTSB LAX85FA262Accident · 2 fatalField investigationFinal reportCessna TU-206E · San Manuel, AZThis plt was attempting to air drop illegal drugs to someone on the ground. While executing an intentional low pass, at dusk, theacft inadvertently collided with a cactus tree & crashed.NTSB LAX85LA044Accident · No injuriesLimited investigationFinal reportCessna 185F · Glendale, AZThe acft went to the left of the desired track for takeoff and the plt said that in the attempt to regain directional control by means of throttle manipulation and brake application (the plt in later inspection of rwy and brakes reported rubber marks on the…NTSB LAX84LA490Accident · No injuriesLimited investigationFinal reportCessna 411 · Dolan Springs, AZAfter lndg, the plt was taxiing back up the rwy to a parking area when the nose wheel 'fell into' a sand filled depression in the surface, collapsing the nose gear. County maintenance personnel had graded the rwy surface after heavy rains but no compaction…NTSB LAX84LA436Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Chinle, AZAt about 1400 MST, the plt took off. He climbed & leveled off at 8500 ft. he was using fuel from the right tank which ran dry, then he switched to the left tank. At that time, he thought he had 30 mins of fuel remaining. He decided to land at Chinle, AZ, &…NTSB LAX84LA224Accident · No injuriesLimited investigationFinal reportBeech 55 · Phoenix, AZThe acft veered off the rwy into soft dirt collapsing the right main landing gear. The left brake was foundNTSB LAX84LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · St. Johns, AZAbout 10 min after takeoff the pax door opened & the plt elected to make a precautionary landing at St. Johns. Unaware that the wind was calm, the plt selected rwy 20, which is 3400 ft long, rather than RWY31, which is 5300 ft long, because when he departed…NTSB LAX84LA003Accident · No injuriesLimited investigationFinal reportBeech S35 · Elgin, AZWhile taking off from a dirt, ranch strip, the plt elected to use tracks that were worn in the vegetation beside the strip. He believed that these tracks had been formed by other acft & thought the takeoff would be smoother if he used them. However, the…NTSB LAX83LA441Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Winkelman, AZThe right wing collided with wires at the end of a swath run and the acft was pulled to the ground about 300 ft from the wires.NTSB LAX83LA363Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Clifton, AZThe acft collided with soft terrain and nosed over during an attempted takeoff. Custom officials said the acft was being tracked on radar. The plt of the accident acft saw the customs acft after he landed and attempted to takeoff, lost control and nosed over…NTSB LAX83FA050Accident · 4 fatalField investigationFinal reportBellanca 17-30A · Williams, AZThe original departure point was camarillo, CA. Before departing camarillo, the pilot obtained a weather briefing for a flight to flagstaff, AZ. At about that time, the flagstaff weather was, in part: zero ceiling, 1/16 mi visibility. The pilot was warned of…NTSB LAX83FA030Accident · 1 fatalField investigationFinal reportCessna T337D · Scottsdale, AZFour minutes after takeoff the plt radioed that his eng had failed & he was going down. The acft crashed into a residential area, striking power lines, a fence & two houses. The acft had been flown during the day with no refueling the right aux tank contained…NTSB LAX82DA325Accident · No injuriesFinal reportCessna 188 · Casa Grande, AZThe pilot initiated his takeoff with a light quartering tail wind from a 2300 ft runway that was covered with tall grass. The temperature and elevation were 95 deg and about 1500 ft, respectively. He reported that the plane accelerated slowly, but was about…NTSB LAX82DA266Accident · No injuriesFinal reportBeech A36 · Grand Canyon, AZThe aircraft dragged a wingtip during an aborted takeoff and swerved off the runway. The density altitude was 8200 feet. The pilot said he could not maintain a climb so he lowered the landing gear to abort the takeoff and lost control of the aircraft. The…NTSB LAX82FA111Accident · 5 fatalField investigationFinal reportCessna 401 · Sunflower, AZAt 1027 the plt received a wx briefing for holbrook, AZ. The plt was told of forecasts for "at least moderate icing in clouds or in precipitation above the freezing level" & the briefer stated "I guarantee you moderate to severe turbulence..." For a route…NTSB LAX82DUJ05Accident · No injuriesClosedCessna A185F · Prescott, AZNTSB LAX81DUJ61Accident · No injuriesClosedBeech V35A · Seligman, AZNTSB LAX81FUJ45Accident · Serious injuriesClosedCessna A188 · San Manuel, AZNTSB LAX81FUJ43Accident · No injuriesClosedCessna 210D · Phoenix, AZNTSB LAX81DUJ34Accident · No injuriesClosedBeech F33A · Goodyear, AZNTSB LAX81FA037Accident · 4 fatalClosedBeech S35 · Casa Grande, AZNTSB LAX81FUJ02Accident · Serious injuriesClosedBeech S35 · Chandler, AZNTSB LAX80FUJ97Accident · Serious injuriesClosedCessna A188B · Casa Blanca, AZNTSB LAX80DUJ89Accident · No injuriesClosedCessna 188B · Hyder, AZ