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 ANC10CA031Accident · Minor injuriesData collectionFinal reportPiper PA-31-350 · Eek, AKAn in-flight collisions with two Cackling Geese (Branta Hutchinsii).NTSB CEN10CA228Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Jamestown, NDThe pilot's failure to lower the landing gear, resulting in a gear-up landing.NTSB ERA10IA254Incident · No injuriesIncident investigationFinal reportPiper PA 46-350P · Owensboro, KYA failure of the pilot's side window due to undetected cracking around the lower aft portion of the storm window cutout.NTSB ERA10LA247Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Clemson, SCThe airplane's inadvertent collision with deer during a night takeoff. Contributing to the accident was the lack of a deer barrier between the airport and an adjacent wooded area.NTSB WPR10LA189Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Honolulu, HIThe pilot's failure to maintain clearance from a parked airplane during taxi due to his inadequate visual lookout.NTSB ERA10FA180Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Williston, FLThe pilots of both airplanes did not maintain an adequate visual lookout to see and avoid each other.NTSB CEN10FA125Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Belleville, ILThe pilot’s spatial disorientation and subsequent failure to maintain airplane control during the instrument approach.NTSB WPR10FA142Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Groveland, CAThe pilot's continued flight into night instrument meteorological conditions during the landing approach, which resulted in an in-flight loss of aircraft control due to spatial disorientation.NTSB CEN10CA106Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Cherokee, IAThe pilot misjudged his altitude while on short final approach.NTSB ERA10WA116Accident · 3 fatalForeign investigationPiper PA-32-300 · Bimini, Bahamas, BahamasOn January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…NTSB WPR10FA107Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Honolulu, HIThe pilot's continued visual flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance. Contributing to the accident was the air traffic controller's failure to issue a safety alert after observing the…NTSB ERA10LA110Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Auburn, ALThe pilot's loss of directional control after landing, which resulted in a runway excursion.NTSB ERA10LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Concord, NCA missing right main landing gear aft trunnion mount attachment nut.NTSB ERA10FA028Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Zephyrhills, FLA total loss of engine power during a night approach for undetermined reasons.NTSB CEN10FA027Accident · 2 fatalField investigationFinal reportCommander 114-B · Adrian, MIThe pilot did not maintain control of the airplane due to spatial disorientation while on an instrument approach in instrument meteorological conditions.NTSB ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.NTSB CEN10CA018Accident · Minor injuriesData collectionFinal reportCessna T206H · Johnson City, KSThe pilot's delayed action in applying full power during a go-around after flying into a fog bank.NTSB ANC10CA002Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Nondalton, AKThe pilot's decision to attempt a landing in weather conducive to strong downdrafts, resulting in a loss of control.NTSB ERA10LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Whiteville, NCThe pilot's improper flare and subsequent hard landing during an intentional gear-up landing following multiple mechanical malfunctions. Also causal to the accident was an inoperative landing gear emergency-down valve which had blockage for undetermined…NTSB ERA10CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Highgate, VTThe pilot’s improper fuel management which resulted in loss of engine power due to fuel starvation.NTSB CEN09FA610Accident · 1 fatalField investigationFinal reportMooney M20M · Albany, INThe incapacitation of the pilot during high-altitude cruise flight for undetermined reasons.NTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.NTSB ERA09FA526Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Fort Lauderdale, FLFatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…NTSB ERA09CA518Accident · No injuriesData collectionFinal reportPiper PA46 · Chamblee, GAThe pilot's failure to maintain aircraft control during landing. Contributing to the accident was pilot fatigue.NTSB CEN09FA562Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Tulsa, OKThe non-instrument-rated pilot’s decision to attempt flight in instrument meteorological conditions, which resulted in spatial disorientation and an in-flight collision with a radio tower guy wire.NTSB WPR09LA412Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Santa Barbara, CAA loss of power during approach due to fuel exhaustion for undetermined reasonsNTSB ERA09LA471Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Sanford, FLThe fatigue cracking at the point the nose landing gear actuator attaches to the mount resulting in separation of the actuator and partial collapse of the nose landing gear. Contributing to the accident was the lack of specific inspection guidance for…NTSB ERA09MA447Accident · 9 fatalClass 1 · MajorFinal reportPiper PA-32R-300 · Hoboken, NJ(1) the inherent limitations of the see-and-avoid concept, which made it difficult for the airplane pilot to see the helicopter until the final seconds before the collision, and (2) the Teterboro Airport local controller’s nonpertinent telephone conversation,…NTSB CEN09CA465Accident · No injuriesData collectionFinal reportPiper PA32R · Colorado Springs, COThe pilot's low altitude encounter with windshear during takeoff.NTSB WPR09LA361Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Redmond, ORAn undetermined hydraulic system malfunction in the engine compartment during descent from cruise flight which resulted in an in-flight fire.NTSB CEN09FA393Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Lakeview, ARThe pilot's poor judgment/decision making in attempting the no-flap takeoff, his failure to comply with weight and balance limitations, and his failure to calculate the airplane's performance under exiting conditions.NTSB WPR09LA297Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Roosevelt, UTThe retraction of the left main landing gear due to the failure of the extension and retraction actuator arm attach bolt. Contributing to the accident was the failure of maintenance personnel to discover the extensive elongation of the actuator attach fitting…NTSB ANC09LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nunapitchuk, AKThe pilot's failure to maintain sufficient airspeed to avoid a stall during the landing approach.NTSB ERA09CA227Accident · No injuriesData collectionFinal reportPiper PA-31-325 · Newark, NJThe pilot's decision to continue to operate the airplane with inoperative brakes on the airplane's right side.NTSB WPR09FA158Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Corona, CAThe pilot did not maintain airplane control during climb due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the pilot's lack of recent instrument flying experience.NTSB ANC09LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Buckland, AKThe pilot's failure to abort the landing while landing on a snow/ice-covered runway.NTSB WPR09CA143Accident · No injuriesData collectionFinal reportBellanca 17-31ATC · Bakersfield, CAThe pilot's failure to maintain directional control while landing.NTSB WPR09CA120Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Lincoln, CAThe pilot's failure to extend the landing gear for landing. Contributing to the accident was the pilot's diverted attention due to an open door and the airport's pilot activated runway lights turning off.NTSB ANC09LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKThe pilot's continued flight into adverse weather and his failure to maintain clearance from terrain while on approach in flat light conditions.NTSB WPR09FA116Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Hagerman, IDThe student pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the pilot's mental condition which could have contributed to the inappropriate decision to fly the…NTSB ERA09CA134Accident · Serious injuriesData collectionFinal reportPiper PA-32R-300 · Manteo, NCThe pilot's failure to follow the missed approach procedure while landing with a low ceiling.NTSB CEN09FA099Accident · 1 fatalField investigationFinal reportPiper PA-32R · North Canton, OHThe pilot’s inappropriate control inputs as a result of spatial disorientation, which led to an aerodynamic stall and loss of control. Contributing to the accident were the pilot's decision to conduct flight into known icing conditions, ice accumulation that…NTSB CEN09WA091Accident · 2 fatalClass 5 · ForeignPiper PA46 · Baden, AustriaNTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.NTSB ERA09CA217Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Middletown, DEThe pilot's failure to maintain aircraft control while landing in gusty conditions.NTSB ERA09CA016Accident · No injuriesData collectionFinal reportCessna 182T · Gulf Shores, ALThe pilot's improper recovery from a bounced landing.NTSB WPR09LA014Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fresno, CAThe pilot misjudged the flare resulting in a hard landing.NTSB DFW08CA236Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Augusta, KSA loose oil line that resulted in a total loss of engine oil, causing the engine to cease.NTSB LAX08FA286Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Las Vegas, NVA loss of power in the right engine due to an in-flight fuel-fed fire in the right engine compartment that, while the exact origin could not be determined, was likely related to the right engine-driven fuel pump, its fuel supply line, or fitting. Contributing…NTSB ANC08LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Aniak, AKA partial loss of engine power during takeoff due to a failure of the left engine's turbocharger as a result of the failure of a turbine shaft bearing. Contributing to the accident was unsuitable terrain for a forced landing.