NTSB investigations: Lycoming VO-435 series, CA

6 cases on aircraft whose registry engine model is Lycoming VO-435 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

NTSB investigations: Lycoming VO-435 series, CA per year, 1983–2026: 6 cases
1983	2
1987	1
1996	1
2004	1
2006	1

Where

Open the map

Latest cases

Query with SQL

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" = 353)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 353))
  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" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 LAX06CA180Accident · No injuriesData collectionFinal reportBell 47-G5 · Soledad, CAfuel exhaustion due to the pilot's inaccurate fuel consumption calculations and failure to refuel the helicopter which resulted in a loss of engine power.May 23, 2006 · N4741R · Substantial damage NTSB LAX04LA158Accident · No injuriesLimited investigationFinal reportQuinn E L Tom Cat MK-5A · Galt, CAa loss of engine power due to water contamination of the fuel system.Mar 15, 2004 · N8429 · Substantial damage NTSB LAX96LA287Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Lost Hills, CAimproper installation of the carburetor air box.Jul 23, 1996 · N7885S · Substantial damage NTSB LAX87DVM03Accident · No injuriesFinal reportBell 47G-5 · Salinas, CAAt the end of an aerial application operation, enroute to the airport, the engine quit. The pilot autorotated the helicopter onto a soft field, where on touchdown, the helicopter was substantially damaged. Inspection of the helicopter revealed that the fuel…Jun 28, 1987 · N6288N · Substantial damage 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…Sep 19, 1983 · N62221 · Substantial damage 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…Jun 14, 1983 · N2252W · Substantial damage