NTSB investigations, AZ
185 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 15 |
|---|---|
| 1983 | 10 |
| 1984 | 10 |
| 1985 | 8 |
| 1986 | 9 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 9 |
| 1990 | 10 |
| 1991 | 13 |
| 1992 | 12 |
| 1993 | 7 |
| 1994 | 4 |
| 1995 | 9 |
| 1996 | 7 |
| 1997 | 9 |
| 1998 | 5 |
| 1999 | 8 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 4 |
| 2007 | 5 |
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\" = 353)
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" = 353) 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 LAX07CA205Accident · Minor injuriesData collectionFinal reportSaunders Stiletto · Quartzsite, AZFuel exhaustion due to the pilot's inadequate preflight inspection during which he failed to insure security of the fuel tank's cap.NTSB SEA07LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Flagstaff, AZThe loss of engine power during cruise flight due to fuel exhaustion, as a result of the pilot's failure to refuel and inadequate preflight planning.NTSB LAX07CA182Accident · No injuriesData collectionFinal reportCessna 340A · Chandler, AZfuel starvation due to the pilot's failure to adequately manage and monitor his fuel supply.NTSB LAX07CA144Accident · No injuriesData collectionFinal reportGadbois Apex Cross 5 · Show Low, AZthe pilot's inadequate in-flight fuel consumption calculations and failure to divert to an alternate airport, which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA07CA076Accident · No injuriesData collectionFinal reportCessna 182H · Phoenix, AZThe pilot's inadequate preflight inspection, resulting in fuel exhaustion and the loss of power. A factor was the sign.NTSB LAX07LA037Accident · 1 fatalLimited investigationFinal reportBeechcraft J35 · Flagstaff, AZThe pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.NTSB LAX06CA299Accident · Minor injuriesData collectionFinal reportBeech 95-55 · Safford, AZThe pilot's inadequate in-flight planning/decision and inaccurate fuel consumption calculations, which led to fuel exhaustion and total loss of power to both engines.NTSB ANC06LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Winslow, AZThe presence of a foreign material/substance in the fuel system, which partially blocked the fuel flow divider, and resulted in a loss of engine power during takeoff-initial climb, and an emergency landing. A factor associated with the accident was unsuitable…NTSB LAX06CA120Accident · No injuriesData collectionFinal reportCessna 177 · Carefree, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations and his failure to refuel the airplane prior to the accident flight.NTSB LAX06CA033Accident · No injuriesData collectionFinal reportRotorway 162F · Chandler, AZa loss of engine power due to fuel contamination (rust, water) as a result of the pilot's inadequate preflight planning preparation.NTSB LAX06CA026Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Payson, AZa loss of engine power due to fuel exhaustion, which was caused by the pilot's inadequate preflight and in-flight planning, his inadequate fuel consumption calculations, and his failure to divert to an alternate airport before the fuel situation became…NTSB LAX05LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Oro Valley, AZa loss of engine power due to the pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion. Contributing to the accident was the inaccuracy of the cockpit fuel gages which read 1/4 tank when empty.NTSB LAX05LA115Accident · No injuriesLimited investigationFinal reportSukhoi SU-26 · Tucson, AZthe pilot's inadequate in-flight planning and fuel consumption calculations, which resulted in fuel exhaustion.NTSB LAX05CA044Accident · Minor injuriesData collectionFinal reportCessna 150J · Amado, AZthe pilot's inaccurate fuel consumption calculations and failure to refuel the airplane at the intermediate stop, which resulted in fuel exhaustion.NTSB LAX04LA111Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Goodyear, AZThe pilot's inadequate fuel consumption calculations and in-flight planning/decision, which resulted in fuel exhaustion.NTSB LAX04LA032Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Williams, AZa loss of engine power in the right engine due to fuel exhaustion, caused by the pilot's inadequate preflight inspection and failure to refuel the airplane. Also causal was his failure to feather the right propeller and to maintain directional control of the…NTSB LAX03LA101Accident · No injuriesLimited investigationFinal reportCreitz, Robert D RV-3 · Deer Valley, AZThe pilot's improper use of carburetor heat, which resulted in carburetor icing and loss of engine power.NTSB LAX03LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Scottsdale, AZThe pilot's inadequate preflight inspection and failure to refuel the airplane resulting in a loss of engine power due to fuel starvation.NTSB LAX02LA290Accident · No injuriesLimited investigationFinal reportCessna 172G · Vail, AZThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB LAX02LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Prescott, AZFuel starvation on final approach due to the pilot's fuel mismanagement, and his inattentiveness in following established prelanding procedures.NTSB LAX01FA212Accident · 1 fatalField investigationFinal reportSchultz Lancair IV-P · Flagstaff, AZthe builder's failure to install a fuel compartment vent in the right wing, affecting the total available fuel capacity, and resulting in the loss of engine power due to fuel starvation. A contributing factor was the pilot's intentional flight with a known…NTSB LAX01LA180Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Tucson, AZThe pilot's inadequate preflight inspection, which included verifying the position of the fuel selector handle, which subsequently led to fuel starvation and a forced landing.NTSB LAX01LA157Accident · No injuriesLimited investigationFinal reportBell 206-L3 · Willcox, AZA loss of engine power due to the likely unporting of the fuel tank pickups as the helicopter was maneuvered to look at animals on the ground. Also causal was the pilot's misjudged touchdown point during an autorotational approach, which resulted in the…NTSB LAX01LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Flagstaff, AZThe loss of engine power during cruise flight for undetermined reasons that resulted in a forced landing in rough terrain.NTSB LAX01LA072Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Mesa, AZThe pilot's improper fuel management in cruise flight that resulted in a loss of engine power, because of fuel starvation, and a collision with a fence during the subsequent forced landing.NTSB LAX01LA065Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado City, AZthe pilot's improper preflight and failure to refuel the airplane.NTSB LAX01FA007Accident · 2 fatalField investigationFinal reportCessna P210N · Phoenix, AZThe failure of the pilot to operate the airplane according to the flight manual, resulting in fuel starvation and loss of engine power during a critical phase of flight. A factor was the lack of suitable terrain for a forced landing and the presence of…NTSB LAX00LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Prescott, AZAn improper engine installation by other maintenance personnel that resulted in a fuel leak at the main fuel line fitting to the carburetor and subsequent fuel exhaustion during cruise flight.NTSB LAX00LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Casa Grande, AZThe student pilot's inadvertant movement of the fuel selector to the "off" positon when selecting the alternate tank, and the flight instructor's lack of verification that the fuel selector was in the proper position during the emergency procedure checklist.…NTSB LAX00LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Marana, AZthe pilot's failure to refuel the airplane as required by the airplane's published flight manual resulting in a loss of engine power due to fuel starvation.NTSB LAX00FA160Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Grand Canyon, AZA snow ingestion caused loss of engine power due to the pilot's inadequate preflight inspection and failure to remove the accumulated snow from the engine inlet area. Also causal was the pilot's failure to maintain main rotor rpm while maneuvering to avoid…NTSB LAX00LA037Accident · No injuriesLimited investigationFinal reportCessna 150K · Phoenix, AZFuel exhaustion due to the pilot's improper preflight planning, and failure to ensure that an adequate fuel supply was onboard the airplane.NTSB LAX00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZFuel exhaustion due to the pilot's inadequate preflight verification of the fuel quantity, and, once he became aware of the critical fuel state, his decision to over-fly two alternate airports in order to continue to his destination.NTSB LAX99LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Buckeye, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations used in flight planning.NTSB LAX99LA240Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Polacca, AZThe pilot's inadequate preflight inspection, which failed to determine the fuel supply in each fuel tank, and his mismanagement of the fuel supply, which resulted in fuel starvation.NTSB LAX99GA216Accident · Serious injuriesFinal reportHughes OH-6A · Tucson, AZFuel exhaustion resulting from pilot's failure to perform adequate fuel consumption calculations. The unreliable and inoperative fuel level indicating system components and the operator's operation of the aircraft with known deficiencies were factors in the…NTSB LAX99LA205Accident · No injuriesLimited investigationFinal reportCessna 180 · Sedona, AZFuel exhaustion due to an inadequate fuel supply, and the pilot's inadequate in-flight planning fuel consumption calculations.NTSB LAX99LA173Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's improper use of the carburetor heat and throttle control (rapid movement), which induced an overly rich condition and a loss of power.NTSB LAX99FA136Accident · 1 fatalField investigationFinal reportBell 206B · Grand Canyon, AZThe failure of the flight crew to properly preflight the helicopter and to detect and remove accumulated snow from the engine inlets and plenum chamber. Factors in the accident were the clouded plenum chamber inspection window and the failure of preceding…NTSB LAX99LA039Accident · No injuriesLimited investigationFinal reportVarga 2150A · Chandler, AZFuel exhaustion due to the pilot's failure to perform an adequate preflight of the aircraft to ensure that adequate fuel was available for the flight.NTSB LAX99LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe failure of the flight instructor to provide adequate supervision of the student pilot during a simulated emergency landing.NTSB LAX98LA281Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Phoenix, AZFuel starvation due to the pilot's inadequate in-flight fuel management and his failure to select a tank containing fuel prior to the loss of power.NTSB LAX98LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZFuel exhaustion due to the pilot's inadequate preflight planning and in-flight monitoring of the aircraft's fuel consumption.NTSB LAX98LA237Accident · 1 fatalLimited investigationFinal reportDe Malignon Varieze · Globe, AZfuel starvation due to the pilot's failure to properly plan his flight with regard to his estimated flight time, planned descent(s), and the amount of usable fuel available and required in the fuselage tank. The pilot/builder's deviation from the aircraft…NTSB LAX98LA041Accident · Minor injuriesLimited investigationFinal reportRans S91 · Phoenix, AZThe pilot's failure to maintain an adequate airspeed margin during the forced landing, which resulted in an inadvertent stall/mush.NTSB LAX98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Temple Bar, AZthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the terrain condition (ditch) in the emergency landing area.NTSB LAX97LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gila Bend, AZthe pilot's failure to verify the fuel quantity prior to departure, and his failure to perform sufficient en route fuel consumption calculations during the cross-country flight.NTSB LAX97LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Rimrock, AZFuel starvation due to the pilot's failure to monitor the fuel level in the right tank, and to select a tank containing fuel during the approach and landing in accordance with the checklist.NTSB LAX97LA183Accident · No injuriesLimited investigationFinal reportNorth American Navion NA-1 · Morristown, AZfailure to replace an old and abraded oil feedline hose which led to its rupture and the in-flight loss of engine oil pressure. A related factor was the pilot's misjudgment of distance-to-go versus altitude remaining during the subsequent forced landing.NTSB LAX97LA147Accident · No injuriesLimited investigationFinal reportCessna 182D · Tucson, AZFuel exhaustion due to the inadequate preflight inspections performed by both pilots. A factor in the accident was the crosswind experienced during landing rollout.