NTSB investigations: Lycoming 0-540 series
82 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of engine power”. 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\" = 350))
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" = 350))
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 ANC95LA055Accident · No injuriesLimited investigationFinal reportMaule M-5-235-C · Anchorage, AKA loss of engine power for an undetermined reason. A factor in the accident was the unsuitable terrain.NTSB CHI94FA263Accident · 2 fatalField investigationFinal reportPiper PA-25 · Decatur, NELoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB SEA94LA197Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Nampa, IDA cracked cylinder.NTSB NYC94LA103Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Monmouth Beach, NJA power loss due to fuel starvation, for undetermined reasons. A factor was the night conditions.NTSB BFO94LA107Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Forest Hill, MDThe loss of engine power during for undetermined reasons.NTSB FTW94LA192Accident · Minor injuriesLimited investigationFinal reportCallair A-5T · Fabens, TXLoss of engine power for undetermined reason(s).NTSB CHI93LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Mexico, MOa loss of engine power for undetermined reasons. A factor in the accident was the soft field landing site.NTSB ATL92LA184Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Powellsville, NCThe failure of the no.1 exhaust valve.NTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.NTSB BFO92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Norwalk, OHLoss of engine power due to undetermined reasons and the lack of suitable terrain for a forced landing.NTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.NTSB LAX91LA367Accident · No injuriesLimited investigationFinal reportCessna R182 · Fredonia, AZFailure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.NTSB FTW91DPJ01Accident · Serious injuriesFinal reportPiper PA-25 · Spiro, OKA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB NYC90LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Reading, PAA loss of engine power for unknown reasons and an off airport landing on unsuitable terrain.NTSB MKC87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARThe PIC was climbing enroute to a field to spread fertilizer. Abt 2 minutes into the climb the acft eng quit. The forced landing substantially damaged the acft. The PIC commented in his rpt that he should have checked fuel before departure even though he had…NTSB FTW86FPA27Accident · Minor injuriesFinal reportPiper PA-25-235 · Marlin, TXThe plt reported the eng quit during a right turn after takeoff at an alt of aprx 200 ft AGL. The acft crashed in a heavily wooded area aprx 1/4 mile west of the arpt. Cause of the eng failure was not determined.NTSB ATL85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Goodway, ALDuring aerial application the acft lost total pwr and the plt made an emergency landing in a fld. The plt stated that shortly after the eng lost pwr, he noticed smoke coming from the eng nacelle. After landing in the fld, the acft began to burn and was…NTSB LAX85LA303Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Santa Maria, CAThe pilot reported to the tower, while on base leg, that he was out of fuel. He then landed short and contacted a fence and a tree on the landing roll. The pilot stated that the aircraft contained 45 gallons of fuel when he departed and that he had flown for…NTSB NYC85LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · New Milford, CTAccording to the plt, the preflt and runup checks were normal. The plt then applied full pwr for takeoff and rotation was initiated at 60 KTS. After liftoff, the acft appeared to loose pwr and began to yaw to the left. The stall warning horn sounded and the…NTSB NYC85LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Batavia, NYThe acft was substantially damaged during a forced landing following a loss of pwr on initial takeoff climb. The plt reported that at an alt of aprx 100 ft AGL, the eng quit operating. A forced landing was made 100 yrds off the end of rwy 28. Inspection of…NTSB MIA85LA130Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Everglades, FLThe acft was on a flt over the Everglades at aprx 500 ft AGL, when the eng began to run rough & decreased to about 1200 RPM. During a forced landing, the acft fuel system burst before the acft came to rest & a fire erupted. The plt exited the acft & attempted…NTSB NYC84FNC07Accident · Minor injuriesFinal reportPiper PA-32-260 · Brunswick, METhe acft eng failed without warning at an alt of 2500 ft MSL. During the forced landing at nas Brunswick, the plt executed normal emergency procedures but was not successful in air-starting the acft. He stated that after having the 'abandoned field made' he…NTSB MKC84LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Schuyler, NEWhile descending toward the planned destination, the eng began running rough & the plt attempted to improve the eng's performance by using carburetor heat. He made a localizer-only apch, but was unable to see the rwy at the min descent alt. A missed apch was…NTSB NYC84FA024Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · West Seneca, NYThe acft was being repositioned by the owner from a maintenance facility at buffalo intl arpt to buffalo airpark. Maintenance personnel at both locations who had dealt with the owner indicated he had attempted to cut costs by performing unauthorized repairs…NTSB ATL83LA227Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9 · Florala, ALThe plt reported that during takeoff, the eng began to lose power at the edge of the arpt. He noted that fuel pressure was lost & reported that he was unable to regain the pressure with the electric fuel pump. He switched the fuel selector to the fullest…NTSB LAX83LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · El Cajon, CAShortly after takeoff, at an altitude of aprx 300 ft AGL, the eng lost power. The plt turned & landed wheels-up on an unimproved grass area on the southwest corner of the arpt. An exam of the eng & fuel systems revealed no evidence of a preimpact/mechanical…NTSB MIA83LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Culebra, PRThe flight had departed st. thomas, VI at 0900 on a VFR flight plan to roosevelt roads after discharging passengers in st. thomas. While enroute in cruise at 1800 MSL the engine failed. He turned toward the island of Culebra and when all efforts to restart…NTSB NYC82DA235Accident · No injuriesFinal reportCessna TR-182 · Honesdale, PAThe aircraft experienced a power loss at 300 feet after takeoff and a forced landing was made with the wheels up in a plowed field. An investigation revealed that a seal around the carburetor air mixing box had come loose and an oil seal in the turbocharger…NTSB CHI82DA347Accident · No injuriesFinal reportBell 47G-4A · Near Brooten, MNThe pilot had been engaged in a spraying operation for 2.5 hrs when he returned and landed on a flat bed type trailer to service the helicopter. After the hopper was serviced with 60 gal of herbicide, the pilot began his take off. He stated that just after…NTSB DEN82DA144Accident · No injuriesFinal reportPiper PA-25-235 · Leonard, NDThe pilot stated the engine lost power as he pulled up from the final spray run. The aircraft wing contacted a tree and a forced landing was made in a barley field. Post flight exam showed no reason for the power loss.NTSB MKC82DA097Accident · Minor injuriesFinal reportPiper PA-25-235 · Kimball, NEThe aircraft was loaded with 100 gallons of 2-4-D and 40 gallons of fuel. During the preflight run-up check, the pilot noted a mag drop of 225 RPM. He stated that leaning the fuel mixture cleared the excessive decrease in RPM, and he observed 2500 RPM on the…NTSB LAX82DA198Accident · No injuriesFinal reportPiper PA-24-250 · Apple Valley, CADuring a flight from saint george, ut to imperial, GA, the pilot encountered fog as he approached el cajon pass, south of Apple Valley, CA. He attempted to go under the fog but was unable. He reversed course and headed back toward Apple Valley. As he was…