NTSB investigations, 2003
24 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 91 |
|---|---|
| 1983 | 77 |
| 1984 | 88 |
| 1985 | 82 |
| 1986 | 76 |
| 1987 | 58 |
| 1988 | 76 |
| 1989 | 67 |
| 1990 | 74 |
| 1991 | 62 |
| 1992 | 48 |
| 1993 | 53 |
| 1994 | 54 |
| 1995 | 60 |
| 1996 | 42 |
| 1997 | 43 |
| 1998 | 50 |
| 1999 | 35 |
| 2000 | 41 |
| 2001 | 28 |
| 2002 | 36 |
| 2003 | 24 |
| 2004 | 45 |
| 2005 | 33 |
| 2006 | 28 |
| 2007 | 37 |
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\") = 2003
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\" = 352)
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") = 2003 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" = 352) 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 DCA04IA002Incident · No injuriesIncident investigationFinal reportAirbus Industrie A330 · Miami, FLan uncontained engine failure that resulted from the coking (carbon build-up) in a vent tube which led to a fire and the subsequent liberation of the IP turbine blades. Contributing to the cause of the uncontained engine failure was the absence of measures to…NTSB MIA03LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLA loss of engine power due to inadequate maintenance.NTSB SEA03LA176Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Hood River, ORA power loss due to a mis-seated intake valve on the #1 cylinder resulting in leakage during the compression stroke and low compression. Contributing factors were the rising terrain and trees.NTSB LAX03LA260Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Saint Johns, AZThe failure of the exhaust valve on the number two engine cylinder, which resulted in a partial loss of engine power during the final approach to land, and an on ground collision with a ditch during the subsequent off-airport landing roll.NTSB NYC03LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Rhinebeck, NYA loss of engine power due to a failure of the number eight cylinder.NTSB SEA03LA156Accident · No injuriesLimited investigationFinal reportHughes 269C · Marblemount, WAThe partial failure of a magneto during hover taxi over water, leading to a forced landing in shallow water near the shoreline. Factors include the aircraft being over a lake at the time that the partial loss of power made it impossible to keep it airborne.NTSB NYC03FA164Accident · 1 fatalField investigationFinal reportHawker T Mk 7A · Pittston, PAThe pilot's failure to abort the takeoff, after the engine experienced a partial power loss for undetermined reasons. Factors were the pilot's improper preflight planning by his failure to determine if the airplane was airworthy, and the operators inadequate…NTSB SEA03LA146Accident · No injuriesLimited investigationFinal reportCessna 182S · Henry's Lake, IDA set of inadequately torqued vacuum pump retaining nuts, leading to the failure of the vacuum pump gasket, resulting in oil exhaustion, which resulted in a loss of engine power during cruise. A ditch and rough uneven terrain were factors.NTSB MIA03LA143Accident · No injuriesLimited investigationFinal reportCessna 172P · Plymouth, FLThe pilot's continue operation with known deficiencies (engine vibration) resulting in a partial loss of engine power during climb after takeoff and overrun of the runway during the aborted takeoff.NTSB FTW03LA188Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Kerrville, TXThe loss of engine power due to the failure of the number three cylinder as the result of undertorqued cylinder bolts. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA134Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Logan, UTthe loss of engine power due to partial mechanical failure, which resulted in a forced landing. Contributing factors include the pilot's improper preflight planning/preparation, the improper rigging of the propeller governor control, the high density altitude…NTSB ATL03LA109Accident · No injuriesLimited investigationFinal reportKeuthan Buccaneer II · Pell City, ALThe failure of the throttle cable due to fatigue resulting in a loss of engine power. Factor were uphill rough and uneven terrain.NTSB IAD03LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-180 · Akron, OHthe pilot's failure to maintain minimum control single engine airspeed (Vmc) during a loss of power on one engine, which resulted in a loss of control in flight an in-flight collision with terrain. A factor was a shifted main journal, which resulted in a…NTSB NYC03LA155Accident · Serious injuriesLimited investigationFinal reportBeech BE-56TC · Bethany, WVA total loss of power in the right engine for undetermined reasons. A factor was a partial loss of power in the left engine due to a loose oil line.NTSB DEN03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Englewood, COthe pilot's improper flare which resulted in a hard landing. Contributing factors were the out-of-calibration waste gate actuator, a blown tire, and the airport sign.NTSB SEA03LA125Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · La Grande, ORThe cross threading and separation of the clutch assembly while maneuvering which resulted in a loss of engine power followed by a hard landing. An inadequate maintenance overhaul was a factor.NTSB NYC03LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Williamson, NYThe failure of a rocker arm shaft boss, which resulted in a partial loss of power and subsequent forced landing. A factor was the unsuitable terrain.NTSB IAD03CA062Accident · No injuriesData collectionFinal reportWilliam Stevens RAF2000 · Stoutsville, OHSeparation of the engine computer wire and connector, which resulted in a partial loss of engine power.NTSB NYC03FA131Accident · 4 fatalField investigationFinal reportCessna 205 · Jeannette, PAThe loss of power caused by fragments of the air filter being ingested in the engine. A factor was the pilot's delayed decision to perform a forced landing after experiencing a partial loss of engine power.NTSB SEA03LA076Accident · No injuriesLimited investigationFinal reportFokker F27MK 600 · Port Townsend, WAThe failure of the accessory drive shaft due to deterioration of bearing number 1 in the aft fork of the universal joint for undetermined reasons during cruise flight.NTSB FTW03FA118Accident · 2 fatalField investigationFinal reportBell 407 · Broadus, TXThe partial loss of engine power due to erratic fuel flow metering to the engine resulting from the single point failure of the PLA potentiometer in the hydro-mechanical fuel control unit. A contributing factor was the lack of suitable terrain to execute a…NTSB MIA03IA062Incident · No injuriesIncident investigationFinal reportCessna 500 · Fort Lauderdale, FLInadequate quality control following overhaul of the high-pressure compressor (HPC) impeller by other maintenance personnel that resulted in a machining groove on the aft face of the HPC impeller being undetected, which resulted in a fatigue fracture and an…NTSB SEA03FA026Accident · No injuriesField investigationFinal reportCessna 172K · Gig Harbor, WAThe loss of engine power in the climb due to the fracture of the number seven engine crankshaft cheek due to the propagation of a fatigue crack initiation point. Factors include a vehicle pulling onto the road that the pilot selected for his forced emergency…NTSB LAX03LA059Accident · Serious injuriesLimited investigationFinal reportFarmer R B DA5-A · Apple Valley, CAthe detonation of the number 1 and 3 cylinders and the subsequent over temperature of those cylinders and their corresponding pistons.