NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases, newest first
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.\"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."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 MKC87LA058Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Tipton, MOThe pilot stated that, fifteen minutes into the flight, while at cruise the engine oil pressure began dropping as the oil temperature rose. While attempting to reach sedalia, Missouri to perform a precautionary landing, oil began covering the aircraft's…NTSB FTW87LA074Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Refugio, TXEngine failure occurred on climb. The aircraft was destroyed during the forced landing. Teardown revealed that the no. 1 cylinder rocker arm shaft retainer ear had broken. The two lock bolts had backed out because they had not been safety wired. The no. 2…NTSB MKC87LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Malden, MOThe acft was being used on training flt when the eng failed. During the forced landing in a muddy field, the acft flipped forward to an inverted position. Post accident inspection revealed the eng failed due to a connecting rod bolt failure on the number two…NTSB SEA87LA061Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Haines, AKWhile at cruise a total loss of engine oil pressure occurred with the engine seizing shortly afterwards. The aircraft was force landed into trees in a remote area. The aircraft came to rest inverted. Due to the position of the aircraft, examination of the…NTSB LAX87FA128Accident · No injuriesField investigationFinal reportBritish Aerospace BA146-200A · Fresno, CAFailure of company maintenance personnel to adequately examine the engine lubrication system when contamination was detected.NTSB NYC87LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Old Bridge, NJThe Cessna 152 took off and after becoming airborne, experienced a total loss of power. The student pilot who had made the takeoff turned control of the aircraft over to the flight instructor, who made an emergency landing in a drag strip parking lot which…NTSB ATL87FA071Accident · 1 fatalField investigationFinal reportHughes 269A · Buford, GAThe helicopter was observed to slow down over the parking lot then continued out over the lake. A puff of smoke was observed around the rear of the engine area and the helicopter fishtailed as it almost came to a stop then dropped into the water nose first.…NTSB SEA87LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Mountain Home, IDAcft lost pwr on init climb from takeoff, necessitating a forced landing in an open field. Acft nosed over inverted after touchdown in soft terrain. Investigation revealed #3 cylinder rocker arm bosses had broken. Inspection showed, during previous repair,…NTSB 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 NYC87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Marienville, PAThe Cessna 172 experienced a total loss of power while cruising at 4000 ft on an IFR flight plan. The pilot made a landing on a road and clipped a road sign after touchdown, the aircraft swerved into a ditch and received susbtantial damage. The two occupants…NTSB MKC87LA047Accident · No injuriesLimited investigationFinal reportCessna 182C · Rolla, MOThe engine started running rough enroute and pilot was able to get it running smoothly but he continued to his destination. Airplane was too high on approach so pilot went around. On downwind, engine started running rough again and pilot was unable to correct…NTSB LAX87DVD01Accident · Serious injuriesFinal reportBell 47G4A · Stockton, CAJust after takeoff, the engine experienced a power loss while transporting agricultural equipment. A fractographic examination of the failed fuel disconnect fitting by anamet laboratories, concluded that approximately 70% of the retaining ring on the fuel…NTSB FTW87LA055Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Jacksonville, TXThe pilot stated that he had added oil to the engine prior to his departure on a sight seeing flight, but on scene investigation revealed that the engine froze from oil starvation. No evidence of leakage was found. The aircraft had been owner-maintained for…NTSB CHI87LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, INAt aprx 2500 MSL, the eng stopped and attempts to restart it were not successful. The instructor took control of the acft and attempted to land on the highway, but the acft struck powerlines and a telephone pole before nosing over and coming to rest. The eng…NTSB LAX87LA098Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Tracy, CAJust after takeoff while climbing through 200 ft AGL the engine quit. The pilot made a forced landing in a gravel pit where the aircraft collided with a bank. Examination of the engine revealed that the #1 cylinder and piston had moderate to severe scuffing…NTSB ATL87LA066Accident · Minor injuriesLimited investigationFinal reportCessna 337D · Savannah, GAThe pilot was flying a donated aircraft in support of a program to document the activities of wright whales off the coast of the carolina's and Georgia. The plt had been with the owner on a previous flt, when problems developed while switching to/and/or from…NTSB LAX87LA082Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Spring Valley, CAA Mooney M20C collided with an automobile during landing roll after landing on a road. The plt indicated that while cruising at 3,500 ft MSL he noticed the eng oil pressure fall to zero. The constant speed propellor simultaneously went to low pitch, followed…NTSB MKC87LA039Accident · No injuriesLimited investigationFinal reportCessna 120 · Salem, ARThe airplane was being ferried when the engine failed. The only available field had cattle, hills and trees. On landing roll the pilot had to brake hard to avoid trees. The airplane nosed over to the inverted position. Inspection revealed total engine failure…NTSB LAX87FA072Accident · 1 fatalField investigationFinal reportNorth American T-28C · Van Nuys, CAThe plts were practicing lndgs, and were on the 3rd flt after the eng had been overhauled. After takeoff from a tough-&-go, the instructor noticed that the oil temp was high. Soon thereafter, the eng began to run rough, then it seized. Unable to get back to…NTSB CHI87DEP04Accident · No injuriesFinal reportMooney M20F · Greenwood, WIThe aircraft lost engine power during a descent due to a loose throttle linkage and the pilot was forced to make an emergency landing in a field. On landing roll the aircraft struck a reflector post with the right wing.NTSB LAX87FA065Accident · 1 fatalField investigationFinal reportRockwell 112TC · Gardena, CAThe pilot elected to return and land at his home airport when the aircraft's landing gear failed to retract after a night takeoff. After reentering the traffic pattern the pilot changed his fuel selector to the left tank for landing. As the aircraft turned…NTSB MIA87FA041Accident · Serious injuriesField investigationFinal reportCessna 320 · Panama City, FLWhile executing an ILS approach with aircraft radios that were not operating properly and using a hand held transceiver, the right engine failed due to a broken fuel pressure sensor wire, and the pilot lost control of the aircraft in IMC conditions and…NTSB LAX87DUJ01Accident · Minor injuriesFinal reportRobinson R-22 · Tucson, AZAfter 50 minutes of cruise flight, the pilot observed a decrease in oil pressure to zero and the illumination of the low oil pressure light. The pilot landed the helicopter and had an airframe and powerplant mechanic inspect the aircraft. There were no…NTSB MKC87LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Harrison, ARThe routine business flt had progressed normally until approaching bentonville, Arkansas. The PIC rptd his eng ran rough for a very brief period and quit. Emerg procedures were conducted but a restart was impossible. Only 1.5 hrs of flt had transpired since…NTSB SEA87LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-400 · Oregon City, ORShortly after takeoff, an eng failure occurred. The plt elected to make a forced lndg on a freeway. During the landing, the acft collided with two vehicles. An inspection revealed an eng oil line had ruptured which led to oil exhaustion. Evidence indicated…NTSB ATL87FA009Accident · Minor injuriesField investigationFinal reportBell 206B III · Nashville, TNThe plt was in a descent toward a building in a downtown area which he wanted aerial photographs of. At about 1700 ft AGL he reported the helicopter jerked hard and yawed to the left. He initiated an autorotation and during the descent to the selected landing…NTSB NYC87FA022Accident · 1 fatalField investigationFinal reportGulfstream American 112 · Beekman, NYThe acft departed dutchess county airport, poughkeepsie, NY, and had an engine failure due to inadequate lubrication. The oil filter was found disconnected from the engine. At duthess county airport parking area, fresh oil was found on the grass parking area…NTSB NYC87DNC02Accident · No injuriesFinal reportCessna 172M · Van Buren, MEWhile climbing from 1000 ft. the pilot of a C-172 expericed an engine failure at 1500 ft and made an emergency landing striking small trees and brush. Subsequent inspection of the engine revealed that the crankshaft dowel pin was sheared and the crankshaft…NTSB LAX87LA015Accident · No injuriesLimited investigationFinal reportCessna 182A · King City, CAWhile cruising near King City, CA, the aircraft lost power and an attempt to restart the engine was unsuccessful. The aircraft was then landed in a field, but it collided with a tree during the landing roll. An examination of the aircraft revealed that the…NTSB NYC87DNC01Accident · No injuriesFinal reportEnstrom F-28A · Belmont, NHThe helicopter was in cruise flt when an engine failure occurred. The plt entered an autorotation and made a hard landing which collapsed the left front strut. The nose lowered as the tail cone rose and the main rotor made contact with the tail rotor. The…NTSB CHI87LA003Accident · No injuriesLimited investigationFinal reportCessna 150L · East Jordan, MIThe pilot stated that after extending 10 degrees of flaps and applying carburetor heat on final apch, he reduced throttle. Upon throttle reduction, the engine quit. Inspection of the engine revealed a broken mixture control cable housing. The engine operated…NTSB MIA87LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Lakeland, FLThe plt stated the acft lost power and he was unable to make it to the arpt. The acft crashed in a field about 3/4 of a mile from the Lakeland arpt. Post crash examination of the eng revealed a complete failure of both magnetos, resulting in the loss of power…NTSB CHI86FA233Accident · 1 fatalField investigationFinal reportBeech E18S · Chicago, ILThe acft had departed on rnwy 13. He was then directed to climb to 6000 ft. thirty seconds later he advised he had eng trouble and was returning to the arpt. Shortly thereafter he advised he could not maintain alt. The acft, one mile se of the arpt, struck…NTSB MIA86LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Arcadia, FLWhile established in curise flight the engine failed and all attempts to start it were to no avail. The pilot executed a forced landing to a soft field and the aircraft nosed over. Examination of the engine revealed that the #1 engine exhaust valve had failed…NTSB CHI86LA236Accident · No injuriesLimited investigationFinal reportHughes 269B · Baldwin, WIAfter picking up his passenger at williams pipeline, minneapolis, Minnesota, the plt flew eastward along interstate 90 enroute to a pipeline near wausau, Wisconsin. While flying at approximatelly 400 feet, the plt and passenger stated that the engine started…NTSB MKC86LA193Accident · No injuriesLimited investigationFinal reportCessna T210M · Old Monroe, MOThe PIC had initiated his descent ot his destination arpt when he rptd experiencing eng pblms. The rough running eng finally quit and the PIC made a forced lndg to an open fld. The subsequent lndg encountered a ditch and the nose gear collapsed. Exam of the…NTSB MIA86IA250Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Atlantic Ocean (Atlantic Ocean)The helicopter ditched in the Ocean after sustaining a flameout. After the helicopter was towed ashore on its floats the fuel system was found to contain at least 4 gals of fuel. Info contained in helicopter manual revealed all fuel was usable except about 1…NTSB SEA86LA249Accident · No injuriesLimited investigationFinal reportCessna P-210 · Pasco, WAWhile in cruise at 14,000 feet MSL, a catastrophic engine failure with a flash fire at the turbocharger occurred. A turn to reverse direction for a forced landing was initiated while making a rapid descent. An undershoot to the runway occurred with the…NTSB ATL86LA261Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Plymouth, NCDuring a turn to reverse direction while dispersing chemicals over a peanut crop, the engine lost power. The pilot dumped the load of chemicals and made a hard full stall forced landing in the peanut field. Inspection of the engine revealed that the left…NTSB NYC86FA234Accident · Serious injuriesField investigationFinal reportCessna U206F · Holoyoke, MAWhile en route at 6000 ft, the acft lost power. The plt descended through a scattered layer of clouds and made a forced landing in a grass covered field 1 1/2 miles north of barnes municipal airport, shearing off the nose gear and coming to rest inverted.…NTSB FTW86FA156Accident · 1 fatalField investigationFinal reportGreat Lakes 2T-1A-2 · Houston, TXThe ends of the outer string and the inner reinforcing wire of the engine air intake duct were not properly positioned under the duct clamp during installation. As a result, they unwound during engine operation and moved out of their normal position on and in…NTSB ATL86LA230Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Shellman, GAJust after liftoff, the plt noted smoke and attributed it to an overhauled prop which had just been installed. He then heard a loud squeal from the eng and noted a loss of power. A forced landing was made in a rough corn field, where the acft was damaged. An…NTSB MKC86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Wilson, KSThe pilot stated that before the flight the spark plugs were cleaned and inspected and the engine was serviced with eleven quarts of oil. Three hours into the flight instrument meteorological conditions (IMC) with rain was encountered and shortly thereafter…NTSB LAX86LA331Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Salton City, CAA total loss of power was experienced during a descent from 17,500' MSL to 10,000' MSL. Attempts to restart the engine failed and the acft was landed gear-up in a rocky field. Post accident inspection disclosed a track of internal electrical arcing in the…NTSB MIA86LA242Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Pierce, FLWhile in cruise flt the acft's eng failed and the acft was ditched in a river. Post crash eng exam revealed the no. 1 and no. 2 connecting rods separated from the crankshaft when both bolts failed on the no. 1 rod and 1 bolt failed on the no. 2 rod.…NTSB MIA86FA239Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Vero Beach, FLFlight experienced loss of engine power while climbing through 200 feet shortly after takeoff. While attempting to return to the runway the aircraft collided with trees and the ground coming to rest adjacent to the runway. Examination of aircraft records…NTSB MKC86LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Goodwin, ARThe ag acft was being used to spray nudrin on soybeans when the engine lost power. The plt made a forced landing in a rice field and the acft flipped forward to the inverted position. Investigation revealed the two-piece cam reduction gear came apart. An AD…NTSB LAX86FA326Accident · Serious injuriesField investigationFinal reportCessna 182N · Wilmington, CADuring a local night instructional flt the plts reported that the eng began to run very rough and eventually quit when power was reduced slightly to begin the descent for the destination arpt. The acft struck power lines, two small buildings and a brick wall…NTSB MKC86FCD03Accident · Serious injuriesFinal reportRoger Warnell KR-1 · Waterloo, IAThe pilot reported that he had carburetor problems. The engine quit and the pilot made a forced landing about one mile from airport. This was the pilots first flight in this aircraft.NTSB MIA86LA238Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Merritt Island, FLThe plt stated that while he was towing a banner the engine lost fuel pressure and the RPM began to deteriorate. He dropped his banner and tried to make it back to the airport but couldn't and landed short of runway 29 in the water. Post crash examination of…