NTSB investigations: Lycoming 0-540 series
83 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “In flight collision with object”. 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 MKC88DCA02Accident · Serious injuriesFinal reportCallair A-9A · Rush Hill, MOAbout 25 minutes after sunset, the airplane struck a powerline and pole during a spray run. The airplane struck the ground inverted.NTSB CHI88DER04Accident · No injuriesFinal reportPiper PA-25 · Elbow Lake, MNThe pilot was practicing low level flight in preparation for his certification under 14 CFR 137 when the aircraft experienced a collision with wires. The aircraft was substantially damaged during this collision and the subsequent collision with trees and the…NTSB LAX88DVA05Accident · No injuriesFinal reportHiller 12E · Firebaugh, CADuring an aerial application, the helicopter collided with a guy wire and then a field. The pilot knew that the wire was there. He stated that he simply forgot that it was there and did not see it. There were no mechanical problems prior to the accident.NTSB LAX88LA111Accident · Serious injuriesLimited investigationFinal reportCessna R182 · San Andreas, CADuring a night flight the plt attempted to land on a 3600-FT-long rwy. He misjudged his altitude, touched down long & attempted to go-around. The acft became airborne & upon passing the airport's boundary it collided with a fence & crashed. The plt did not…NTSB DEN87LA190Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Fargo, NDThe plt was spraying a field with orthine, used to exterminate grasshoppers. The plt said he was making his last pass at the field and was flying into a setting sun. He said he did not see the powerline. The acft struck the powerline and the plt made a crash…NTSB DEN87LA105Accident · No injuriesLimited investigationFinal reportCessna TR182 · Santa Rosa, NMAn a & p acft mechanic who additionally was a commercial plt was operating a borrowed acft on a local flt. He landed on an island in a lake and shut down. Later, when airborne on takeoff, the right elevator struck a small tree and the acft yawed right. The…NTSB ATL87LA095Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Bainbridge, GAThe acft collided with trees while conducting an ag training flight. The training program was part of the locust control in central and southern africa. There was an instructor on the ground who acted as a radio controller for the flight. The pilot failed to…NTSB FTW87FA025Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Baytown, TXThe plt took off from a decommissioned, unlighted arpt at night after telling friends in a bar that he was going to new orleans. Later, witnesses observed the acft as the plt made several low passes over an interstate highway near the departure arpt. While…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 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 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 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 DEN85LA159Accident · No injuriesLimited investigationFinal reportPiper PA-25-235-B · Lovington, NMThe plt attempted to take off to the east from a 1000-foot mowed alfalfa field at a field elevation of 3700 ft MSL. The plt estimated the winds to be from the southeast at 8 mph. The density altitude was computed to be between 6578 and 6871 ft MSL. According…NTSB DEN85LA146Accident · No injuriesLimited investigationFinal reportPiper PA-25-260-C · Ordway, COThe airplane departed the airport on an aerial application operation. Immediately after takeoff the pilot retarded the propeller control to climb setting and turned east. The pilot said he was aware of and saw power lines ahead. He said he advanced the…NTSB MKC85FCA02Accident · Serious injuriesFinal reportPiper PA-25-235 · Dexter, MOThe plt was making a swath run while on an aerial application training flt. During a pull-up at the end of the swath run, the rgt wing struck the tops of 3 willow trees. The acft then entered a rgt roll, struck an eletrical power line, rolled inverted &…NTSB ANC85LA019Accident · No injuriesLimited investigationFinal reportHelio H-250 · Anchorage, AKThe plt stated during two telephone interviews that he hit trees during takeoff and then continued his two hour flt to to the homer arpt. The left wing was damaged and both left and right sides of the horizontal stabilizer were crushed andbent up about 19…NTSB MKC84LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Arapahoe, NEWhile on a swath run to apply insecticide, the acft collided with electrical transmission lines that were crossing the field. After the initial impact, the acft angled to the left & hit another transmission line, then impacted the ground.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 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 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 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 CHI83LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Baroda, MIThe acft collided with wires during a spraying operation. During the forced landing following the wire strike the acft nosed over. The pilot said chemical spill from powerline strike obscured his vision through windshield and made the forced landing…NTSB CHI83LA342Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Camp Point, ILThe plt had just completed a swath run. As he approached a road he pulled up to avoid a car, then attempted to descend below power lines & in so doing collided with a stop sign. The acft cartwheeled & landed inverted in a bean field.NTSB MKC83LA129Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Puxico, MOThe plt stated that while trimming a rice field he was watching his drift & when he looked forward he saw the transmission line but was too close to avoid the lines.NTSB CHI83LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Roseau, MNDuring an aerial application flt, the acft collided with power lines during a pull-up from a swath run. The plt reported no preimpact malfunctions.NTSB FTW83LA113Accident · No injuriesLimited investigationFinal reportCessna R182 · George West, TXThe plt reported that after he touched down on a wet grass runway, he was unable to stop, so he elected to go around. During the go-around, the gear collided with a fence, and subsequently, the acft crashed into trees and a building.NTSB ATL83LA057Accident · No injuriesLimited investigationFinal reportCessna 182B · Huntsville, ALThe aircraft collided with trees during a landing approach in instrument meeorological conditions on a dark night. A VFR flight plan was filed. The aircraft was damaged in the collision but the pilot managed to continue the approach and land. No injuries were…NTSB FTW83LA042Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waco, TXDuring the second swath run the pilot struck a power wire located in a tree line. The aircraft crashed in a OAT field and was destroyed by ground fire.NTSB SEA83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Vernonia, ORThe acft was observed high & fast during the approach & touched down about 300 ft from the departure end of the turf rwy. During the go-around the acft struck a wood fence, crossed a road & crashed in a "stumped off" area.NTSB ATL82FLJ08Accident · Serious injuriesFinal reportPiper PA-25-260 · Scotland Neck, NCDuring the fourth swath run the acft struck a 60-foot tree approximately 5 ft from the top.NTSB MKC82IA138Incident · Minor injuriesIncident investigationFinal reportPiper PA-25-235 · Wilsonville, NEThe pilot stated that he was overcome by exposure to the organic phosphate he was deploying. According to local law enforcement authorities, the aircraft crashed in a field and came to rest inverted. Medical tests for toxic chemical exposure were inconclusive.NTSB ATL82DA062Accident · 1 fatalFinal reportPiper PA-25-235 · Griffin, GAThe pilot was hired to perform for the filming of an agricultural spraying operation. During one of the low passes the aircraft struck two of the ground crew. The cameraman received fatal injuries. Pieces of the wooden propeller, used to drive the spray pump,…NTSB MIA82DA032Accident · Serious injuriesFinal reportPiper PA-23-250 · Okeechobee, FLThe aircraft owner and a friend were taken to a hospital emergency room with serious injuries at about 2115 local time. They stated that they had been attacked and robbed while hitch-hiking. On the next morning, the owner's aircraft was found where it had…