NTSB investigations: Lycoming VO-435 series, OR
10 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 |
|---|---|
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1994 | 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\" = 'OR' 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" = 'OR' 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 SEA94LA064Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy H-23D · Seaside, ORThe pilot's improper use of flight controls resulting in settling with power.NTSB SEA88LA014Accident · No injuriesLimited investigationFinal reportBell 47G2 · Lebanon, ORThe student was performing an autorotation at about 50' AGL and the flare was begun. The instructor pilot noticed that the helicopter was not leveling and took control of the aircraft. The helicopter settled tail low onto the soft ground striking the tail…NTSB SEA85LA126Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Athena, ORThe acft settled back to the ground shortly after takeoff before achieving translatioanal lift. The plt was attempting to test a new spray unit that had been installed. He had put 80 gallons of water in the spray tanks.NTSB SEA84LA066Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Forest Grove, ORThe plt reported that while hovering, during an external load operation, the eng lost power & blue smoke & flames exited the back of the helicopter. The helicopter then struck trees before coming to rest. During an investigation, the eng started normally &…NTSB SEA82DA057Accident · Serious injuriesFinal reportHiller-Soloy 12E · Christmas Valle, ORThe helicopter was being used to string a transmission line. A rope (attach line) was used to connect the helicopter to the transmission line. The rope became detached and the pilot landed to have it reattached. A man, involved in the ground operations,…NTSB SEA81FYM09Accident · Minor injuriesClosedBell 47G-3 · Buell, ORNTSB SEA75DYC40Accident · Serious injuriesClosedBell 47G-2A · Corvallis, ORNTSB SEA73FYC37Accident · Serious injuriesClosedBell 47G-3B · Warm Springs, ORNTSB SEA72DYC08Accident · No injuriesClosedBell 47G3B1 · Legrande, ORNTSB SEA65A0045Accident · No injuriesClosedBell 47G3 · Lagrande, OR