NTSB investigations, OK
48 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 1 |
| 1992 | 3 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 4 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
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\" = 'OK' 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\" = 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 c."eventStateOrRegion" = 'OK' 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" = 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 FTW04LA110Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Locust Grove, OKThe improper installation of the generator, which resulted in oil starvation. A factor was the unsuitable terrain.NTSB FTW03FA120Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Broken Arrow, OKFailure of the engine due to the blow-by condition in the number six cylinder for undetermined reasons, which resulted in oil starvation and eventual failure of the associated connecting rod end cap. Also causal was the pilot's failure to maintain airspeed…NTSB FTW01LA143Accident · Minor injuriesLimited investigationFinal reportCommander 114-B · Okmulgee, OKthe failure of the #6 cylinder's connecting rod, which resulted in a complete loss of engine power. A contributing factor to the accident was the lack of suitable terrain for the forced landing.NTSB FTW00LA038Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Stillwater, OKThe total loss of engine power due to the dry-rotted diaphragms in the pressure carburetor. A factor was the hilly terrain encountered during the forced landing.NTSB FTW00LA028Accident · No injuriesLimited investigationFinal reportCessna 210K · Ponca City, OKInadequate quality control by the manufacturer of the throttle control cable, which resulted in failure of the cable due to fatigue. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA009Accident · Minor injuriesLimited investigationFinal reportCessna 150G · El Reno, OKThe total loss of engine power resulting from a fatigue failure of the intake rocker arm for the #4 cylinder. A factor was the soft terrain encountered during the forced landing.NTSB FTW99FA235Accident · 1 fatalField investigationFinal reportBeech D-35 · Seminole, OKThe loss of engine power caused by oil starvation, which resulted in the failure of the #6 cylinder connecting rod bolts. A factor was the pilot's performance of an evasive maneuver to avoid impacting buildings, trees, people on the ground, and power lines.NTSB FTW99LA023Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Tulsa, OKThe loss of engine power due to detonation for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98FA229Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Guthrie, OKThe designated pilot examiner's decision to execute a single engine go-around which exceeded the airplane's engine out climb capability in the gear down configuration. Factors were the arcing of an electrical wire that grounded the engine starter and the high…NTSB FTW98LA171Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cushing, OKThe total loss of engine power resulting from a sheared accessory drive due to an undetermined reason. A factor was the lack of suitable terrain for the forced landing.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 FTW97LA146Accident · No injuriesLimited investigationFinal reportBeech G33 · Bixby, OKfailure of a number two connecting rod bolt, possibly from being either over-torqued or under-torqued during installation, and failure of the pilot to see-and-avoid the transmission line, while performing a forced landing.NTSB FTW96IA248Incident · No injuriesIncident investigationFinal reportFairchild SA227-DC · Enid, OKfailure of the accessory drive bearing, causing the accessory drive gear teeth to shear and disengage the fuel pump accessory drive shaft, resulting in a disabled fuel pump and subsequent fuel starvation.NTSB FTW96LA094Accident · No injuriesLimited investigationFinal reportCessna A188B · Enid, OKThe pilot's failure to maintain sufficient airspeed during the forced landing and to jettison the aircraft's load for a forced landing. A factor was the engine's failure due to a disconnected fuel line which was the result of improper maintenance.NTSB FTW96LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Dibble, OKan overload failure of the #1 connecting rod bolt and resulting connecting rod fatigue failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94FA295Accident · 2 fatalField investigationFinal reportCessna 175 · Oklahoma City, OKImproper maintenance of the engine by unknown person(s), the installation of unapproved parts, and subsequent bearing seizure. The lack of suitable terrain in the forced landing area was a related factor.NTSB FTW94FA273Accident · 3 fatalField investigationFinal reportCessna 310 · Pryor, OKFailure of the pilot to maintain minimum control airspeed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were: an oil leak from a fatigue crack in the engine crankcase, and inadequate maintenance.NTSB FTW94LA166Accident · No injuriesLimited investigationFinal reportBell 47G · Sulphur, OKThe loss of engine power due to the failure of an engine accessory oil pump gear. A factor was the lack of suitable terrain for the autorotation.NTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.NTSB FTW92LA122Accident · No injuriesLimited investigationFinal reportCessna A188B · Washita, OKThe failure of the main landing gear during the forced landing due to corrosion and fatigue. A factor was the power loss due to a fractured crankshaft.NTSB FTW92LA101Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Weatherford, OKFuel starvation due to a mechanical failure of the fuel selector. A factor was the lack of suitable terrain.NTSB FTW90LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Tulsa, OKAn engine failure due to a disconnect in the magneto drive train caused by the crankshaft gear not being properly installed and secured during a recent engine overhaul.NTSB FTW90DPJ01Accident · Minor injuriesFinal reportZimmerman Moni Motorglider · Oklahoma City, OKPower loss due to the deteriorated muffler baffle which was not discovered in the recent annual inspection. A factor was the pilot's failure to properly analyze and correct for the headwind.NTSB FTW89LA160Accident · No injuriesLimited investigationFinal reportCessna 210P · Bethany, OKA loose fuel line connection, due to inadequate maintenance, which resulted in fuel starvation. Factors related to the accident were: darkness and the obstructions (hay bale & approach light pole) in the emergency landing area.NTSB FTW89DPJ05Accident · No injuriesFinal reportNord Stampe SV4C · Bartlesville, OKTotal failure of the engine connecting rod.NTSB FTW89LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Edmond, OKImproper maintenance performed by the company mechanic who failed to tighten the oil sump plug, and also failed to safety it.NTSB FTW89LA003Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Fairfax, OKThe plt reported that the engine locked and he made a forced landing in a muddy, plowed field. The airplane landed hard and the plt received a fracture to the skull just above his right eye. During engine teardown, the head from the exhaust valve on the…NTSB DCA88MA059Accident · Serious injuriesMajor investigationFinal reportEmbraer EMB-110P · Lawton, OKNone submittedNTSB FTW87DPJ02Accident · Serious injuriesFinal reportAir Tractor AT-302 · Colony, OKDuring a downwind swath run the number one compressor bearing failed in the ltp 101-600-1A engine which resulted in the engine failing completely. During an attempt to turn into the wind for an emergency landing the left wing tip struck the ground and the…NTSB FTW86LPJ11Accident · Minor injuriesFinal reportHomebuilt SA-100 · Oklahoma City, OKThe acft nosed over during a forced landing after a power loss. The plt stated after the accident that the engine lost power during a roll maneuver. The engine ran for a short time at aprx 1800 RPM and then stopped completely. The plt landed in a cultivated…NTSB FTW86LA148Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Altus, OKThe engine failed at 10,500 feet MSL and the pilot was vectored to a small private sod strip. However, this strip had been closed and plowed up for about a year and was not listed on the current aeronautical charts. The pilot was then revectored to another…NTSB FTW86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Bartlesville, OKThe plt took off on a test flt after an annual inspn of the acft & a top overhaul of the eng had been completed. While climbing thru about 1200 to 1300 ft AGL, the eng started running rough, then quit. The plt attempted to return to the arpt, but was unable.…NTSB FTW85LA322Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cushing, OKThe plt was test flying the acft after a major eng overhaul.a left turn was made away from the arpt after takeoff and immediately thereafter the eng lost pwr. With no suitable landing area within gliding distance, the acft was manuevered straight ahead where…NTSB FTW85LA290Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Guthrie, OKThe plt stated he lost eng power shortly after takeoff and during initial climb. He elected to go into the trees due to lack of altitude to allow a more suitable landing area. An eng examination disclosed that the no. four exhaust valve was stuck open due to…NTSB FTW85LA073Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe acft experienced a power failure while in cruise flight at 1100 ft AGL. He stated that after switching tanks, the 'engine started twice bit failed to continue'. Investigation revealed that the left fuel tank was empty and the right tank had an…NTSB FTW84FA342Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Tulsa, OKOn climbout from a night takeoff, a complete power loss occurred. The plt attempted to return to the airport, but insufficient altitude was available. During an ensuing forced landing, the acft collided with trees before ground impact. An investigation…NTSB FTW84LA213Accident · No injuriesLimited investigationFinal reportAerospatiale AS 315B · Hartshorn, OKThe helicopter sustained substantial damage during an autorotative landing following an explosion in the engine compartment. While in level flight at 1000 ft AGL, the plt heard a loud screech from the engine area followed by a loud bang. A wingman observed 10…NTSB FTW84LA051Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Moore, OKThe acft crashed during a forced landing after the engine quit. The acft had a prior forced landing and the fuel pump was suspect. Post accident investigation showed that only one safety pin was installed in the fuel selector shaft allowing excessive free…NTSB FTW83FA406Accident · 1 fatalField investigationFinal reportPiper PA 28R-200 · Copan, OKThe acft collided with an electric transmission line and burned during an emergency landing. The flt had been in progress only an hour when the plt lost his engine oil pressure and his engine failed. ATC gave him a heading to the nearest arpt but he could not…NTSB FTW83FA311Accident · Minor injuriesField investigationFinal reportBell 47G-2 · Bethany, OKThe helicopter collided with trees and rolled over during a forced landing after engine failure. The plt had been takingpassengers up for sight-seeing for several hours. After the last flt he and his wife had departed the city park to fly back to the acft…NTSB FTW83FPJ02Accident · Serious injuriesFinal reportCessna R172E · Little, OKThe acft had been landed twice to check for leaking fluid on the windshield. When the fuel pressure went to zero and theengine quit the leak was confirmed to be acft fuel. During a forced landing the acft struck a fence and the nose gear collapsed. The…NTSB FTW83LA082Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Mangum, OKThe pilot stated that shortly after takeoff the left engine surged twice and quit. He elected to make a precautionary landing in an open field which was soft from melting snow. During roll out the nose wheel dug in and the drag link broke which collapsed the…NTSB FTW83LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Ardmore, OKPilot tookoff with prop governor inoperative. While cruising 21 miles south of Ardmore, he began to loose oil pressure and turned toward Ardmore. Engine quit 4 miles from airport. Pilot declared an emergency and descended through the clouds. He went through…NTSB FTW83LA019Accident · No injuriesLimited investigationFinal reportNorth American F-51D · Piedmont, OKThe eng failed at 5,500 ft MSL. During an emergency landing at a 5,000 ft dirt strip (under construction for paving), gear extension was delayed to increase glide. The right gear did not have time to lock down & retracted during landing. Initial exam of the…NTSB LAX82FVG30Accident · Serious injuriesFinal reportPiper PA-36-285 · Malin, OKPower loss during takeoff resulted in forced landing. Aircraft collided with canal bank. Cylinder had broken rings. Both plugs were badly oil fouled. One plug would not fire & the other fired intermittently.NTSB FTW82DA227Accident · No injuriesFinal reportBoeing 75A · Picher, OKThe pilot had just completed spraying a field and was climbing to return to his home airstrip when the engine failed. He landed in a nearby pasture but was unable to stop on the wet terrain before hitting a low fence. The main gear caught on the fence and the…NTSB FTW82DA153Accident · No injuriesFinal reportJurca 3/4 Spitfire · Bartlesville, OKDuring initial climb on the first flight of the homebuilt aircraft, the engine failed. The aircraft was landed off the airport and demolished. Investigation revealed the fuel pump drive designed by the builder had failed.NTSB FTW82FPJ11Accident · No injuriesFinal reportPiper PA-28R-201T · Watonga, OKThe pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…