NTSB investigations, 2001
28 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\") = 2001
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") = 2001 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 MIA02LA021Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Southern Pines, NCThe dislodging of the front crankshaft oil seal for undetermined reasons resulting in loss of engine oil, loss of engine power, and collision with a tree and then the ground during a forced landing.NTSB DEN02LA010Accident · Minor injuriesLimited investigationFinal reportAgusta A119 · Ogden, UTimproper rigging of the rotary variable differential transformer by the manufacturer, resulting in incorrect fuel scheduling to the fuel control unit.NTSB FTW02IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-132 · Midland, TXthe #1 engine's fatigue failure of the #3 bearing due to the manufacturer's inadequate design of the high-pressure compressor stubshaft coating, which resulted in a loss of engine power and an emergency landing.NTSB NYC02LA018Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Batavia, OHMalfunction of an exhaust valve. A factor was the pilot/owner's failure to comply with the engine manufacturer's service instructions.NTSB FTW02LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Bethany, OKthe mechanic's failure to properly lock the exhaust valve's clearance adjusting screw locknut, which resulted in a loose nut, disabling of the exhaust valve pushrod, and a partial loss of engine power while in cruise flight. A contributing factor was the…NTSB LAX02LA006Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Rosamond, CAThe pilot's failure to attain sufficient airspeed during the attempted takeoff, which resulted in a stall/mush. The airplane's failure to accelerate was due to a disintegrated bearing on the camshaft. The pilot's failure to make a timely abort decision was a…NTSB FTW02LA002Accident · Serious injuriesLimited investigationFinal reportHamilton Genesis · Grants, NMthe loose throttle cable resulting in a partial loss of engine power. Contributing factors were the pilot's failure to perform the required yearly condition inspection prior to flight and the lack of suitable terrain for the forced landing.NTSB ANC01LA138Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-3 · Cordova, AKThe loss of engine power during cruise due to the fracture of an engine cylinder exhaust valve.NTSB CHI01LA303Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sheldon, IAthe in-flight planning/decision and proper touchdown point not attained by the pilot. Contributing factors were the ingested exhaust valve and lack of experience of the pilot.NTSB FTW01LA193Accident · No injuriesLimited investigationFinal reportGrumman G164B · Rayville, LAthe partial failure of the magneto drive coupling while maneuvering, which resulted in a loss of engine power and a forced landing. A contributing factor to the accident was the lack of suitable terrain for the forced landing.NTSB DEN01LA141Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Ouray, COthe partial loss of engine power due to the slippage of the wastegate linkage as a result of the plunger on the linkage being undertorqued by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA229Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge Center, MNThe pilot not maintaining directional control on the ground during the takeoff roll. Factors relating to this accident were the total failure of the propeller governor and the corn crop.NTSB ANC01TA076Accident · No injuriesFinal reportBell 212 · Clear, AKThe pilot's selection of an unsuitable landing site following a partial loss of power during approach to landing in a multiengine helicopter. Factors associated with the accident are an automatic fuel control unit that had a restricted fuel flow due to an…NTSB IAD01LA067Accident · No injuriesLimited investigationFinal reportde Havilland DH-82 Tiger Moth · Allamuchy, NJThe loss of engine power over unsuitable terrain due to an exhaust valve stuck in the open position.NTSB CHI01LA173Accident · No injuriesLimited investigationFinal reportCessna 172S · Cambridge, NEthe pilot's high airspeed and improper emergency procedures during the emergency landing. Factors relating to this accident were the fractured engine exhaust valve push rod, the bent intake valve push rod, and oil exhaustion during cruise flight, the…NTSB MIA01LA159Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Dahlonega, GAThe failure of the No. 3 exhaust valve due to fatigue cracking for undetermined reasons, which resulted in a partial loss of engine power and an in-flight collision with a building during an attempted forced landing to unsuitable terrain..NTSB IAD01LA068Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Danbury, CTthe pilot's misjudged altitude and excessive airspeed resulting in a collision with a pole. A factor was the cracked exhaust stack, which resulted in a partial loss of engine power.NTSB LAX01FA199Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Big Bear City, CAthe student pilot's selection of a takeoff runway conducive to a tailwind weather condition and his failure to maintain airspeed and his inadvertent stall during takeoff initial climb. Factors in the accident were the partial loss engine power resulting from…NTSB LAX01LA195Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Butte City, CAa fatigue failure of a propeller bolt.NTSB NYC01LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Osceola Mills, PAA partial power loss due to a stuck exhaust valve in the # 2 cylinder, which resulted in a forced landing. A factor was the rising terrain.NTSB LAX01LA161Accident · Serious injuriesLimited investigationFinal reportTaylor Bandit · Marysville, CAThe pilot performed an inadequate preflight inspection resulting in a loss of engine power at a low altitude because of water contamination.NTSB NYC01LA098Accident · Minor injuriesLimited investigationFinal reportFobes CGS Hawk Plus · West Middlesex, PAThe partial loss of engine power, for undetermined reasons. Factors included the headwinds on base leg, and the unsuitable terrain for a forced landing.NTSB LAX01LA140Accident · No injuriesLimited investigationFinal reportCessna 210B · Camp Verde, AZThe throttle linkage disconnection resulting in the engine producing idle power. A factor was the lack of suitable terrain for a forced landing.NTSB LAX01IA118Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Tucson, AZthe failure of 4th stage turbine blades during takeoff roll, which resulted in a dynamic imbalance in the engine.NTSB CHI01LA101Accident · No injuriesLimited investigationFinal reportCessna P206 · Derby, KSThe misjudged in-flight planning the pilot had for the forced landing. Factors were the induction air ducting separation, the pilot not coordinating his emergency procedure with airfield traffic, and the trees.NTSB ANC01LA039Accident · No injuriesLimited investigationFinal reportHelio H-295 · Clear, AKThe shifting of engine connecting rod bearings, and the fracture of an engine connecting rod.NTSB CHI01LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Overton, NEThe open exhaust valve. Factors relating to the accident were the sticking exhaust valve guide and the snow drift the airplane encountered during the precautionary landing.NTSB FTW01LA047Accident · Serious injuriesLimited investigationFinal reportNord 1101 · McKinney, TXthe loss of engine power during takeoff resulting from the inadequate engagement of the throttle torque tube rod end into the support bushing by unknown maintenance personnel.