NTSB investigations: Lycoming VO-540 series, CA
95 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND 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 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 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 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 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 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 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 LAX82FVG10Accident · No injuriesClosedHiller Acft UH-12E · Angels Camp, CANTSB LAX82DVA05Accident · No injuriesClosedBell 47G-4A · Wasco, CANTSB LAX81FVD43Accident · Minor injuriesClosedHiller Acft UH-12E · Brentwood, CANTSB LAX81DVA51Accident · No injuriesClosedHiller Acft UH-12E · Delano, CANTSB LAX81DVM24Accident · No injuriesClosedHiller Acft UH-12E · Shandon, CANTSB LAX81FVA28Accident · No injuriesClosedHiller Acft UH12E · Huron, CANTSB LAX80FVA56Accident · No injuriesClosedHiller Acft UH-12E · Farmersville, CANTSB LAX80FVA03Accident · Serious injuriesClosedHiller UH-12E · Mendota, CANTSB LAX79FA081Accident · 5 fatalClosedBell 47J-2 · Long Beach, CANTSB LAX79DVA42Accident · Minor injuriesClosedHiller UH-12E · Porterville, CANTSB OAK79FVG29Accident · Minor injuriesClosedHiller UH-12 · Weaverville, CANTSB OAK79DVA11Accident · No injuriesClosedHiller UH-12E · Ivanhoe, CANTSB OAK78DVA82Accident · No injuriesClosedHiller UH12E · Tuolumne, CANTSB LAX78FUG44Accident · No injuriesClosedHiller UH-12E · Blythe, CANTSB LAX78FUG39Accident · Minor injuriesClosedHiller Acft UH-12E · Redlands, CANTSB OAK78FVG33Accident · Minor injuriesClosedHiller Acft UH-12E · Oroville, CANTSB LAX78FA008Accident · 2 fatalClosedBell 47J-2 · Burbank, CANTSB OAK78FVA03Accident · No injuriesClosedHiller UH-12E · Los Banos, CANTSB LAX77FUG53Accident · No injuriesClosedHiller Acft UH-12E · Blythe, CANTSB OAK77DVW25Accident · No injuriesClosedHiller 12SL4 · Bishop, CANTSB OAK75DVA70Accident · No injuriesClosedHiller Acft UH-12E · Merced, CANTSB LAX75AUM24Accident · No injuriesClosedHiller Acft UH-12E · Seeley, CANTSB LAX74FUM09Accident · No injuriesClosedHiller Acft UH-12E · El Centro, CANTSB OAK73DVG28Accident · No injuriesClosedHiller UH12L4 · San Andreas, CANTSB LAX73FUA12Accident · No injuriesClosedBell 47J-2 · Huntgtn Bch, CANTSB LAX72FUA02Accident · No injuriesClosedBell 47J-2 · Hntngtn Bch, CANTSB LAX71FVQ74Accident · Minor injuriesClosedBell 47J2 · Sta Barbara, CANTSB LAX70DUA17Accident · No injuriesClosedBell 47J-2 · Long Beach, CANTSB LAX70A0031Accident · No injuriesClosedBell 47J · Goleta, CANTSB LAX69D0359Accident · No injuriesClosedHiller UH-12L · Victorville, CANTSB LAX69A0011Accident · No injuriesClosedBell 47J-2 · Los Angeles, CANTSB OAK69F0075Accident · Serious injuriesClosedHiller UH-12E · Greenville, CANTSB LAX68A0067Accident · Serious injuriesClosedHiller UH12L4 · Cucamonga, CANTSB LAX67A0051Accident · No injuriesClosedHiller UH12L4 · Castaic, CANTSB LAX67A0020Accident · No injuriesClosedHiller US-12E · Frazier Prk, CANTSB LAX66A0040Accident · No injuriesClosedHiller UH-12E · Brawley, CANTSB OAK66A0007Accident · No injuriesClosedHuller UH12E · Honeydew, CANTSB OAK65A0074Accident · No injuriesClosedHiller UH-12E · Mammoth Lakes, CA