NTSB investigations, 1987
55 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 33 |
|---|---|
| 1983 | 43 |
| 1984 | 74 |
| 1985 | 60 |
| 1986 | 60 |
| 1987 | 55 |
| 1988 | 64 |
| 1989 | 44 |
| 1990 | 48 |
| 1991 | 67 |
| 1992 | 52 |
| 1993 | 45 |
| 1994 | 53 |
| 1995 | 44 |
| 1996 | 27 |
| 1997 | 44 |
| 1998 | 35 |
| 1999 | 37 |
| 2000 | 45 |
| 2001 | 37 |
| 2002 | 29 |
| 2003 | 39 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 29 |
| 2007 | 34 |
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\") = 1987
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\" = 354)
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") = 1987 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" = 354) 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 FTW88LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Fargo, OKDuring takeoff roll, the engine RPM dropped to 2600 and started running rough. Shortly after takeoff, the pilot elected to make a precautionary landing. During landing roll the aircraft's left wing hit a tree causing substantial damage to the aircraft. Prior…NTSB LAX88LA050Accident · No injuriesLimited investigationFinal reportCessna 150H · Fullerton, CAAs the aircraft began its initial climb after takeoff, the engine began to run rough and the pilot elected to land on a street. The aircraft impacted street signs during the ground roll and collided with the street curbing. Post acc investigation revealed the…NTSB FTW88LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Mangum, OKAccording to the pilot, the engine started running rough during cruise flight. He elected to make a forced landing and intentionally stalled the aircraft into some trees to cushion the impact, substantially damaging the aircraft. The pilot further stated that…NTSB MIA88FA049Accident · 1 fatalField investigationFinal reportBeech K-35 · Crescent City, FLThe pilot experienced a partial engine failure at lift off with 1/2 of the runway remaining in front of him. The pilot then attempted to do a 180 degree teardrop back to the runway, stalled and crashed. Investigation revealed water contamination of the fuel…NTSB DEN88LA031Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Conner, MTOn takeoff from a private, grass strip the pilot stated the engine began to lose power at approximately 20 to 30 feet AGL. A ravine was ahead and he attempted to stretch his glide to the FAR side of the ravine; however, the aircraft stalled and crashed into…NTSB FTW88LA026Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dallas, TXThe plt reported that the acft was no. 3 in the pattern for landing on rwy 17. He said carb heat was applied on downwind and eng power was used until the acft was on a 3 mi final. At that point pwr was reduced and a glide was established. A short time later…NTSB MKC88LA010Accident · No injuriesLimited investigationFinal reportCessna 182 · Atwood, KSThe PIC said that he did an engine runup and allowed the engine to run about 6 additional minutes before commencing the takeoff. The PIC said that upon reaching 100 feet altitude in the takeoff sequence, he observed a decline in engine revolutions per minute…NTSB ATL88LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Homer, GAThe pilot reported a gradual decrease in power after reaching 4000 feet. The plt was unable to obtain a restart. He then elected to attempt a forced landing in a field. The aircraft collided with a tree prior to landing. The aircraft collided with and came to…NTSB ATL88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Scyrene, ALThe engine lost pwr during a low-altitude powerline patrol. The airplane nosed over during the subsequent forced ldg. Post-crash examination of the acft by an FAA inspector revealed that the fuel tank vent system was obstructed with mud-dauber nests in…NTSB LAX88LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Livermore, CAThe right engine ran rough during the initial climb phase of a personal flight. The pilot advised the tower controller of the aircrafts loss of power and entered the downwind leg of the traffic pattern for landing. The pilot stated that the aircraft was…NTSB ANC88LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wind River, AKThe acft lost power during takeoff and the acft stall/mushed back to ground contact. The pilot stated that the partial power failure was due to carburetor icing. The examination of the aircraft engine revealed no mechanical failure or malfunction.NTSB LAX87FA337Accident · Serious injuriesField investigationFinal reportPiper Aerostar 601P · Corona, CAThe airplane was refueled before it dept on the accd flight; the pilot did not supervise the fueling. Shortly after takeoff, the plt advised the ontario dept controller that both engines were experiencing a power loss and that he suspected jet fuel…NTSB ANC87LA150Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Island Lake, AKThe pilot stated that during the initial climbout the aircraft lost power, stalled, and crashed into a row of trees near the lake. The pilot also stated it was fuel contamination which caused a partial power loss.NTSB BFO87LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Tappahannock, VAThe acft was at 1500 MSL when a 300 RPM loss of power occurred. The plt sighted a private landing strip and he decided to make a precautionary landing on it. During the landing roll on the 62 ft wide grass strip the l wing struck corn stalks in an adjacent…NTSB LAX87LA320Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sonora, CADuring a pleasure flt the engine suddenly lost partial power. The plt made a forced landing in a parking lot where the aircraft touched down and collided with a fence that borders the lot. The engine was inspected and test run for approx 20 minutes at…NTSB LAX87LA316Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Condord, CAAfter an annual inspection the acft was prepared for a test flight. The pilot loaded 3 passengers and began the run-up checks. During run-up the left engine ran rough. After the roughness cleared the pilot initiated the takeoff. As the acft accelerated down…NTSB LAX87LA299Accident · No injuriesLimited investigationFinal reportBeech C23 · Mammoth Lakes, CADuring a pleasure flight, just after take-off, the engine experienced a partial loss of power when the plt positioned the carb heat control to full cold. The plt stated that in order to obtain full power, during the runup he would position the carb heat to…NTSB NYC87FA215Accident · 4 fatalField investigationFinal reportCessna 182Q · Sparta, NJThe acft was observed to fly near power lines, then roll inverted, crash & burn in a wooded area. The 4 occupants rcvd multiple impact injuries which were fatal. The acft was destroyed by the impact & post crash fire. Svrl witnesses rprtd the eng power was…NTSB MKC87LA151Accident · No injuriesLimited investigationFinal reportCessna 150F · Bono, ARThe pilot said he had glided down to 500 feet AGL with the throttle reduced to idle trying to locate a landing strip. He said he applied power and the engine responded too late to avoid hitting a levee in the rice field and he flipped to the inverted position.NTSB FTW87FA175Accident · No injuriesField investigationFinal reportCessna 337B · Laporte, TXThe aircraft had been sitting outside in the wx since its last annual inspection on 12/1/84. After purchasing the aircraft, the pilot (who is an aircraft and powerplant maintenance technician) examined it and a ferry permit was issued by FAA for the proposed…NTSB SEA87LA143Accident · No injuriesLimited investigationFinal reportCessna 170B · Coeur D'Alene, IDOn initial climb a partial loss of power occurred and the pilot made a forced landing in a wheat field. During landing roll the aircraft's left main gear struck an irrigation pipe and the aircraft nosed over inverted. No evidence of a preimpact mechanical…NTSB ATL87LA215Accident · No injuriesLimited investigationFinal reportCessna 150K · New Carlisle, OHDuring a takeoff attempt, the student retarded the throttle shortly after liftoff. This flt was the student plts second flight and the first flight with this instructor. The student was instructed to follow along on the flight controls. This was the first…NTSB BFO87LA060Accident · Minor injuriesLimited investigationFinal reportFleet 16B · Spencer, WVShortly after takeoff on runway 16, the engine began misfiring. The pilot turned back toward the airport to make a landing. He circled the airport and then attemped to land on runway 34. The pilot stated he was over the approach end ofrunway 34, turning left…NTSB ANC87LA093Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Dillingham, AKThe student pilot stated that the aircraft lost partial power during the take off run due to water being ingested into the engine air filter as he made his water takeoff. He elected to continue with the takeoff attempt and struck the shoreline prior to…NTSB MKC87LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Lincoln, NEAfter completing an IFR simulated NDB approach to runway 35L, PIC side-stepped to land VFR on 35R. During base leg acft had a partial power loss followed shortly by total power loss. PIC informed control tower of the emergency and made a forced ldg in a farm…NTSB MIA87FA189Accident · 2 fatalField investigationFinal reportBeech 23 · Miramar, FLAfter the plt lndd, the acft was serviced with 58.9 gal of fuel. Its fuel capacity was 60 gal. Subsequently, when the plt took off, the acft remained on the rwy for about 2500' of the available 3000'. After lift-off, the acft entered a rgt turn & reached a…NTSB CHI87DCA01Accident · Minor injuriesFinal reportBeech 3NM · Cahokia, ILThe acft experienced a loss of pwr in the rt eng immediately aft tkof. The plt was not able to feather the propeller and was forced to land in a wheat field on arpt property. Conditions were conducive to carburetor icing at the time of the accd. Investigation…NTSB MIA87FA176Accident · No injuriesField investigationFinal reportBell 206L-1 · Winter Haven, FLThe pilot stated that on short final approach the engine began surging and losing power. He attempted to stretch the glide and the aircraft landed hard, short of the intended point of touchdown. The engine was removed, examined, partially disassembled and…NTSB FTW87FA137Accident · Serious injuriesField investigationFinal reportGrumman AA-1B · Bulverde, TXThe plt attempted liftoff two or three times but after each try the acft would settle back onto the rwy. When about 50 yards from the end of the rwy, the acft again lifted off the ground and climbed to about 15 ft. the plt stated that the stall warning…NTSB DEN87LA144Accident · No injuriesLimited investigationFinal reportCessna 188B · Malta, MTAfter takeoff on initial climb the acft had a pwr loss which resulted in a forced landing. A hard landing occurred in an open field which sheared off the main landing gear and damaged the airframe. The cause of the pwr loss could not be determined.NTSB DEN87LA142Accident · No injuriesLimited investigationFinal reportBell 206B II · Logan, UTThe plt did not have authorizatoin from his employer to conduct the flight. The plt stated after the acc that he was on a LCL flt with the pax to view property. He cont to state that drng a rt turn the eng low rotor RPM warning sounded. The plt executed an…NTSB DEN87LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monticello, UTThe plt stated after the accident that shortly after departure the pax smelled something burning. The plt circled the arpt and determined the flt could continue. A short time later the burning smell returned followed by a loss of fuel pressure. The plt…NTSB DEN87LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Milbank, SDThe private plt and a pax were on a local flt. On climb out, at about 50 feet AGL, the engine had partial pwr loss. The plt landed straight ahead in a field and made a successful forced landing. On roll out, the nose wheel fell into a hole and the acft nosed…NTSB DCA87MA033Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Kenner, LAThe acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…NTSB DEN87LA131Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Emerado, NDThe commercial plt was en route on a personal flt. Thirteen miles from his destination, he smelled oil fumes and the cabin filled with oil smoke. The engine oil pressure dropped to zero. The plt shut down the engine, ventilated the cabin, and declared an…NTSB MKC87DPG01Accident · 1 fatalFinal reportCessna A188B · Lake Village, ARAfter completing several spary swaths, the pilot began another turn for another spray swath. A witness stated that during this right turn, the aircraft initiated a left descending turn and crashed into nearby trees and then burned. Examination found no…NTSB NYC87DGM02Accident · No injuriesFinal reportNoonan VARI-EZE · Ebensburg, PAThe vari-eze was part of a three ship flyby at an airshow. The accident aircraft was observed to break formation and turn downwind for a landing. A witness reported the engine sputtering. The aircraft landed in a open field next to the runway. Examination…NTSB DEN87LA126Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COThe private plt and his pax were starting a cross country business flt. The plt reported that on initial climb, at 100 feet AGL. The acft lost partial pwr and began to settle. A gear up, forced landing to a field resulted in substantial damage to the acft.…NTSB ATL87FA136Accident · 2 fatalField investigationFinal reportPiper J4A · Collierville, TNIt was reptd that the plt was taking his pax up for a LCL photographic flt at the req of the pax. Witnesses reptd that the acft remained over the apt for two or three circuits and then deptd the area in the dir of Collierville. Witnesses near the crash site…NTSB CHI87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kentland, INPilot reported a loss of power approx. 10 to 30 feet above the runway. The aircraft came to rest along the left side and approx. 1500 feet down the 3500-foot runway. Inspection of the aircraft after the accident did not reveal any evidence of engine problems.…NTSB ATL87DEG05Accident · No injuriesFinal reportEnstrom F-28A · Wilmington, OHDuring a climbout the pilot reported a power reduction. The engine continued operating and the rotor RPM dropped as the helicopter climbed to 10 feet. The wreckage examination failed to disclose any system malfunction or failures. The pilot was attempting to…NTSB LAX87LA195Accident · Serious injuriesLimited investigationFinal reportCessna 402A · Kahului, HIShortly after takeoff, the plt reqd an 'immediate downwind' to rtrn to the arpt & was clrd to land. When asked if equip-ment was needed, he replied, 'negative, sir, a little matter of fuel.' A witness said the acft appeared very low on final apch with both…NTSB FTW87FA100Accident · No injuriesField investigationFinal reportBeech D55 · Cameron, LAThe left engine lost power at rotation but, due to the short runway (2500-SOD), the pilot elected to continue the takeoff. He switched the left fuel selector, placed the boost pump switch in the 'high' position and retracted the landing gear and flaps but did…NTSB ATL87LA118Accident · Minor injuriesLimited investigationFinal reportBeech A23-19 · Huron, OHSoon after takeoff the aircraft experienced a loss of power and made a forced landing 200 feet short of the runway. The pilot reported a loss of fuel pressure. The FAA reported that the fuel aboard the aircraft had the smell and appearance of auto fuel. The…NTSB ATL87FA111Accident · 1 fatalField investigationFinal reportAeronca 7AC · Sharpsburg, GAPlt dep a pvt grass airstrip for a LCL VFR flt. Acft was observed to lift off the grass rwy at about 1000 ft. it climbed to about 30 ft AGL and leveled off. At about the end of the 1800 ft rwy the acft nosed up into a 'fairly steep' climb attitude. The ground…NTSB CHI87DER05Accident · Minor injuriesFinal reportPiper PA-25 · Henning, MNAfter experiencing a rough running engine the pilot initiated an emergency landing. During the off airport landing, the aircraft received substantial damage and the pilot reported minor injuries. This was this pilot's first experience in this type of…NTSB DEN87LA089Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bountiful, UTThe stud plt was practicing stalls about 10 n of arpt. During recovery from a stall the eng began to run rough. The plt said he advanced throttle, applied carb heat, and tried to adjust mixture. The eng continued to run rough and lose pwr and the plt returned…NTSB FTW87LA091Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Horizon City, TXThe pilot delayed in initiating recovery from a simulated forced landing. Then when the throttle was advanced from idle to full open the engine hesitated briefly and full power was restored too late to recover. A hard left bank was initiated to align the…NTSB ATL87FA101Accident · Serious injuriesField investigationFinal reportBeech A36 · Dalton, GAOn t/o at 1st power change PIC noted loss of performance. He turned left to downwind leg for landing. PIC and ground witnesses said eng quit and acft crashed into trees and ground. Post crash fire destroyed acft. PIC rpted taking fuel sample before t/o with…NTSB LAX87LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Chandler, AZWhile clbg fm a go-arnd at abt 400' AGL, the instructor (CFI) shut dwn the l eng by closing the mixture & the student (pvt plt) feathered the left prop. The CFI then moved the prop ctl out of the feather psn, but the prop rmnd feathered. The CFI was unable to…