NTSB investigations: Lycoming VO-435 series, CA
130 cases on aircraft whose registry engine model is Lycoming VO-435 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 ('41525'))
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 ('41525'))
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 LAX84LA424Accident · No injuriesLimited investigationFinal reportBell 47G-5A · Winterhaven, CAThe acft collided with the ground during a takeoff attempt. According to the plt, after the acft was loaded with 60 gallons of pesticide a takeoff was begun. The acft became airborne and traveled about 300 ft when the plt inadvertantly allowed the rotor RPM…NTSB LAX84LA341Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Oceanside, CAA security guard with no flight experience attempted to fly the helicopter which he was guarding during early morning hours after substantial alcoholic beverage consumption. The acft sustained substantial damage when it touched down on the rt skid aprx 15 ft…NTSB LAX83FA448Accident · No injuriesField investigationFinal reportBell 47G · Oceanside, CAShortly after takeoff, the eng lost power at an alt of aprx 400 ft AGL. An autorotative landing was made on uneven terrain beside a stream with weeds aprx 3 ft high. During touchdown, the main rotor struck the tail boom. An inspection of the engine revealed…NTSB LAX83FUM07Accident · No injuriesFinal reportBell 47G-5 · Valley Center, CAThe acft was damaged during a forced landing following a power loss while engaged in aerial application. The pilot took off with 25 gallons of fuel which he said was usually enough for spraying 40-50 acres. This job was 19 acres but it was 10-12 miles away at…NTSB LAX83FUA03Accident · No injuriesFinal reportBell 47G-5 · Irvine, CAThe helicopter landed hard in a field off the airport following an engine power loss. The acfr had lifted off and only traveled about 50 feet at 15 feet AGL when the power loss occurred. An engine teardown revealed that the rings on 3 cylinders had not seated…NTSB LAX82DA360Accident · No injuriesFinal reportBell 47G-5 · Soledad, CAThe pilot experienced a power loss during lift-off. A hard landing was made. No reason for the malfunction was found.NTSB LAX82DA186Accident · No injuriesFinal reportBell 47G2 · Santa Maria, CAThe helicopter contacted the platform with a landing skid and rolled over during an attempted takeoff. As the helicopterlifted off of a truck mounted platform a skid became fouled by the truck and a dynamic roll-over occurred.NTSB LAX82DA135Accident · No injuriesFinal reportBell 47G-2 · Stockton, CAThe pilot landed to pick up a flagger and take him to the end of the field. The landing was made facing north on a north-south driveway. An overhead line was located along the east side of the driveway. During takeoff, the pilot moved laterally to the west,…NTSB LAX81FUQ25Accident · No injuriesClosedBell 47G-2 · Agua Dulce, CANTSB LAX81FUG25Accident · Serious injuriesClosedBell 47G-2 · Oasis, CANTSB LAX81DVM17Accident · No injuriesClosedBell 47G · Pescadero, CANTSB LAX80FVM37Accident · 1 fatalClosedTexas Hel OH-13H · Salinas, CANTSB LAX80FVD29Accident · No injuriesClosedBell 47G-5 · Stockton, CANTSB LAX80DUQ15Accident · No injuriesClosedBell 47G-2 · Rosamond, CANTSB LAX80FVD25Accident · No injuriesClosedBell 47G-5 · Oakland, CANTSB LAX80FA063Accident · Serious injuriesClosedBell 47G2 · Brentwood, CANTSB LAX79FVM30Accident · No injuriesClosedBell 47G-2A · Salinas, CANTSB LAX79FUM20Accident · Serious injuriesClosedBell 47G-5 · Escondido, CANTSB OAK79DVA44Accident · No injuriesClosedBell 47G-2 · Kerman, CANTSB LAX78FUQ40Accident · No injuriesClosedBell 47G-5 · Camarillo, CANTSB OAK78DVG52Accident · No injuriesClosedBell 47G5 · Napa, CANTSB LAX78DVM17Accident · No injuriesClosedBell 47G5 · Templeton, CANTSB LAX78FUQ21Accident · Minor injuriesClosedBell 47G · Santa Ynez, CANTSB LAX78DUM16Accident · No injuriesClosedBell 47G2 · Oceanside, CANTSB LAX78FVA25Accident · No injuriesClosedBell 47G1 · Buttonwillow, CANTSB LAX78FUA09Accident · Minor injuriesClosedBell 47G-2 · San Pedro, CANTSB LAX77FUM34Accident · No injuriesClosedHiller Acft UH-12E · Calipatria, CANTSB OAK77FXQ26Accident · Minor injuriesClosedBell 47G-2 · So Lake Tahoe, CANTSB OAK77DVM12Accident · Serious injuriesClosedBell 47G2 · King City, CANTSB LAX77DVA02Accident · No injuriesClosedEL Tomcat MK5A · Wasco, CANTSB LAX76FUA32Accident · Minor injuriesClosedBell 47G · San Pedro, CANTSB OAK76DVD36Accident · No injuriesClosedBell 47G-5 · Cloverdale, CANTSB LAX76FUQQ5Accident · No injuriesClosedBell 47G-2 · Valencia, CANTSB OAK75FVG79Accident · 1 fatalClosedTomcat MK 5A · Gridley, CANTSB LAX75FYM34Accident · Serious injuriesClosedHiller Acft UH-12D · Paso Robles, CANTSB OAK75DVD48Accident · No injuriesClosedBell 47G-5 · Oakland, CANTSB LAX75FUQ05Accident · No injuriesClosedBell 47G-5 · Oceanside, CANTSB OAK75DVD03Accident · No injuriesClosedBell 47G-2 · Linden, CANTSB LAX74AL084Accident · 2 fatalClosedBell 47G-3B · La Crescnta, CANTSB OAK74DVD28Accident · No injuriesClosedBell 47G-5 · Stockton, CANTSB LAX74DUG31Accident · No injuriesClosedBell 47G-5 · La Verne, CANTSB OAK74FVM08Accident · Minor injuriesClosedBell 47G-5 · Santa Clara, CANTSB OAK74FVM01Accident · Minor injuriesClosedBell 47G-2 · Salinas, CANTSB OAK73DVA62Accident · No injuriesClosedBell 47G-2 · Kettlmn Cty, CANTSB OAK73DVD28Accident · No injuriesClosedBell 47G-2 · Stockton, CANTSB OAK73DVM21Accident · No injuriesClosedBell 47G-2 · Salinas, CANTSB LAX73DUQ04Accident · No injuriesClosedBell 47G-2 · Sylmar, CANTSB LAX73FUD02Accident · No injuriesClosedBell 47G-5 · Santa Mnica, CANTSB OAK72DVD57Accident · No injuriesClosedBell 47G2 · Stockton, CANTSB LAX72FUG73Accident · No injuriesClosedBell 47G-2 · Glen Ivy, CA