NTSB investigations, AZ
108 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 5 |
| 1986 | 1 |
| 1987 | 5 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 7 |
| 1997 | 6 |
| 1998 | 6 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 4 |
| 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\" = 351)
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" = 351) 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 LAX08CA033Accident · Minor injuriesData collectionFinal reportSenft/Anderson/salmon C-5 · Tucson, AZa total loss of engine power due to the failure of the number 3 articulating rod.NTSB LAX07LA197Accident · Minor injuriesLimited investigationFinal reportEvenson Roger J Vans RV-9A · Tucson, AZthe loss of engine power during takeoff-initial climb, which resulted from the owner/builder's improper adjustment of the supercharger waste gate valve, that resulted in the failure of the waste gate servo motor.NTSB SEA07LA160Accident · No injuriesLimited investigationFinal reportCessna 182D · Phoenix, AZThe loss of engine power due to the intake manifold disconnection to the engine's cylinders on the left side.NTSB LAX07LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZa loss of engine power due to oil starvation to the number 3 cylinder crankpin and connecting rod bearing. The underlying cause of the oil starvation to the number 3 cylinder components could not be ascertained.NTSB LAX07LA011Accident · Minor injuriesLimited investigationFinal reportMorrisey 2150A · Chandler, AZLoss of engine power during cruise flight due to a crack in the oil cooler and subsequent loss of engine oil.NTSB LAX06LA273Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Casa Grande, AZInternal damage to the stop electro valve which resulted in fuel starvation and subsequent loss of engine power during takeoff.NTSB LAX06CA090Accident · Serious injuriesData collectionFinal reportQuicksilver MX II Sprint · Bouse, AZLoss of engine power after takeoff due to engine overheating and piston seizure.NTSB LAX06LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Tucson, AZthe separation of the mixture cable at the carburetor control arm, which resulted in a loss of power, and maintenance personnel's inadequate inspection of the airplane during the last annual inspection.NTSB LAX05LA244Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Globe, AZThe fatigue failure of the compressor turbine stator vane, the liberation of vane material into the compressor turbine, and the total loss of engine power. Also causal was the operator's failure to inspect the compressor turbine vane during fuel nozzle checks.NTSB LAX05LA159Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Tucson, AZa loss of engine power due to the fatigue fracture and separation of the mixture control cable. The fatigue crack resulted from inadequate installation techniques by unknown maintenance personnel.NTSB LAX05LA136Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Phoenix, AZa loss of power for undetermined reasons.NTSB LAX05TA018Accident · Serious injuriesFinal reportHughes OH-6A · Tucson, AZThe loss of engine power due to a fatigue fracture of the PC line from the governor to fuel control, resulting from fretting damage induced by excessive vibration, which was due to the failure of maintenance personnel to install the proper bearings in the…NTSB LAX04LA232Accident · No injuriesLimited investigationFinal reportBeech S35 · Flagstaff, AZoil exhaustion due to a leak from the bottom oil drain line gasket and o-ring for the turbo charger.NTSB LAX04LA229Accident · No injuriesLimited investigationFinal reportSimmons BD-5 · Goodyear, AZThe overheating and failure of the number 4 connecting rod, which resulted in a total loss of engine power during descent.NTSB LAX04LA069Accident · Serious injuriesLimited investigationFinal reportAllison KR-2 · Glendale, AZloss of engine power due to a loose carburetor jet. A contributing factor was the owner/operators failure to have a condition inspection performed on the aircraft.NTSB LAX04FA042Accident · 1 fatalField investigationFinal reportCessna 177RG · Blk Canyon City, AZa loss of engine power due to the failure of the single-drive dual magneto that resulted from inadequate lubrication of the breaker cam. Also causal was the improper maintenance by other maintenance personnel during a recent inspection, which should have…NTSB LAX03LA216Accident · Serious injuriesLimited investigationFinal reportCessna 210D · Carefree, AZfuel exhaustion due to a crack on the elbow fitting to the gascolator resulted in a fuel leak.NTSB LAX03LA164Accident · No injuriesLimited investigationFinal reportCessna T207A · Page, AZa loss of engine power due to a oil starvation induced catastrophic internal failure of the engine caused by the rotation of the number 2 cylinder main bearing. This narrative was modified on February 16, 2005.NTSB LAX03FA108Accident · Minor injuriesField investigationFinal reportStinson 108-1 · Eloy, AZa loss of engine power caused by the fatigue failure of the number 4 cylinder exhaust valve.NTSB LAX03FA005Accident · 1 fatalField investigationFinal reportGrumman AA-5A · Phoenix, AZfailure of the lubricating system resulting in a total loss of engine power and an off airport forced landing.NTSB LAX02LA204Accident · No injuriesLimited investigationFinal reportBeech V35A · Cottonwood, AZThe loss of engine power as a result of the failure of the #1 lower connecting rod bolt due to fatigue.NTSB LAX01LA254Accident · Minor injuriesLimited investigationFinal reportWatkins Velocity · Winslow, AZThe separation of the number three cylinder head from the barrel resulting in a loss of engine oil during flight. Factors were the lack of suitable terrain for the forced landing, and the rough uneven ground of the forced landing site.NTSB LAX01LA179Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paulden, AZCatastropic engine failure due to oil depletetion caused by an oil filter gasket failure.NTSB LAX00LA350Accident · No injuriesLimited investigationFinal reportWorgull Hornet · Camp Verde, AZSeparation of the forward spark plug due to wear damage to the cylinder head threads. A factor in the accident was traffic on the highway and the pilot having to maneuver to avoid the traffic.NTSB LAX00LA258Accident · No injuriesLimited investigationFinal reportCessna 205 · Tacna, AZThe piston and rings in cylinder No. 1 failed resulting in a total loss of engine power. The pilot made a forced landing on a road and the airplane's wing collided with a road sign.NTSB LAX00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Mayer, AZthe total loss of engine power resulting from the mechanic's failure to properly torque the connecting rod bolt nuts during engine overhaul.NTSB LAX00GA102Accident · No injuriesFinal reportCessna T210M · Elfrida, AZThe company mechanic's failure to correctly install one or more of the crankshaft counterweight pin retaining plate snap rings, specifically ensuring that the snap rings were fully seated in their grooves. This led to the complete separation of the No. 2…NTSB LAX00LA074Accident · No injuriesLimited investigationFinal reportBeech F-33A · Mobile, AZthe manufacturer representative's improper reinstallation of the crankshaft counterweight snap rings which subsequently separated, allowing the crankshaft counterweight to contact the crankshaft resulting in a total power loss of engine power.NTSB LAX00LA034Accident · Serious injuriesLimited investigationFinal reportHawker Siddeley Hunter T MK 7 · Mesa, AZThe fatigue failure and separation the stage 3 compressor blades due to corrosion pitting of the blade retention lug bores. A factor in the accident was the failure of the various post military surplus operators of this engine to incorporate the…NTSB LAX00LA055Accident · No injuriesLimited investigationFinal reportBell 206B · Apache Junction, AZOil starvation and seizure of the engines Nos. 6 and 7 bearings due to a clogged oil jet, which resulted in a total loss of engine power.NTSB LAX99LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Gila Bend, AZThe crankshaft gear attach bolt loosening and backing out of its crankshaft bore, which led to the fatigue failure of the crankshaft gear dowel pin due to excessive working of the gear. The sequence of failures was the result of the engine overhaul shop's…NTSB LAX98LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZOil system contamination with an unidentified metal substance that traveled through the oil system and blocked the number 4 main bearing and number 6 connecting rod bearing oil ports, resulting in oil starvation and failure of the engine. The source of the…NTSB LAX98LA192Accident · No injuriesLimited investigationFinal reportArner Challenger II S · Pleasant Valley, AZLoss of engine power due to a loose spark plug wire cap caused by a broken spark plug retainer spring.NTSB LAX98LA254Accident · Minor injuriesLimited investigationFinal reportGirgen Kitfox II · Peoria, AZAn engine failure due to a broken rotary valve for unknown reasons. Contributing factors to the accident was an inadequate inspection by the owner of a previously damaged engine during maintenance overhaul prior to installation in the airframe.NTSB LAX98LA181Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mesa, AZFailure of a weld in the engine's throttle control support assembly due to inadequate maintenance which was the ultimate responsibility of the owner-pilot. Contributing factors were the presence of rough terrain, the lack of a suitable forced landing site,…NTSB LAX98LA129Accident · No injuriesLimited investigationFinal reportAyres S2RT-34RE · Buckeye, AZThe incorrect turbine blades installed on the engine, the fractured compressor turbine blades and separation of the blade, and the improper maintenance installation of the incorrect CT blades by the repair station. A factor in the accident was the inadequate…NTSB LAX97LA266Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Buckeye, AZThe total oil exhaustion of the engine due to the inadequate maintenance installation of the oil cooler lines by the owner/mechanic.NTSB LAX97LA247Accident · No injuriesLimited investigationFinal reportSikorsky S-58T · Page, AZan engine failure resulting from the fracture of two power turbine blades, which had been previously subjected to a hot or hung start.NTSB LAX97LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T-34 · Tonopah, AZthe failure of the power turbine due to an overtemperature condition created by an improperly adjusted fuel control. A factor in the accident was the tripped circuit breaker which prevented the wing lights from operating during the forced night landing.NTSB LAX97IA170Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Tucson, AZan undetermined failure in the #1 (left) engine turbine assembly, which resulted in a fracture of the first stage nozzle guide vane (NGV) and subsequent damage to the turbine blades.NTSB LAX97LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Continental, AZloss of engine power as a result of detonation in the number 2 cylinder for undetermined reasons. A factor in the accident was the unsuitable nature of the forced landing area.NTSB LAX97LA116Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Morristown, AZfailure of the crankshaft due to improper inspection/overhaul procedures.NTSB LAX97LA058Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Scottsdale, AZdetonation/pre-ignition for unknown reason(s), which resulted in failure of the number two piston, loss of engine power, and a subsequent forced landing on rough/uneven desert terrain.NTSB LAX97LA037Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Williams, AZa foreign object in the oil system, which resulted in failure of the oil pump, oil starvation, loss of engine power, and a subsequent forced landing. Rough/uneven terrain in the emergency landing area was a related factor.NTSB LAX97LA031Accident · 2 fatalLimited investigationFinal reportRainey Rans S-12 · Tucson, AZa broken wire in the ignition coil, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spin and uncontrolled collision with the terrain.NTSB LAX97LA028Accident · Serious injuriesLimited investigationFinal reportLeibert BD-5B · Phoenix, AZloss of engine power during the takeoff initial climb, due to an undetermined cooling system malfunction. A related factor was: soft terrain in the forced landing area.NTSB LAX96LA311Accident · No injuriesLimited investigationFinal reportAtkinson Varieze · Glendale, AZThe fracture and separation of the mixture control cable housing from the carburetor mounting bracket, which resulted in fuel starvation due to an overlean condition, and the pilot's failure to maintain an adequate airspeed while stretching the glide to the…NTSB LAX96LA280Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B · Scottsdale, AZan uncontained failure of the second stage turbine wheel due to fatigue. Factors were: obstructions in the forced landing area and the inability of the airplane to climb after the turbine wheel failure.NTSB LAX96FA155Accident · Serious injuriesField investigationFinal reportCessna 182RG · Beaver Dam, AZan engine failure due to oil starvation resulting from the pilot's improper aircraft preflight. A factor relating to the accident was: failure of the operator to ascertain that proper maintenance was performed after the airplane's high oil consumption rate…NTSB LAX96LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Congress, AZfailure of the #3 cylinder exhaust valve. A factor was the pilot's need to perform an evasive maneuver to avoid colliding with an automobile.