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 ANC86LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Stoney River, AKThe pilot stated that after liftoff he failed to maintain airspeed. The aircraft stalled and crashed into the River.NTSB SEA86FA203Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Grangeville, IDA passenger in the acft reported the plt made more than one pass over 'a salt lick', each time coming closer and closer to the trees. On the last pass the acft 'just fell out of the sky', hit the trees, and landed upside down. Fire broke out almost…NTSB DEN86LA221Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Albuquerque, NMThe plt rprtd the acft was refueled to capacity at longmont, CO. Full capacity should have provided at least 3.6 hrs of flying time at normal consumption. After refueling, the acft was flown 1.3 hrs to fowler, CO, where it remained parked for a week. The plt…NTSB DEN86FTK04Accident · Serious injuriesFinal reportPiper PA-25-235 · Clear Lake, SDThere was a power line across the approach to the field being treated. The plt reports that he got too low during the flare out for entry to the swath run. The wheels contacted the sunflower crop and the acft impacted the ground. A fire developed during…NTSB MIA86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile on final aprch with the ldg gear extended for ldg, the plt observed another acft ahead of him which he felt he was overtaking. He elected to execute a go-around & while on downwind leg, the plt retracted the gear absent-mindedly thinking he was…NTSB CHI86FA194Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Oshkosh, WIThe aircraft ran out of fuel after 3+41 hours of flight. The pilot stated that he was sure the tanks were full on takeoff. Flight planning and a documented conservative fuel burn rate indicated that the aircraft should have been able to remain airborne for at…NTSB MKC86LA163Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Hershey, NEThe pilot stated he was spraying insecticides on corn and encountered a wind shear that pulled the airplane down into the corn. He was unable to recover and the airplane hit the ground.NTSB DEN86FA208Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Boulder, COThe purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a…NTSB DEN86LA204Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Sisseton, SDThe plt reported that the eng lost about 200 RPM during the takeoff roll and he decided to abort. During the abort the plt swerved to avoid a fence at the end of the rwy and the acft slid sideways collapsing the lt MLG. Investigation revealed a broken…NTSB ATL86FEK03Accident · No injuriesFinal reportHiller UH-12E · Pataskala, OHThe acft autorotated to a forced landing after the eng quit at 600 ft AGL. The landing was made in a corn field. The plt told a FAA inspector at the scene that he had 8 gals of fuel remaining. When the fuel tank was drained it contained aprx 6 oz total. The…NTSB SEA86LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Boise, IDWhile taxiing for takeoff an inadvertant ground loop occurred during which the acft veered left striking another parked acft. The plt stated it felt as though the tailwheel jammed; however, post accident exam failed to disclose any failure/malfunction.NTSB CHI86FER12Accident · Minor injuriesFinal reportPiper PA-25-235 · New Richland, MNThe aircraft performed a forced landing which resulted in substantial damage. Water was found in the fuel system. Water was also found in the underground fuel supply used to refuel the crop duster.NTSB CHI86FEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Ionia, MIDuring initial banner pick-up of a banner towing operation the tow cable fouled the rudder control mechanism. The rudder was jammed and the banner release mechanism failed to operate. The aircraft impacted the ground left wing first and was substantially…NTSB DEN86LA183Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bynum, MTAfter the first landing on a gravel road for reloading liquid insecticide the pilot attempted to take off for an aerial application flight. During the take off ground roll the pilot observed that the left door was not properly closed. He momentarily reduced…NTSB DEN86LA182Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Williston, NDDuring the telephone interview, the plt stated the eng of his crop duster quit due to fuel exhaustion and a forced landing was made.NTSB ATL86LA177Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · West Chester, OHDrg flt, the eng lost power & the plt was unable to maintain alt. He made a forced landing on a road, but drg the lndg roll, the acft collided with a road sign. A post crash exam of the eng revealed the #6 cylinder had separated aprx 4' above the cylinder…NTSB ANC86FA074Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Volkmar Lake, AKAfter touchdown the pilot lost directional control of the aircraft causing the right wingtip to strike the water. The aircraft then rolled over and sank. The PIC was operating the aircraft and carrying passengers with only student pilot certificate.NTSB DEN86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Harve, MTAccording to the plt, shortly after takeoff the eng lost partial pwr as a result of carb ice, & a forced landing was made.NTSB LAX86FA233Accident · 4 fatalField investigationFinal reportPiper PA 28-236 · Chino, CAThe private non-instrument rated pilot, overflew his home airport by 23 nautical miles upon returning from a night cross country flight and descended into a hill. Instrument meteorological conditions were reported in the area due to reduced visibility. The…NTSB MIA86LA123Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Ocala, FLPurpose of the flight was to calibrate the spray equipment. The plt loaded the hopper with about 70 gallons of water and initiated a takeoff. At about 100 ft AGL on initial climb the cockpit filled with smoke and the eng failed. The acft struck a tree on…NTSB FTW86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Springtown, TXThe pilot reported colliding with a fence at the end of the runway when he landed short while on final approach into kezer airport near Springtown, TX. His aircraft sustained substanial damage to the left wing, nose gear and propeller after travelling 200 ft.…NTSB LAX86LA110Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Francisco, CAOn feb 9, 1986 at 1717 PST a Piper PA-23, N5300Y, ditched approximately 460 NM sw of sfo, CA. The flt originated from hnl, HI. In flt fuel leak was discovered after 7 hrs of flight. Fuel vapors were seen contrailing off both wings. The plt attempted to…NTSB CHI86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mechanicsburg, OHThe plt was on a personal flt when IMC was encountered. The plt elected to climb to a clear area above the IMC when the acft became totally 'socked in.' A 180 deg turn was made, vertigo was experienced and control of the acft was lost. An emergency descent…NTSB CHI86LA064Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Schaumburg, ILAccording to the pilot, the aircraft had been refueled the day before in buffalo new york. The aircraft was then flown to chicago,IL. The duration of the flight was four hours and thirty minutes. The following day, without refueling, the aircraft was flown to…NTSB NYC86LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Mttituck, NYPilot states on landing flair the aircraft was tracking on a 190 degree heading for rwy 29 winds were from 260 pt 20 KTS on flair acft drifted approx 16 ft to the left and left wide extended beyond rwy making contact with shrubbry on the edge of the rwy. Acft…NTSB LAX86LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Canoga Park, CAWhile the plt was cruisin in his own acft, an eng oil leak developed, oil pressure decreased & eng power was lost, the plt attempted to make an emergency ldg on a city street, on approach the acft collided with power lines & a fence, & the acft came to rest…NTSB LAX86FA063Accident · 2 fatalField investigationFinal reportCessna TR182 · Independence, CAWhile en route, the acft collided with moutainous terrain (trrn) at an aprx elev of 13,500 ft. previously, the plt had requested & was rcvg traffic advisories fm ARTCC. Bfr the acdnt, the acft's psn & alt (mode c reply) were noted by the controller (ctlr). No…NTSB ATL86LA033Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Albany, GAThe aircraft landed on the wet sod runway with a 30 to 35 knot tailwind and ran off the end of the runway and into the trees. The pilot related that the wind shifted 180 degrees upon touchdown. The pilot also stated that he touched down approximately 1000 ft…NTSB LAX86LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Tustin, CAThe plt's mechanic performed a pre-purchase inspection of the acft. No malfunctions were detected with the fuel system, & the mechanic informed the plt that the acft was overall 'in good condition.' Later in the day the plt purchased the acft, & after…NTSB MIA86FA028Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Sorrento, FLThe flt was on a VFR x-country at 9500 ft with ATC flt following. The non-instrument rated plt advised ATC that he was unable to maintain VFR & climbed to 11,000 ft. he again avised he was unable to maintain VFR & was going to descend. The acft was observed…NTSB FTW86FPA04Accident · No injuriesFinal reportPiper PA-24-250 · Terrell, TXThe acft traveled through a barbed wire fence during a forced landing short of rwy 35 at Terrell arpt. When aprx 1 mile from the arpt, the eng quit. The plt was unable to move the fuel selector, however, by applying a full rich mixture and turning on the…NTSB FTW86FPA03Accident · Minor injuriesFinal reportPiper PA-28-235 · Yantis, TXThe acft contacted a tree and a large bale of hay during a forced landing following a loss of pwr. Post accident inspection disclosed 18 gallons of fuel remained in the left main tank and 3 gallons remained in the left wing tip tank. Both right wing fuel…NTSB NYC86FA015Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Tobyhanna, PAAt about the time N4298K was departing pocono mountains mun icipal airport, recorded radar information from new york ARTCC displayed an aircraft in that area. The aircraft flew eastward and then northward. The aircraft disappeared from the radar screen about…NTSB CHI85LA372Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Washington, ILThe plt attempted to takeoff on the 1800 ft long grass airstrip with 3 passengers on board. A 90 deg, 12 kt x-wind was present and the OAT was 91 deg f. after liftoff, the acft settled back on the airstrip and continued off the end into a bean fld where the…NTSB ATL85LA268Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Florence, SCThe plt was unable to extend the landing gear & performed a gear-up landing. Post accident examination revealed that the nose gear door was restricting the movement of the landing gear due to improper repair of the landing gear door attachment.NTSB CHI85LA363Accident · No injuriesLimited investigationFinal reportCallair A-9 · Hollandale, MNDuring a maneuvering turn while crop dusting the pilot experienced a muffler failure and engine fire. He landed successfully and abandoned the aircraft. Subsequent investigation revealed that the bracket that holds the muffler/ exhaust pipe to the aircraft…NTSB FTW85FQG03Accident · 1 fatalFinal reportPiper PA-25-235 · Morton, TXAfter the plt completed a swath run, the acft entered a rgt climbing maneuver, then rolled wings level. After that, it reportedly began an abrupt climb for aprx 50 to 60 ft, then nosed down & crashed in a steep descent. After impact, the acft was destroyed by…NTSB FTW85LA326Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Farmerville, LAThe plt took off and started his climbout with the fuel selector on a fuel tank which was virtually empty. The eng stopped reaching an alt of 200 feet AGL. The plt made forced landing in trees. There was an ample supply of fuel (about 70 gallons) distributed…NTSB ATL85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Goodway, ALDuring aerial application the acft lost total pwr and the plt made an emergency landing in a fld. The plt stated that shortly after the eng lost pwr, he noticed smoke coming from the eng nacelle. After landing in the fld, the acft began to burn and was…NTSB FTW85LA319Accident · No injuriesLimited investigationFinal reportCessna R182 · Lubbock, TXThe plt made a hard landing at the town and country arpt at Lubbock, TX, and a collapse of the nose gear resulted.NTSB ANC85LA188Accident · 2 fatalLimited investigationFinal reportMaule M-5-235C · Mccarthy, AKThe pilot departed a sand bar near the bernard glacier on 8/8/85, and never returned to pick up the passenger he had dropped off earlier. On 8/12/91 the wreckage was found by hunters at 61-11N 141-42W at the 1,000-FT level in mountainous terrain. The wreckage…NTSB SEA85LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Cold Meadows, IDThe plt was attempting to land on an airstrip with a density alt of 9000 ft. during a go-around the acft was unable to out climb rising terrain due to the density alt. A departure stall into trees resulted. A post-impact fire destroyed the acft. The plt…NTSB MKC85LA173Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Norcatur, KSThe acft had been spraying for 40 minutes at 2500 ft MSL with a density alt of aprx 4600 ft when it stalled during a turnaround. It then impacted an electric pwr pole followed by the terrain.NTSB BFO85LA059Accident · No injuriesLimited investigationFinal reportCessna 182RG · Stevensville, MDAfter landing to the left of the centerline of rwy 10, the acft veered left off the rwy and collided with a drainage ditch located approximately 10 yards from the rwy. Following contract with the ditch, at approximately 15 mph, the acft flipped over, coming…NTSB MIA85IA211Incident · No injuriesIncident investigationFinal reportCessna R182 · Jacksonville, FLThe plt stated that he made a normal touchdown & on his landing rollout the nose gear collapsed. The landing gear was cycled several times after this occurrence & no abnormality was observed. No determination could be made of the malfunction of the landing…NTSB DEN85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Thistle, UTThe plt had just completed an aerial spray mission and was flying through a canyon when the acft collided with pwr lines. Control of the acft was lost and it contacted the terrain.NTSB NYC85FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Tioga, PAThe plt initiated a downwind landing on a grass rwy that sloped mostly uphill, but began sloping downhill at its departure end. A witness near the apch end of the 2150 ft rwy watched the acft touch down beyond its midpoint, then disappear over its crested…NTSB ATL85LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peachtree City, GAAccording to the pilot, he forgot to extend the landing gear. He stated most of his flight time had been in fixed gear aircraft. On this flight he had been told by his instructor to work on smoothing his radio technique on the second landing of the flight he…NTSB ANC85LA119Accident · No injuriesLimited investigationFinal reportHelio 250 · Anchorage, AKThe plt reported that he took off downwind with a heavily loaded acft. He estimated the wind was from the north at 4 gusting to 6 KTS. He stated that after climbing about 100 ft, the acft began to mush as he began retracting the flaps. Subsequently, it…NTSB SEA85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mccall, IDThe acft was damaged during a forced landing in a fld following fuel exhaustion. The plt reported he departed yellow pine, ID, with the fuel gages indicating 1/2. Upon reaching an alt of 10,000 ft, the eng quit due to fuel exhaustion. The right fuel tank was…