NTSB investigations, 2002
29 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 33 |
|---|---|
| 1983 | 43 |
| 1984 | 74 |
| 1985 | 60 |
| 1986 | 60 |
| 1987 | 55 |
| 1988 | 64 |
| 1989 | 44 |
| 1990 | 48 |
| 1991 | 67 |
| 1992 | 52 |
| 1993 | 45 |
| 1994 | 53 |
| 1995 | 44 |
| 1996 | 27 |
| 1997 | 44 |
| 1998 | 35 |
| 1999 | 37 |
| 2000 | 45 |
| 2001 | 37 |
| 2002 | 29 |
| 2003 | 39 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 29 |
| 2007 | 34 |
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\") = 2002
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\" = 354)
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") = 2002 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" = 354) 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 SEA03LA020Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1 · Chehalis, WAThe total loss of engine power, for undetermined reasons, while the aircraft was on a VFR final approach. No suitable terrain for landing and water were factors.NTSB LAX03LA044Accident · No injuriesLimited investigationFinal reportCessna 150H · Twentynine Palm, CAThe improper use of carburetor heat, and the instructor's inadequate supervision which resulted in a loss of engine power due to carburetor icing.NTSB MIA03LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Powells Point, NCa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB LAX03LA041Accident · Serious injuriesLimited investigationFinal reportClyde K Carrier Team 1400Z · Woodland, CAthe builder/pilot's improper modification of wing fuel caps resulting in the failure of the vent system to adequately compensate for the pressure differential between the fuel tank and the external low pressure area of the wing. This led to the partial loss…NTSB CHI03LA029Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stalwart, MIThe pilot's improper fuel management during the flight and the pilot's improper decision not to select the outboard fuel tank when a loss of engine power was experienced, resulting in fuel starvation, a sustained loss of engine power, and subsequent forced…NTSB ANC03LA009Accident · No injuriesLimited investigationFinal reportArima Kolb Fire Star II · Chugiak, AKThe pilot's inadequate preflight inspection which failed to remove contaminated fuel from the airplane's fuel system, resulting in a loss of engine power during takeoff.NTSB MIA03LA006Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Las Palmas, PRThe pilot's failure to switch fuel tanks resulting in a partial loss of engine power due to fuel starvation during a go-around. Additionally, the pilot's failure to monitor airspeed and proper touchdown point during the emergency landing resulted in another…NTSB NYC02FA200Accident · 1 fatalField investigationFinal reportMooney M20E · West Creek, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, and his failure to maintain airspeed.NTSB IAD02LA094Accident · 1 fatalLimited investigationFinal reportGarlick OH-58AT · Rochester, MAThe pilot's failure to center the sling load prior to commencing forward flight. Also causal, was the pilot's improper decision to attempt a takeoff with a quartering tailwind, which resulted in an engine compressor stall.NTSB DEN02FA106Accident · 1 fatalField investigationFinal reportBeech B19 · Delta, COthe pilot's failure to properly plan and compensate for the high density altitude conditions, resulting in partial engine power during takeoff, his failure to abort the takeoff, and his failure to maintain aircraft control on initial climb. Contributing…NTSB SEA02FA171Accident · 1 fatalField investigationFinal reportCessna 175B · Arlington, WAA partial loss of engine power for undetermined reasons during the initial climb, followed by the pilot's failure to maintain airspeed while maneuvering. Impairing drugs found in the pilot's system at the time of the accident were a factor.NTSB IAD02LA090Accident · No injuriesLimited investigationFinal reportCessna T210N · Glastonbury, CTA partial loss of engine power for undetermined reasons. A factor in the airplane's damage was the standing corn.NTSB MIA02LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · La Belle, FLThe student pilot's improper in-flight planning and failure to use carburetor heat while conditions existed that were conductive to carburetor icing.NTSB CHI02LA223Accident · No injuriesLimited investigationFinal reportCessna A188B · Nickerson, KSFuel starvation due to the fuel contamination, the blocked fuel strainer, and the refueling truck's contaminated fuel. A factor was the berm.NTSB NYC02FA138Accident · Serious injuriesField investigationFinal reportYakovlev YAK 52 · Matawan, NJThe pilot's excessive maneuvering and failure to maintain aircraft control, following a partial power loss during the initial climb, which resulted in an inadvertent stall/spin. A factor in the accident was an inadequate annual condition inspection performed…NTSB CHI02LA180Accident · Serious injuriesLimited investigationFinal reportAune Glastar GS-1 · South St Paul, MNThe pilot's failure to utilize carburetor heat. Factors included ambient conditions for the formation of carburetor ice, and the unsuitable terrain for the forced landing.NTSB DEN02LA051Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Medicine Bow, WYthe unsuitable terrain encountered during the emergency autorotation, following a partial loss of engine power. Factors contributing to this accident were fuel contamination (water), the low altitude, the high winds, and the tailwind.NTSB NYC02TA104Accident · Minor injuriesFinal reportHughes OH-6A · Angola, NYThe loss of engine power for undetermined reasons.NTSB ATL02LA114Accident · No injuriesLimited investigationFinal reportBeech 23 · Greensboro, NCThe loss of engine power for undetermined reasons, A factor was the pilot's intentional ground loop during a forced landing.NTSB ATL02FA107Accident · 1 fatalField investigationFinal reportBell 47G-4A · Yauco, PRThe pilot's failure to apply carburetor heat that resulted in a partial loss of engine power and the subsequent collision with an object during the forced landing. A factor was weather conditions favorable for the formation of carburetor ice.NTSB ATL02LA105Accident · No injuriesLimited investigationFinal reportStearman A75N1 · Panacea, FLLoss of engine power due to fuel starvation resulting from fuel restriction through the fuel shutoff valve.NTSB ANC02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Noorvik, AKThe partial loss of engine power during the climb to cruise for an undetermined reason, which resulted in a forced landing in soft terrain. A factor associated in the accident was the lack of suitable terrain for the forced landing.NTSB LAX02FA162Accident · Minor injuriesField investigationFinal reportCessna 152 · Livermore, CAA loss of engine power due to the failure of the CFI to apply carburetor heat which resulted in carburetor icing. The unsuitable landing area in mountainous terrain, and carburetor icing conditions were factors.NTSB LAX02LA152Accident · No injuriesLimited investigationFinal reportCessna 182P · Boulder City, NVthe pilot's failure to lean the mixture properly resulting in a partial loss of power.NTSB ATL02LA084Accident · No injuriesLimited investigationFinal reportCessna 150D · Chatsworth, GAThe pilot's failure to apply carburetor heat that resulted in the loss of engine power. Factors were conditions favorable for the formation of carburetor icing and the selection of unsuitable terrain for a forced landing.NTSB MIA02LA080Accident · 1 fatalLimited investigationFinal reportGary L. Zeigler Monnett Moni · Sevierville, TNThe failure of the pilot to maintain airspeed while turning to reverse direction resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees. A factor in the accident was the failure of the pilot to tighten the spark plugs…NTSB IAD02LA041Accident · No injuriesLimited investigationFinal reportCessna U206F · Matinicus, MEA partially blocked fuel metering unit inlet screen, which resulted in a partial loss of engine power. Also causal, was the operator's lack of inlet screen inspection procedures.NTSB SEA02LA062Accident · Minor injuriesLimited investigationFinal reportStadden Flybaby · Buhl, IDThe pilot's failure to return the carburetor heat to the OFF (cold) position prior to applying full power following a touch and go landing, which resulted in poor climb performance and the subsequent impact with a fence and collision with the ground. A…NTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.