NTSB investigations: Lycoming VO-435 series, AZ
19 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 per year
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1978 | 2 |
| 1980 | 4 |
| 1981 | 2 |
| 1985 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 2022 | 1 |
Where
Open the mapLatest 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\" = 'AZ' 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" = 'AZ' 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 WPR23LA006Accident · No injuriesClass 3 · LimitedFinal reportBell 47G2 · Mesa, AZA total loss of engine power due to fuel exhaustion.NTSB LAX94LA303Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Scottsdale, AZThe pilot's failure to refuel appropriately, the altitude and airspeed at the time the engine stoppage occurred were factors in the accident.NTSB LAX92LA378Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Chandler, AZThe pilot's misjudging the performance and weight and balance data of the helicopter prior to departure. Contributing to the accident was a failure of the pilot to jettison the chemical load.NTSB LAX92LA278Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Mesa, AZA partial loss of engine power due to unknown reason (s). Factors in this accident were 1) low altitude when the partial loss of power occurred 2) low rotor RPM as a result of the loss of power, and 3) the pilot not being able to take remedial action due to…NTSB LAX86FUM01Accident · Minor injuriesFinal reportBell 47 G-5 · Yuma, AZThe pilot was hovering after a night takeoff and collided with an electrical power line.NTSB LAX81DUK10Accident · No injuriesClosedTexas Hel OH-13H · Yuma, AZNTSB LAX81DUK02Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX81FUJ03Accident · No injuriesClosedBell 47G-5 · Roll, AZNTSB LAX80FUK01Accident · No injuriesClosedBell 47G-5A · Yuma, AZNTSB LAX80FUJ83Accident · Minor injuriesClosedBell 47G-5 · Sommerton, AZNTSB LAX80DUJ43Accident · No injuriesClosedBell 47G5 · Somerton, AZNTSB LAX79DUJ18Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX79FUJ13Accident · 1 fatalClosedBell 47G3B · Springerville, AZNTSB LAX76DUJ29Accident · No injuriesClosedBell 47G-5 · Chandler, AZNTSB LAX74DUJ49Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX74DUJ05Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX71FUJ40Accident · Serious injuriesClosedBell 47G-5 · El Mirage, AZNTSB LAX68A0003Accident · Minor injuriesClosedBell 47G-5 · Casa Grande, AZNTSB DEN66A0005Accident · No injuriesClosedBell 47G3B1 · Grand Canyon, AZ