NTSB investigations, 1987
276 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 344 |
|---|---|
| 1983 | 386 |
| 1984 | 389 |
| 1985 | 341 |
| 1986 | 311 |
| 1987 | 276 |
| 1988 | 311 |
| 1989 | 296 |
| 1990 | 322 |
| 1991 | 250 |
| 1992 | 229 |
| 1993 | 254 |
| 1994 | 219 |
| 1995 | 220 |
| 1996 | 217 |
| 1997 | 212 |
| 1998 | 166 |
| 1999 | 160 |
| 2000 | 159 |
| 2001 | 116 |
| 2002 | 124 |
| 2003 | 140 |
| 2004 | 121 |
| 2005 | 115 |
| 2006 | 102 |
| 2007 | 111 |
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\" = 353)
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" = 353) 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 LAX88LA078Accident · No injuriesLimited investigationFinal reportCessna 150K · San Andreas, CANTSB MIA88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLEn route to the destination during a cross country flt, the acft was diverted to an alternate arpt due to weather conditions below minimums. Unable to land at the alternate due to poor visibility the non-instrument rated plt requested vectors to the…NTSB ATL88FA069Accident · Serious injuriesField investigationFinal reportCessna 172M · Warner-Robins, GAThe non-ifr rated plt dptd in VFR wx. He subsequently encountered IFR wx several hrs after departure and attempted to continue on to his destination arpt in IFR conditions. He made several VOR approaches to the destination arpt. But was unable to visually…NTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…NTSB LAX88LA077Accident · No injuriesLimited investigationFinal reportCessna 150E · Hilo, HIDuring a local pleasure flt, while climbing to 5500 feet, the engine sputtered and quit. During the landing roll, the acft nosed over. The engine was examined with no mechanical failures or malfunctions noted. The acft was operating in the range of serious…NTSB LAX88LA076Accident · No injuriesLimited investigationFinal reportCessna 210K · Chowchilla, CADuring a cross country flt, the plt had diverted to another arpt for fuel. The plt was unable to activate the rwy lights and a forced landing was made that was perpendicular to the rwy. Upon inspection of the acft, an incorrect frequency was noted on the…NTSB MIA88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLU.S. Coast guard personnel stated that the pilot reported that they were out of fuel and were ditching approximately 110 miles southeast of Marathon FL. The pilots were picked up by the coast guard and were transported back to miami.NTSB MKC88LA030Accident · No injuriesLimited investigationFinal reportCessna 150H · Siloam Springs, ARWhen the airplane was on downwind, the pilot thought he was pulling on the carburetor heat. The pilot attempted to apply power on final and found the engine was windmilling. The pilot found he had pulled the mixture instead of the carburetor heat. During the…NTSB CHI88FA035Accident · 1 fatalField investigationFinal reportBeech 58 · Wedron, ILThe airplane struck trees and descended uncontrolled into a river while attempting a night forced landing after running out of fuel during a cargo flight. The airplane was found under water on the fifth day of a search conducted by the cap after two boys…NTSB BFO88FA010Accident · Serious injuriesField investigationFinal reportSwearingen SA-226 · Chantilly, VAThe acft had descended through a cloud layer enroute for the scheduled lndg at iad and according to the crew had picked up some trace rime ice on its wing surfaces. Although pitot and sas (stall avoidance system) heat were used the captain elected not to use…NTSB MIA88LA062Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Ocoee, FLThe plt rprtd that before takeoff, he made a thorough preflt, which included a check of the fuel sys for contaminates & water, but no discrepancies were noted. Shortly after takeoff, at an alt of aprx 100 ft, the eng sputtered & lost pwr. The plt stated he…NTSB MKC88FA026Accident · Serious injuriesField investigationFinal reportVarga 2150A · Conroe, TXThe pilot took off for a short flight without being sure of his fuel quantity. He was not able to locate his destination which was 32 NM from his departure airport. The engine stopped and the pilot attempted a forced landing. During the forced landing, the…NTSB FTW88FA035Accident · Serious injuriesField investigationFinal reportLockheed 250 TRI-GEAR · Dallas, TXThe right engine of the aircraft failed three times in flight. After the last failure near the middle marker the pilot feathered the propeller. The aircraft collided with power lines and the ground about 400 yards short of runway 31 at the redbird airport.…NTSB FTW88DPA01Accident · No injuriesFinal reportBell 206B · Dallas, TXThe fuel pump warning light came on and the pilot headed for a local airport. Enroute, the engine surged and flamed out. During the landing, the rotor blades hit trees, and the helicopter made a hard landing. The fuel gage indicated 11 gallons. Later the gage…NTSB LAX88DVG02Accident · No injuriesFinal reportGrumman G-164A · Williams, CAShortly after takeoff, the engine experienced a loss of engine power. The pilot made a forced landing and collided with a fence on hilly terrain during the landing roll. The engine was inspected with no reported mechanical failures or malfunctions. Wx…NTSB ATL88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Paducah, KYAbt 20 mi from Paducah (pah), the plt contacted the fss & said the acft was low on fuel & that he intended to land at pah. He was informed that the FBO at pah was closed for the night & fuel was available only if a $25 call-out fee was paid. Also, he was told…NTSB LAX88LA063Accident · Minor injuriesLimited investigationFinal reportCessna 177 · San Carlos, AZThe plt added pwr on final approach and later stated that the eng seemed to be losing pwr. He said he noticed that the fuel selector was l of ctr abt 1/2 inch, ctrd it and added carb heat, however the eng still quit. The acft was too low to land on the rwy so…NTSB ATL88LA047Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Northport, ALBefore reaching the arpt, the eng lost power. Subsequently, the acft was damaged during an emerg landing on an embankment about 1.5 mi short of rwy 29. Only about 1 cup of fuel was found in each fuel tank. The plt thought there was about 12 gal of fuel…NTSB LAX88FA058Accident · Minor injuriesField investigationFinal reportCessna T210N · Fullerton, CAWhile on final appr to runway 24 at Fullerton arpt, the pilot experienced a total engine power loss. The airplane's alt was insufficient to land on the runway & the plt elected to land in an open area adjacent to the arpt. The airplane's left wing collided…NTSB DEN88LA029Accident · No injuriesLimited investigationFinal reportCessna 182RG · Boulder, MTWhile on a cross country flt at 6000 ft MSL, the eng lost power. Exam of the acft revealed that the left fuel tank contained 23 gallons while the right was empty. The fuel selector was found on the empty tank. The acft was destroyed during the emergency…NTSB DEN88LA028Accident · No injuriesLimited investigationFinal reportCessna 150L · Aberdeen, SDThe private plt was returning home with his son and encountered marginal VFR weather. The flight continued through freezing rain and snow at below freezing temperatures for over twenty minutes. When carburetor heat was applied for landing, the plt reported…NTSB LAX88LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Honolulu, HIThe pilot estimated that the aircraft's reduced fuel quantity was adequate for the flight during his preflight inspection. As the aircraft descended for the traffic pattern near the destination airport both engines failed. After the loss of power the pilot…NTSB MIA88LA041Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Roseland, FLThe acft was preflighted approx 20 min after refueling with no discrepancies noted. The plt had difficulty starting the acft. Mechanics flushed the acft fuel lines and declared the acft ok. No water was found in the fuel sumps or strainer during the plts…NTSB CHI88FA024Accident · Serious injuriesField investigationFinal reportBeech TC-45J · St Clair Shores, MIWhile enroute to home base after delivery of revenue cargo, the pilot experienced a total loss of engine power in both engines due to fuel exhaustion. The pilot performed emergency procedures and set the aircraft up for a forced landing in a grassy field on…NTSB CHI88LA027Accident · No injuriesLimited investigationFinal reportCessna 150J · Patoka, INWhile enroute to Patoka airport for fuel the aircraft experienced fuel exhaustion and the pilot was forced to make an emergency landing in a field. The aircraft landed approximately two miles northeast of the airport. The nose gear of the aircraft became…NTSB DEN88LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260B · Akron, COBfr tkof, snow was melted off the acft in a heated hangar. The flt was bgn in blowing snow with a forecast of ocnl mod icing to 20,000'. The plt said the snow lasted only 5 to 10 min & only a trace of ice (less 1/16 inch) accumulated drg the 1st 15 min of…NTSB LAX88LA046Accident · No injuriesLimited investigationFinal reportCessna T210M · Colusa, CAThe pilot executed a missed approach at the destination because of fog and reduced visibility. The pilot elected to divert to Colusa due to the weather and on approach to calusa the engine quit. Attempts to restart the engine were unsuccessful and the pilot…NTSB LAX88LA043Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe plt rprtd that during an external load operation, the helicopter ran out of fuel. Subsequently, it was damaged when it touched down hard during a forced landing.NTSB MKC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Des Moines, IAApprox eight miles from the dest arpt, the PIC experienced partial, then a complete power loss. An emergency lndg was made on a golf course, about one mile short of the dest arpt. Post accident inspection revealed no fuel in any of the four tanks. Damage was…NTSB LAX88LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Jamestown, CADuring a local sightseeing flight over a lake, the plt reported after circling for some time at a low altitude, the engine lost power. The plt made an emergency landing on the lake where the acft sank. Several days later, the acft was retrieved and the engine…NTSB ATL88LA035Accident · No injuriesLimited investigationFinal reportMooney M20A · Southport, NCThe airplane lost engine pwr shortly after takeoff. A forced ldg was subsequently made in a nearby waterway. Post-crash exam of the airplane revealed that the fuel selector was in the left tank position, and that the left tank contained about 1/2 gallon of…NTSB LAX88LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Corona, CAThe acft lost engine pwr during cruise and during the ensuing forced landing the acft collided with an object and was damaged. The post acc inspection revealed that the acft fuel tanks were empty and the fuel lines lacked fuel. No other malfunctions were…NTSB MKC88LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bonne Terre, MOThe plt rprtd the eng lost pwr fm fuel exhaustion as he was cruising at ngt on a x-country flt at 6500' MSL. He declaredan emerg with st louis apch & reqd vectors to the nearest arpt. The controller (ctlr) provided vectors to the Bonne Terre arpt which was…NTSB CHI88LA017Accident · No injuriesLimited investigationFinal reportCessna T210N · Sugar Grove, ILWhile descending for landing the aircraft experienced total power failure due to fuel exhaustion. An emergency landing was made on a road and on short final, the aircraft collided with power lines which ran along the south side of the road. According to the…NTSB ATL88LA028Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Beaufort, SCThe airplane engine lost pwr at cruise and the plt made a forced lng in a salt-water marsh. Investigation revealed that the plt was ferrying the acft to another arpt to have maintenance performed on the fuel selector valve, which was stuck in the aux tank…NTSB NYC88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norfolk, MAThe pilot of the Cessna 172 was making her third takeoff, having made two prior takeoffs and landings to a full stop, when she experienced a loss of power. The aircraft ran off the departure end of the runway and was observed to porpoise several times prior…NTSB MKC88LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Sweet Springs, MODuring a night cross country flight an emergency ldg was made due to complete power failure. PIC said he failed to visually check fuel supply before departure, and also failed to check winds aloft, which were quartering headwinds, of twenty five knots. Post…NTSB MKC88FA012Accident · Serious injuriesField investigationFinal reportMerchant Pitts S-1S · Vinton, IAThe plt was rprtd to be on a maint ferry flt to another state. He rprtd that before the flt, he topped off the fuel tank & that the preflt, takeoff & departure were normal. Due to low clouds, he leveled off at aprx 2000' AGL. Shortly thereafter, the eng RPM…NTSB FTW88LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Angelo, TXWhile on a long final approach the aircraft ran out of fuel. The pilot made a forced landing in a field. During landing roll the nose gear collapsed, the main landing gear came off, and both wings were damaged. The pilot stated that he could have avoided the…NTSB LAX88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Casa Grande, AZDuring an instructional flt, the student was performing climbs, descents and turns when the engine sputtered and lost power. The flight instructor took control of the aircraft but was unable to restart the engine. The aircraft was landed on a dirt road where…NTSB FTW88MA021Accident · Minor injuriesMajor investigationFinal reportConvair 640 (340D) · Bartlesville, OKThe capt was cross-feeding both engines from the right tank while the first officer (f/o) was flying, without informing the f/o. the capt then left the cockpit while cross-feeding. Both tank valves and the right boost pump were on. The right tank ran dry, the…NTSB FTW88LA019Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Fort Supply, OKThe acft was forced to land due to loss of eng power. The plt attempted to land on a roadway. During the landing the acft rt wing struck a fence post. The landing gear collapsed during a groundloop after lndg. Post acc investigation revealed that the eng was…NTSB ATL88LA024Accident · Minor injuriesLimited investigationFinal reportCessna 337C · Columbus, OHPIC rpted rear eng quit after take-off. Fuel selector found on right main tank which was empty. Prop was not feathered and landing gear was found in transient position after crash. Owners manual cautions against higher drag with gear in transit due to large…NTSB FTW88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Brownsville, TXWhile executing a single engine ILS approach to a touch and go landing, the CFI pulled the mixture control on the right engine. Upon landing the pilot applied full power to both engines but the right engine did not respond. About 2 ft above the rwy the…NTSB NYC88LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Pepperell, MAA student pilot on a cross country training flight experienced fuel exhaustion at about 3500 feet. The pilot stated that when the engine lost power he contacted approach control on 121.5 but did not have sufficient altitude to make it to an airport. The…NTSB MIA88LA018Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Key Colony Bch., FLThe plt stated that he did not check the fuel system for contaminates after refueling but an eighteen minute flt after refueling was uneventful. He then landed the helicopter, remained on the ground aprx 20 minutes, performed a walk around insp, again without…NTSB FTW88FA011Accident · 1 fatalField investigationFinal reportCessna 172M · Midway, TXThe plt (a co-owner) was on the 1st flt of the acft after its 150 HP Lycoming O-320 eng had been replaced with a 180 HP Lycoming O-360 eng. He took off at about 1115 CDT. The flt progressed w/o rprtd incident until 1437 CDT, when the plt stated the acft was…NTSB LAX88LA021Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Chino, CAThe pilot and passenger both stated that the engine lost all power during the final approach for landing. The passenger switched the fuel tank selector from the left to the right tank. There was not time to attempt a restart. He then raised the landing gear…NTSB MIA88FA012Accident · Serious injuriesField investigationFinal reportCessna 210M · Jacksonville, FLDuring a part 135 on-demand air taxi cargo flt, the plt reported an eng malfunction when the acft was aprx 15 miles sw of the arpt while on apch to land. The flt continued & the plt then reported that the eng quit & the flt was 5 miles sw of the arpt. A…NTSB SEA88LA010Accident · No injuriesLimited investigationFinal reportCessna 150-M · Myrtle Creek, ORA loss of power occurred shortly after takeoff due to fuel exhaustion. A field was chosen for the off airport landing. During the landing rollout the aircraft struck a fence and raspberry bushes, collapsing the nose gear.