NTSB investigations: Lycoming TI0-540 series
2,259 cases on aircraft whose registry engine model is Lycoming TI0-540 series. 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'))
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'))
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 ERA24LA111Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301T · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during the landing roll in a gusting crosswind.NTSB ERA24LA081Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Gordonville, PAThe pilot’s improper fuel management resulting in fuel starvation, a total loss of engine power, and subsequent off-airport forced landing.NTSB CEN24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Forney, TXThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA060Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Anthony, KSA failure of the airplane’s alternator, which resulted in a loss of electrical power, and the pilot’s failure to use the emergency gear extension procedure during the initial landing approach, which led to a gear-up landing.NTSB ERA24FA050Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Attalla, ALThe undetected wear of both pawl retaining rivets of the left magneto impulse coupling and fatigue failure of one pawl retaining rivet, which led to cascading fractures of the second pawl retaining rivet, left gear retainer assembly, and gear teeth of…NTSB CEN24LA039Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Ozark, MOA reported total loss of engine power for undetermined reasons.NTSB ERA24LA034Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Florala, ALThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the flight instructor’s inadequate supervision of the flight.NTSB ERA24FA026Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Marion, OHA descent and impact with terrain for undetermined reasons.NTSB CEN24FA028Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46 · McCook, NEThe pilot exceeded the airplane’s critical angle of attack during the initial climb, resulting in an aerodynamic stall from which he could not recover. Contributing to the accident was the pilot’s decision to take off with the airplane well above its maximum…NTSB WPR24FA024Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Orangeville, UTThe pilot's controlled flight into mountainous terrain for reasons that could not be determined.NTSB CEN24LA020Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA 46-350P · Pierre, SDThe total loss of engine power due to fuel starvation as a result of the pilot’s improper configuration of the automatic fuel transfer system. Contributing to the accident was the pilot’s failure to adequately monitor the header tank’s fuel quantity.NTSB CEN23LA415Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Moberly, MOThe flight instructor’s inadequate fuel management that resulted in fuel starvation and a total loss of engine power during an approach for landing.NTSB ERA23LA362Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Cincinnati, OHA loss of engine power for reasons that could not be determined.NTSB CEN23LA370Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Durant, OKThe loosening of a connecting rod cap nut for reasons that could not be determined, which resulted in a mechanical failure of the engine and an in-flight fire.NTSB GAA23WA240IncidentClass 4 · ForeignPiper PA-31-350 · North Eleuthera, BahamasNTSB ERA23LA354Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Fishers Island, NYThe loss of engine power for reasons that could not be determined. Contributing was the pilot’s misjudgment of airspeed and altitude during the forced landing.NTSB ERA23LA337Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Haines City, FLA total loss of engine power due to fuel starvation for reasons that could not be determined.NTSB WPR23LA317Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Fullerton, CAThe separation of the stabilator actuator from the stabilator tab, which resulted in pitch control surface flutter and structural damage.NTSB ERA23LA301Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-310 · Lumberton, NJThe pilot's failure to extend the landing gear before landing.NTSB GAA23WA195AccidentClass 5 · ForeignPiper PA-23-250 · The Valley, AnguillaNTSB ERA23FA280Accident · 5 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · North Myrtle Beach, SCThe pilot’s loss of control during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s operation of the airplane above its maximum gross weight and near its aft center of gravity limit,…NTSB CEN23LA246Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · College Station, TXThe mechanic’s failure to properly secure the oil suction screen plug during recent maintenance, which resulted in an oil leak and subsequent loss of engine power due to oil starvation.NTSB WPR23FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-31-325 · Tupelo, MSThe pilot's exceedance of the airplane's critical angle of attack while maneuvering after takeoff for reasons that could not be determined, which resulted in an aerodynamic stall and subsequent loss of control.NTSB ANC23LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Point Thomson, AKThe pilot’s inadvertent descent below the published minimum descent altitude, while operating in flat light conditions, which resulted in controlled flight into terrain.NTSB WPR23FA188Accident · 2 fatalClass 3 · FieldFinal reportCessna T182T · Albany, WYThe pilot’s decision to conduct flight into an area of icing in an airplane that was prohibited from such conditions, which resulted in exceedance of the airplane’s critical angle of attack, an aerodynamic stall/spin, and the pilot’s spatial disorientation…NTSB ERA23FA181Accident · 4 fatalClass 3 · FieldFinal reportPiper PA32R · Venice, FLThe pilot’s decision to initiate a visual flight rules flight into dark night conditions, which resulted in spatial disorientation during the initial climb and subsequent steep banking descent into water.NTSB CEN23LA138Accident · Serious injuriesClass 4 · LimitedFinal reportSocata TB21 · Eden Prairie, MNThe pilot’s continued flight into icing conditions in an airplane that was not equipped for icing, which led to structural icing, subsequent loss of airplane control and impact with terrain.NTSB WPR23LA116Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · San Jose, CAA landing gear collapse due to an inadequately maintained landing gear extension and retraction system.NTSB GAA23WA069Incident · No injuriesClass 5 · ForeignPiper PA-23-250 · Nassau, BahamasNTSB ERA23LA122Accident · Serious injuriesClass 3 · LimitedFinal reportAero Commander 500 · Sylacauga, ALThe pilot’s failure to assure there was an adequate amount of fuel onboard to complete the flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA23LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-31-350 · Middlefield, OHA runway overrun during a precautionary landing following a total loss of right engine power due to detonation and subsequent oil starvation. Contributing was the pilot’s failure to lower the flaps and the excessive airspeed at touchdown.NTSB GAA23WA068Accident · No injuriesClass 5 · ForeignPiper PA-23-250 · George Town, BahamasNTSB ERA23LA107Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · Old Bridge, NJThe pilot’s failure to maintain adequate clearance from trees during the landing approach.NTSB ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.NTSB GAA23WA042Accident · 1 fatalClass 5 · ForeignPiper PA 46-350P · Happy Valley-Goose Bay, CanadaNTSB WPR23FA044Accident · 1 fatalClass 3 · FieldFinal reportGallagher XLT-RG · Banning, CAAn inflight engine fire for reasons that could not be determined that resulted in impact with terrain.NTSB ERA23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Lake Worth, FLA loss of engine power for reasons that could not be determined.NTSB ERA23FA025Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Brentwood, TNA total loss of engine power due to the catastrophic failure of the crankshaft resulting from the improper installation of the crankshaft for this application.NTSB CEN23LA012Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Paola, KSThe pilot’s improper positioning of the fuel selector, which resulted in fuel starvation and a loss of engine power during a departure climb.NTSB ERA22LA424Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell International 700 · Sevierville, TNThe total loss of engine power to the twin-engine airplane during final approach due to fuel exhaustion. Contributing to the accident was the pilot’s failure to maintain aircraft control during the approach to land, which resulted in a runway excursion and…NTSB ERA22FA418Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Afton, VAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power at night over mountainous terrain.NTSB CEN22LA413Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Bulverde, TXThe partial loss of engine power due to excessive carbon deposits that resulted in one or more stuck exhaust valves.NTSB ERA22LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Gardiner, NYThe pilot’s failure to go-around in a timely manner which resulted in a collision with a fence.NTSB WPR22LA296Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Corona, CAThe airplane’s partial loss of engine power during the landing for reasons that could not be determined based on the available evidence, which resulted in an off airport landing and subsequent fire.NTSB CEN22LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Dallas, TXMaintenance personnel’s inadequate maintenance of the magneto, which resulted in a loss of engine ignition, a loss of engine power, and a subsequent forced landing.NTSB WPR22LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB21 · San Marcos, CAThe failure of the mechanical fuel pump due to internal friction for reasons that could not be determined based on available evidence, which resulted in a total loss of engine power.NTSB GAA22WA227Accident · 2 fatalClass 5 · ForeignPiper PA-31-325 · Queretaro, MexicoNTSB CEN22LA313Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Rapid City, SDA total loss of engine power for reasons that could not be determined because the airplane was unavailable for examination.NTSB GAA22WA249Accident · No injuriesClass 5 · ForeignPiper PA-32R-301T · Tamaulipas, MexicoNTSB CEN22LA307Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300T · Frankston, TXThe pilot’s delayed aborted takeoff that resulted in a runway overrun and impact with terrain.