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 CHI89FA062Accident · Serious injuriesField investigationFinal reportHughes 269C · De Kalb, ILFatigue failure of the number four connecting rod which resulted in an engine failure. Factors in the accident were the broken ring in the number one piston and a deteriorated center main bearing.NTSB ATL89FA112Accident · Serious injuriesField investigationFinal reportBell 206B · Atlanta, GAFatigue failure of the engine spur adapter gearshaft in an area where there was a lack of lubrication (oil starvation) due to a partially blocked oil delivery tube. Contributing factors were: inattentive maintenance or servicing of the aircraft by unknown…NTSB MKC89IA082Incident · No injuriesIncident investigationFinal reportGulfstream 690A · Bismark, NDA failed (cracked) engine plenum resulting in loss of engine power.NTSB ATL89LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Kershaw, SCFatigue failure of the crankshaft dowel pin. Factors related to the accident were: failure of maintenance personnel to follow the applicable service bulletin and darkness.NTSB MKC89LA080Accident · No injuriesLimited investigationFinal reportCallair A9-B · Fisher, ARFailure of the engine magneto resulting in engine failure.NTSB SEA89LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Seabeck, WAA fatigue failure of the engine crankshaft. Contributing to the accident was the lack of suitable landing area.NTSB MKC89LA079Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARFailure of the engine blower assembly drive shaft, while maneuvering at low altitude, and failure of the pilot to maintain adequate airspeed, which resulted in a stall before he could land.NTSB DEN89LA082Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Custer, SDThe improper maintenance by the pilot in command/owner in that the magneto drive gear retaining nuts were not safetied which resulted in them backing off, disconnecting the magnetoes and one of the gears falling into the engine.NTSB MKC89LA064Accident · No injuriesLimited investigationFinal reportCessna 172B · Unionville, IAThe failure of the engine due to carburetor ice. Contributing factors included carburetor icing conditions, improper use of the carburetor heat control by the pilot, and the improperly rigged carburetor air box which resulted in reduced carburetor heating…NTSB MIA89IA095Incident · No injuriesIncident investigationFinal reportCessna 172N · Homestead, FLFuel starvation caused by a sticking needle valve which was softened by contact with automotive fuel previously used to operate the engine.NTSB MIA89FA093Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Inverness, FLThe failure of the propeller governor oil line due to fatigue which was caused by bending damage to the line and the failure of mechanics to install support clamps on the line which caused the fatigue to propagate at a faster rate.NTSB LAX89LA114Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6 · Compton, CAFatigue cracks that existed in an engine cylinder.NTSB FTW89LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Conroe, TXFailure of the engine crankshaft due to fatigue. The low ceiling, dark night, and trees in the emergency landing area were factors.NTSB LAX89LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Pacific Ocean (Pacific Ocean)Loss of oil pressure due to unknown circumstances. Contributing to the cause of the accident was the overweight condition of the airplane necessitated by overwater fuel requirements.NTSB FTW89LA048Accident · Serious injuriesLimited investigationFinal reportPitts S2B · Walker, LALoss of total engine power due to fuel exhaustion. Fuel exhaustion occurred due to the pilot's failure to perform fuel consumption calculations. Contributing was the inadequate fuel quanity sight gauge in the rear cockpit, which was occupied by the PIC.NTSB NYC89LA082Accident · No injuriesLimited investigationFinal reportCessna R172K · Ballston Spa, NYWorn connecting rod bearing(s), and failure of the #1 connecting rod. A factor related to the accident was: the lack of suitable terrain for an emergency landing.NTSB ANC89FA041Accident · 1 fatalField investigationFinal reportCessna U206G · Fairbanks, AKSeparation of the torsional vibration dampers from the crankshaft boss.NTSB MIA89IA080Incident · Minor injuriesIncident investigationFinal reportWaco UPF-7 · Marathon, FLFuel starvation due to a corroded carburetor.NTSB LAX89DVG04Accident · No injuriesFinal reportSchweizer G-164C · Bayless, CAThe deparation of a turbine blade followed by a forced landing during which the landing gear collapsed due to overload forces.NTSB FTW89LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ore City, TXSlippage of the center crankshaft bearing, which resulted in oil starvation and subsequent failure of the #3 connecting rod. Contributing factors were: the aircraft owner's continued operation of the engine beyond the manufacturer's recommended overhaul…NTSB NYC89LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Fire Island, NYThe improper installation of an unauthorized sealant used on the oil ressure screen housing gasket contaminated the oil and restricted the flow of oil through the main bearings causing oil starvation and connecting rod, bearing, and bolt failure.NTSB SEA89FA040Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Carson City, NVLoss of power on the left engine due to a foreign object which obstructed the fuel flow, and the pilot's failure to maintain airspeed above VMC during his attempted return to the airfield. Contributing to the accident was the lack of recent flight time by the…NTSB MKC89LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodland, KSThe loss of engine power resulting from an exhaust valve failure. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB LAX89FA095Accident · 1 fatalField investigationFinal reportMooney M20F · Truckee, CAThe pilot's decision to fly with a known deficiency of the aircraft, the worn fuel injector with an interior leak, which resulted in loss of engine power, and the pilot's failure to maintain adequate airspeed, which resulted in a stall.NTSB CHI89DEC02Accident · Serious injuriesFinal reportPiper PA-28R-201 · Brighton, MIInstallation of an improper oil drain valve by other maintenance personnel and their failure to follow the applicable airworthiness directive (AD 81-11-02/R1), resulting in subsequent interference between the landing gear and oil drain valve. This caused the…NTSB MIA89LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLFailure of the #5 connecting rod bolt. Factors related to the accident were: dark night and the soft and wet (marshy) terrain conditions in the emergency landing area.NTSB ATL89LA074Accident · No injuriesLimited investigationFinal reportCessna T210N · Florence, SCThe failure of maintenance personnel to properly torque the thru bolts during number 2 cylinder installation. Contributing factors to the accident were terrain features which led to the collapse of the nose gear during landing.NTSB MIA89LA069Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Sebring, FLFailure of the cam gear snap ring, which allowed the camshaft gear to become disconnected. Factors related to the accident were trees in the emergency landing area.NTSB MIA89LA061Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Margate, FLFailure of the engine driven oil pump due to foreign object(s), which resulted in oil starvation and subsequent engine failure. Factors related to the accident were: dark night and trees in the emergency landing area.NTSB FTW89LA036Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · S.Timbalier 151A collision between the aircraft and the platform during the emergency autorotation which caused the left skid and float to separate and destabilized the autorotation. The collision was probably unadoidable due to the maneuver that was being conducted at the…NTSB LAX89LA071Accident · Serious injuriesLimited investigationFinal reportUnivair Globe GC-1B · Chino, CA**This report was modified on 2/24/2016. Please refer to the public docket for this accident for additional information.** The pilot's failure to maintain airspeed during an emergency landing following an inflight loss of engine power, resulting in an…NTSB MIA89LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Starke, FLFlt was 3 miles east of arpt returning to land at alt of aprx 2,000 ft, when the eng quit. Plt was unable to restart & elected to land in small trees as a nearby highway was congested. Acft collided with trees & fell to the ground. Examination of the eng…NTSB ATL89LA056Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Athens, GAWhile cruising at 6,000', the plt felt an intense vibration fm the eng. Power was reduced & a descent was begun toward a nearby arpt. Before reaching the arpt, the eng lost power & an emergency wheels-up landing was made in an open field. An exam of the eng…NTSB MIA89LA053Accident · Minor injuriesLimited investigationFinal reportPilatus P-2/05 · St. Augustine, FLAfter an en route stop, the pilot took off in the newly acquired acft. Shortly after gear and flap retraction, the eng sustained a partial loss of power. The plt stated that all eng gages appeared normal and a turn was begun in an attempt to return to the…NTSB ATL89LA055Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Athens, GADuring descent toward his intended destination, the pilot noted a floating ammeter needle and shortly thereafter he noted his oil pressure was zero. The engine seized and he selected a straight stretch of paved road for his forced landing. In the final stages…NTSB MKC89LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Crete, NEThe pvt pilot said shortly after takeoff, the engine coughed, sputtered, then quit. An emergency ldg was attempted on a farm field which resulted in substantial damage to the acft, serious injury to the pax and minor injuries to the pilot. Post accident…NTSB ATL89LA053Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Vidalia, GAAircraft experienced loss of power and returned to airport. Departed second time and experienced rough running engine. Aircraft attempted emergency landing and overturned in field. Examination of the engine revealed piston failure in #4 cylinder. Post acc…NTSB ATL89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ft Mill, SCTwo days before the acdnt, the plt had fueled the acft to capacity & flown it a short distance to his house at a pvt airstrip. After the flt, he noticed fuel on the tops of both wings, aft of the fuel filler caps. He was aware that fuel had leaked from the…NTSB MIA89LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Okeechobee, FLThe student pilot reported that during preflight inspection, he did not replace the oil cap after he checked the oil. Subsequently, oil was vented overboard during flight & the engine lost power. The nose gear collapsed during a forced landing.NTSB LAX89LA054Accident · No injuriesLimited investigationFinal reportCessna 175 · Tracy, CAThe airplane was found nosed over and abandoned short of the airport. The owner of the airplane was identified as the pilot, however, he does not hold a pilots license nor a medical certificate. Inspection of the airplane revealed that the fuel tanks were…NTSB FTW89LA021Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Gulf-Of-Mexico (Gulf of Mexico)Engine failure for undetermined reasons and the pilot misjudging his altitude during the flare resulting in a hard landing.NTSB ATL89LA040Accident · No injuriesLimited investigationFinal reportCessna 170 · Batavia, OHAfter about 3 hours and 20 mins of flight the pilot experienced a complete power failure. He attempted to reach the closest airport, but was forced to land in a field 3 miles short. The pilot had estimated that he had 4 hrs fuel. At about 9 gph and 33.5 gals…NTSB ATL89LA034Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Uriah, ALWhile cruising at 6500 ft, the eng lost power & the prop stopped windmilling. The plt elected to land on a highway. Drg the landing, the right wing hit overhanging tree limbs which yawed the acft off the right side of the road & down an embankment. The eng…NTSB CHI89DEV03Accident · No injuriesFinal reportRyan Navion · Lane, ILAirplane landed in a plowed field after losing power during initial climb. The flight purpose was to accomplish a biennial flight review. The landing gear failed after digging into the soft dirt of the plowed field. During the investigation the acft owner…NTSB ATL89FA035Accident · 2 fatalField investigationFinal reportHughes 269C · Mohawk, TNThe helicopter had landed at a private airstrip and the instructor deplaned. The dual student remained in the helicopter with the engine running. The CFI reboarded and the student made the takeoff. Later, on downwind in traffic pattern, a witness reported a…NTSB ATL89LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lumberton, NCThe pilot had been flying about 45 minutes when he crashed short of the runway. He believed he departed with 16 gallons of fuel, based on fuel gauge readings. The wreckage examination failed to disclose any system problems. After the accident, only a small…NTSB LAX89LA048Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Page, AZFailure of the number five cylinder piston, for undetermined reasons, initiating an engine failure and subsequent forced landing in unsuitable terrain.NTSB MIA89LA024Accident · Minor injuriesLimited investigationFinal reportBell 206L · St. ThomasThe plt autorotated the helicopter into the water after a loss of power while transitioning from fwd flight to a hover. While landing with the emergency floats armed, he attempted to deploy the floats but was unable. The plt & pax evacuated. The helicopter…NTSB LAX89DUM03Accident · No injuriesFinal reportGrumman G-164 · Blythe, CAThe pilot stated that the engine lost power on a 'spray pass.' He then executed a forced landing straight ahead and nosed over after touchdown in a cotton field. Investigation revealed an elbow fitting connecting the main fuel supply line and the carburetor…NTSB CHI89DEV01Accident · No injuriesFinal reportCessna 152 · Vandalia, ILThe eng began running rough aprx 5 min after the plt took off from an en route arpt drg a night, x-country training flt. He reversed course back toward the departure arpt with the eng providing partial power. While maneuvering to land on rwy 18, the eng…