NTSB investigations: Lycoming VO-540 series
376 cases on aircraft whose registry engine model is Lycoming VO-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 ('41534', '41582'))
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 ('41534', '41582'))
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 LAX84LA010Accident · No injuriesLimited investigationFinal reportHiller UH12E · Los Banos, CAThe plt loaded the helicopter & started a spraying operation. He stated that as he pulled the helicopter up from the 1st spray run, it started shaking & went partially out of control. He was able to regain enough control to get the helicopter in level flt…NTSB LAX83FA462Accident · No injuriesField investigationFinal reportBell 47G-4G · Lodi, CADuring takeoff, the helicopter lost power after climbing aprx 20 ft. the plt made an autorotative landing, but after touchdown, the helicopter slid down a river bank, rolled over & began burning. The fuel tanks did not rupture & still contained fuel. When…NTSB ATL83LA379Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Wise, VAThe plt held a commercial certificate, but was a student in helicopter flying. He had over 15,000 hrs total time in airplanes, but only aprx 13 hrs of experience in helicopters. On his 1st solo flt in a helicopter, he was making approaches to a grassy area…NTSB ATL83LA355Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cameron, SCThe plt stated that he was on a trimming/swath run at about 15 ft AGL & 15 mph when he heard a strange noise which was followed by a 180 deg yaw. Subsequently, the helicopter crash landed, damaging the tail boom & tail rotor blades and spreading the landing…NTSB LAX83LUQ04Accident · No injuriesFinal reportHiller UH 12-E · Lancaster, CAAccording to the pilot, after spraying an onion field he was departing for the next job when he noted an increase in engine RPM and a decrease in rotor RPM. Unable to maintain altitude, he made an emergency landing aprx 200 feet AGL. Prior to landing, the…NTSB CHI83LA292Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Wheeler, ILThe plt reported that while he was returning for another load of chemicals, the eng missed a couple of times, then smoothed out for about 1 min. After that, the eng missed again, then quit while the helicopter was at aprx 150 ft AGL. The plt chose to clear…NTSB LAX83LA236Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Thermal, CAThe plt reported that he was aprx 1/3 of the way thru a procedure turn at about 60 ft AGL, when he experienced a partial power loss. He completed the turn, leveled the helicopter & moumentarily regained complete power, then the engine quit operating. An…NTSB ATL83LA160Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Charleston, WVDuring an approach to land, the engine lost power at aprx 500 ft AGL. The plt reported that during an autorotative landing, he had to maneuver to avoid trees & a ridge in order to land in a suitable area. During this time, rotor RPM dropped & a crash landing…NTSB LAX83LA181Accident · No injuriesLimited investigationFinal reportHiller UH12-E · Kettleman City, CAThe pilot reported that he began flying about 0725 with 23 gallons of fuel on board. He applied a herbicide for about an hour and came back to reload. After reloading he began a return to the area to be sprayed. About 10 minutes later all power was lost.…NTSB LAX83FA087Accident · Minor injuriesField investigationFinal reportBell 47G4 · Five Points, CAThe pilot was on his final pass of the operation. He flew under 2 sets of wires but failed to see a third set. The spray boom caught on the the wire pitching the helicopter nose down. The main rotor hit the tail boom and the helicoptercrashed into a canal.NTSB MIA82DA181Accident · Minor injuriesFinal reportBell 47G4 · Madison, FLThe eng did not respond when power was added beginning a swath run. The plt hit the dump button to jettison the load & collided with the ground. Eng teardown revealed no evidence of failure or malfunction prior to the accident.NTSB LAX82DA306Accident · No injuriesFinal reportHiller UH-12E · Chandler, AZThe pilot was spraying liquid chemicals at night. The pilot flew into his own wake turbulence and lost control and collided with the ground. Control was regained to make an upright landing in the field. Skids were torn off the aircraft.NTSB MKC82DA135Accident · No injuriesFinal reportBell 47J-2 · Chesterfield, MOThe pilot stated that he took off and was going through translational lift at about 15 to 20 ft AGL when he heard a loud bang. He said the loud bang was accompanied by a power loss. An immediate descent was made and the helicopter was landed hard with a…NTSB ATL82DA214Accident · No injuriesFinal reportHiller UH-12E · Centre, ALWhile returning from a spraying operation, the pilot was flying low toward the rising sun when the helicopter collided with power lines. An autorotation was initiated, but the skids collapsed during the landing.NTSB LAX82FA245Accident · No injuriesField investigationFinal reportHiller UH-12L3 · Stockton, CAThe pilot reported that the engine lost power at about 5 ft AGL as he was taking off from a trailer. He turned to avoid a gas and water tank near the poll truck. The helicopter came to rest, right-side-up, but was damaged. A fuel leak was found in a line that…NTSB MIA82DA133Accident · No injuriesFinal reportBell 47G-4 · N. Greenville, FLThe pilot took off at about 1922 to dispense a non-toxic liquid chemical and fertilizer on a nearby melon field. After one normal swath run on a northerly heading, he pulled up and began a procedure turn to the left (west). He stated the afternoon sun…NTSB MIA82DA125Accident · No injuriesFinal reportBell 47J-2A · Marathon, FLThe pilot reported that an intermittent vibration was felt during the magneto check before takeoff. During a second magneto check at high power, the nose of the helicopter came up, a loud explosive noise was heard, and a fire erupted near the left fuel tank.…NTSB LAX82DVA14Accident · Serious injuriesFinal reportHiller UH-12E · Chowchilla, CAThe pilot was conducting an aerial dusting operation over a grape vineyard. While on a swath run, he gradually converged on a powerline that crossed the field at a slight angle from his flight path. As he proceeded on his swath run, the helicopter got closer…NTSB ATL82DA073Accident · No injuriesFinal reportHiller UH12E · Lydia, SCThe pilot was applying liquid fertilizer on his last swath run prior to reloading when the engine stopped. A run-on landing was attempted during which the skids sank into the soft ground causing the helicopter to roll over. The field was level and covered…NTSB LAX82FVG10Accident · No injuriesClosedHiller Acft UH-12E · Angels Camp, CANTSB FTW82DRG16Accident · No injuriesClosedBell 47G-4A · Encinal, TXNTSB FTW82DRG07Accident · No injuriesClosedBell 47G-4A · Telegraph, TXNTSB LAX81DJA01Accident · No injuriesClosedHiller Acft UH-12E · Kahului Maui, HINTSB LAX82DVA05Accident · No injuriesClosedBell 47G-4A · Wasco, CANTSB LAX81FVD43Accident · Minor injuriesClosedHiller Acft UH-12E · Brentwood, CANTSB LAX81DVA51Accident · No injuriesClosedHiller Acft UH-12E · Delano, CANTSB ATL81DA085Accident · No injuriesClosedBell 47G-4 · Jackson, MSNTSB FTW81FPG50Accident · No injuriesClosedHiller Acft UH-12E · Warren, ARNTSB LAX81DVM24Accident · No injuriesClosedHiller Acft UH-12E · Shandon, CANTSB MKC81FCG36Accident · No injuriesClosedBell 47J-2 · Branson, MONTSB LAX81FJA10Accident · No injuriesClosedHiller Acft UH-12E · Lahaina, HINTSB SEA81FA035Accident · 2 fatalClosedBell 47G-4A · Aberdeen, WANTSB LAX81FVA28Accident · No injuriesClosedHiller Acft UH12E · Huron, CANTSB DEN81DTG03Accident · No injuriesClosedHiller Acft UH-12E · Watford City, NDNTSB ANC80DAD10Accident · No injuriesClosedHiller Acft UH-12E · Petersburg, AKNTSB CHI80FEX31Accident · No injuriesClosedHiller Acft UH-12E · Milan, INNTSB DEN80DTC28Accident · No injuriesClosedHiller UH-12E · Greybull, WYNTSB CHI80FEX29Accident · No injuriesClosedHiller Acft UH-12E · Elrod, INNTSB LAX80DUJ91Accident · No injuriesClosedHiller Acft UH-12E · Sommerton, AZNTSB LAX80FVA56Accident · No injuriesClosedHiller Acft UH-12E · Farmersville, CANTSB ATL80FIJ02Accident · No injuriesClosedHiller Acft UH-12E · Oak Hill, WVNTSB LAX80FVA03Accident · Serious injuriesClosedHiller UH-12E · Mendota, CANTSB LAX79FA081Accident · 5 fatalClosedBell 47J-2 · Long Beach, CANTSB FTW79FRD52Accident · No injuriesClosedBell 47G-4A · Hackberry, LANTSB FTW79FRG52Accident · No injuriesClosedBell 47G-4A · Alice, TXNTSB FTW79FRD50Accident · No injuriesClosedBell 47G-4A · Lafayette, LANTSB FTW79FRA34Accident · No injuriesClosedBell 47G-4 · Manvel, TXNTSB FTW79FPJ26Accident · Minor injuriesClosedHiller UH12L4 · Elk City, OKNTSB MIA79FKJ42Accident · Serious injuriesClosedHiller UH-12E · Verbena, ALNTSB LAX79DVA42Accident · Minor injuriesClosedHiller UH-12E · Porterville, CA