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 MKC88LA145Accident · No injuriesLimited investigationFinal reportGrumman G-164B · West Helena, ARThe plt said, while enroute to an aerial application operation, the engine lost power and an emergency ldg was made into the trees. Post accident investigation revealed that an intake valve on number 9 cylinder had failed.NTSB ATL88DKG11Accident · Minor injuriesFinal reportPiper PA-25-235 · Climax, GANTSB MKC88LA142Accident · No injuriesLimited investigationFinal reportShirlan Dickey E-RACER · Dubuque, IAAt a fuel stop in Dubuque, IA the PIC purchased fuel for the final leg of his flt to oshkosh. After a pre-flt chk and subsequent eng runup, the PIC took the active rwy and commenced a takeoff roll. The lift off and initial climb went without difficulty until…NTSB LAX88FA273Accident · Minor injuriesField investigationFinal reportRearwin 8500 · Glendale, CASeperation of an engine cylinder that moved into the plane of the wooden propeller blades. The propeller blades were sheared by the dislodged cylinder. The rough landing surface contributed to the accident.NTSB ANC88LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Sand Point, AKThe pilot reported that the aircraft had high oil temp and moderate vibrations. The aircraft was landed at Sand Point and a company mechanic arrived to inspect the aircraft. The oil quantity was checked and a run-up performed. The mechanic reported that no…NTSB MKC88LA137Accident · No injuriesLimited investigationFinal reportGrumman G164B · Knobel, ARThe plt said he had just completed an aerial application operation and was returning to his base airfield to re-load. While in a low level cruise, the engine quit abruptly, and an emergency ldg was attempted in a soft, muddy soy bean field. During the ldg…NTSB NYC88LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Smoketown, PAThe plt reported that the eng lost power at about 300 ft AGL after takeoff. A forced landing was made in a corn field. During the landing roll the aircraft nosed over. The wreckage was examined after the accident and water was discovered in the fuel system.…NTSB MIA88IA231Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Miami, FLFlt experienced failure of the number two engine shortly after takeoff when the combustion outer case ruptured. Metallurgical examination revealed the ruptured case had a 1/2 inch crack in it when it went through overhaul 16 cycles before the failure. It was…NTSB MIA88FA234Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Daytona Beach, FLThe acft departed spruce creek arpt and aprx 2 minutes later lost power and crashed into trees just west of the volusia county landfill aprx 4 miles northeast of the Daytona Beach regional arpt. Postcrash examination of the engine revealed the drain line on…NTSB LAX88LA267Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chico, CADuring a cross country flight, the pilot noted a loss of oil pressure. Shortly after, the pilot heard a loud bang and the engine lost power. A forced landing was made short of the airport where the airplane collided with the terrain during the landing roll.…NTSB ATL88LA217Accident · No injuriesLimited investigationFinal reportMooney M20E · Lawrenceville, GAThe plt reported that the engine failed shortly after takeoff. The pilot made a 180 degree turn and landed downwind on the runway. He elected to land gear up to avoid a drop-off past the runway end. The acft slid off the runway end, but came to a stop before…NTSB MKC88LA133Accident · No injuriesLimited investigationFinal reportGrumman 164A · Poplar Bluff, MOThe pilot experienced an engine failure while attempting to land during an aerial application flight. Altitude was not adequate to select a suitable forced landing area. The aircraft impacted in a pipeline right of way and came to rest in a small stream,…NTSB CHI88DEM07Accident · No injuriesFinal reportSilliman Hatz CB-1 · Battlecreek, MIWhile attempting to execute a forced landing due to an engine failure, the pilot misjudged his emergency procedure and collided with trees then the gnd during the descent to the fairway he had selected for landing. The engine failure was due to fuel…NTSB MKC88LA127Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Lowell, ARAbout one hour after takeoff, the plt noted that the eng began to run rough. He reduced the power to 2000 RPM & enriched the mixture. He continued flying for about another hour, then the eng lost power. The plt attempted an emergency landing on a frontage…NTSB LAX88LA257Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmdale, CAWhile cruising at 9500 feet, the pilot noted that the oil pressure was low. Shortly after, the engine quit. The pilot turned toward an airport, however, the airplane was landed short of the runway and nosed over in soft sand during the landing roll.…NTSB LAX88FA251Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Compton, CAStudent pilots failure to adequately remove moisture from the fuel system during his preflight inspection which led to a loss of engine power during a critical phase of flight.NTSB DEN88FA151Accident · Serious injuriesField investigationFinal reportAerospatiale SA-315B · Dubois, WYNTSB LAX88LA250Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Palo Alto, CADuring a local flight, the pilot noted that the oil pressure was low. En route to the airport, the engine quit. A forced landing was made on a road where during the landing the airplane collided with telephone wires and subsequently the terrain. Inspection of…NTSB DEN88LA145Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58J · Sioux Falls, SDN62243 was being used to lift air conditioning units to the top of a shopping mall. The plt stated that he was on the 16th lift of the day and had just taken off when he heard two loud pops and the engine lost power. After jettisoning the load he executed an…NTSB LAX88DVG07Accident · No injuriesFinal reportSnow AT-301 · Davis, CAAt the end of an aerial application flight, en route to home base, the engine quit. The pilot made an emergency landing in a field, where during the landing roll the airplane collided with a bale of hay and nosed over. Inspection of the engine revealed that…NTSB LAX88LA243Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Lancaster, CANTSB LAX88LA242Accident · No injuriesLimited investigationFinal reportPiper J3 · Rialto, CADuring a local flight, the engine quit while descending to the airport. A forced landing was made on a road where during the landing roll a gust of wind pushed the airplane off the road. The airplane ground looped, collided with the terrain and nosed over.…NTSB DEN88LA143Accident · No injuriesLimited investigationFinal reportMooney M-20K · Gunnison, CONTSB DEN88DTE06Accident · No injuriesFinal reportHelfrich-Leonard BD-5B · Englewood, COThis experimental acft is powered by a modified honda 1250 cc, watercooled eng. The plt reported that after takeoff the eng temp reached the redline and the eng lost power. During the forced landing the main landing gear collapsed. Examination of the eng…NTSB CHI88DEX06Accident · No injuriesFinal reportPiper J3 · Bedford, INAircraft was in cruise flight at 1000 feet AGL when the pilot heard a backfire from the engine followed by immediate and total loss of power. Forced landing was made in rugged, rocky terrain. Landing gear sheared off on rollout. Investigation revealed failure…NTSB MIA88LA210Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic Ocean (Atlantic Ocean)The plt stated that the eng started running rough. He decided to divert to alt aprt 15 miles away. While enroute, the plt stated that he heard a 'clanking' noise and oil sprayed the windsheild. The eng lost all power. The a/c was ditched in the Atlantic Ocean…NTSB NYC88DFJ02Accident · Minor injuriesFinal reportHiller UH-12E · Cherry Creek, NYThe pilot reported that during an aerial application operation, he heard a noise that was followed by a decay in rotor RPM. Subsequently, he was forced to land in an area of tall trees & the helicopter was damaged. An investigationrevealed that a connecting…NTSB ATL88IA195Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124A · Hebron, KYDuring en route climb, the left engine failed and the crew executed a safe single engine landing. Examination of the engine revealed an uncontained HP turbine failure in the engine. Metallurgical examination of the failed parts indicated improper steel alloy.…NTSB LAX88LA234Accident · No injuriesLimited investigationFinal reportCessna 172N · La Grange, CANTSB DEN88LA137Accident · No injuriesLimited investigationFinal reportBell 206B3 · Missoula, MTA check airman and a commercial plt were performing an instructional flt. During climbout after a practice autorotation, the engine out audio and light warning activated. Both pilots verified an actual engine out and entered an autorotation. The helicopter…NTSB MKC88LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Eldon, MOTotal failure of the powerplant due to an oil line rupture, and proper touchdown point not attained by the pilot in command.NTSB MIA88LA198Accident · No injuriesLimited investigationFinal reportHughes 369D · Horn Lake, MSBfr tkof, the helicopter was svcd with 100LL fuel (an approved altn fuel if the boost pump is used in flt). Drg flt, theeng lost pwr. An autorotation was made in tall vegetation, but drg the lndg, the main rotor blades severed the tail boom. An inspn of the…NTSB FTW88LA122Accident · No injuriesLimited investigationFinal reportCessna 182R · Garden City, TXThe pilot was inspecting some areas to be sprayed and also a road to be used as an airstrip for his aerial spraying. After a low pass over the road at reduced power, he advanced the throttle but the engine would not respond. During the forced landing in rough…NTSB CHI88DER03Accident · No injuriesFinal reportCessna 172K · Mora, MNDrg flt, one of the plts demonstrated a negative 'g' maneuver by entering a climb, then making a 'push over' to a descent. He throttled back on the back side of the maneuver to maintain airspeed. When the throttle was readvanced, there was no eng response.…NTSB NYC88LA165Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Wantagh, NYThe pilot was on a return VFR flight to republic airport after having repairs performed on the aircraft. The pilot stated that he experienced an engine power loss and prepared for an emergency landing with the gears retracted. The aircraft landed between two…NTSB CHI88DEM06Accident · No injuriesFinal reportKoopsen Miller Sport II · Lake City, MIJust prior to turning on final approach to land, the pilot experienced a complete loss of power. He continued the approach but decelerated more rapidly than he anticipated and was unable to clear a stand of trees on the approach path. Examination revealed a…NTSB MIA88LA186Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Callahan, FLWhile maneuvering the helicopter during an aerial application flt the eng quit. During the autorotative landing the helicopter landed hard. Examination of the eng revealed the accessory drive gear, which is attached to the crankshaft by 6 AN-4A bolts with the…NTSB MIA88LA183Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Gretna, FLWhile on an aerial application flt, the plt stated he maneuvered the helicopter to release the remaining chemical. He then heard a loud 'screeching' noise followed by silence as the eng quit. The helicopter landed hard breaking the skids. It came to rest on…NTSB LAX88LA207Accident · No injuriesLimited investigationFinal reportBeech M35 · Scottsdale, AZDuring the climb out the engine experienced a loss of power. A forced landing was made where during the landing roll the airplane collided with the terrain. Inspection of the engine revealed that the number two connecting rod broke.NTSB CHI88LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe student pilot was making the fourth leg of a solo cross country flight totalling 314 nautical miles. Although he departed with full fuel, none was added during the trip. The aircraft experienced a power failure, due to fuel exhaustion, approximately five…NTSB NYC88LA157Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lairdsville, PAThe Cessna 172 took off on a solo x-c flight with a student pilot/owner operator at the controls. After takeoff. The pilot reported a loss of engine power and made an off airport forced landing in a plowed field. The nose wheel dug in after approx 200 ft and…NTSB LAX88LA200Accident · Serious injuriesLimited investigationFinal reportCessna 175C · Santa Rosa, CANTSB MIA88FA178Accident · Serious injuriesField investigationFinal reportRockwell A9B · Marianna, FLThe acft sustained a complete & sudden power loss while engaged in ag operations at low alt. The prop, fwd portion of the crankshaft, cyl head & other eng parts separated from the acft. The acft struck a row of 40 ft trees & crashed to the grnd. An exam of…NTSB DCA88MA059Accident · Serious injuriesMajor investigationFinal reportEmbraer EMB-110P · Lawton, OKNone submittedNTSB ATL88LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Conway, SCThe pilot was conducting a maintenance test flight when he experienced a drop in engine RPM. After a series of bangs the engine quit. The pilot made a forced landing into a rough field. The engine examination disclosed that no. 1 piston had failed. The engine…NTSB ANC88FA057Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Wasilla, AKThe private pilot and passenger were making an approach to the Wasilla airport, Wasilla, AK, when the engine lost power. The pilot made a sharp 180 degree turn to try and reach a paved street about 3/4 of a mile short of the runway. The airplane stalled and…NTSB LAX88LA184Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Carlos, CADuring a post maintenance test flight prior to sign off of an annual inspection, the engine quit and the pilot performed a forced landing in a mud field colliding with a dike. Examination of the engine revealed that a fuel pressure line had disconnected from…NTSB SEA88LA090Accident · No injuriesLimited investigationFinal reportAyres S2R Thrush · Lind, WADuring an aerial application maneuver, a total loss of power occurred due to the number nine cylinder failing. A restart was attempted, but was unsuccessful. The pilot made a forced landing onto a very soft sandy field, where the aircraft nosed over inverted…NTSB CHI88DEE04Accident · Minor injuriesFinal reportCessna 205 · Moline, ILDuring initial climb on a pleasure flight the airplane experienced a loss of fuel pressure and then total engine failure. The airplane nosed over during the subsequent off airport landing. Post accident examination of the engine driven fuel pump revealed…NTSB NYC88DFJ01Accident · Minor injuriesFinal reportHurd/Drifter XP503 · Baldwinsville, NYThe plt rprtd that during a preflt, he noted the fuel tank was about 1/4 full. He rprtd that as he was taking off, the acft was climbing thru about 200 ft AGL, when the eng lost power. From that position, he was unable to rtrn to the arpt or glide to an open…