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 MKC84LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pollard, ARThe plt stated that he was spot spraying a bean field and was aware of the location of the electrical transmission line. As he attempted to maneuver the acft under the line, a wing made contact with the line and the acft inpacted the ground.NTSB CHI84FA289Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Pullman, MIThe acft crashed while practicing aerial application maneuvers. The plt of the acft had been interrupted at the refueling pump by an acft which was awaiting a chemical reload. The student crop dusting plt, who was also a loader, left the refueling area to…NTSB ANC84LA107Accident · No injuriesLimited investigationFinal reportMaule M-5 · Anchorage, AKThe plt reported that when he landed on campbell lake, the left float hit a submerged object. The acft then yawed to the left, banked to the right & went over on its top. Campbell lake was used as a private sea-plane base & was located within the city limits…NTSB CHI84LA265Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kankakee, ILThe eng quit shortly after takeoff & the acft landed in a bean field. The fuel selector was found on the empty right main fuel tank. The left main fuel tank & tip tanks were full of fuel.NTSB ANC84FA092Accident · Minor injuriesField investigationFinal reportMaule M-5-235C · Anchorage, AKThe acft traveled forward into a parked acft after the plt hand propped it to start the engine. A pax who had 'a few hours', according to the plt, was inside the acft to hold the foot brake pedals. The plt said the battery was too low tostart the acft engine…NTSB MIA84LA182Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Lauderdale, FLPlt witnesses reported that the acft stalled during the final approach. The plt was not multi-end rated.NTSB MKC84FA164Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Satanta, KSAfter making a swath run, the plt initiated a turn-around in a downwind direction. During the turn, a wing dropped & the acft entered a descent & struck the ground, nose 1st. It then bounced & traveled another 53 ft before stopping & bursting into flames. The…NTSB CHI84LA236Accident · No injuriesLimited investigationFinal reportMaule M-4 · Middletown, OHPlt was attempting to make a 3 point stall landing when a gust of wind was encountered, resulting in a hard landing. Plt reported the wind was gusting to 20 KTS.NTSB LAX84FA337Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Barstow, CAThe flt had originated somewhere in Mexico & was being tracked by dea investigators until radar contact was lost. In the vicinity of amboy, CA an anonymous caller had contacted the highway patrol & reported a low flying acft near amboy with no visible…NTSB ANC84FA072Accident · No injuriesField investigationFinal reportPiper PA-28-235 · Egegik, AKThe acft crashed during a forced landing on unsuitable terrain. The plt said the acft engine lost oil-pressure about 20 minutes after takeoff and he turned toward the closest arpt. The engine operated a few minutes and then stopped. The acft was landed off…NTSB LAX84FA299Accident · Serious injuriesField investigationFinal reportCessna TR182 · Big Bear City, CAJust after takeoff, shortly after landing gear retraction, the eng backfired and experienced a total power loss. The plt lowered the landing gear and landed straight ahead just off the rwy. The acft bounced once and came to rest in a city park. It immediately…NTSB LAX84LA292Accident · No injuriesLimited investigationFinal reportCessna 182RG · Palo Alto, CAAcft touched down on the nose gear, porpoised and finally impacted the rwy on the nose gear.NTSB LAX84LA282Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Visalia, CAWhen the plt arrived at his destination, he was unable to fully extend the gear. He diverted to Visalia, CA. After reducing the fuel load, he made an intentional, power-off, wheels-up landing. An exam revealed that nose gear bellcrank assy had caught on the…NTSB CHI84LA171Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Marion, INThe student plt reported that during a landing, he reduced the power too soon & flared the acft too high, then the acft bounced about 8 to 10 ft in the air. The hard landing resulted in spar damage to the right wing.NTSB MKC84LA128Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Pocahontas, ARThe acft crashed after an engine failure during a swath run at an alt of 20 ft AGL. Examination of the engine revealed 3 dowel pins and 6 screws which hold the starter drive gear and the accessory drive gear had sheared. Metallurgical exam revealed that dowel…NTSB SEA84LA093Accident · No injuriesLimited investigationFinal reportPiper PA-25-235D · Heppner, ORThe plt reported that he was making a turn below the lee side of a ridge line at an alt of about 30 ft AGL. The acft reportedly encountered a downdraft & settled into the ground. During this occurrence, the landing gear collapsed, but no other major damage…NTSB MIA84LA144Accident · No injuriesLimited investigationFinal reportCessna TR182 · Daytona Beach, FLThe plt was unable to lower the landing gear and made a wheels-up landing. An exam revealed that a rod end, pn S02321-3, on the nose gear door had failed. The failure was in tension bending with no signs of preexisting fatigue or corrosion.NTSB CHI84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Morrow, OHAbout 10 min. After takeoff on an aerial application flt the acft's eng lost pwr. The plt made a forced landing in a corn field & during rollout collided with a tree. According to the plt, the acft's eng blew its right rear cylinder because its hold down…NTSB DEN84LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Ogden, UTThe plt got out of the acft to check the starter solenoid by turning the propeller. He left the mags on and the brakes off. When the prop was turned the acft started and collided with a parked acft.NTSB MKC84LA113Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Osage City, KSDuring an aborted takeoff, executed due to an inoperative airspeed indicator, the acft swerved off the left side of the rwy across a ditch, damaging the left wing & main landing gear. A clogged pilot tube was the cause of the airspeed indication of zero mph.…NTSB CHI84LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe pilot initiated flight into adverse wx conditions in order to pick up a heart attack victim. The pilot encountered fog & in an attempt to return to his departure point, collided with the frozen lake.NTSB MIA84LA114Accident · 4 fatalLimited investigationFinal reportPiper PA-28-235 · Sanibel Island, FLThe acft failed to arrive at its destination. A satellite photo of the area showed wx & cloud cover between the departure & destination arpts. Radar data showed that an acft had left key west, FL, at about 1700, went northbound at 4500 until it encounter bad…NTSB ANC84LA041Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Mcgrath, AKThe pilot told flight service personnel that the aircraft struck the ground while circling. His passenger was attemptingto photograph something on the ground.NTSB NYC84LA103Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A-8 · Tobyhanna, PAThe acft made a precautionary landing on a highway after both engines lost oil pressure. The plt feathered the right propeller because it gave abnormal indications before the left engine. The left engine was still operating at touchdown post accident…NTSB DEN84LA105Accident · No injuriesLimited investigationFinal reportCallair A · Tremonton, UTThe acft collided with a snow covered field while the plt was applying carbon black and fertilizer to induce snow melt. The overcast sky'gave a white-out effect on depth perception'. The collision with a rise in the field tore off the landing gear and the…NTSB MKC84FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Oconto, NEAfter attending a business conference at muncie, IN, the plt received a wx briefing & took off at 2026 CST on a flt to des moines, IA, where he refueled. In a phone call to his wife at their home in north platte, NE, he indicated the wx was such that he would…NTSB ATL84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Walterboro, SCThe plt did not get a green gear down indication when the landing gear was lowered. A fly-by was performed and he was told that the landing gear looked down. The plt did not properly operate the emergency system. During landing, the gear collapsed. The…NTSB SEA84FA058Accident · 3 fatalField investigationFinal reportPiper PA-28-J3A5D · Mountaindale, ORThe acft crashed during an instrument approach to hillsboro airport. Witnesses reported seeing the acft below a very low overcast sky condition prior to impact. Examination of the wreckage revealed that the stabilator failed in overload before the point of…NTSB NYC84LA095Accident · No injuriesLimited investigationFinal reportCessna 182RG · Teterboro, NJAccording to the plt after about an hour and 10 min flight he returned for landing. During the landing roll the acft skidded off the rwy onto soft dirt damaging the propeller and right wing tip.NTSB MIA84FA078Accident · Serious injuriesField investigationFinal reportHiller UH-12E · Waldo, FLThe acft was being used to dispense aerial incendiary devices (aids) to control forest burning. The aids were 1.25 inch diameter polystyrene balls containing potassium permanganate. They were injected with ethylene glycol prior to being dropped out of the…NTSB DEN84FA085Accident · 1 fatalField investigationFinal reportCessna TR182 · Tappen, NDThe private non-instrument rated plt received two weather briefings before the flight. During the last briefing at 1350 MST, he was informed that VFR flt was not recommended. At 1554 MST, the acft departed crystal arpt in a westerly direction. Several…NTSB ANC84LA034Accident · Serious injuriesLimited investigationFinal reportHelio H-250 · Iliamna, AKAccording to witnesses, the ski equipped acft took off toward the north. They reported that after taking off, the acft made a tight left turn, then spiraled to the ground. They estimated that the maximum alt was aprx 150 ft. also, they reported that the eng…NTSB FTW84LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Del Rio, TXDuring landing on a 4000 ft sod ranch strip the plt ran off the rwy into a raving and collapsed the landing gear. The plt said he landed in a crab and ran off the rwy. The owner on form 6120.1 stated that it was plt error, that the plt missed the rwy and ran…NTSB MKC84LA054Accident · No injuriesLimited investigationFinal reportCessna 182 · Marion, IAThe acft collided with a snowbank after swerving during takeoff. The swerve was started when the acft hit a windblown snowdrift which changed the acfts direction. After the collision the acfts nose gear collapsed and the left main gear retracted.NTSB LAX84FA118Accident · No injuriesField investigationFinal reportPiper PA28-235 · Irwindale, CAAccording to the flt instr the eng lost pwr after the stu had completd varous turning maneuvers. He stated that the fuel sel was in the left main position and estimated that there were 18 gals in that tank, 25 gals in the right tank,5 gals in the left tip…NTSB ATL84LA074Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Pennington Gap, VAEnroute at 7,000 ft MSL the acft started picking up heavy ice. The plt make a 180 deg turn & descended to 6,000 ft. he was able to see the ground through breaks in the clouds. Upon sighting lee county arpt the plt elected to make a precautionary landing.…NTSB MKC84LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Schuyler, NEWhile descending toward the planned destination, the eng began running rough & the plt attempted to improve the eng's performance by using carburetor heat. He made a localizer-only apch, but was unable to see the rwy at the min descent alt. A missed apch was…NTSB NYC84FA053Accident · 2 fatalField investigationFinal reportCessna R182 · Greenwich, CTThe acft collided with trees during an ILS approach to westchester arpt in NY. The weather was IMC and an IFR flt plan was filed. The accident occurred during the 2nd attempt with the 1st ending in a missed approach. It was apparent to thecontroller that the…NTSB LAX84FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Holtville, CAThe plt had departed mazatlan, Mexico at 0632 PST & had landed at los mochis & mexicali, Mexico & at calexico, CA, where he cleared U.S. Customs. Before departing calexico, he telephoned his family & told them the wx had been poor all day. The estimated time…NTSB CHI84LA048Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Norwalk, OHThe acft made a hard landing while on a cross-country flt. The plt stated that he encountered turbulence below 3000 ft MSL. During the he encountered wind shear which caused him to drop 40 ft onto the rwy. The acft manual states that 'in high wind conditions…NTSB LAX84LA067Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glendale, AZOn short final to a 2400 ft rwy the plt's father, who was in the rt ft seat and also a rated plt, asked 'you do realize this is a short rwy?' The son, who was the PIC, answered 'yes.' The acft touched down hard abt 1/3 of the way down the rwy, bounced up and…NTSB FTW84LA062Accident · No injuriesLimited investigationFinal reportCessna R182 · Houston, TXThe acft nosed down during a crosswind landing. The rwy is 100/280 degrees and the wind was 360 degrees at 19 KTS. Shortly after the landing touchdown the acft nose gear separated from the acft.NTSB NYC84FA024Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · West Seneca, NYThe acft was being repositioned by the owner from a maintenance facility at buffalo intl arpt to buffalo airpark. Maintenance personnel at both locations who had dealt with the owner indicated he had attempted to cut costs by performing unauthorized repairs…NTSB CHI84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Warsaw, INThe acft collapsed the landing gear during a forced landing following eng failure. The acft had been flown 5.5 hours before landing 3 miles NE of the intended refueling stop. The pilot had passed ft wayne at flt time of 5+ hours with about 10 gallons of fuel…NTSB LAX84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · New River, AZThe tow pilot reported that during a takeoff tow with both acft still on the ground, he started to drift right as a gust of wind caught him. The glider pilot decided to release. The tow acft then went 100 yards off the rwy and collided with a parked glider.…NTSB NYC84FFJ02Accident · No injuriesFinal reportPiper PA-25-235 · Williamson, NYThe right wing of N82526 struck a telephone pole guy wire while involved with applying agricultural chemicals.NTSB DEN84FA019Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Kim, COThe acft collided with the ground in a wing down nose low attitude. The plt had been advised that VFR flt was not recommended for his route of flt. The non-instrument rated plt went anyway and encountered weather. In maneuvering to get below or out of the…NTSB ATL83LA382Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9 · Andalusia, ALAfter spraying 2 fields, the plt was en route to spray a 3rd field when a severe vibration of the acft was encountered. He elected to land in the 1st available field & dumped his chemical load. During the landing, the acft hit a terrace & nosed over. The plt…NTSB MIA83LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Quebradillas, PROn 9/4/83, the plt took off from arecibo, PR on a flt of aprx 26 mi to aguadilla, PR. While en route, the eng lost power from fuel exhaustion & the plt made a successful forced landing on a farm at Quebradillas, PR. The acft was refueled, but during takeoff…NTSB ATL83LA360Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Pinehurst, GAThe plt stated that all three shock cords on the left main landing gear broke during the landing roll allowing the gear to collapse. The acft veered off the rwy & crossed a drainage ditch, at which time all three shock cords on the right main landing gear…