NTSB investigations: Lycoming 0-235 series, 1997, TX
10 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\") = 1997
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") = 1997
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 FTW98LA017Accident · No injuriesLimited investigationFinal reportCessna A152 · Rockwall, TXThe pilot's improper recovery from a bounced landing and her failure to maintain directional control during the aborted landing. Factors were the wind gust and the turbulence.NTSB FTW97LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Zavalla, TXthe pilot's improper planning/decision, becoming lost/disoriented during the flight, and selection of unsuitable terrain for an emergency/precautionary landing. Factors relating to the accident were: the hazy weather condition, and rough terrain in the…NTSB FTW97LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfailure of the pilot in the Cessna 172 to maintain clearance from the Cessna 152 aircraft.NTSB FTW97LA244Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfuel exhaustion, due to the pilot's failure to refuel before taking off on the remainder of the flight after making a precautionary landing. Factors related to the accident were: the pilot becoming lost and disoriented, and the lack of suitable terrain for a…NTSB FTW97LA243Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gorman, TXthe student pilot's improper inflight planning/decision, and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: a fluctuation in the electrical system, due to an undetermined reason, the student pilot's lack of…NTSB FTW97LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe pilot's loss of control due to delayed landing flare. A factor was the porpoise encountered during landing.NTSB FTW97FA173Accident · Minor injuriesField investigationFinal reportGowan LONG-EZ · Roanoke, TXThe pilot's failure to maintain the proper descent rate. A factor was the gascolator's filter screen becoming contaminated with fiber glass residue due to the pilot/mechanic's inadequate maintenance.NTSB FTW97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Abilene, TXThe unlatching of the front bench seat for an undetermined reason.NTSB FTW97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Brownsville, TXThe pilot's delayed go-around and subsequent inadvertent stall. A factor was the gusty winds.