NTSB investigations: Lycoming VO-435 series, OK
9 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
| 1964 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 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\" = 'OK' 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" = 'OK' 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 FTW94FA158Accident · 1 fatalField investigationFinal reportBell 47G-2 · Tulsa, OKIn flight loss of control due to the pilot's improper use of the cyclic and collective controls when he maneuvered abruptly to avoid colliding with a flock of birds. Factors were the birds and the inflight separation of the left synchronized elevator.NTSB FTW87DPJ09Accident · Serious injuriesFinal reportG&C Helicopters EL Tomcat MK5A · Marlow, OKPilot failed to see and avoid tree at end of swath run during a spraying operation. After contacting the tree, the helicopter started to spin and struck the ground in an approximate 90 degree right bank and started to burn.NTSB FTW83FA311Accident · Minor injuriesField investigationFinal reportBell 47G-2 · Bethany, OKThe helicopter collided with trees and rolled over during a forced landing after engine failure. The plt had been takingpassengers up for sight-seeing for several hours. After the last flt he and his wife had departed the city park to fly back to the acft…NTSB FTW81DPJ24Accident · No injuriesClosedBell 47D1 · Okeene, OKNTSB FTW80DPJ20Accident · No injuriesClosedHiller Acft HU-12D · Norman, OKNTSB FTW76DPJ49Accident · Minor injuriesClosedBell 47G-2 · Elgin, OKNTSB FTW74FPJ06Accident · 1 fatalClosedEL Tomcat MK5 · Springer, OKNTSB FTW72DPM26Accident · No injuriesClosedBell 47G · Wynona, OKNTSB UNK65X0693Accident · No injuriesClosedBell 47G2A · Yukon, OK