NTSB investigations: Lycoming 0-235 series, 1983, OK
5 cases on aircraft whose registry engine model is Lycoming 0-235 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 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 2 |
| 1969 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 2 |
| 1980 | 4 |
| 1981 | 4 |
| 1982 | 1 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 4 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 3 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 6 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 2 |
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2021 | 1 |
| 2024 | 1 |
| 2025 | 1 |
Where
Latest 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 year(c.\"eventDate\") = 1983
AND 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 ('41505'))
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 year(c."eventDate") = 1983
AND 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 ('41505'))
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 FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…NTSB FTW84LA073Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Walters, OKThe plt & safety plt had made two simulated instrument approaches at duncan,OK &a low VFR pass at Walters which was to terminate with a circling approach & landing. The acft stalled during the pull-up from the low pass.NTSB FTW83LA368Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe acft collided with a fence and a powerline during takeoff climb. The student pilot was visiting a small field with A1300 ft rwy of sod for practice. The C-152 uses 1340 ft to clear a 50 ft obstabcle for a standard day on a surfaced rwy this day was above…NTSB FTW83LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft collided with a ditch during a forced landing. This was an instructional flt and the CFI gave the student a simulated forced landing. During the attempted go-around the engine reportedly developed only 1800 RPM and a landing wasmade in a field by the…NTSB FTW83LA240Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodward, OKAs the a/s increased drng tkof roll the acft started to skid to the rt. The student plt stated that with full l aileron and no rt rudder the acft continued to skid to the rt. He then atmptd to apply l rudder and abort the tkof by reducing pwr. The acft veered…