NTSB investigations: Lycoming VO-435 series, WI
14 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
| 1970 | 1 |
|---|---|
| 1973 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 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\" = 'WI' 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" = 'WI' 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 GAA15CA122Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Elk Mound, WIThe pilot's failure to maintain a positive rate of climb after taking off from the service truck, which resulted in the helicopter impacting terrain.NTSB CHI08CA019Accident · No injuriesData collectionFinal reportBell 47G-2A · Wautoma, WIThe pilot's failure to maintain control of the helicopter resulting from a distraction in the cockpit. A contributing factor was the distraction due to the dog in the cockpit.NTSB CHI94FA330Accident · 1 fatalField investigationFinal reportBell 47G-5A · Wisconsin Rpds, WIUndetermined.NTSB CHI93DEP05Accident · Minor injuriesFinal reportBell 47-G5 · Fulton, WIthe failure (fracture) of the number one cylinder intake valve retainer (keeper).NTSB CHI93LA179Accident · Minor injuriesLimited investigationFinal reportBell 47 · Berlin, WIThe pilot-in-command's failure to see the obstruction.NTSB CHI92LA137Accident · Serious injuriesLimited investigationFinal reportBell 47-G2A · Dousman, WIThe in-flight loss of the swash plate drive link bolt which allowed the swash plate drive assembly to disconnect.NTSB CHI90DEP07Accident · No injuriesFinal reportBell 47-G2 · Hatley, WIThe partial loss of power due to sticking intake valves.NTSB CHI86FA017Accident · 1 fatalField investigationFinal reportBell 47G-5 · Plainfield, WIThe acft crashed into trees and nosed into the wooded terrain after a loss of powr. The helicopter had been refueled the day before the acc. Normal fuel load was 20 gals. The plt had sprayed 20 acres & flown 9 miles to another field to spray but aborted due…NTSB CHI85LA338Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Pickett, WIThe fld where this accident occurred had been sprayed one week prior to the accident by a fixed-wing acft at an alt of 20 ft. no wires were noted to be a hazard at that time. On the day of the accident the plt of the helicopter was talking to a spotter on the…NTSB CHI84LA263Accident · Minor injuriesLimited investigationFinal reportHiller UH 12 D · Deerfield, WIPlt was aware of pwr lines which crossed the field over which he was performing a calibration test. Plt stated that because of sun glare visual contact with the wires was lost. The acft contacted the wires.NTSB CHI81DEP22Accident · No injuriesClosedBell 47G-5 · Coloma, WINTSB CHI78FEP14Accident · Minor injuriesClosedBell 47-J · Wilmot, WINTSB CHI73DEP66Accident · Minor injuriesClosedBell 47G-5 · Appleton, WINTSB CHI71DDJ11Accident · No injuriesClosedBell 47D1 · Manitowish, WI