NTSB investigations: Lycoming 0-540 series
3,541 cases on aircraft whose registry engine model is Lycoming 0-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 ('41532'))
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'))
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 MIA08CA143Accident · No injuriesData collectionFinal reportCessna TR182 · Factoryville, PAThe pilot's diverted attention while on final approach and his delay in performing a go-around during the landing roll. Contributing to the accident were sun glare and excessive airspeed.NTSB SEA08LA156Accident · Serious injuriesLimited investigationFinal reportCessna TR182 · Bend, ORThe failure of the crankshaft during cruise flight due to fatigue.NTSB DEN08CA115Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Osage Beach, MOThe pilot failed to maintain separation from the parked airplanes while taxiing at an excessive speed for the conditions. Contributing to the accident was the airport personnel's decision to park the airplanes in close proximity to the taxiway.NTSB SEA08CA152Accident · Minor injuriesData collectionFinal reportPiper PA-24-250 · Vernal, UTThe pilot's failure to verify the airplane's fuel quantity during his preflight, resulting in fuel exhaustion. Contributing to the accident was the presence of a vehicle on the road where the pilot executed his forced landing.NTSB DFW08CA160Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Amistad, NMFuel starvation while in cruise flight. Contributing to the accident were incorrect maintenance, the fuel selector movement was impeded and a plowed field.NTSB CHI08FA146Accident · 2 fatalField investigationFinal reportPiper PA28 · Hillsboro, OHThe pilot's failure to maintain control of the airplane due to an in-flight fire as a result of a corrosion hole in the muffler that was not identified by the mechanic. Contributing to the accident was the improper emergency procedure performed for an…NTSB NYC08CA192Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Millinocket, METhe pilot’s failure to properly monitor fuel consumption during the flight.NTSB NYC08FA180Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Cruso, NCThe pilot's inadequate preflight planning and inadvertent flight into instrument meteorological conditions with moderate to severe turbulence prevailing. Contributing to the accident were the instrument meteorological conditions and turbulence.NTSB CHI08LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · New Lisbon, WIThe pilot's failure to maintain adequate altitude during a course reversal at the completion of an agricultural spray run.NTSB MIA08CA093Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Ellington, CTThe pilot's failure to perform a go-around when the airplane floated during landing.NTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.NTSB LAX08WA113Accident · Minor injuriesClass 5 · ForeignCessna 182 · San Quintin, MexicoOn April 13, 2008, about 0905 Pacific daylight time, a Cessna 182, N6278T, collided with a greenhouse during the initial climb out from a private airstrip in San Quintin, Mexico. The pilot and three passengers received minor injuries; the airplane was…NTSB LAX08CA106Accident · No injuriesData collectionFinal reportMaule M-5-235C · Monroe, WAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing rollout.NTSB SEA08CA103Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Alturas, CAThe pilot's inadequate compensation for the gusty crosswind conditions. The wind gusts were a contributing factor.NTSB LAX08CA111Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Grand Canyon, AZThe pilot's inadequate compensation for the wind conditions and delay in aborting the takeoff. Contributing to the accident were wind gusts and a crosswind.NTSB NYC08LA142Accident · No injuriesLimited investigationFinal reportPiper PA32 · New Albany, MSA loss of engine power for undetermined reasons.NTSB NYC08CA141Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Opa Locka, FLThe entanglement of the hook rope with the rudder horn during banner pickup.NTSB SEA08CA092Accident · No injuriesData collectionFinal reportPiper PA-24 · Bountiful, UTThe pilot's failure to extend the landing gear.NTSB DFW08LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Spring, TXFailure of the pilot to ensure that the fuel system was purged of water prior to flight. Contributing to the severity of injuries was the lack of shoulder restraints.NTSB DFW08LA065Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Antonio, TXSeparation of the turbocharger exhaust stack, which resulted in a loss of engine power.NTSB MIA08CA042Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Atlanta, GAThe failure of the pilot-in-command to maintain directional control of the airplane during landing.NTSB NYC08CA063Accident · No injuriesData collectionFinal reportMaule M-7-235 · Key Largo, FLThe pilot's loss of control during the landing. Contributing was the wind gust.NTSB MIA08LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA32-260 · Marathon, FLA loss of engine power for undetermined reasons.NTSB MIA08FA026Accident · 2 fatalField investigationFinal reportCessna R182 · Woodland, ALThe flight instructor’s failure to maintain control of the airplane while attempting to conduct visual flight in reduced visibility conditions at night. Factors contributing to the accident include the flight instructor’s inadequate preflight planning, and…NTSB NYC08LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Hollywood, FLThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall. Contributing to the accident were an inoperative stall warning system and an erroneous airspeed indicator.NTSB NYC08FA026Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 · Jamestown, TNThe pilot’s failure to maintain clearance from a known wire hazard during takeoff.NTSB LAX08CA011Accident · No injuriesData collectionFinal reportMaule M-5-235-C · Mesa, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB DFW08LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Houston, TXThe pilot's failure to properly position the fuel tank selector before takeoff. Contributing to the accident were the non suitable terrain for the forced landing and fuel starvation.NTSB DFW07CA211Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Navasota, TXThe hard landing as result of the pilot's improper landing flare.NTSB MIA07LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wimauma, FLThe failure of the pilot to maintain airspeed while maneuvering for a precautionary landing following a reported loss of engine power for undetermined reasons.NTSB ANC07CA105Accident · No injuriesData collectionFinal reportPiper PA-32 · Chenega Bay, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch during the landing roll. A factor associated with the accident was the ditch.NTSB SEA07CA241Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Soda Springs, IDThe pilot's inadequate in-flight planning/decision making and subsequent loss of engine power due to fuel exhaustion. Contributing factors were the terrain conditions (soft and rough/uneven) and the tailwind weather conditions.NTSB NYC07FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-260 · Westhampton, NYUndetermined. The airplane remains missing.NTSB ANC07CA087Accident · No injuriesData collectionFinal reportMaule M7 · Bettles, AKThe pilot's selection of an unsuitable landing site, which resulted in an encounter with soft terrain, and a nose over during the landing roll.NTSB LAX07CA251Accident · No injuriesData collectionFinal reportCessna R182 · Coeur D'Alene, IDthe instructor's misjudged landing flare.NTSB CHI07LA254Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Overly, NDThe pilot's failure to maintain terrain clearance during the agricultural application flight. Contributing to the accident was the wheat crop.NTSB LAX07LA234Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Ramona, CAA total loss of engine power due to a short circuit between both magneto ground leads. A factor in the accident was the inadequate annual/100-hour maintenance inspection regarding the wires.NTSB ATL07FA102Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Tyringham, MAThe pilot's inadvertent encounter with thunderstorms during cruise flight. Contributing to the accident was the failure of air traffic control to appropriately issue weather information and initiate an in-flight deviation around known and clearly observed…NTSB LAX07CA196Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Boulder City, NVthe pilot's failure to extend the landing gear.NTSB ANC07LA057Accident · No injuriesLimited investigationFinal reportCessna 182RG · Tok, AKThe pilot's failure to maintain control of the airplane during takeoff initial climb.NTSB NYC07CA150Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Machias, METhe pilot's inadequate in-flight planning.NTSB SEA07LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Flagstaff, AZThe loss of engine power during cruise flight due to fuel exhaustion, as a result of the pilot's failure to refuel and inadequate preflight planning.NTSB ANC07CA049Accident · No injuriesData collectionFinal reportBritten-Norman BN2A26 · Egegik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage during the landing roll when the airplane encountered soft sand.NTSB DFW07CA132Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Madison, MSThe pilot's failure to extend the landing gear prior to landing.NTSB LAX07CA178Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Mammoth Lakes, CAthe pilot's failure to ensure that the runway was clear of other aircraft before takeoff.NTSB LAX07LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Winslow, AZLoss of engine power for undetermined reasons.NTSB LAX07LA163Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Delta, UTthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall and collision with terrain.NTSB SEA07CA123Accident · No injuriesData collectionFinal reportPiper PA28-235 · San Jose, CAWind shear encounter during approach for landing.NTSB CHI07FA114Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Bass Lake, INThe pilot's failure to maintain a proper approach glidepath, which resulted in a settling-with-power flight condition. Contributing to the accident was the dark night light condition.NTSB LAX07FA103Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Tooele, UTThe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight separation of the wings and horizontal stabilizers. Contributing to the accident were the night lighting conditions, clouds, turbulence and icing conditions.