NTSB investigations: Lycoming 0-235 series, 1985, MD
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 | 9 |
|---|---|
| 1965 | 7 |
| 1966 | 2 |
| 1967 | 2 |
| 1972 | 2 |
| 1973 | 2 |
| 1974 | 2 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1985 | 5 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 2001 | 2 |
| 2003 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2026 | 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\") = 1985
AND c.\"eventStateOrRegion\" = 'MD' 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") = 1985
AND c."eventStateOrRegion" = 'MD' 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 BFO86LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDAccording to the student plt, approximately one-third down the rwy he flared too high, and the acft bounced and became airborne again. The plt decided to not attempt a go-around, and the acft contacted the rwy again. On the final bounce, the nose gear…NTSB BFO85LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDAfter not obtaining surface wind info and not observing the wind sock, the student plt entered final apch without observing any significant drift. When the acft was at nose-up attitude. It floated and stopped descending for a few seconds. Suddenly, the plt…NTSB BFO85LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe plt prefldd the acft iaw a checklist and did not note any abnormalities. Following a normal tkof the plt remained in the traffic pattern, experiencing no complications until touchdown. The winds recorded at bwi were out of 220 degrees at 8 knots. The plt…NTSB BFO85LA020Accident · No injuriesLimited investigationFinal reportBellanca 7-ECA Citabria · Annapolis, MDDuring final apch to rwy 30, a go-around was executed due to a shift in wind direction, according to the plt. He subsequently entered the pattern for rwy 12, made a full stop lndg with no difficulties, and took off again for a planned touch and go on the next…NTSB BFO85LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152-II · Ocean City, MDWhile on a student solo x-country flight, the plt experienced vertical gusting conditions during the second landing pattern, following an initial go-around. Fearing a hard landing due to a severe gust, the plt abruptly applied full back pressure on the stick,…