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 NYC89LA020Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Ebensburg, PAThe acft experienced a total loss of power and crashed in trees near Ebensburg, PA. A teardown inspection revealed extensive preimpact damage to the engine. The #3 main bearing had failed, causing the interruption of oil supply to the #4 and 5 bearings and…NTSB LAX89FA032Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Anaheim, CAFive minutes after departure and during normal cruise flight, the certified flight instructor noticed a prop overspeed. He immediately pulled back on the prop control to reduce engine r.p.m. and instructed the student, a private pilot, to divert to the…NTSB FTW89IA011Incident · No injuriesIncident investigationFinal reportBell 206 L-1 · Brownsville, TXUncontained engine failure due to the thermal fatigue of the first stage trubine wheel.NTSB ATL89LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazel Green, ALThe flight instructor and the pre-solo student crashed after takeoff about 1/2 mile from the Hazel Green airport. The acft had been operated about one hour since the original takeoff from huntsville, Alabama. The instructor pilot reported that about 12…NTSB ATL89LA014Accident · No injuriesLimited investigationFinal reportRockwell 114 · Palma, KYThe pilot reported a complete engine failure while descending to traffic pattern altitude. The attempts to restart the engine failed. The pilot crashed in a field. The investigation disclosed an internal magneto timing of 30 and 27 degrees respectively. The…NTSB LAX89FA014Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Sedona, AZTotal failure of the magneto's impulse coupling which resulted in a shearing of the crankshaft's idler gear teeth and the crankshaft dowel pin.NTSB LAX89DVM01Accident · No injuriesFinal reportContinental Copters OH13H · Castroville, CADuring aerial application by helicopter, engine power was lost. Plt maneuvered to avoid power lines during autorotation, resulting in hard lndg. Investigation revealed failure of accessory drive to magnetos.NTSB FTW89LA003Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Fairfax, OKThe plt reported that the engine locked and he made a forced landing in a muddy, plowed field. The airplane landed hard and the plt received a fracture to the skull just above his right eye. During engine teardown, the head from the exhaust valve on the…NTSB ANC89LA007Accident · No injuriesLimited investigationFinal reportCessna 207 · Perde Bay, AKThe pilot experienced a power loss during cruise flight and during his descent the engine stopped producing power. He landed on the tundra and the airplane was substantially damaged. An engine teardown revealed that the number 4 piston was burned past…NTSB MIA89LA007Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Flora, MSAfter dispensing a chemical load, the plt was rtrng to re-load when the eng began running rough. He said he noted the fuel flow was erratic, so he turned on the boost pump. The eng stabilized momentarily, then smoke entered the cockpit & the eng began…NTSB CHI89FA005Accident · Minor injuriesField investigationFinal reportPiper PA-28 · Schaumburg, ILEngine failure due to oil starvation and the pilot's misjudged emergency landing, during which the aircraft collided with trees and a swimming pool, before coming to rest on the ground and a chain link fence.NTSB NYC89IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Newark, NJThe #3 eng suffered an uncontained turbine blade failure during a takeoff roll. The takeoff was aborted at 120 KTS without further incident. Investigation revealed that all 12 tierods for the 2nd stage low compressor suffered a progessive failure. This…NTSB MIA89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · La Belle, FLThe pilot while on a ferry permit flight experienced a failure of the #4 cyl of the left engine and did not attain the vyse speed and the aircraft started to descend. The pilot ditched the aircraft in a lake and it was not recovered. No records on the engines…NTSB FTW89DRG01Accident · No injuriesFinal reportShamgaugh Pitts Special · San Benito, TXImproper torquing of the 'b' nut fitting on the main fuel supply line to the powerplant at the firewall and the pilot's inadequate pre-flight inspection.NTSB DEN89LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Price, UTThe pilot was performing a business flight over mountainous terrain. About 1 hr into the flight, he noticed smoke or oil vapor in the cockpit. He saw oil on the lower cowling and wing and communicated his position and problem to the salt lake city ARTCC. The…NTSB BFO89LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sandston, VAThe plt said he was on final apch about 600 to 800 ft AGL when power loss occurred. He forced landed on an open field about 1/2 mi short of the rwy. The eng exam revealed that two teeth of the idler gear had separated. This resulted in a loss of continuity…NTSB MKC88LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Harrison, ARWhile in normal cruise flt, the plt declared an emergency. He stated the eng had failed & that he thought it had 'thrown a rod.' Subsequently, the acft was extensively damaged drg an emerg landing in a wooded area. An investigation revealed the #6 connecting…NTSB LAX88FA330Accident · No injuriesField investigationFinal reportBell 206L-1 · Santa Barbara, CAFailure of the #1 turbine wheel. Contributing to this accident was the unreported over temperature cycles of the engine. Also contributing was the unsuitability of the landing surface from the presence of the 1/4 inch steel sheeting.NTSB LAX88DVM04Accident · No injuriesFinal reportWeatherly 201B · Soledad, CAThe pilot stated that after detecting smoke in the cockpit he turned off all electrical switches and made one more spray pass. After the pass, smoke became visible from the engine and part of the cowl separated. The engine lost power and the pilot executed a…NTSB MIA88LA274Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Groveland, FLThe acft crashed into the trees at the end of the rwy while on initial climb after sustaining complete eng failure. FAA personnel attempted to test run the engine after the accident, but were unable to due so due to an air leak on the gascolator. When upward…NTSB NYC88FA238Accident · Serious injuriesField investigationFinal reportde Havilland DH-7-58C · Albany, NYThe acft experienced an uncontained disintegration of the no.2 engine. Scorched engine fragments ripped through the fuselage injuring two passengers, one seriously. The uncontained failure was the result of wear or spalling of the 1st stage reduction gear and…NTSB MKC88LA174Accident · No injuriesLimited investigationFinal reportBeech A23 · Davenport, IAThe PIC said there was a loud metallic explosion in the engine compartment. When the acft was about 7 miles from the destination apt and beginning a descent. The aircraft began vibrating violently and the windshield became covered with engine oil. Attempts…NTSB DEN88IA204Incident · No injuriesIncident investigationFinal reportCessna 206 · Glade Park, COThe failure of the #1 connecting rod assembly in the engine, resulting in a forced landing. A factor in the incident was that the pilot did not see & avoid power wires in the forced landing path.NTSB CHI88LA235Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Detroit Lakes, MNDuring the initial climbout, as the aircraft climbed through approximately 200' AGL, the powerplant failed completely. The pilot executed a forced landing in an plowed field, substantially damaging the aircraft. Post-accident examination of the engine…NTSB CHI88LA234Accident · No injuriesLimited investigationFinal reportFairchild PT-19 · Converse, INDuring initial climbout after takeoff, the aircraft experienced a loss of engine power. After an unsuccessful attempt to restart the engine, the pilot executed a forced landing in a corn field. Post accident exam revealed a broken universal joint in the fuel…NTSB MIA88LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Waynesboro, MSWhile cruising at 5500 ft, the plt smelled burning oil. Moments later, oil press was lost, the prop went into high RPM & the tach zoomed over redline. A loud report was heard & all power was lost. A forced ldg was attempted in the rolling country but the acft…NTSB ANC88LA126Accident · No injuriesLimited investigationFinal reportStinson 108 · Mt Spur, AKAt 1500 feet m.s.l. a complete engine failure occurred. An emergency landing was made on a gravel bar. During the rollout the airplane collided with a gravel bank. An on site examination of the engine revealed a hole in the case next to the left exhaust…NTSB ANC88LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Fairbanks, AKThe airplane was on a climbout at approximately 1000 to 1200 feet m.s.l. when the engine quit and the pilot encountered an engine fire. The pilot elected to go back to the airport. The airplane crashed on the taxiway, and the airplane was substantially…NTSB CHI88LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Gary, INFailure of the powerplant due to an oil leak and subsequent forced landing into unsuitable terrain.NTSB DEN88LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lordsburg, NMFollowing takeoff the acft lost power at 150-200 ft AGL. Plt landed in rough terrain. During landing the left wing and landing gear separated. Examination revealed a failed exhaust valve guide and soft valve springs due to blow-by heat. At the time of the…NTSB SEA88LA161Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Shelton, WAThe pilot reported a complete loss of power in cruise flight while ferrying an aircraft to its home base after an annual inspection. The pilot landed in a small field of rye crop. The pilot stated that the size of the field precluded a normal approach. The…NTSB ATL88LA236Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bamberg, SCWhile at cruise, the pilot reported hearing a ticking sound coming from the engine. Shortly afterward the eng quit. During the emergency landing, the airplane nosed over. Engine examination disclosed that teeth from the crankshaft and camshaft gears were…NTSB ATL88DLT02Accident · No injuriesFinal reportGrumman G-164B · Dancyville, TNNTSB CHI88FA214Accident · 3 fatalField investigationFinal reportHughes 269B · Hampton, ILNTSB CHI88DER09Accident · Serious injuriesFinal reportSmith Miniplane · Superior, WIWhile in normal cruise the aircraft experienced a total loss of engine power. The pilot executed an emergency descent to a forced landing. The aircraft encountered unsuitable terrain which resulted in a hard landing and substantial damage to the aircraft. The…NTSB SEA88LA158Accident · No injuriesLimited investigationFinal reportCessna 185 · Hillsboro, ORThe pilot reported that the engine lost power during a fuel tank switchover. The aircraft collided with a telephone pole guy wire on the road during the forced landing. The investigation revealed a fuel leak induced when the fuel boost pump was in operation.…NTSB ATL88LA232Accident · Serious injuriesLimited investigationFinal reportHiller UH-12A · Paducah, KYAfter departure the eng quit & PIC made an autorotative landing in a wooded area. Initial exam of eng revealed water in the carb float bowl. Investigation showed helo had 100 hr inspection recorded in the log, but may have been returned to service by mechanic…NTSB ATL88DMG07Accident · No injuriesFinal reportCessna A188B · Oak City, NCNTSB CHI88LA209Accident · No injuriesLimited investigationFinal reportCessna 172RG · Mt. Vernon, OHWhile in cruise flight in VFR conditions and on an IFR flight plan, the pilot experienced a total loss of engine power. The pilot executed a forced landing in a soy bean field after an unsuccessful restart attempt. Examination of the oil cooler hose revealed…NTSB DEN88LA180Accident · No injuriesLimited investigationFinal reportBell 206B · Sturgis, SDThe plt was on a flt with 2 pax to take pictures. He stated that 'while in level flight at 120 mph and 300 feet above the ground, a pitch over was initiated for picture taking. At that moment, it appeared that the fuel flow cavitated. The forward fuel pump…NTSB NYC88LA203Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Wildwood, NJThe aircraft struck a building after if experienced a power loss due to fuel exhaustion caused by oil dilution and low engine compression.NTSB DEN88LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Casper, WYDrg flt after an annual inspn, the eng lost power as the acft was climbing to cruise. Attempts to restart the eng were unsuccessful. Subsequently, the acft was landed on rough/rocky terrain where it nosed over. When the eng was being checked after the acdnt,…NTSB ANC88LA106Accident · No injuriesLimited investigationFinal reportCessna 207A · Cooper Landing, AKAfter loss of oil pressure then engine failure at 2,800 feet MSL, the pilot elected to make an emergency Landing along the shore line. After the pilot and passengers exited the aircraft, the airplane sank into 100 to 150 feet of water. Neither the airplane…NTSB LAX88LA283Accident · No injuriesLimited investigationFinal reportCessna 175 · Needles, CAWhile at cruise flight, the pilot noticed that the oil pressure was low and shutdown the engine. During the emergency landing, the prop freewheeled, vibrated severely, and smoke filled the cockpit. The acft landed on a pipeline right of way causing…NTSB LAX88DVM03Accident · No injuriesFinal reportWittman Tailwind W-8 · Watsonville, CANTSB CHI88DER08Accident · Serious injuriesFinal reportCessna T337D · Jacobson, MNDuring the climb from takeoff, the front engine sustained a total power loss due to a fuel leak. The pilot secured the engine, however was unable to maintain altitude, losing about 50 ft per minute. Due to a thunderstorm at the departure airport, he elected…NTSB ATL88IA227Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GANTSB MKC88FA147Accident · 2 fatalField investigationFinal reportMooney M20C · Missouri City, MOThe co-owner of the acft stated he had experienced a fuel flow pblm while flying to the (ojc) arpt, where pax (one of them was a co-owner) were to board. He stated he advzd the other owner of the pblm, but no corrective action was taken. The acft was then…NTSB MKC88LA148Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tarry, ARThe pilot said the engine quit abrubtly during an aerial application turn around maneuver. He attempted to land in a nearby farm field and because of the soft terrain conditions, the acft nosed over during the roll out. Post accident investigation revealed a…NTSB MKC88LA143Accident · No injuriesLimited investigationFinal reportCessna 188 · York, NEEn route to perform an aerial application operation, the plt said he experienced a partial power loss followed by complete power failure. He attempted an emergency ldg in a farm cornfield, substantially damaging the acft. An on scene investigation by the FAA…