NTSB investigations, 1997
91 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 175 |
|---|---|
| 1983 | 165 |
| 1984 | 138 |
| 1985 | 155 |
| 1986 | 126 |
| 1987 | 129 |
| 1988 | 160 |
| 1989 | 129 |
| 1990 | 123 |
| 1991 | 128 |
| 1992 | 133 |
| 1993 | 115 |
| 1994 | 129 |
| 1995 | 151 |
| 1996 | 119 |
| 1997 | 91 |
| 1998 | 78 |
| 1999 | 91 |
| 2000 | 92 |
| 2001 | 70 |
| 2002 | 54 |
| 2003 | 78 |
| 2004 | 63 |
| 2005 | 65 |
| 2006 | 62 |
| 2007 | 59 |
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\") = 1997
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\" = 351)
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") = 1997 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" = 351) 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 NYC98LA056Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Ferncliff, VAthe improper installation of the engine oil temperature probe which resulted in oil starvation and a total loss of engine power. A factor in the accident was the pilot's overflight of available airports in an effort to reach the 'Nearest Airport' displayed on…NTSB LAX98LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Truckee, CAinternal mechanical failure of the engine due to a progressive failure of the No. 3 connecting rod assembly. A contributing factor was the snow pack which covered the only accessible emergency landing area.NTSB NYC98LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Fairplain, WVan improper overhaul of the fuel servo by the manufacturer, which resulted in the loss of engine power. Factors in the accident were the dark night conditions and rough forced landing terrain.NTSB FTW98LA062Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Houston, TXThe total loss of engine power resulting from detonation and the ensuing failure of the engine piston and connecting rod components. Factors were: the instructor's decision to take off with a known deficiency (magneto drop over limit), the flight instructor's…NTSB MIA98LA037Accident · Minor injuriesLimited investigationFinal reportCessna FR-172J · Marietta, GAA catastrophic failure of the oil cooler core which led to overboard porting of lubricating oil and subsequent engine failure.NTSB LAX98LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Saipan, MaliThe loss of engine power for undetermined reasons that resulted in the pilot ditching the aircraft into the ocean.NTSB MIA98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palatka, FLthe student pilot's failure to properly secure the oilcap/dipstick within it's integral oil filler tube during his preflight inspection.NTSB FTW98LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Van, TXfuel starvation, resulting from restricted carburetor float travel, due to improper maintenance installation. The encounter with a power line was related factor.NTSB FTW98LA039Accident · No injuriesLimited investigationFinal reportCessna 175 · Arnaudville, LAa cracked fuel line, which allowed air to enter the line and lead to fuel starvation and loss of engine power. A related factor was: the lack of suitable terrain for a forced landing.NTSB LAX98LA037Accident · No injuriesLimited investigationFinal reportRodgers/Gaust RV-6 · Wellington, NVFuel starvation due to a fatigue fractured mixture control cable. Contributing factors were the soft, brush-covered emergency landing field.NTSB CHI98FA028Accident · 6 fatalField investigationFinal reportBeech BE 58 · New Berlin, ILA loss of engine power due to separation of the left engine's number 2 connecting rod as a result of fatigue failure. Also causal was the pilot's failure to maintain adequate airspeed which resulted in a stall/spin. Contributing to the accident was the…NTSB NYC98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Scottsville, VAimproper engine operation by undetermined person(s) that initiated gauling on the connecting rod, and led to its subsequent failure.NTSB FTW98LA026Accident · No injuriesLimited investigationFinal reportCessna 182P · Thompsons, TXThe loss of engine power resulting from a disconnected carburetor float due to improper maintenance. A factor was the lack of suitable terrain for a forced landing.NTSB ATL98LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Miami, FLexcessive wear to the number one valve stem and valve stem keepers that resulted in the separation of the valve assembly.NTSB FTW98LA016Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Altus, OKThe loss of engine power due to the cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB IAD98LA004Accident · No injuriesLimited investigationFinal reportFord RV-4 · Dansville, NYThe internal mechanical failure of the engine driven fuel pump which resulted in a loss of engine power.NTSB NYC98LA005Accident · No injuriesLimited investigationFinal reportCessna 120 · Mineral Wells, WVA loss of engine power to a blockage in the carburetor resulting in fuel starvation.NTSB NYC98LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Gt. Barrington, MAslippage of the number 2 main bearing for undetermined reason(s) which resulted in a broken crankshaft.NTSB ATL97LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fulton, MSThe excessively rich mixture produced by the carburetor, which led to the fuel exhaustion.NTSB ATL97LA136Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Zellwood, FLfailure of mechanics to adequately torque the crankcase through-bolts following a top overhaul, which subsequently resulted in a crankshaft failure. Soft/uneven terrain in the emergency landing area was a related factor.NTSB MIA97LA243Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Oxford, NCfatigue failure of the No.4 connecting rod in an area where galling had occurred, which resulted in loss of engine power and a forced landing. Related factors were: the pilot's lack of communication by failing to select the proper UNICOM frequency; and his…NTSB MIA97FA242Accident · 1 fatalField investigationFinal reportMooney M20F · Coral Springs, FLThe pilot's misjudging the distance vs. altitude resulting in the collision with the water short of the intended touchdown point of the rough field. Contributing to the accident was the total loss of engine power due to failure of the No. 3 cylinder…NTSB ANC97FA143Accident · 2 fatalField investigationFinal reportAero Commander AC-500A · Ketchikan, AKThe rupture of the right engine fuel supply line as a result of inadequate inspection by the pilot/mechanic, and the pilot's excessive pull up which resulted in exceeding the design stress limits of the airplane. Factors were the improper emergency procedures…NTSB LAX97LA307Accident · No injuriesLimited investigationFinal reportCessna T210M · San Martin, CAInstallation of improper connecting hardware by maintenance personnel, and, the inadequate inspection of the installed hardware by inspection personnel resulting in separation of the engine throttle linkage.NTSB CHI97LA273Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIfailure of a connecting rod in the engine assembly, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: lack of a recommended engine overhaul, and the lack of suitable terrain for an emergency landing.NTSB FTW97LA321Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Sudan, TXThe loss of engine power due to the failure of a compressor turbine blade. A factor was the lack of suitable terrain for the forced landing.NTSB SEA97LA195Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Elk City, IDOil starvation of the engine due to undetermined reasons, which led to the failure and separation of a main bearing and a connecting rod. A factor contributing to the accident was the lack of suitable terrain for a successful forced landing.NTSB ATL97LA124Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Anderson, SCthe pilot misjudged distance and speed on final approach to land and failed to attain a proper touchdown point during the landing, which resulted in an overrun of the runway and collision with a fence. A related factor was the loss of engine power during…NTSB SEA97LA193Accident · No injuriesLimited investigationFinal reportCessna TU206G · Edwall, WAA fatigue failure of the engine crankshaft. Factors contributing to the accident were the rolling terrain, and the fence.NTSB CHI97LA260Accident · No injuriesLimited investigationFinal reportCessna 182 · Derby, KSthe Airworthiness Directive and propeller overhaul not being complied with. Factors to the accident were the propeller blade retention failure and rough/uneven terrain condition.NTSB FTW97FA304Accident · 1 fatalField investigationFinal reportGrumman G-164 · Wilmot, ARThe loss of engine power due to a fractured throttle cable because the cable housing prevents an inspection of the cable by maintenance personnel. Factors were the pilot's impairment due to a heart attack, the lack of suitable terrain for the forced landing,…NTSB ATL97FA115Accident · 2 fatalField investigationFinal reportMooney M20F · Tallahassee, FLfatigue failure of the crankshaft for undetermined reasons. Related factors were: darkness, and obstructions (trees) in the emergency landing area.NTSB LAX97LA280Accident · Serious injuriesLimited investigationFinal reportNorth American Navion B · Las Vegas, NVThe separation of the number 3 cylinder due to improper overhaul procedures, and the failure to adequately torque the cylinder hold down nuts and through bolts to specification.NTSB LAX97LA269Accident · Serious injuriesLimited investigationFinal reportMitteer Mini 500 · Agua Dulce, CAfailure of the owner/builder to obtain and comply with service literature from the kit manufacturer, which resulted in improper setting of the carburetor fuel mixture and led to loss of engine power. An additional cause was the pilot's failure to successfully…NTSB LAX97LA266Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Buckeye, AZThe total oil exhaustion of the engine due to the inadequate maintenance installation of the oil cooler lines by the owner/mechanic.NTSB MIA97LA222Accident · No injuriesLimited investigationFinal reportWaco YMF5 · Lake Buena Vist, FLfailure of maintenance personnel to follow installation procedures pertaining to the torque of the propeller retention nut, which resulted in a loose propeller retention nut, subsequent fatigue failure of the crankshaft, and loss of engine power. The lack of…NTSB ANC97LA112Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Palmer, AKA fatigue failure of the engine crankshaft, and an inadequate engine cylinder replacement by maintenance personnel. A factor in the accident was unsuitable terrain for a forced landing.NTSB NYC97GA148Accident · Serious injuriesFinal reportSchweizer 269C · Baltimore, MDA total loss of engine power which was a result of incomplete and improper engine overhaul by company maintenance personnel. A factor in the accident was the unsuitable forced landing area terrain.NTSB LAX97LA247Accident · No injuriesLimited investigationFinal reportSikorsky S-58T · Page, AZan engine failure resulting from the fracture of two power turbine blades, which had been previously subjected to a hot or hung start.NTSB ATL97LA104Accident · No injuriesLimited investigationFinal reportCessna 177RG · Knoxville, TNthe pilot's inadequate preflight by failing to ensure the oil filler cap was secured during his preflight inspection, and loss of engine oil (oil exhaustion), which resulted in subsequent engine failure. A factor relating to the accident was: the lack of…NTSB LAX97LA242Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Lake Mead, NVFailure of the number 4 piston for undetermined reasons.NTSB ANC97FA097Accident · 4 fatalField investigationFinal reportPiper PA-32 · Skagway, AKjamming/failure of the left magneto impulse coupling, which stopped rotation of the magneto gear, and resulted in subsequent shearing of the accessory intermediate idler gear. Factors relating to the accident were: the lack of suitable terrain for a forced…NTSB ATL97LA091Accident · Serious injuriesLimited investigationFinal reportBeech E50 · Tullahoma, TNimproper operation of the engine that produced internal damage, and improper servicing of the airplane by the owner/pilot mechanic that resulted in the subsequent mechanical failure of the engine crankshaft counterweight. Contributing to the accident was the…NTSB LAX97IA209Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Las Vegas, NVthe maintenance/overhaul facility's improper repair, which led to obstructed oil supply hole(s) at the #5 bearing inner race, then oil starvation and subsequent uncontained engine failure.NTSB FTW97LA223Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400A · Black Oak, ARThe loss of engine power due to compressor turbine blade failure. A factor was the lack of suitable terrain for the forced landing.NTSB ATL97LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbus, MSinadequate maintenance/inspection and subsequent corrosion of the air filter, which resulted in pieces of the air filter to block the intake to the carburetor and result in loss of engine power. A factor relating to the accident was: failure of maintenance…NTSB ANC97LA084Accident · No injuriesLimited investigationFinal reportAnderson Kitfox IV-1200 · Fairbanks, AKa seized crankshaft connecting rod bearing. A factor relating to the acciden was: the lack of suitable terrain for an emergency landing.NTSB FTW97LA202Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lamar, COFailure of the left magneto and crank shaft idler drive gears. Factors were failure to perform a 100 hour inspection and unsuitable terrain for a forced landing.NTSB CHI97LA145Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-G · Colusa, ILimproper installation of the rocker arm assembly by maintenance personnel which led to the failure of the rocker arm. A factor was the soft terrain.NTSB LAX97LA192Accident · Minor injuriesLimited investigationFinal reportCrosby GEE BEE Sportster · Watsonville, CAan unknown failure of the engine oil system, which resulted in loss of oil and a seized engine.