NTSB investigations: Lycoming TI0-540 series

69 cases on aircraft whose registry engine model is Lycoming TI0-540 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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 ('41533')
      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\" = 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.

NTSB CHI88FA010Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Oshtemo Townshp, MIThe aircraft was at cruise altitude (9,000 feet) for approximately 20 minutes when the pilot reported the loss of right engine power. Chicago ARTCC reported the closest airport was kalamazoo, 28 miles west. The aircraft began to descend and at 0330:53 chicago…Oct 23, 1987 · N554AC · DestroyedNTSB LAX88LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · San Mateo, CAWhile over the ocean, the pilot noted that the engine did not sound right and that the oil pressure indication had dropped to zero. Shortly afterward, the engine began to vibrate violently and seized. The pilot planned for a forced landing to an open field…Oct 16, 1987 · N9097P · Substantial damageNTSB MIA88FA007Accident · 2 fatalField investigationFinal reportRockwell 700 · Pompano Beach, FLWitnesses stated that just after takeoff, the left engine started to leave a trail of white smoke, the acft then turned left back towards the arpt & crashed into the street. Post crash examination revealed one of the left engine crankshaft counterweights…Oct 12, 1987 · N26574 · DestroyedNTSB MIA87FA257Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Geneva, FLFlt experienced engine failure when the number six connecting rod separated from the crankshaft after failure of the connecting rod bearing. During an attempted forced landing during darkness the acft collided with trees and then crashed to the ground.…Sep 23, 1987 · N4010R · DestroyedNTSB MKC87LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Harrison, ARThe routine business flt had progressed normally until approaching bentonville, Arkansas. The PIC rptd his eng ran rough for a very brief period and quit. Emerg procedures were conducted but a restart was impossible. Only 1.5 hrs of flt had transpired since…Nov 29, 1986 · N4031R · Substantial damageNTSB MIA86LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ft.Lauderdale, FLFlt experienced loss of power in the left engine shortly after takeoff due to corrosion blocking the main jet in the fuel control unit. The pilot feathered the engine and returned for a landing. While on short final he remembered he would have to manually…Aug 14, 1986 · N36LS · Substantial damageNTSB ATL86LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birmingham, ALAfter takeoff pilot noted loss of engine oil pressure. Engine siezed and pilot landed short of runway. A/c hit ILS antenna during landing roll, severed right wing. Engine oil cooler line burst due to aging. Line was fabricated in the 1st qtr 0F 1972. Oil…Apr 11, 1986 · N4087W · Substantial damageNTSB FTW85LA351Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mt. Pleasant, TXThe pilot stated he lost engine power shortly after takeoff. He made an emergency forced landing in a grassy field. An examination showed a collapsed flex air duct from the air filter to the fuel injector. A forty five degree metal duct was not installed…Sep 19, 1985 · N95RA · Substantial damageNTSB MKC85LA171Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Cozad, NEThe plt reported that during a descent to land at kearney, NE, the eng lost power & oil oozed out of the cowling & covered most of the windshield. During a forced landing apch, he released his seat belt so he could see thru a small section of the windshield.…Jul 28, 1985 · N6598V · Substantial damageNTSB CHI85LA321Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Delaware, OHTotal loss of engine power occurred in the descent. The flight was vectored toweard the nearest airport but was unable to reach the runway. The aircraft was landed in a rough field. The left magneto was found seized during engine examination.Jul 27, 1985 · N110CF · Substantial damageNTSB LAX85FA130Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Bishop, CAThe plt rptd that shortly after leveling off at 11500 ft MSL, the engine exploded causing both windscreens to be covered with oil and fire. The fire stopped during the emergency descent. The acft landed on ry 30 at Bishop arpt, Bishop, CA without further…Jan 31, 1985 · N2129G · Substantial damageNTSB MIA85LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Floridana, FLDuring cruise flight the pilot noted the engine was vibrating severely and spraying oil and then failed. Examination of the engine revealed that the #2 cylinder connecting rod had failed in overload. A small piece of gear tooth was found inside the engine the…Jan 15, 1985 · N1496X · Substantial damageNTSB MKC84FA235Accident · Serious injuriesField investigationFinal reportPiper PA32R300 · Des Moines, IAThe acft eng began to 'shudder badly' upon reaching a cruise alt of 3500 ft MSL shortly after takeoff. The plt made a 180 deg course reversal to return to the arpt but reported to ATC he was unable to see outside the acft because oil was smeared on the acft.…Jul 30, 1984 · N1654H · Substantial damageNTSB MIA84FA196Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Niceville, FLThe acft crashed into trees short of the rwy after the engine quit on final approach. The engine failed from internal failure of the crankshaft gear retention system. A teardown revealed that the crankshaft gear bolt had backed out & the bolt head was noted…Jun 30, 1984 · N32538 · DestroyedNTSB DEN84LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Crested Butte, COThe acft was damaged during a forced landing on snow covered terrain after the engine failed during climb. An investigaiton revealed that the acft had 50 weight oil in it and the temperature was about 15 degrees f. the engine had been, pre-heated from the top…Feb 12, 1984 · N8984P · Substantial damageNTSB ANC82DA049Accident · No injuriesFinal reportPiper PA-32-300 · Near Ekwok, AKThe pilot made a forced landing when power would not develop more than 1500 rmp. Takeoff and climb had been normal up to 1000 feet when the engine began to lose power. Since not enough power was available to continue flight a landing was made in the tundra.…Jun 17, 1982 · N9561K · Substantial damageNTSB DEN82FTK04Accident · No injuriesFinal reportCallair A-9B · Sioux Falls, SDThe eng quit & the plt landed in an adjacent field after first hitting a wooded fence. An inspectin of the bendix fuel servo unit, model PSA-10ED-1, revealed that the fuel diaphragm stem, pn 2539806, had failed.May 27, 1982 · N7769V · Substantial damageNTSB CHI82FA157Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Milwaukee, WIEngine failure forced pilot to land in an open plowed field. Aircraft collided with wires but a successful landing was made. Oil pump gear tooth had failed.May 9, 1982 · N6837J · Substantial damageNTSB 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…Jan 10, 1982 · N6995Y · Destroyed