NTSB investigations: Lycoming 0-540 series
74 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “In flight collision with terrain/water”. 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\" = 230))
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" = 230))
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 ANC88FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Skwentna, AKThe on-demand air taxi flight with the pilot and two passengers struck the rock face of a mountain at the 8600 foot level. According to witnesses at the time of the accident the weather conditions were poor and visibility was less than one-half mile. The…NTSB DEN88LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe private plt and two passengers were conducting a personal night flight. During landing, the aircraft drifted left and the left main gear struck a snow drift. The plt elected to go around and on the second approach at touchdown, the aircraft skidded left…NTSB MIA87LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kissimmee, FLThe plt failed to lower the landing gear prior to touchdown. Insp of the acft revealed that the landing gear warning horn & gear down & locked light were inoperative.NTSB MIA87LA026Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLWhile being followed at a low altitude by a united states customs service aircraft, the aircraft was observed entering a left turn. The left wing tip of the aircraft struck the water and it cartwheeled. After the crash, bales of an unknown substance floated…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 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 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 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 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 LAX85FA216Accident · 1 fatalField investigationFinal reportPiper PA25-235 · Walnut Grove, CAThe acft flew into the ground on a procedure turnaround while spraying wheat with a toxic chemical. The acft did not stall and the engine sound did not change. A separated aileron crossover cable showed no fatigue. The cholinesterase level in the pilot's…NTSB ATL85LA033Accident · No injuriesLimited investigationFinal reportCessna 182RG · Charleston, SCPilot landed the aircraft with the landing gear in the up position. Examination of the landing gear after the accident revealed no evidence of mechanical malfunction or failure that would have prevented normal gear operation.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 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 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 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 DEN83FA180Accident · 4 fatalField investigationFinal reportPiper PA-28-235C · Pitkin, COThe acft was on a x-country flt from camarillo, CA to oshkosh, WI. The plt landed at about noon at montrose, CO, where the acft was refueled & the occupants went to a restaurant to eat. After departing montrose, the acft was seen flying low over rising,…NTSB FTW83FA261Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Omega, OKThe plt had just completed spraying a field & was in a right turn when the right wing tip hit gently rising terrain. The owner thought that the plt might have diverted his attention while looking at a farmer's map to locate the next field. (Several similar…NTSB ATL83IA070Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Moultrie, GAThe pilot was making a refueling stop in Moultrie, GA when the aircraft touched down on runway 14 at spence field with the landing gear in the up position. The pilot does not recall what events led to the wheels up landing. On exiting the aircraft, he noted…NTSB LAX82FA260Accident · 5 fatalField investigationFinal reportCessna TR182 · Happy Camp, CAThe aircraft impacted the side of a narrow and steep canyon in a climb attitude. The weather was VFR. The crash occurrednorthwest of the departure point after about 1 hour and 15 minutes of flight. No flight plan was filed, destination was not determined.NTSB MIA82DA150Accident · No injuriesFinal reportPiper PA-24 · Clearwater, FLDuring the approach to the airport, the pilot was distracted by other aircraft and failed to extend the gear. The propeller and lower surface of the aircraft were damaged during a gear up landing.NTSB ATL82DA171Accident · Minor injuriesFinal reportPiper PA-25-235 · Ripley, INWhen the pilot arrived to spray the field for the first time, he saw powerlines along a road and saw poles on both sides of a creek. He assumed that all of the lines followed the road. He was unaware that a powerline crossed the narrow field that he was about…NTSB DEN82FTA10Accident · Serious injuriesFinal reportPiper PA-25-235 · Glendive, MTThe pilot reported that he had just loaded the sprayer and had made one pass downhill. At the end of the field, he started a left turn to make an uphill pass. The pilot stated that he got into bad air or down slope air and started to dump the chemical but it…NTSB MIA82DA094Accident · No injuriesFinal reportPiper PA-23-250 · Jacksonville, FLImmediately after raising the gear handle during takeoff, the pilot heard a loud noise that he thought was an explosion. He aborted the takeoff and landed on the remaining runway without extending the gear. The loud noise occurred when the cabin door popped…