NTSB investigations: Lycoming 0-235 series, 2006, 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\") = 2006
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") = 2006
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 MIA07CA012Accident · No injuriesData collectionFinal reportAmerican AA-1 · Lakeland, FLThe pilot's misjudgment of the landing flare/touchdown which resulted in a hard landing.NTSB SEA06LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe student pilot's improper recovery from a bounced landing.NTSB DEN06LA126Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Live Oak, FLa loss of engine power for reasons undetermined, and an inadvertent stall while maneuvering.NTSB ANC06CA091Accident · No injuriesData collectionFinal reportDahlstrom - Piel Emeraude CP-30 · Venice, FLThe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident were a crosswind, and an inadvertent swerve.NTSB MIA06LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe loss of engine power for undetermined reasons.NTSB MIA06LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sanford, FLA loss of engine power during takeoff-initial climb due to contamination (debris) lodged in the carburetor jet, which resulted in a forced landing and collision with trees.NTSB MIA06CA047Accident · No injuriesData collectionFinal reportCessna 152 · Lantana, FLThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in the nosegear collapsing, the airplane veering off the runway, and nosing over.