NTSB investigations: Lycoming 0-540 series
136 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW96LA031Accident · Serious injuriesLimited investigationFinal reportCessna 182TR · Boulder, COThe pilot's failure to determine the amount of fuel aboard the aircraft during preflight, and his failure to refuel the aircraft.NTSB SEA95LA225Accident · No injuriesLimited investigationFinal reportCessna TR182 · Richfield, IDThe instructor's failure to use carburetor heat during a simulated engine-out descent. Carburetor icing conditions was a factor.NTSB CHI95LA332Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ludington, MIfuel exhaustion resulting from the pilot's inaccurate fuel calculations and the failure to refuel the airplane prior to takeoff. An additional cause was the stall/mush during the forced landing.NTSB SEA95FA199Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Sheridan, WYfuel starvation for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB FTW95LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Farmington, NMThe pilot's failure to verify the fuel tank selector position and the resultant fuel starvation induced power loss.NTSB NYC95FA068Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Suffolk, VAThe pilot's inadequate preflight and improper in-flight planning/decision, which resulted in fuel exhaustion. Darkness was a factor related to the improper planning/decision-making for the emergency landing.NTSB LAX95LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAthe pilot's mismanagement of the fuel system and his failure to select a tank containing fuel.NTSB ATL94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Washington, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion. A factor was the unsuitable terrain, a plowed field, available for landing.NTSB ATL94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Foley, ALThe pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and collision with the ground. The pilot's inadequate preflight and resultant improper positioning of the fuel selector were factors.NTSB MIA94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Margate, FLFailure of the pilot-in-command to position the fuel selectors to the fullest tank before landing resulting in the total loss of engine power from both engines due to fuel starvation.NTSB LAX94LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Selma, CAThe pilot's improper use of the fuel supply which allowed the engine to sustain fuel starvation, and his failure to follow the emergency checklist by not using the electrical fuel boost pump. The engine fuel starvation was a factor in this accident.NTSB ATL94FA046Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Centreville, ALThe pilot's failure to assure that the fuel selector was in the proper position for takeoff.NTSB ANC94LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKFuel starvation from water and/or ice crystals in the fuel system. A factor in the accident was the improper preflight of the fuel sumps by the pilot-in-command.NTSB LAX93LA196Accident · No injuriesLimited investigationFinal reportDornier DO-28 · Paradise, CAThe poor in flight fuel consumption calculations by the pilot and the pilot's in flight decision not to switch fuel tanks which caused the total failure of both of the airplane's engines. Factors relating to this accident were fuel starvation and the high…NTSB FTW92LA226Accident · No injuriesLimited investigationFinal reportBell 47-J2A · Booneville, ARThe pilot's failure to maintain adequate rotor RPM during autorotative landing. Factors were fuel exhaustion, the pilot's improper fuel consumption calculations, and the pilot not refueling the helicopter.NTSB FTW92LA097Accident · No injuriesLimited investigationFinal reportCessna R182RG · Little Rock, ARThe complete loss of engine power due to carburetor icing, and the pilot's delayed application of carburetor heat. Factors were the weather conditions which were highly conducive to carburetor icing, and the unsuitable terrain at the pilot's disposal to…NTSB FTW92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Houston, TXThe pilot's failure to correctly calculate fuel consumption and the loss of engine power. A factor was the unsuitable terrain.NTSB LAX92LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Linden, CAThe pilot in command inaccurately calculating the aircraft's fuel consumption, and not re-fueling the aircraft prior to takeoff from his last departure point. This resulted in a power loss due to fuel exhaustion. A factor in this accident was the unsuitable…NTSB SEA91LA247Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Arco, IDWater in the fuel tank and the inability of the pilot to flare for landing after maneuvering to avoid transmission lines in his flight path during the forced landing.NTSB ATL91LA133Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Hawkinsville, GAThe pilot's inadequate preflight planning, his failure to refuel the airplane when he observed his fuel supply getting low, and the resultant exhaustion of his fuel supply.NTSB LAX91FA310Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Hesperia, CAThe pilot's improper refueling and inadequate preflight which resulted in fuel contamination and the inadvertent stall.NTSB NYC91LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wildwood, NJThe pilot's failure to apply carburetor heat during the descent which resulted in a loss of engine power due to carburetor ice.NTSB CHI91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oswego, KSFuel starvation due to improper placement of the fuel tank selector by the pilot.NTSB CHI90LA253Accident · No injuriesLimited investigationFinal reportPiper PA25-235 · Logansport, INThe engine failed due to fuel exhaustion. The presence of standing corn in the touchdown area was a factor.NTSB DEN90LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bingham, NMThe fuel exhaustion induced power loss. Factors were the pilot's failure to refuel and the unsuitable terrain in which the forced landing was performed.NTSB SEA90LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Burns, ORLoss of engine power due to a blocked fuel line and the operation of the aircraft in an non-airworthy condition by the PIC.NTSB LAX90LA262Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Long Beach, CAThe pilot's improper planning/decision, which resulted in fuel exhaustion.NTSB ATL90DMG03Accident · No injuriesFinal reportPiper PA-25 · Farmville, NCThe pilot's inadequate pre-flight preparation when he declined to add fuel between aerial application flights. The engine quit as a result of fuel exhaustion.NTSB ATL90LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Bolivar, TNThe pilot failed to properly select a tank with sufficient fuel prior to takeoff.NTSB ATL90LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Danielsville, GAInadequate preflight preparation/planning by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Related factors were: a false fuel quantity indication, trees in the emergency landing area, and failure of the landing gear…NTSB ATL90FA031Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Helen, GAThe pilot's failure to properly preflight and plan en route refueling stops. The airplane collided with trees during the emergency descent.NTSB CHI90DET01Accident · No injuriesFinal reportPiper PA-24-250 · Decatur, INThe pilot's misjudgement of the fuel supply, inaccurate fuel consumption calculations, and his improper in-flight planning/decision, which resulted in fuel exhaustion. The lack of suitable terrain for an emergency landing was a related factor.NTSB ATL89LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hickory, NCPilot's failure to adequately monitor the engine fuel consumption in flight.NTSB LAX89LA214Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAFuel starvation due to the pilot's inadvertent selection of the off position on the fuel selector.NTSB MKC89LA132Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Scandia, KSImproper planning/decision by the pilot and fuel exhaustion. Contributing factors were the pilot becoming lost/disoriented and small trees.NTSB FTW89DRD02Accident · Minor injuriesFinal reportPiper PA-25-235 · Bogalusa, LAThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB CHI88DEP10Accident · No injuriesFinal reportPiper PA-25-235 · Beaver Dam, WIWhile in cruise flight the aircraft experienced a total loss of power due to fuel exhaustion. The pilot stated that there were no good landing areas available, so he elected to make the emergency landing in a marsh. The aircraft landed hard and sustained…NTSB CHI88DEE06Accident · No injuriesFinal reportPiper PA-25 · Chebanse, ILThe acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup.NTSB LAX88LA155Accident · No injuriesLimited investigationFinal reportCessna 182RG · Davis, CANTSB MKC88LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mound City, MOThe PIC, after an earlier lndg at tarkio, Missouri and an unsuccessful attempt to reach his fishing partner, flew his acft to and landed at st. joseph rosecrans arpt. After contacting his friend, and catching a few hours of sleep, the PIC made an early…NTSB MIA88LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · San Juan, PRThe pilot, while on an on-demand air taxi flight, switched to an empty fuel tank in preparation for landing and the engine failed. The pilot then executed a forced landing to the grass short of the runway and the landing gear failed.NTSB ANC88LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKThe pilot had selected the left auxiliary fuel tank for takeoff. During the climbout the engine quit; the aircraft crashed short of a private airstrip. The pilot stated that he ran the left auxiliary fuel tank dry and did not select another fuel tank with the…NTSB MKC88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Des Moines, IAApprox eight miles from the dest arpt, the PIC experienced partial, then a complete power loss. An emergency lndg was made on a golf course, about one mile short of the dest arpt. Post accident inspection revealed no fuel in any of the four tanks. Damage was…NTSB ANC87LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Anchorage, AKThe pilot stated that she departed the airport with only one quarter tank of fuel; on final approach to the runway the engine quit. The owner stated there was less than ten (10) gallons on board the aircraft prior to take off.NTSB BFO87LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Roanoke, VARoanoke tower cleared the aircraft for landing and the pilot pulled the power to idle. The pilot did not realize the engine had quit until he applied power on short final and the engine did not respond. The aircraft struck short of runway 33. The pilot stated…NTSB ATL87LA231Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Knoxville, TNThe plt rprtd that drg takeoff, the acft clbd normally for about 100 to 150 ft, then the eng lost pwr w/o warning. He switched fuel tanks & tried to restart the eng, but was unable. The acft was lndd & sank in a river, short of an open fld. When the acft was…NTSB ATL87LA224Accident · No injuriesLimited investigationFinal reportCessna R182 · Calera, ALThe airplane collided with trees during a forced ldg attempt. The plt reported that he observed the fuel gauges indicating near empty shortly after departure. As he executed a 'steep' 180 deg turn back toward the arpt, the engine sputtered and 'quit'. During…NTSB ATL87LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Pinehurst, NCThe pilot called approach control and reported he was out of fuel and didn't think he was going to make the airport. He had landed at an airport enroute but had not refueled. He stated that he started descending when he got within ten miles of the airport. He…NTSB MIA87LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Meridian, MSThe pilot did not assure the fuel level in the aircraft fuel tanks prior to departure. During the flight the pilot canceled a planned fuel stop and continued to his destination. The engine failed due to fuel exhaustion 2 1/2 miles short of the destination and…NTSB CHI87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Oshkosh, WIAccording to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…