NTSB investigations: Lycoming IO-540 series
69 cases on aircraft whose registry engine model is Lycoming IO-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 ('41530', '41585')
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 ('41530', '41585')
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 FTW86FPA18Accident · 1 fatalFinal reportEagle Eagle DW-1 · Howe, TXThe acft appeared to stall during a sharp pull-up and turn during a test flt after a low pass over the airstrip. The plt was testing the spray equipment and made the low pass so the ground observer could see the spray pattern. No malfunctions in equipment…NTSB MIA86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Melbourne, FLThe plt stated that on his landing rollout he lost control of the acft & veered off the left side of rwy 9L collapsing the nose gear.NTSB FTW85LRG02Accident · No injuriesFinal reportHomebuilt Tiger Bird · Kerrville, TXThe acft nosed over on landing following a loss of directional control. The plt reported touchdown was made on the first 100 ft of the rwy and as the acft slowed to aprx 10 mph directional control was lost. The acft traveled off the left side of the airstrip…NTSB MKC85LA200Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Fredericktown, MOThe plt reports that he lost directional control during the landing roll. The acft swerved off the side of the rwy, down an embankment and collided with a fence. The landing and brake system were examined by a mechanic after the accident and no evidence of a…NTSB SEA85LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fish Lake Valle, NVDuring landing roll the acft veered sharply to the left and struck an irrigation sprinkling system. The operator discovered that the valve stem to the tire had broken and the plt had landed with a flat tire.NTSB LAX85LA133Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Big Bear, CAAfter spending the day skiing, the plt & passengers planned to depart on a return flt to san diego. The wind was from 210 to 220 deg at about 10 mph. The plt elected to takeoff on rwy 7 since low clouds were approaching from the west & the visibility was near…NTSB CHI85LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Wheeling, ILThe low time pilot with six POB was ld at dark night light saw showers and icy patches on runway during rollout the acft entered a skid with nose cocked to the left the left main gear failed outboard and the acft exited the left side of the rwy the left wing…NTSB MIA85LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Cross City, FLPlt stated that after touchdown as braking was initiated the acft began to pull to the left. Right brake was applied with no correcting effect. The acft ran off the left side of the runway and the landing gear collapsed. Post crash exam of brakes revealed no…NTSB ANC85LA013Accident · No injuriesLimited investigationFinal reportMaule M-6 · Homer, AKShortly after touchdown the acft veered left. Right rudder was applied causing the acft to over correct back to the right. In an effort to regain directional control left rudder was applied. The acft ground looped to the right collapsing the left main landing…NTSB SEA84LA226Accident · No injuriesLimited investigationFinal reportMaule M6 · Driggs, IDAfter landing long and fast brakes were applied, directional control was lost and the acft ground looped off of the rwy. The acft collided with and came to rest in a ditch.NTSB FTW84LA200Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · New Orleans, LAShortly after touchdown on a x-wind landing, the tailwheel equipped acft began to weathervaned to the left into the wind. The plt lost directional control & the acft ground looped to the left. The right gear collapsed & the right wing dragged on the ground.…NTSB NYC84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-600 · Newark, NJThe acft was on landing roll when it began to veer from the rwy. The plt attempted to maintain directional control but the acft left the rwy and collided with a taxiway marker sign causing substantial damage to the acft. Shortly thereafter, the right main…NTSB MKC84LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Kearney, NEDuring the landing roll, the plt held the nosewheel off while slowing down, and used right rudder to compensate for a reported x-wind condition. As soon as the nosewheel touched down, the acft veered to the right. It went off the right side of the rwy, the…NTSB ATL84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Sewanee, TNThe acft collided with trees during landing roll. The plt has recounted several variations of the accident from locked brakes (parking) to a flat left tire with full right rudder to maintain directional control. There was a left tire skid mark from touchdown…NTSB SEA83LA138Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Bliss, IDAccording to the plt, he was returning to a road to land & reload chemicals for aerial application. He stated that the right main tire went flat during flt due to a puncture. During the landing roll-out, the acft veered to the right & nosed over.NTSB ATL83LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Leonardtown, MDPilot did not maintain alignment during takeoff and collided with a pile driver. The aircraft was then landed gear up inan adjacent field. The wind was calm and there was no known reason for failure to maintain runway alignment.NTSB CHI82DA068Accident · No injuriesFinal reportPiper PA-60 · Cleveland, OHDuring takeoff roll from a dry runway the pilot reported the aircraft started veering to the left. The pilot attempted to straighten the aircraft with power & brakes to no avail then pushed in throttle in an attempt to fly out. The aircraft departed the…NTSB MKC82DA020Accident · No injuriesFinal reportPiper PA-32-300 · Topeka, KSThe pilot was practicing crosswind landings on runway 35. The wind was from 290 degrees at 15 gusting 23 knots. During a landing flare, a gust of wind was encountered. The plane skidded and departed the runway. The nose gear struck an ice bank and collapsed.NTSB NYC82DA018Accident · No injuriesFinal reportMaule M-5-235C · White Plains, NYAfter returning from a short local flight, the pilot landed in light and variable wind conditions. During landing, the aircraft bounced and ground looped. The left main gear failed and the left wing and propeller were damaged.