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 ATL82DA105Accident · Minor injuriesFinal reportAyres S2R-600 · Evergreen, ALThe pilot stated that about 5 minutes after takeoff the engine skipped once, popped, then quit completely with no other warning. The aircraft was over a wooded area and was forced to land in the trees. It was determined that the aircraft was approximately 740…NTSB MKC82FCA08Accident · Serious injuriesFinal reportBell 47G-4 · St Genevieve, MOThe pilot reported that about 40 minutes after takeoff, there was a drop in oil pressure followed almost immediately by an engine failure. The engine failure occurred over a wooded area. The pilot attempted an emergency landing in a small clearing, but the…NTSB FTW82DA153Accident · No injuriesFinal reportJurca 3/4 Spitfire · Bartlesville, OKDuring initial climb on the first flight of the homebuilt aircraft, the engine failed. The aircraft was landed off the airport and demolished. Investigation revealed the fuel pump drive designed by the builder had failed.NTSB ANC82DA031Accident · Minor injuriesFinal reportCessna A185E · Juneau, AKDuring an approach to land, the pilot of the amphibious aircraft extended the gear and performed his prelanding checks. He stated that while he was descending, he noticed an excessive loss of altitude and began to add power. However, the engine did not…NTSB CHI82IA113Incident · No injuriesIncident investigationFinal reportCessna 402B · Waukegan, ILPilot reported an oil leak in the right engine to controller while on an instrument approach to Waukegan airport. Several minutes later, pilot reported that he had lost sight of the airport and due to loss of power in the right engine, elected to land in a…NTSB MIA82DA127Accident · No injuriesFinal reportPiper PA-18 · Hollywood, FLThe pilot was towing a banner along a beach when the engine failed. He landed in the water just offshore and escaped without injury. The aircraft was subsequently destroyed by the surf. An examination of the engine revealed that the no. 3 cylinder had…NTSB LAX82DA124Accident · No injuriesFinal reportBeech D55 · Napa, CAThe pilot stated that he rotated the aircraft at about 90 knots during takeoff and at about 30 feet AGL the engine lost power. It started again briefly but then stopped and an emergency landing was made approximately 2000 feet from the approach end of runway…NTSB CHI82FA110Accident · Minor injuriesField investigationFinal reportCessna 210N · Wadsworth, OHWhile descending through about 4500 ft MSL, the pilot heard a rattling sound in the engine and noticed a loss of power. He declared an emergency and was provided vectors to the Wadsworth municipal airport. However, he was unable to reach the airfield. The…NTSB NYC82FNA12Accident · Serious injuriesFinal reportPiper PA-32R · Rochester, MAThe pilot reported that while he was en route, a power loss occurred and he was unable to restart the engine. He selected a clearing for a forced landing, but was unable to reach it. A crash landing, but was made in an area of trees and brush. An…NTSB LAX82FVD12Accident · No injuriesFinal reportCessna 182 · Livermore, CADuring takeoff, the engine lost power as the aircraft was climbing through about 150 ft AGL. The pilot landed in a plowed field where the nose gear failed and the aircraft flipped over. An investigation revealed that the number five piston and piston pin had…NTSB CHI82IA082Incident · No injuriesIncident investigationFinal reportSwearingen SA-266TC · South Bend, INThe captain reported that at lift-off above VI speed, he heard a loud pop that sounded like a tire had failed. A "bright yellowish" illumination was then seen in front of the right engine. There was insufficient runway to abort, so the takeoff was continued.…NTSB ATL82FKW05Accident · Serious injuriesFinal reportCessna 177RG · Kingston, TNDuring cruise flight a gear tooth from the aluminum idler gear in the engine oil pump failed. This locked the oil pump causing failure of the main drive gear. The aircraft landed in rough terrain with gulleys.NTSB CHI82DA089Accident · No injuriesFinal reportCessna 310 · Freemont, MIThe student was a rated pilot on his first instructional flight in this aircraft. After a practice aborted takeoff, the student applied power to start another takeoff. At about this time, the aircraft veered to the right. The instructorapplied left rudder and…NTSB FTW82FRJ09Accident · Serious injuriesFinal reportCessna 182L · Farmerville, LAThe pilot reported that his takeoff and climb to 2200 ft MSL were normal. After the plane was in cruise configuration, he heard an abnormal noise and decided to return to the airport. The noise level increased and the engine began to vibrate. The pilot…NTSB LAX82DA092Accident · Minor injuriesFinal reportPiper J3F-65 · Chandler, AZWhile on a downwind leg of the traffic pattern, the pilot noticed a very loud grinding noise as if the engine was coming apart. He stated that the engine RPM became very high. He attempted to maneuver for a landing on the runway but entered a high sink rate.…NTSB ATL82DA064Accident · No injuriesFinal reportMooney M20F · Belton, KYAfter leveling at 2500 ft, oil fumes were noted, but no abnormal indications were noted on the engine gauges. The pilot suspected oil had been spilled during a repair before takeoff. A short time later, the engine RPM began to increase & was adjusted by the…NTSB MKC82DA036Accident · No injuriesFinal reportPiper PA-32R-301T · Marceline, MOThe pilot stated that while cruising at 7000 feet the engine began vibrating, lost power, and eventually stopped. He elected to land in an open field resulting in substantial damage to the aircraft. Examination of the engine revealed that the intake valve…NTSB CHI82DA067Accident · No injuriesFinal reportPiper PA-28-140 · Lakerville, MNWhile on downwind, the pilot moved the fuel selector to what he believed was the left tank position. He also moved the throttle to idle to simulate an engine failure. He extended his pattern to allow time for another pilot to back-taxi down the runway to the…NTSB NYC82IA036Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-100 · Jamaica, NYDuring cruise flight, the aircraft experienced a power failure and fire in the left engine. The crew secured the engine and discharged the fire extinguisher without effect on the fire. During descent to jfk international the fire extinguished itself. A normal…NTSB NYC82FNE03Accident · Serious injuriesFinal reportPiper PA-28-140 · Ellington, CTThe aircraft was allowed to warm up for 5 to 10 minutes at end of the runway before takeoff. The instructor pilot (ip) reported that the before takeoff run-up was made by using the checklist and all engine instruments were in-the-green. He reported that…NTSB LAX82FUQ09Accident · 2 fatalFinal reportSons Mustang II · Lancaster, CAThe purpose of the flight was to demonstrate the aircraft to a prospective buyer. About 20 to 30 minutes after takeoff, witnesses observed the aircraft in a circling descent. At 500 to 700 ft AGL, the descent angle suddenly increased to nearly vertical and…NTSB MKC82DA017Accident · No injuriesFinal reportCessna 177RG · Urbandale, IAAfter takeoff, the engine lost power at about 2000 ft MSL. The plane was damaged during a forced landing on an interstate highway. When checked after the accident, the engine would start but lost power when accelerated above 1000 RPM. The bendix servo fuel…NTSB LAX82FUJ26Accident · Minor injuriesFinal reportBeachner Quick Silver · Kingman, AZAfter climbing up to pattern altitude the engine lost power. The pilot made a turn back towards the airport while trying to restart the engine but had to land in an old B-17 parking area. The aircraft struck a fence and ditch during rollout and nosed over.…NTSB LAX82DA042Accident · Minor injuriesFinal reportConvair 440 · Honolulu, HIAfter lift-off, the pilot called for the landing gear to be raised. As the plane was climbing through about 100 ft AGL, the pilot noted a loss of power in the right engine and saw a fire light. Ground witnesses heard a muffled explosion and saw smoke and fire…NTSB FTW82FPJ11Accident · No injuriesFinal reportPiper PA-28R-201T · Watonga, OKThe pilot stated that the engine lost oil pressure and shortly thereafter quit. During the forced landing the pilot veered the aircraft off the highway he had elected to land on due to oncoming traffic. The aircraft sustained substantial damages due to the…NTSB CHI82FA025Accident · No injuriesField investigationFinal reportPiper 23-250 · Wheeling, ILShortly after takeoff the pilot noticed a loss of oil pressure on both engines and initiated a left turn back to the airport. During landing the aircraft departed the right side of runway 12, collided with, and substantially damaged two Cessna 150'S and…NTSB DEN82DA015Accident · No injuriesFinal reportBeech 35 · Jackson, WYThe temperature was approximately a minus 15 degrees fahrenheit. The pilot reported the engine was preheated for 30 minutes and that everything was in the green before takeoff. Shortly after takeoff, the engine began to overspeed. The pilot throttled back and…NTSB MIA82DA028Accident · No injuriesFinal reportSmith WCS-222 (Bell 47G) · Miami, FLDuring flight, the engine lost power and fire erupted on the engine compartment. Subsequently, the engine driven hydraulic boost for the flight control system became inoperative. The pilot was flying over a populated area. During his forced landing, he was…