NTSB investigations: Lycoming 0-540 series
84 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the first occurrence was “Loss of control - on ground/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\" = 260))
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" = 260))
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 SEA89LA168Accident · No injuriesLimited investigationFinal reportCessna R182 · Jordan Valley, ORFailure of the pilot to maintain directional control. Factors related to the accident were: the pilot's selection of unsuitable terrain (closed/rough runway), and the crosswind.NTSB LAX89LA122Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Fullerton, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB NYC88LA115Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Walton, NYThe pilot decided to land on a sod strip. He bounced once, then lowered the nose to keep it on the ground. The prop dug into the ground and the aircraft flipped over. The pilot reported that he was practicing manuevers and wanted to practice a sod landing.NTSB NYC88LA110Accident · No injuriesLimited investigationFinal reportCessna 182RG · Princeton, NJDuring landing at Princeton, new jersey, the flight encountered turbulence in the last 500 feet before reaching the runway. The pilot initiated a go around and came in with 10 degree flaps. Aircraft touched down and rolled a few feet then lifted off again…NTSB LAX88LA106Accident · No injuriesLimited investigationFinal reportCessna TR182 · Truckee, CANTSB DEN87LA160Accident · No injuriesLimited investigationFinal reportCessna 182RG · Deming, NMDuring the landing flare the plt reported he flared late and the acft bounced and porpoised. The plt commented and the plt rated passenger in the right seat misinterpreted the comment as a request for assistance. With two people conflicting on the controls a…NTSB NYC87LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-20 · Allaire, NJDuring landing roll, the pilot lost directional control. The aircraft veered off the runway to the left, collided with a tree and was substantially damaged.NTSB LAX87LA081Accident · No injuriesLimited investigationFinal reportCessna T182 · Big Bear City, CAThe plt rprtd that when the nose wheel touched down during the landing, a severe vibration began & the acft veered to the left. She said she pulled the yoke aft, but this had no response. Also, she said she applied brakes, but could not stop the acft or make…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 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 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 CHI85LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Valparaiso, INAcft contacted a ditch following a loss of directional control during landing roll. Plt reported, 'more experience in handling crosswinds' could have prevented the accident.NTSB ATL85LA156Accident · No injuriesLimited investigationFinal reportPiper PA-25-260C · Ashburn, GAThe plt was on a flt to clean the spray boom by flying down the center of the airstrip & dispensing a cleaning substance thru the spray boom. He made one pass down the strip, then entered a pull-up to the right. He stated that he then turned back to the left…NTSB ATL85LA149Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Ravenswood, WVDuring ldg roll the std plt lost directional control of the acft & ran off of the side of the rwy while practicing touch & go ldg with CFI.the CFI stated that the std made a normal approach & upon touchdown the acft made a sharp turn to the right and went off…NTSB CHI85LA122Accident · No injuriesLimited investigationFinal reportCessna 182RG · Mundelein, ILThe plt of this acft did not know the rwy surface condition prior to an attmpted landing. UNICOM advisories were not available. Due to a recent storm, six to twelve inches of wet snow overlying a patchy layer of compacted snow existed when he touched down.…NTSB MIA85LA094Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ft.Lauderdale, FLThe acft landed with a x-wind component of about 25 KTS from the right. The plt and witnesses stated the wind lifted the right wing of off the rwy. Side forces resulted in the left main landing gear collapsing. Maximum demonstrated takeoff and landing x-wind…NTSB FTW85LA099Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Addison, TXThe plt stated that on touchdown, the acft veered left & went off the edge of the 30' wide rwy. The nose gear then collapsed in soft terrain before the plt could get the acft back on the rwy surface. At 1900 CST, the wind was from 360 deg at 30 gusting 40 KTS.NTSB ANC84LA121Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Anchorage, AKThe pilot lost control during landing, the acft ground looped and both main landing gear collapsed.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 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 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 FTW83LA307Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Franklinton, LAThe acft slid into a tree during a landing on a wet rwy. The plt had encountered the rain shortly after takeoff and returned to the arpt. The private strip had become soft from the rain and the plt lost control of the acft. The acft veered off the strip and…NTSB FTW83LA284Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Abilene, TXThe agricultural acft collided with a pole during an aborted takeoff after directional control was lost. The plt stated that a soft spot in the rwy caused the acft to veer left. The takeoff was aborted but the acft continued off the rwy andcollided with the…NTSB DEN83LA130Accident · No injuriesLimited investigationFinal reportCessna TR182 · Cando, NDAfter returning to the arpt, the plt landed on rwy 30 with a right x-wind at about 16, gusting 23 KTS. Reportedly, the grass was aprx 1 ft tall on the rwy & the landing area sloped downward to the west. After touchdown, the plt maintained control of the acft…NTSB MKC83LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Kaiser, MOThe acft sustained substantial damage when the nose gear collapsed during landing. The weather was VMC but the pilot said he encountered a gusty crosswind during landing. He had checked the wind sock prior to landing and it was hanging limp. The reported wind…NTSB NYC83LA084Accident · No injuriesLimited investigationFinal reportCessna 182 · Batavia, NYThe pilot had trouble with maintaining heading during the entire flight due to malfunction of the rudder trim. During landing, directional control was lost and the acft left the runway and collided with trees. An inspection of the rudder sys revealed…NTSB LAX83LA106Accident · No injuriesLimited investigationFinal reportCessna 182RG · Marble Canyon, AZDuring the landing the pilot lost control of the aircraft in a gusty wind. The aircraft left the runway and nosed over. In soft terrain. He blamed his slow reaction and inexperience for the accident. The wind was from 300 degrees at 11 KTS gusting to 18 KTS.NTSB MKC82DA127Accident · No injuriesFinal reportPiper PA-28-235D · Falls City, NEThe pilot reported that while he was landing with a 6 to 7 kt crosswind, the plane was blown toward the left side of the runway. In order to avoid the runway lights, he intentionally maneuvered the aircraft off the side of the runway, into the grass. When he…NTSB FTW82DA162Accident · Minor injuriesFinal reportPiper PA-25-235 · Lubbock, TXPrior to the flight, the aircraft had been serviced in preparation for the beginning of the spraying season. As part of the servicing, the operator/pilot added hydraulic fluid to the left brake. However, he did not purge the system of air after adding the…NTSB CHI82DA122Accident · Minor injuriesFinal reportPiper PA-28-235 · Graytown, OHDuring landing roll the aircraft contacted a soft area on the pilot's privately owned sod runway. The nose gear collapsed and the aircraft came to rest with the tail in the air.NTSB CHI82DA092Accident · Minor injuriesFinal reportPiper PA-24-250 · Columbus, OHWhile performing a touch and go landing on runway 27R, the aircraft veered off the runway to the right and struck a drainage ditch. The pilot reported that the wind was from 350 degrees at 15 knots. Runway 32, an asphalt runway with a length of 3040 ft and a…NTSB CHI82DA087Accident · No injuriesFinal reportCessna 182 · Lake Village, INThe pilot reported that the wind was from the west at 25, gusting 40 knots. During landing on runway 36, he touched down long and then attempted to go-around. At the north end of the field, the aircraft encountered soft, soggy terrain, the pilot lost…NTSB FTW82DA115Accident · No injuriesFinal reportPiper PA-25-235C · Big Spring, TXThe pilot reported that he had been practicing crosswind landings in winds that were gusting to 25 knots. On the last landing, he used flaps. He reported that he had landed and was taxiing on the runway when a gust of wind raised the right wing. The left wing…NTSB LAX82DA059Accident · No injuriesFinal reportCessna TR182 · Las Vegas, NVThe pilot stated that on landing after the second bounce the plane veered left and ran off the runway on to the desert and flipped over.