NTSB investigations: Lycoming 0-235 series, 2008, FL
7 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 | 6 |
|---|---|
| 1965 | 7 |
| 1967 | 3 |
| 1968 | 3 |
| 1970 | 1 |
| 1971 | 5 |
| 1972 | 5 |
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 3 |
| 1976 | 6 |
| 1977 | 4 |
| 1978 | 11 |
| 1979 | 3 |
| 1980 | 9 |
| 1981 | 11 |
| 1982 | 16 |
| 1983 | 11 |
| 1984 | 11 |
| 1985 | 9 |
| 1986 | 8 |
| 1987 | 12 |
| 1988 | 6 |
| 1989 | 14 |
| 1990 | 9 |
| 1991 | 13 |
| 1992 | 6 |
| 1993 | 7 |
| 1994 | 13 |
| 1995 | 10 |
| 1996 | 5 |
| 1997 | 8 |
| 1998 | 7 |
| 1999 | 11 |
| 2000 | 7 |
| 2001 | 7 |
| 2002 | 8 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 8 |
| 2006 | 7 |
| 2007 | 10 |
| 2008 | 7 |
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 5 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 6 |
| 2018 | 8 |
| 2019 | 6 |
| 2020 | 4 |
| 2021 | 2 |
| 2024 | 1 |
| 2025 | 3 |
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\") = 2008
AND c.\"eventStateOrRegion\" = 'FL' 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") = 2008
AND c."eventStateOrRegion" = 'FL' 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 MIA08CA171Accident · Minor injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLBoth pilots' inadequate preflight inspection of the fuel.NTSB MIA08LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe failure of the No. 3 connecting rod cap due to oil starvation. Contributing to the accident was the contamination of the engine oil.NTSB MIA08CA113Accident · No injuriesData collectionFinal reportCessna 152 · Okeechobee, FLThe student pilot's improper recovery from a bounced landing.NTSB NYC08CA161Accident · Minor injuriesData collectionFinal reportCessna 152K · Okeechobee, FLThe loss of engine power during cruise flight due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB NYC08CA092Accident · Minor injuriesData collectionFinal reportKral Series 5 Kitfox · Fruitland Park, FLThe pilot's failure to maintain adequate clearance from obstructions during the landing approach. Contributing to the accident was the reduced visibility due to sunglare and haze.NTSB NYC08CA094Accident · Minor injuriesData collectionFinal reportPiper J3-C65 · Hollywood, FLThe pilot's failure to maintain directional control while landing. Contributing was the gusty crosswind condition.NTSB NYC08CA080Accident · No injuriesData collectionFinal reportCessna C-152 · Labelle, FLThe pilot's improper decision to takeoff from an inadequate field after a forced landing.