NTSB investigations: Lycoming 0-235 series, 2013, TX
4 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 | 3 |
|---|---|
| 1965 | 7 |
| 1966 | 4 |
| 1967 | 3 |
| 1968 | 7 |
| 1969 | 2 |
| 1970 | 4 |
| 1971 | 6 |
| 1972 | 3 |
| 1973 | 3 |
| 1974 | 3 |
| 1975 | 4 |
| 1976 | 3 |
| 1977 | 7 |
| 1978 | 10 |
| 1979 | 20 |
| 1980 | 13 |
| 1981 | 23 |
| 1982 | 14 |
| 1983 | 14 |
| 1984 | 10 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 8 |
| 1988 | 6 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 6 |
| 1996 | 8 |
| 1997 | 10 |
| 1998 | 7 |
| 1999 | 4 |
| 2000 | 6 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 9 |
| 2006 | 4 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 5 |
| 2019 | 7 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 3 |
| 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\") = 2013
AND c.\"eventStateOrRegion\" = 'TX' 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") = 2013
AND c."eventStateOrRegion" = 'TX' 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 CEN14FA057Accident · 2 fatalField investigationFinal reportCessna 152 · Spring, TXThe flight instructor's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and subsequent loss of airplane control.NTSB CEN13LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Carrizo Springs, TXThe pilot’s failure to identify the water contamination of the fuel system during his preflight inspection, which resulted in a total loss of engine power during the airplane’s initial climb.NTSB CEN13LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe failure of the nose landing gear fork during landing due to fatigue.NTSB CEN13LA149Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · College Station, TXThe flight instructor’s and commercial pilot’s failure to see and avoid the other airplane, which resulted in a collision during cruise flight. Contributing to the accident was the failure of the flight instructor to activate the transponder before departure,…