NTSB investigations
1,176 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
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\" = 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 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 MKC89LA002Accident · No injuriesLimited investigationFinal reportCessna 140 · Quinter, KSThe pilot was flying at reduced power without the use of carburetor heat. The aircraft engine began to run rough. The pilot added carburetor heat and full throttle which resulted in the engine backfiring. The pilot elected to execute a precautionary landing.…NTSB BFO89LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cumberland, MDThe pilot stated that shortly after takeoff at an altitude of aprx 150 ft AGL, the engine sputtered and lost power. According to the police report, the pilot attempted to return to the airport. During the turn the wingtip contacted the ground and the airplane…NTSB ATL89LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Silerton, TNThe student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about…NTSB SEA89LA004Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Bellingham, WADrg the initial climb after takeoff, the eng lost power. Subsequently, the acft was damaged drg an emergency landing in a rough field northwest of the arpt. A post-acdnt eng run-up was made with a club prop installed. The eng operated normally to 1500 RPM…NTSB LAX88FA327Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · Fullerton, CAFailure of the pilot to properly preflight the acft followed by loss of power during takeoff. The plt also failed to about the takeoff.NTSB LAX88LA325Accident · No injuriesLimited investigationFinal reportBell 206L · Lihue, HIDuring a local sightseeing flight, the pilot reported that while on final approach for landing, the audio and light for low RPM sounded and illuminated. The helicopter was autorotated. It initially bounced when it touched down, then landed hard. The engine…NTSB LAX88LA305Accident · No injuriesLimited investigationFinal reportCessna 150J · Santa Ynez, CAThe pilot stated that while en route, the airplane's engine began to run rough. He turned on the carburetor heat. The engine returned to normal operation. The pilot turned off the carburetor heat. The engine again ran rough then lost all power. The pilot…NTSB ANC88LA115Accident · No injuriesLimited investigationFinal reportPiper PA-12 · King Mountain, AKThe pilot-in-command was maneuvering through a valley for the second time. During the second pass the engine lost power. Mixture was full rich, and the pilot applied carburetor heat and when nothing happened he turned the carburetor heat off. He attempted a…NTSB CHI88FA201Accident · 4 fatalField investigationFinal reportCessna 210B · Noblesville, INNTSB SEA88LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Yoncalla, ORStudent plt was at 8500 ft crz when pwr loss occurred. Forced lndg made in open field where acft collided with fence on lndg roll. Engine ran normally post-mishap. Fuel sample clear of water or other contaminant. Plt did not use carb heat when pwr loss…NTSB CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WINTSB CHI88DET05Accident · No injuriesFinal reportBell 47J · Dowagiac, MIFailure to maintian adequate rotor RPM by the unqualified pilot.NTSB CHI88DEV04Accident · No injuriesFinal reportGrumman G164A · Chenoa, ILUnavailability of suitable terrain on which to accomplish a forced landing.NTSB DEN88FA170Accident · 1 fatalField investigationFinal reportBeech B23 · Cimarron, NMThe pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.NTSB NYC88FA193Accident · 1 fatalField investigationFinal reportCessna 150J · Palmyra, NYCessna N51413 departed Palmyra airpark with full flaps and crashed into a barn about 75 feet past the departure end of runway 35. Afterward, the flap actuator was found in the flap up position. The pilot said that the engine lost 200 to 300 RPM about 300 feet…NTSB ANC88LA093Accident · No injuriesLimited investigationFinal reportCessna 185 · Bettles, AKThe pilot reported that the aircraft ran out of fuel approximately 25 miles from the airport. The aircraft crashed into a wooded area. The pilot stated that both fuel indicators were indicating at or near empty at the time of the accident.NTSB CHI88LA169Accident · No injuriesLimited investigationFinal reportBeech E18S · Elyria, OHDuring the takeoff roll, the right engine 'surged'. The pilot was unable to maintain directional control of the aircraft, and the aircraft swerved to the right, departed the right side of the runway, struck a ditch and groundlooped, collapsing the left main…NTSB CHI88DEI02Accident · Serious injuriesFinal reportGeddes Commander 503 · North Lima, OHPilots continued operation of the aircraft with a known deficiency and attempting to stretch his partial power descent to reach a runway rather than land off airport.NTSB FTW88LA130Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot landed on the private strip to pick up a passenger. The pilot reported that after takeoff he smelled smoke and almost immediately, the engine started cutting out. The airplane impacted the tops of tall trees, thena fence, and then impacted…NTSB CHI88DEP06Accident · No injuriesFinal reportHuntley Challenger II · Platteville, WIAfter climbing about 100' after takeoff, a partial power loss occurred & the plt initiated a left turn to rtrn to the arpt. Unable to reach the arpt, an emerg lndg was made in a corn field & the acft was damaged. No airframe failure was found & the eng ran…NTSB MKC88LA121Accident · No injuriesLimited investigationFinal reportBeech A-60 · Lexington, MOThe pilot failed to provide the aircraft with a fuel supply adequate to complete the proposed flight and the pilots failure to maintain directional control of the aircraft during the landing roll on the active runway.NTSB BFO88FA063Accident · No injuriesField investigationFinal reportPiper PA-23 · Friendly, MDShortly after takeoff at an altitude of 200 ft AGL, a power loss was experienced on the left engine. According to the plt, when the throttle was retarded to verify the engine failure, the engine seemed to 'come back to life'. The throttle was advanced and…NTSB ATL88LA206Accident · No injuriesLimited investigationFinal reportCessna 172M · Spring Creek, NCThe plt reported that the engine began to run rough & lose power as the airplane climbed through 9,000 ft MSL. She then switched fuel tanks and moved the mixture to full rich, but the engine continued to lose power. Carb heat was not used at any time. A…NTSB LAX88LA239Accident · Minor injuriesLimited investigationFinal reportCessna 206F · Healdsburg, CAJust after takeoff the engine lost power. A forced landing was made in a field where the airplane collided with rough terrain. Inspection of the engine revealed evidence of corrosion in the main fuel sump bowl and on the fuel injection throttle body fuel…NTSB FTW88DRD11Accident · Minor injuriesFinal reportSchweizer G-164B · Cheneyville, LAThe ag airplane was returning after spraying chemical when the engine started to lose power. During the forced landing on a highway the left wing struck a road sign. No mechanical reason for the engine power loss was found. The acft had an annual inspection…NTSB SEA88LA119Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Elko, NVPlt had just purchased acft and was on initial leg of cross-country flight. Plt calculated 4.9 hrs endurance, verified by CFI as adequate for proposed flt. After 4.2 hours tach time, fuel exhaustion occurred and a forced landing was executed 21 miles short of…NTSB DEN88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDNTSB MKC88LA113Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Florence, MOWhile on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss.NTSB MIA88LA190Accident · No injuriesLimited investigationFinal reportCessna 150J · Carthage, MSWhile on a personal flt, during the upwind leg after completion of the second touch-and-go landing, the plt reported that the eng sputtered. He then turned crosswind & attempted to land on a section of road under construction. Shortly before touchdown a…NTSB LAX88LA216Accident · No injuriesLimited investigationFinal reportCessna 150M · Ramona, CADuring the climb to cruise phase of the flt, the engine experienced a loss of power. The pilot applied carburetor heat and the power began to return. Due to the loss in altitude, the plt opted to make a forced landing in a field where just prior to touchdown,…NTSB MIA88FA184Accident · 2 fatalField investigationFinal reportPiper J3C · N Fort Myers, FLThe plt tkof on rwy 27 with the wind fm 060 deg at 12 gusting 23 KTS. Density alt was 2100'. Witnesses said the acft was in a slow speed, nose hi climb, when eng pwr was interrupted momentarily. Pwr was restored, but soon thereafter, the acft rolled rgt,…NTSB NYC88FA147Accident · 1 fatalField investigationFinal reportLake LA4-250 · Shaftsbury, VTThe Lake amphibian was being flown with two ferry tanks installed in the cabin. The pilot departed with full fuel in the aircraft tanks and 15 gallons in the ferry tanks. The center of gravity at zero fuel weight was 3/4 inch past the aft limit. With addition…NTSB NYC88LA154Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Kensington, NHUpon reaching the destination airport, the pilot decided to do a few touch and go landings. The aircraft touched down about 600 feet downfield at about 45-50 mph. The pilot reported that with application of full throttle, the engine hesitated. The aircraft…NTSB FTW88FA103Accident · Serious injuriesField investigationFinal reportGlobe GC-1B · Powderly, TXThe airplane had not been flown for more than seven months. It did not have a current annual inspection. Witnesses said the pilot ran the engine and it ran rough. Then he washed the airplane, then refueled, drained the sumps and ran the engine again at the…NTSB MKC88FA085Accident · Serious injuriesField investigationFinal reportCessna 182K · Neligh, NENone submittedNTSB SEA88LA087Accident · Minor injuriesLimited investigationFinal reportStearman A-75-N1 · Medford, ORPlt performed a negative 'g' maneuver, estimated at 2 to 2.5 negative 'g' force, following which the engine lost power. A forced landing was accomplished in scrub trees. The engine is equipped with a float carburetor. There were indications that the cause of…NTSB MKC88LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Dexter, MOShortly after takeoff, during an instructional night cross country training flt, the CFI said he began to lose engine RPM. He made a 180 degree turn to return to the departure apt, when he had a complete power failure. An emergency ldg was made on a freshly…NTSB FTW88IA092Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Henderson, TXThe pilot experienced total loss of power from the left engine and a partial loss of power from the right engine due to fuel starvation. The main fuel tanks on which the engines were operating were found empty but there was an adequate fuel supply in the…NTSB CHI88DEM03Accident · No injuriesFinal reportGrumman G-164A · Allegan, MIThe pilot had just completed two swath runs and was turning to start the third when the aircraft began to buffet and approached a stall. The pilot then lowered the nose of the aircraft and added full throttle. After applying full throttle the pilot stated he…NTSB NYC88LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Manchester, NHA flight to burlington, Vermont was uneventful. While on the ground at burlington the aircraft was serviced; then the flight was continued. After about one hour of flight, high engine temperature and low oil pressure was experienced and the aircraft landed at…NTSB DEN88FA087Accident · 2 fatalField investigationFinal reportCessna 421A · Albuquerque, NMThe plt and one pax were on a business trip in the U.S. From Canada. The plt had the acft fuel tanks 'topped off' prior to departure from Kansas city. The flt plan indicated 3 hours 30 min enroute to Albuquerque with 5 hours 30 min of fuel on board. Strong…NTSB NYC88LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Plymouth, MAThe pilot of the PA-24 said everything was normal until he switched fuel tanks and turned on the boost pump. He said a power loss followed. He was unable to get the engine restarted prior to making an off airport landing. A witness in the aircraft said the…NTSB FTW88LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Fabens, TXThe plt reported that the eng ran rough on a previous flt and he removed, cleaned, and replaced the spark plugs. He then took off and at a point seven miles from the departure arpt, the eng again began to run rough and intermittently. An emergency landing…NTSB BFO88LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Annapolis, MDThe plt said he did a preflight inspection of the acft which included a check for water in the fuel. Tanks were partially full- 17 gals in each one. A pre-takeoff eng runup was normal. During the initial takeoff climb the eng had a partial power loss. After…NTSB MIA88FA107Accident · 2 fatalField investigationFinal reportBeech 58P · Dunedin, FLFlt was being vectored for practice ILS approach in VFR conditions while the plt-in-command was receiving a biennial flt review. Radar data showed the acft constantly veering to the left off assigned heading and witnesses reported only hearing one engine…NTSB NYC88LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westerly, RIThe plt reported that he experienced a power loss at 350 ft AGL after takeoff. He turned back toward the airport but had insufficient altitude. He elected to land off-airport at an industrial site with the stall warning horn sounding. During landing roll, the…NTSB DEN88LA060Accident · No injuriesLimited investigationFinal reportCessna 150L · Reynolds, NDNTSB MKC88LA045Accident · No injuriesLimited investigationFinal reportCessna 195 · Rolla, MOShortly after takeoff, during a personal flight, the engine progressively lost power. The PIC attempted an emergency ldg in a pasture. During the ldg roll, the acft collided with a tree, causing substantial damage to the right wing. Post accident aircraft…NTSB MIA88LA093Accident · No injuriesLimited investigationFinal reportCessna 305A · Chuluota, FLPlt stated electric boost pump was operated longer than normal during power off glide for banner pickup. After banner pickup when full throttle was applied for climb the engine sputtered and lost power. The nose was lowered in preparation for a landing…NTSB MIA88FA094Accident · 1 fatalField investigationFinal reportCessna 411 · Venice, FLWitnesses stated that the acft was climbing & just after takeoff, the left wing dropped, the acft then leveled off, climbed aprx 75 more feet. The acft then abruptly turned hard left & went straight in, striking a wall surrounding a swimming pool, burst into…