NTSB investigations: Lycoming VO-435 series, CA
7 cases on aircraft whose registry engine model is Lycoming VO-435 series, where the first occurrence was “Loss of control - in flight”. 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 per year
| 1984 | 1 |
|---|---|
| 1988 | 2 |
| 1989 | 2 |
| 1996 | 1 |
| 1998 | 1 |
Where
Latest cases
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')
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\" = 250))
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')
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" = 250))
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 LAX98LA309Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H · Gilroy, CAThe pilot's loss of control for undetermined reasons.NTSB LAX97LA006Accident · No injuriesLimited investigationFinal reportBell 47G-5A · King City, CAthe pilot's failure to maintain adequate rotor rpm during the takeoff initial climb.NTSB LAX90LA042Accident · Minor injuriesLimited investigationFinal reportBell 47G-II · Rialto, CAThe pilot's loss of directional control and subsequent overcontrol while hovering. Contributing to the accident were the gusty wind conditions and the pilot's inexperience.NTSB LAX89DVA07Accident · No injuriesFinal reportTexas Helicopter OH-13E/M74 · Hilmar, CAThe pilot's loss of directional control during an attempted takeoff from a loading platform.NTSB LAX88DUQ04Accident · No injuriesFinal reportTexas Helicopter M74A · Lancaster, CADuring an aerial application flight, just after takeoff, the nose of the helicopter suddenly pitched up. The pilot reduced power to keep from climbing. The fore/aft cyclic control had no effect. The helicopter settled to the ground resulting in substantial…NTSB LAX88LA126Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A-1 · Oceanside, CAThe non-U.S. Certificated pilot lost control of the helicopter while hovering 3-FT AGL during a maintenance test flight. The acft descended, touched down hard and rolled over. The non-english speaking pilot immediately departed the scene & reportedly headed…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…