NTSB investigations: Lycoming VO-435 series, AL
12 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 |
| 1987 | 2 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1999 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2015 | 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\" = 'AL' 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" = 'AL' 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 ERA15LA296Accident · No injuriesLimited investigationFinal reportBell 47G 3B 1 · Camden, ALA failure of the helicopter's hydraulic flight control systems for reasons that could not be determined due to the fire damage, and the pilot's inability to turn off the hydraulic system to relieve control pressure.NTSB ATL07LA052Accident · Minor injuriesLimited investigationFinal reportBell 47G2A · Huntsville, ALThe loss of engine power due to undetermined reasons.NTSB DEN06CA124Accident · No injuriesData collectionFinal reportBell 47G-2 · Hayden, ALengine fire for reasons undetermined.NTSB ATL99FA132Accident · 2 fatalField investigationFinal reportContinental Copters Tomcat MK5A · Heflin, ALThe pilot of N9010T's failure to maintain visual lookout while maneuvering, resulting in a midair collision with N30899. A factor was the sun glare.NTSB ATL99LA107Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Camden, ALThe failure of the cyclic control rod due to an overstress separation resulting from a material defect (inadequate quality of material) by the manufacturer.NTSB ATL94LA009Accident · No injuriesLimited investigationFinal reportBell 47G2 · Billingsley, ALThe pilot's improper vertical liftoff which resulted in dynamic roll-over and the main rotor's impact with the ground.NTSB ATL92LA160Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Slocomb, ALA hard landing due to a power loss from fuel exhaustion. A factor in the accident was the lack of sustable terrain for the landing.NTSB ATL90DKJ02Accident · No injuriesFinal reportBell 47G2 · Wettumpka, ALThe pilot's failure to avoid obstacles during aerial application maneuvering.NTSB ATL87LA249Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Enterprise, ALDuring a practice autorotation, the instructor pilot delayed in appling power to arrest the autorotative descent. The other pilot reported that the autorotation profile was was not the same as the previous successful autorotation. There were no reported…NTSB ATL87LA222Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Huntsville, ALThe helicopter impacted the water during a low-altitude turn over a river. The plt made a low pass to the south over an island at about 30 ft AGL, to show the island to the policewoman/traffic observer onboard. As he was making a climbing right turn at about…NTSB MIA67A0105Accident · Minor injuriesClosedBell 47G-2 · Foley, ALNTSB MIA66A0003Accident · Minor injuriesClosedBell 47G-2 · Selma, AL