NTSB investigations: Lycoming TI0-540 series
77 cases on aircraft whose registry engine model is Lycoming TI0-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 ('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\" = 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 ('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" = 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 MIA89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Tupelo, MSThe operator had applied for an on-demand/air taxi cert, but had not obtained approval. After lvl-off on a flt to carry canceled checks, the plt elected to use the remaining fuel fm the inbd tanks. He stated that soon thereafter, the left eng bgn running…NTSB FTW89FA007Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Edinburg, TXAcft experienced a double eng failure. Plt stated that immediately after the left eng failed, in climb to cruise, the acft rolled left, the stall warning activated, and the acft entered a left spiral. The rt eng failed during the two-turn spiral. Plt's…NTSB SEA88LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Bend, ORAt aprx 1239 PDT, while on an IFR x-country flt at 14,000', the acft enctrd icing conds. Drg the next 1.4 hrs, the plt changed altitude in increments, climbing to 17,000', then descending to 11,000' to avoid icing. At aprx 1411 PDT, he indcd the eng had lost…NTSB MIA88LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Punta Gorda, FLThe plt was returning from VFR xc flt during which many climbs, descents & detours were made to avoid adverse wx & maintain VFR. He stated the strong headwinds considerably reduced his grndspeed. At his 1st intended ldg arpt, strong gusty x-winds made the…NTSB DEN88LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Hamilton, MTThe private plt was descending to the destination arpt at the conclusion of a 3.5 hr x-country flight. The plt said he selected the right main fuel tank and flew until the 'fuel was low to the point of exhaustion.' During a right turn, with the gear extended,…NTSB BFO88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Cambridge, MDThe pilot had departed ocean city, MD aprx 20 minutes after takeoff when nearing the chesapeake bay at an alt of 3000 ft MSL, a total loss of engine power was experienced. The plt attempted to restart the engine to no avail and a forced landing was made in a…NTSB ATL88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cleveland, OHThe plt rptd that both engines began to surge shortly after t/o during climb. The engines subsequently lost pwr completely, and the plt made a forced ldg in trees. Post-crash exam revealed that the fuel selectors were in the inbd tank positions. The lt inbd…NTSB MIA88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLU.S. Coast guard personnel stated that the pilot reported that they were out of fuel and were ditching approximately 110 miles southeast of Marathon FL. The pilots were picked up by the coast guard and were transported back to miami.NTSB DEN88LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260B · Akron, COBfr tkof, snow was melted off the acft in a heated hangar. The flt was bgn in blowing snow with a forecast of ocnl mod icing to 20,000'. The plt said the snow lasted only 5 to 10 min & only a trace of ice (less 1/16 inch) accumulated drg the 1st 15 min of…NTSB FTW87FA149Accident · No injuriesField investigationFinal reportPiper PA-60-601 · Hillsboro, TXAprx 3 min after leveling at 6500', the acft began losing pwr despite attempts to remedy the problem by using boost pump & x-feed. Subsequently, both engs lost power & the acft was damaged drg a wheels-up lndg in a milo field. An exam revealed the upper &…NTSB ATL86LA216Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Ridgeland, SCThe pilot was performing a test flight to test a new spray pump which was recently installed on the aircraft. Following a low pass over the runway the pilot heard a grinding noise from the left side of the aircraft. Shortly thereafter the aircraft lost total…NTSB DEN86LA121Accident · No injuriesLimited investigationFinal reportPiper PA-25-260C · Lamar, CODuring the initial telephone interview, the plt stated the eng quit due to fuel exhaustion while returning from an ag spraying flt. However, in the plt accident report, the plt states that he could not rule out mechanical problems.NTSB MIA86LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Pierce, FLThe plt stated that while switching tanks, his fuel selector froze up & both eng's failed. Upon landing, the acft struck a tree severing a wing. The NTSB form 6120.1 that was sent to the plt was returned, it stated that the addressee moved & left no address.…NTSB LAX86FA069Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Newport Beach, CAThe plt contacted coast TRACON (terminal radar control) & requested VFR traffic advisories to torrence. At aprx 0747 psthe declared an emergency, said the eng had quit & requested vectors to the john wayne/orange county arpt. The controllerprovided a hdg to…NTSB BFO85LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Middletown, DEFollowing takeoff, at about 350 feet AGL, the engine quit abruptly. The plt attempted to land in a field which was located about 15 degrees east of the acft's heading. While attempting to avoid pwr lines near the field, the right wing collided with the wires.…NTSB MIA85FA088Accident · No injuriesField investigationFinal reportPiper PA-23-250 · St. CroixWhen starting descent the pilot stated the right eng failed & the propeller feathered by itself. The pilot then switchedthe left fuel tank selector to the left aux tank. Shortly thereafter, the left engine failed. The pilot declared a mayday to St. Croix twr…NTSB CHI85LA078Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ypsilanti, MIThe acft collided with a fence & two parked cars during a forced landing while on a personal flt. The plt reported that after a 40 to 50 min ground delay he made a normal climb to 5000 ft MSL where he trimmed the acft & leaned the mixture to 75 percent power.…NTSB MKC84LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Garnett, KSWhile enroute pilot was running the acft using the right main fuel tank. He switched to the left to balance the load and the engine quit about 10 seconds after being switched. The pilot could not restart the engine and a forced landing was made in a field.…NTSB NYC84FA033Accident · 6 fatalField investigationFinal reportAero Commander 500B · Franklin, PABefore departing youngstown, OH, the plt filed 2 IFR flt plans, 1 for a flt to plattsburgh, NY, the other for a return flt from plattsburgh back to youngstown. After a 2 hr & 10 min flt to plattsburgh, 70 gal of fuel was added, but the person who serviced the…NTSB CHI84LA047Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Columbus, OHThe plt stated that during the preflt, he visually checked the fuel & estemated that the left tank was aprx 1/4 full & the right tank was about 1/2 full. He made his pretakeoff checks, but stayed on the ground longer than normal to allow the oil to warm up.…NTSB DEN83LA204Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Manning, NDThe acft collided with the ground after an eng failure while stringing power lines. The acft was in a right side low, nose high attitude pulling a wire attached to the left side of the acft. The wind was from the right rear quarter when the loss of power…NTSB CHI83IA360Incident · No injuriesIncident investigationFinal reportPiper PA31-310 · Mount Vernon, OHOn final approach both engines failed. The pilot elected to land intentional gear up short of therunway. Less than 1 pint of fuel was found on board.NTSB MKC83LA150Accident · No injuriesLimited investigationFinal reportBellanca 17-31A · Greensburg, KSThe pilot stated that the auxiliary tank ran dry and the engine quit. He switched the tank selector to the right main fuel tank which had ample fuel but he was unable to restart the engine. He made a forced landing on a highway and after touchdown the left…NTSB NYC83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Pittsfield, MAOn the 1st takeoff, the CFI demonstrated an aborted takeoff by placing the rt selector gasoline valve in the off position and had the student pull the eng back, making a landing on the rwy. The flt then taxied back for another takeoff, again the CFI shut off…NTSB DCA83AA019Accident · Serious injuriesFinal reportPiper PA-31-350-T1020 · Fort Belvoir, VAOn a flt from newark, NJ to richmond, VA, the departure time was delayed, and subsequently, the acft did not arrive at richmond until after the refueling facilities were closed. The plt decided there was sufficient fuel aboard to complete the next flt to the…NTSB FTW83LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Houston, TXThe aircraft struck a tree when the pilot was landing on a road. After tree impact, the aircraft spun around and crashed on the road sliding into a culvert and a telephone pole. The aircraft had been stolen and two occupants were observed to exit the aircraft…NTSB ATL82DA284Accident · No injuriesFinal reportPiper PA-31 · London, KYThe aircraft was on a flight from palm beach, FL to London, KY. Five miles short of runway 23 at London, both engines quit and the aircraft made a forced landing. Post crash examination revealed less than one gallon of fuel on board.