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 LAX88DVG03Accident · No injuriesFinal reportSchweizer G-164B · Gridley, CADuring an agricultural operation, the engine quit at approximately 50 feet AGL. The airplane was landed on a dirt field and nosed over. Inspection of the engine revealed that the left magneto drive gear teeth were missing and the right magneto drive gear was…NTSB ATL88FA155Accident · Serious injuriesField investigationFinal reportCessna 150L · Knoxville, TNNTSB SEA88FA083Accident · 1 fatalField investigationFinal reportCessna 310G · Las Vegas, NVDuring initial climb at 100 ft after takeoff, the pilot announced he had lost an engine. Witnesses observed the aircraft enter a nose high attitude, roll to the right and descend in a vertical nose down attitude until impact with the ground. The aircraft…NTSB ATL88IA146Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101/102 · Dothan, ALDuring cruise flight at 12,000 ft, the flight crew of the DHC-8 observed a low oil pressure warning light. About five seconds later, the right engine fire warning light illuminated. Fire was confirmed and the extinguisher discharged. The fire was extinguished…NTSB MIA88LA148Accident · Serious injuriesLimited investigationFinal reportHenderson RV-4 · Defuniak Sprngs, FLShortly after takeoff at an alt of aprx 100 ft while on a personal flt, the eng quit. The plt banked the acft to the left to land on a rd but lost control during the maneuver. The acft descended uncontrolled and collided with terrain. Examination of the…NTSB SEA88LA077Accident · No injuriesLimited investigationFinal reportBeech K-35 · Pullman, WAWhile on final for the runway the pilot advanced the throttle and the engine lost power. The aircraft was landed short of the runway onto a field, where the nose gear collapsed during the landing roll. Mechanics who examined the aircraft after the accident…NTSB BFO88FA036Accident · Minor injuriesField investigationFinal reportFokker F28 MK 4000 · Charleston, WVEngine and airframe failure were caused by the the separation of the first stage low pressure turbine disk. The disc interstage seal was installed inadequately, resulting in rubbing between the seal and disk, causing failure of the disk. Inadequate procedure…NTSB ANC88IA047Incident · No injuriesIncident investigationFinal reportCessna 207A · Takslesuk Lake, AKThe scheduled commuter flight, friendship flight 305, was en route from chevak, Alaska to bethel, Alaska. During cruise flight, the airplane experienced an engine failure resulting a a forced landing on rough, snow covered terrain. The pilot-in-command stated…NTSB LAX88LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Coarsegold, CAWhile at cruise flight, the engine surged twice then quit. During the emergency landing, the airplane collided with the terrain. Inspection of the engine revealed that the number three connecting rod broke.NTSB CHI88DEM04Accident · No injuriesFinal reportAnderson Pitts S-1S · Mt. Pleasant, MIThe pilot was performing some inverted maneuvers when the engine quit. The pilot stated he attempted to restart the engine but was unable to. He then executed an emergency landing in a farm field. During the landing roll the pilot was unable to maintain…NTSB FTW88DRA06Accident · 1 fatalFinal reportNeff BD-4 · Beaumont, TXDuring the flight, an oil-like odor was detected and oil spots appeared on the windshield. The oil pressure dropped to zero and the engine failed. During the forced landing on a highway, the left wing struck a road sign. The spar/ fuel tank ruptured and the…NTSB LAX88LA154Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Pine Valley, CAFailure of the number one connecting rod bearing. Contributing to this accident was the student pilot's relative inexperience and his inability to judge the glide ratio of the airplane and completing a forced landing in unsuitable terrain.NTSB NYC88LA117Accident · No injuriesLimited investigationFinal reportMooney M20 · Manchester, NHMaintenance personnel improperly installed the number two connecting rod (p/n L-10646) causing it to separate, create a hole in the engine case, loss of engine oil and engine power. Due to the pilot's improper inflight decision, he performed a wheels up…NTSB ATL88FA125Accident · Serious injuriesField investigationFinal reportPiper PA-28-235 · Summerville, SCNTSB MKC88LA071Accident · No injuriesLimited investigationFinal reportRockwell S2-R · Stuttgart, ARDuring a post maintenance test flt, PIC experienced a power loss shortly after lift off. The acft crashed nose low, in a left turn. The engine was thrown clear of the airframe. Post accident inspection of the propeller blades indicated a minimum amount of…NTSB FTW88LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Weatherford, TXA forced landing was attempted following a complete eng failure. The plt overshot the intended touchdown pt and pulled the acft off the grnd in an attempt to clear a busy hwy. however, the acft struck wires located next to the road. Evidence indicated that…NTSB CHI88DEE03Accident · No injuriesFinal reportPiper PA-22-150 · West Chicago, ILThe plt rprtd that just after leveling off, the eng started to sputter. He initiated emergency procedures, but was unable to restore power. During an emergency landing at dusk, the acft hit a ditch & nosed over. An investigation revealed the #3 exhaust valve…NTSB DEN88IA083Incident · No injuriesIncident investigationFinal reportCessna 210 · Billings, MTNTSB LAX88LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-201T · Bullhead City, AZShortly after takeoff, the engine failed. During the forced landing the aircraft ran into a rock quarry. Inspection of the engine revealed that the fuel injector lines were loose and that one line had separated.NTSB ATL88FA110Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Rock Hill, SCThe plt and a certificated pilot/pax departed the Rock Hill apt for a local maint test flt following an engine overhaul and installation. About 10 minutes into the flt, the engine oil pressure dropped to zero and a complete loss of power followed. The plt…NTSB FTW88FA077Accident · Minor injuriesField investigationFinal reportFairchild M-62C · Arlington, TXFailure of the number six cylinder and piston.NTSB CHI88DEM02Accident · No injuriesFinal reportGalloway XTC · Lowell, MIThe pilot of the homebuilt aircraft was attempting to perform some 'pattern flights' when, after turning on to the base leg of the traffic pattern, the engine seized. The pilot attempted to 'dead stick' the aircraft to the runway, but altitude and airspeed…NTSB ANC88LA034Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Mcgrath, AKThe pilot had begun his descent for his destination airport 20 miles away when the engine lost all power. He was unable to restart the engine, and made a forced landing in deep snow. The pilot reported that he had been airborne for approximately two hours…NTSB SEA88FA054Accident · Minor injuriesField investigationFinal reportCessna T210N · Burns, ORThe aircraft engine quit during cruise flt on a bright moonlit night cross country flt at 8000 ft AGL, 28 NM west of Burns, OR. The pilot reversed course in an emergency descent and followed a straight 50 ft wide hwy toward Burns. At approx 500 ft. AGL the…NTSB NYC88LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Maybrook, NYThe Piper PA-28 took off for a local pleasure flight. After takeoff the pilot noticed that the engine was running rough and he had lost his oil pressure. The engine seized and an off-airport landing was made in a snow covered field. Post-crash examination of…NTSB FTW88IA078Incident · No injuriesIncident investigationFinal reportCessna T210M · Grosebeck, TXThe pilot made a forced landing following engine failure. Teardown examination showed the no. 4 exhaust valve head had separated from the stem. Metal debris was found in the oil sump. The no. 1 connecting rod was separated from the crankshaft. There was…NTSB FTW88FA072Accident · Minor injuriesField investigationFinal reportCessna P206D · Eagle Lake, TXAn inflight fire erupted following the separation of the number 4 cylinder. A metallurgist determined that studs failed in fatigue. The aircraft continued to burn after the emergency landing and was completely destroyed. The acft had an annual inspection…NTSB CHI88LA068Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILNTSB FTW88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Worth, TXThe flt was cruising at 2,000 ft MSL when the eng lost pwr. The student plt changed fuel tanks and the engine regained pwr for about 20 sec then again lost pwr. During the forced landing the acft collided with a fence and nosed over. Examination of the eng by…NTSB SEA88FA050Accident · Serious injuriesField investigationFinal reportBell 206A · Roseburg, ORWhile hovering at 200' AGL, the eng lost power & the plt entered an autorotation. He maneuvered to avoid trees & landed amid tree stumps in a logging clear cut area. An investigation revealed the 1st stage turbine wheel had failed. The wheel exited the eng &…NTSB FTW88FA064Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Laplace, LAPlt was in level crz flt at night when he observed sparks and flame coming from the eng cowling. Shortly thereafter, the eng began running rough and then seized. After declaring an emergency and being cleared straight in to a runway about 28 miles away, the…NTSB MKC88IA046Incident · Minor injuriesIncident investigationFinal reportSaab-Fairchild SF-340A · Fayetteville, ARThe capt rprtd that drg the lndg roll, there was a loud noise from the left eng followed by hvy smoke & an eng fire warning bell. He stopped the acft on a twy & ordered an evacuation. The flt attendant had difficulty opening the floor-level emerg exit. No…NTSB LAX88DUK01Accident · Minor injuriesFinal reportColman BD-4 · Half Moon Bay, CANTSB LAX88LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Diamond Springs, CADuring a dual instructional flt, approaching the airport the engine experienced a total loss of power. The plt made a forced landing in a field where during the landing roll the acft nosed over. There were no mechanical failures or malfunctions reported. The…NTSB NYC88FA069Accident · 2 fatalField investigationFinal reportCessna 182L · Waynesburg, PAShortly after departure from runway 26, the aircraft engine failed. The aircraft banked to about 90 degrees, descended and impacted the ground. A flight instructor described the wind as very gusty and varying out of the south at approximately 10-20 knots. The…NTSB FTW88LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Littlefield, TXThe connecting rod cap attaching bolt failed in flight which caused the engine to stop. The pilot was on final approach at the time but was unable to reach the runway. A forced landing was made in a farm field short of the airport. Upon touchdown the aircraft…NTSB MKC88FA039Accident · Serious injuriesField investigationFinal reportCessna 177RG · Camden, ARThe pilot reported that he lost all engine power during cruise. He attempted to make the Camden, Arkansas airport. The aircraft did not make the intended landing area and struck a tree and subsequently, a swamp area. The accident investigation revealed no…NTSB CHI88FA041Accident · 3 fatalField investigationFinal reportFairchild SA226T · Pontiac, MIAcft was scheduled for an instructional flt. During the wx briefing, the CFI told the fss specialist that the flt would include eng-out practice. Witness statements indicate that the acft rolled sharply to the rt and nosed down after attaining about 100 ft of…NTSB CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.NTSB DEN88LA046Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Vernal, UTThe commercial plt and two passengers were surveying a road route in mountainous terrain. At cruise, the pilot noticed a drop in manifold pressure, followed by a loss of oil pressure. The plt reported that the engine quit. An autorotation to a snow covered…NTSB FTW88DPA02Accident · No injuriesFinal reportCessna 150M · Gainesville, TXThe pilot lost engine power due to a throttle cable which failed during flight. He then made a 360 degree turn to lose altitude before initiating an emergency landing on an airport. He lost excessive altitude during the turn which resulted in an off-airport…NTSB DEN88FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Draper, UTDrg a ngt flt to reposition the acft to its home base, the eng lost pwr as the plt was cruising at about 1000' AGL. He transmitted a 'mayday' call & maneuvered the acft to make a forced lndg on an interstate hiway. While apchg to lnd, the acft struck the top…NTSB ATL88FA055Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Lagrange, GAPlt lost power in cruise, in day, VMC. Made apch to interstate hwy I85. Hit overpass support column at 15 feet AGL. Engine overhauled 51 hours before accident. Overhaul records indicated magneto repair. Annual insp records indicated compliance with AD…NTSB ATL88FA052Accident · Serious injuriesField investigationFinal reportPiper PA-60-600 · Mansfield, OHThe pilot departed louisville, KY reportedly with a known oil leak in the right engine and was on the second leg of an on-demand air taxi cargo flight. About 14 minutes after entering Mansfield approach control airspace, the pilot requested and received an…NTSB CHI88LA031Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Danville, ILEarlier in the day, the acft was flown from Danville to rochelle, IL. While on a return flt without refueling, the eng began losing power, so the plt moved the fuel selector to the rgt tank (which indcd 1/4 full) & power was restored. However, about 2 min…NTSB ATL88FA040Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Lewisburg, KYThe pilot experienced a loss of engine power at 5500 feet. He was not able to start the engine after completing an emergency procedure. The pilot established an approach to a landing area, and stalled the aircraft on short final. The aircraft moved about 30…NTSB LAX88FA042Accident · 4 fatalField investigationFinal reportMooney M20C · Grand Canyon, AZWhile cruising en route all engine power was suddenly lost and the plt attempted an emergency ldg at the Grand Canyon arpt. During the glide, the acft crashed into an outcrop of rocks on a steep cliff, 0.5 mi from the end of the rwy. Exam of the engine…NTSB CHI88DER01Accident · No injuriesFinal reportPiper PA-22 · Mcgrath, MNDuring a solo cross-country flight, the aircraft sustained a power loss due to failure of the #3 connecting rod. Subsequently, the student pilot made an emergency landing in a swamp and the aircraft was damaged.NTSB LAX88LA039Accident · No injuriesLimited investigationFinal reportCessna 210A · San Luis Obispo, CAWhile approaching the arpt the plt stated that he slipped the acft from 1800 feet to 1400 feet, leveled the wings, still descending, and entered the pattern at 1200 feet. While on final approach the engine quit. Unable to land on the rwy, the plt landed in a…NTSB LAX88DUJ02Accident · No injuriesFinal reportSadler Vampire · Mesa, AZDuring a local pleasure flight, while climbing to altitude, the engine quit. A forced landing was made on a dirt road where during the landing roll the aircraft collided with a ditch. Examination of the engine revealed that the rear cylinder next to the gear…