NTSB investigations, AZ
104 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 10 |
| 1984 | 8 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 4 |
| 1989 | 4 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 2 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 3 |
| 1999 | 1 |
| 2000 | 7 |
| 2001 | 4 |
| 2002 | 8 |
| 2003 | 6 |
| 2004 | 1 |
| 2005 | 3 |
| 2006 | 5 |
| 2007 | 2 |
Where
Latest 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\" = 350)
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" = 350) 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 SEA07LA252Accident · No injuriesLimited investigationFinal reportKearney Pulsar XP · Cottonwood, AZThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Winslow, AZLoss of engine power for undetermined reasons.NTSB LAX06CA286Accident · Serious injuriesData collectionFinal reportAgeton MXL Sport II · Marana, AZThe loss of engine power for undetermined reasons.NTSB LAX06FA283Accident · 3 fatalField investigationFinal reportCessna 337G · Prescott, AZA loss of power in the rear engine for undermined reasons. Contributing to the accident was the pilot's failure to promptly and correctly configure the airplane for single engine flight, and to maintain an adequate airspeed, which resulted in a stall mush.NTSB LAX06LA185Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries HK 36 TTC · Payson, AZpartial loss of engine power for undetermined reasons.NTSB ANC06FA020Accident · 2 fatalField investigationFinal reportRobinson R22 · Scottsdale, AZA loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain rotor rpm, which resulted in an uncontrolled descent and collision with terrain.NTSB LAX06LA109Accident · Minor injuriesLimited investigationFinal reportSIAI-Marchetti S.205/22R · Phoenix, AZa loss of engine power for undetermined reasons.NTSB LAX05LA168Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Seligman, AZthe pilot's fuel system mismanagement that led to a fuel starvation induced loss of power in the left engine. Also causal was the pilot's improper use of the emergency landing gear extension system.NTSB LAX05LA155Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Peach Springs, AZa loss of power for undetermined reasons.NTSB LAX05LA149Accident · 2 fatalLimited investigationFinal reportSchlitter Randy J Rans S6ES Coyote II · Tombstone, AZloss of engine power for undetermined reasons and the flying pilot's failure to maintain an adequate airspeed that resulted in a stall and uncontrolled descent into terrain.NTSB LAX04LA109Accident · No injuriesLimited investigationFinal reportPiper PA 22-160 · Carefree, AZThe pilot's inadequate fuel management by his failure to switch the fuel tank selector position, which resulted in fuel starvation, a loss of engine power.NTSB LAX04LA049Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZthe flight instructor's inadequate supervision of the flight and delayed remedial action, which resulted in a loss of directional control. The reason for the partial power loss in the left engine was not determined.NTSB LAX03LA302Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Show Low, AZThe pilot-in-command's (CFI) selection of the wrong runway (downwind) for the approach and landing. The failure of the left engine to respond to throttle application for undetermined reasons during the go-around was also causal. The high density altitude was…NTSB LAX03CA261Accident · No injuriesData collectionFinal reportCessna 150C · Tucson, AZthe pilot's inadequate inflight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB LAX03LA217Accident · Minor injuriesLimited investigationFinal reportRans S-10 Sakota/A · Paulden, AZa loss of engine power due to fuel starvation for undetermined reasons.NTSB LAX03LA113Accident · No injuriesLimited investigationFinal reportPiper PA24 · Mesa, AZThe flight instructor's delayed remedial action during a go-around, which resulted in an inadvertent touchdown and hard landing. Factors associated with the accident are a momentary loss of engine power, and the inadvertent touchdown.NTSB LAX03LA087Accident · Minor injuriesLimited investigationFinal reportCessna 182A · The Gap, AZA total loss of engine power for undetermined reasons.NTSB LAX03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Queen Creek, AZa loss of engine power for undetermined reasons.NTSB LAX02LA254Accident · Minor injuriesLimited investigationFinal reportWaco YPF-7 · Dewey, AZThe loss of engine power due to a flooded carburetor. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX02LA250Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Casa Grande, AZThe partial loss of engine power for undetermined reasons.NTSB LAX02LA223Accident · 1 fatalLimited investigationFinal reportSteen SE-1 · Tucson, AZthe loss of engine power during takeoff for undetermined reasons.NTSB LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.NTSB LAX02FA191Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Rio Rico, AZa loss of engine power in the left engine for undetermined reasons, and the failure of the flying pilot to maintain an adequate single engine minimum control airspeed and aircraft control. Also causal was the decision of all three of the pilots to continue…NTSB LAX02LA151Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Flagstaff, AZa loss of engine power for undetermined reasons.NTSB LAX02LA132Accident · Serious injuriesLimited investigationFinal reportCox Aeros Ltd Skyranger · Gila Bend, AZThe failure of the engine for undetermined reasons.NTSB LAX01LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Skull Valley, AZthe loss of engine power during takeoff for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing emergency landing.NTSB LAX01LA216Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Mesa, AZa loss of power for unexplained reasons. Also causal was the CFI's operation of the helicopter in a region of the height/velocity curve where a successful autorotation could not be accomplished. A factor in the accident was the high density altitude.NTSB LAX01LA104Accident · No injuriesLimited investigationFinal reportSchneider, Edmund, Pty. Starduster SA300 · Chino Valley, AZThe pilot's inadequate preflight planning and his failure to dissiminate/coordinate the total distance required to successfully operate the airplane.NTSB LAX01LA089Accident · Minor injuriesLimited investigationFinal reportArthur Dragonfly · Marana, AZA total loss of engine power for undetermined reasons. Contributing to the accident was the rough/uneven terrain.NTSB LAX01LA040Accident · No injuriesLimited investigationFinal reportCessna 150E · Marana, AZThe partial loss of engine power during cruise flight due to an improper maintenance adjustment to the float valve retractor clip of the carburetor. Factors were the lack of suitable terrain for a forced landing and high vegetation.NTSB LAX01LA022Accident · Serious injuriesLimited investigationFinal reportBeech 35B33 · Bullhead City, AZThe pilot's inadequate in-flight planning that resulted in fuel starvation and a loss of engine power, and his failure to engage the fuel boost pump in accordance with the owner's manual. A factor was rough terrain in the forced landing area.NTSB LAX00FA342Accident · Minor injuriesField investigationFinal reportSikorsky/Orlando S-55 · Hoover Dam, AZ**This report was modified on 2/23/2016. Please refer to the public docket for this accident for more information.** The failure of Papillon maintenance personnel to recognize the significance of the increasing metal in the oil analysis test results and the…NTSB LAX00LA336Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Phoenix, AZLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain available for a straight ahead landing during the takeoff initial climb.NTSB LAX00LA197Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Show Low, AZThe pilot's failure to properly position the fuel selector to a tank with fuel resulting in fuel starvation, a loss of engine power, and subsequent collision with the ground during the final landing approach.NTSB LAX00LA143Accident · No injuriesLimited investigationFinal reportMuxlow Pitts S-1C · Phoenix, AZA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain on which the airplane landed.NTSB LAX00LA139Accident · No injuriesLimited investigationFinal reportScovil KR-2 · Tonopah, AZThe fuel control metering unit becoming disengaged and the inadvertent use of the fuel supply during flight.NTSB LAX99LA094Accident · No injuriesLimited investigationFinal reportBeech F33 · Prescott, AZA total loss of engine power for undetermined reasons.NTSB LAX98LA038Accident · 1 fatalLimited investigationFinal reportAdams Sonerai II · Kingman, AZThe complete loss of engine power for undetermined reasons. A factor in the accident was the rough nature of the landing site terrain.NTSB LAX97LA304Accident · Serious injuriesLimited investigationFinal reportWalton Velocity STD/FG · Chino Valley, AZa loss of engine power for undetermined reasons.NTSB LAX97LA238Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Prescott, AZThe pilot's improper placement of the unmarked fuel selector valve to off which resulted in fuel starvation. A factor in the accident was the pilot's lack of total experience in this model aircraft.NTSB LAX97LA040Accident · Serious injuriesLimited investigationFinal reportMoody RV-6 · Cottonwood, AZloss of engine power for undetermined reason(s).NTSB LAX96LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Chandler, AZThe failure of both the engine driven and hand wobble fuel pumps, which resulted in fuel starvation to the engine.NTSB LAX96LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Mobile, AZa loss of engine power for undetermined reasons.NTSB LAX95FA319Accident · 8 fatalField investigationFinal reportCessna 421C · Beaver Dam, AZFailure of the pilot to maintain adequate airspeed, while maneuvering on approach, which resulted in an inadvertent stall/spin and uncontrolled collision with terrain. Factors relating to the accident were: the pilot allowed the aircraft weight and balance…NTSB LAX95LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Payson, AZa loss of power for undetermined reasons.NTSB DCA95MA019Accident · 8 fatalMajor investigationFinal reportPiper PA-31-350 · Tusayan, AZa loss of power on one engine for an undetermined reason(s), and the pilot's improper decision to return to the departure airport for landing which neccessitated maneuvering over increasingly higher terrain. Factors in the accident were: the high gusting…NTSB LAX94LA284Accident · Serious injuriesLimited investigationFinal reportMooney M-20J · Tucson, AZa loss of engine power for undetermined reasons.NTSB LAX94LA267Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Wickenburg, AZLoss of engine power for an unknown reason, and failure of the pilot to maintain airspeed, which resulted in an inadvertent stall and collision with the ground.NTSB FTW94LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Page, AZThe total loss of engine power for undetermined reason. A factor was the lack of suitable terrain at the pilot's disposal.NTSB LAX94LA180Accident · Serious injuriesLimited investigationFinal reportCurry FLY-BABY · Bisbee, AZa loss of engine power due a blockage in the fuel tank outlet which caused fuel starvation.