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.

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…Aug 1, 1984 · N4099G · Substantial damageNTSB 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…Jun 9, 1984 · N2252W · Substantial damageNTSB 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…Sep 19, 1983 · N62221 · Substantial damageNTSB 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…Jun 14, 1983 · N2252W · Substantial damageNTSB 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…Feb 10, 1983 · N1375X · Substantial damageNTSB 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.Sep 27, 1982 · N8562F · Substantial damageNTSB 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.May 21, 1982 · N130V · Substantial damageNTSB 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,…Apr 15, 1982 · N2879B · DestroyedNTSB LAX81FUQ25Accident · No injuriesClosedBell 47G-2 · Agua Dulce, CAJul 5, 1981 · N9763Z · Substantial damageNTSB LAX81FUG25Accident · Serious injuriesClosedBell 47G-2 · Oasis, CAApr 30, 1981 · N2498B · DestroyedNTSB LAX81DVM17Accident · No injuriesClosedBell 47G · Pescadero, CAMar 17, 1981 · N62221 · DestroyedNTSB LAX80FVM37Accident · 1 fatalClosedTexas Hel OH-13H · Salinas, CAAug 6, 1980 · N10003 · Substantial damageNTSB LAX80FVD29Accident · No injuriesClosedBell 47G-5 · Stockton, CAJun 28, 1980 · N8594F · DestroyedNTSB LAX80DUQ15Accident · No injuriesClosedBell 47G-2 · Rosamond, CAJun 17, 1980 · N2498B · Substantial damageNTSB LAX80FVD25Accident · No injuriesClosedBell 47G-5 · Oakland, CAMay 27, 1980 · N7832S · Substantial damageNTSB LAX80FA063Accident · Serious injuriesClosedBell 47G2 · Brentwood, CAMar 8, 1980 · N6701D · DestroyedNTSB LAX79FVM30Accident · No injuriesClosedBell 47G-2A · Salinas, CAAug 2, 1979 · N2817B · Substantial damageNTSB LAX79FUM20Accident · Serious injuriesClosedBell 47G-5 · Escondido, CAJul 6, 1979 · N7914S · Substantial damageNTSB OAK79DVA44Accident · No injuriesClosedBell 47G-2 · Kerman, CAJun 19, 1979 · N7893B · Substantial damageNTSB LAX78FUQ40Accident · No injuriesClosedBell 47G-5 · Camarillo, CAAug 17, 1978 · N6277N · Substantial damageNTSB OAK78DVG52Accident · No injuriesClosedBell 47G5 · Napa, CAJun 21, 1978 · N7923J · Substantial damageNTSB LAX78DVM17Accident · No injuriesClosedBell 47G5 · Templeton, CAApr 10, 1978 · N7914S · Substantial damageNTSB LAX78FUQ21Accident · Minor injuriesClosedBell 47G · Santa Ynez, CAMar 27, 1978 · N2252W · Substantial damageNTSB LAX78DUM16Accident · No injuriesClosedBell 47G2 · Oceanside, CAMar 25, 1978 · N6709D · Substantial damageNTSB LAX78FVA25Accident · No injuriesClosedBell 47G1 · Buttonwillow, CAFeb 18, 1978 · N9421H · Substantial damageNTSB LAX78FUA09Accident · Minor injuriesClosedBell 47G-2 · San Pedro, CAJan 20, 1978 · N9763Z · Substantial damageNTSB LAX77FUM34Accident · No injuriesClosedHiller Acft UH-12E · Calipatria, CAAug 6, 1977 · N62413 · Substantial damageNTSB OAK77FXQ26Accident · Minor injuriesClosedBell 47G-2 · So Lake Tahoe, CAJun 27, 1977 · N8406E · Substantial damageNTSB OAK77DVM12Accident · Serious injuriesClosedBell 47G2 · King City, CAApr 6, 1977 · N6727D · DestroyedNTSB LAX77DVA02Accident · No injuriesClosedEL Tomcat MK5A · Wasco, CAOct 4, 1976 · N9001T · Substantial damageNTSB LAX76FUA32Accident · Minor injuriesClosedBell 47G · San Pedro, CASep 8, 1976 · N62221 · Substantial damageNTSB OAK76DVD36Accident · No injuriesClosedBell 47G-5 · Cloverdale, CAMay 21, 1976 · N6277N · Substantial damageNTSB LAX76FUQQ5Accident · No injuriesClosedBell 47G-2 · Valencia, CAAug 4, 1975 · N2879B · Substantial damageNTSB OAK75FVG79Accident · 1 fatalClosedTomcat MK 5A · Gridley, CAJun 25, 1975 · N9001T · DestroyedNTSB LAX75FYM34Accident · Serious injuriesClosedHiller Acft UH-12D · Paso Robles, CAJun 12, 1975 · N96M · DestroyedNTSB OAK75DVD48Accident · No injuriesClosedBell 47G-5 · Oakland, CAMay 21, 1975 · N7832S · Substantial damageNTSB LAX75FUQ05Accident · No injuriesClosedBell 47G-5 · Oceanside, CAJul 17, 1974 · N2252W · Substantial damageNTSB OAK75DVD03Accident · No injuriesClosedBell 47G-2 · Linden, CAJul 6, 1974 · N6701D · Substantial damageNTSB LAX74AL084Accident · 2 fatalClosedBell 47G-3B · La Crescnta, CAJun 23, 1974 · N8496E · DestroyedNTSB OAK74DVD28Accident · No injuriesClosedBell 47G-5 · Stockton, CAMar 24, 1974 · N7923J · Substantial damageNTSB LAX74DUG31Accident · No injuriesClosedBell 47G-5 · La Verne, CANov 30, 1973 · N4741R · Substantial damageNTSB OAK74FVM08Accident · Minor injuriesClosedBell 47G-5 · Santa Clara, CAAug 31, 1973 · N4754R · Substantial damageNTSB OAK74FVM01Accident · Minor injuriesClosedBell 47G-2 · Salinas, CAJul 5, 1973 · N6728D · Substantial damageNTSB OAK73DVA62Accident · No injuriesClosedBell 47G-2 · Kettlmn Cty, CAJun 9, 1973 · N6720D · Substantial damageNTSB OAK73DVD28Accident · No injuriesClosedBell 47G-2 · Stockton, CAMar 18, 1973 · N5162B · Substantial damageNTSB OAK73DVM21Accident · No injuriesClosedBell 47G-2 · Salinas, CADec 15, 1972 · N6727D · Substantial damageNTSB LAX73DUQ04Accident · No injuriesClosedBell 47G-2 · Sylmar, CAAug 6, 1972 · N2879B · Substantial damageNTSB LAX73FUD02Accident · No injuriesClosedBell 47G-5 · Santa Mnica, CAJul 21, 1972 · N4798R · Substantial damageNTSB OAK72DVD57Accident · No injuriesClosedBell 47G2 · Stockton, CAJun 9, 1972 · N5162B · Substantial damageNTSB LAX72FUG73Accident · No injuriesClosedBell 47G-2 · Glen Ivy, CAApr 24, 1972 · N6709D · Substantial damage