NTSB investigations: Lycoming 0-320 series, 2003, TX
20 cases on aircraft whose registry engine model is Lycoming 0-320 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 | 28 |
|---|---|
| 1965 | 25 |
| 1966 | 30 |
| 1967 | 27 |
| 1968 | 34 |
| 1969 | 33 |
| 1970 | 30 |
| 1971 | 16 |
| 1972 | 24 |
| 1973 | 14 |
| 1974 | 20 |
| 1975 | 18 |
| 1976 | 26 |
| 1977 | 23 |
| 1978 | 23 |
| 1979 | 24 |
| 1980 | 19 |
| 1981 | 22 |
| 1982 | 25 |
| 1983 | 14 |
| 1984 | 11 |
| 1985 | 11 |
| 1986 | 13 |
| 1987 | 6 |
| 1988 | 7 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 10 |
| 1992 | 11 |
| 1993 | 16 |
| 1994 | 4 |
| 1995 | 8 |
| 1996 | 13 |
| 1997 | 13 |
| 1998 | 10 |
| 1999 | 13 |
| 2000 | 11 |
| 2001 | 9 |
| 2002 | 17 |
| 2003 | 20 |
| 2004 | 14 |
| 2005 | 10 |
| 2006 | 14 |
| 2007 | 7 |
| 2008 | 13 |
| 2009 | 10 |
| 2010 | 11 |
| 2011 | 12 |
| 2012 | 7 |
| 2013 | 7 |
| 2014 | 10 |
| 2015 | 11 |
| 2016 | 8 |
| 2017 | 7 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 13 |
| 2021 | 9 |
| 2022 | 11 |
| 2023 | 10 |
| 2024 | 9 |
| 2025 | 7 |
| 2026 | 11 |
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\") = 2003
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 ('41508'))
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") = 2003
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 ('41508'))
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 FTW04FA045Accident · 2 fatalField investigationFinal reportCessna 172K · Grand Saline, TXThe pilot's failure to maintain control of the airplane while on final approach. Factors were the high winds and prevailing crosswind.NTSB FTW04FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Livingston, TXThe pilot's failure to compensate for the wind conditions and maintain control of the airplane during the final approach. Contributing factors were the gusty and high wind conditions.NTSB FTW04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172N · La Grange, TXThe pilot's failure to properly navigate during the day VFR cross-country flight, which resulted in the pilot becoming disoriented.NTSB FTW04LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Amarillo, TXThe pilot's inadequate compensation for wind condition. Contributing factors were the pilot's lack of total experience in the make and model of aircraft, and the crosswind.NTSB FTW03LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Beaumont, TXThe loss of engine power for undetermined reasons.NTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.NTSB FTW03LA191Accident · No injuriesLimited investigationFinal reportBeech 19A · Fredericksburg, TXA partial loss of engine power due to a rich mixture and reduced airflow to the engine. Contributing factors were the owner's failure to obtain an annual inspection, and improper maintenance procedures used in the installation of the air filter.NTSB FTW03FA184Accident · 2 fatalField investigationFinal reportCessna 172M · McAllen, TXThe pilot's failure to recover from a bounced landing which resulted in a loss of control. Contributing factors were the gusty winds.NTSB FTW03LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXThe instructor's delay in executing a go-around and his failure to maintain aircraft control due to inadequate compensation of wind gusts. A contributing factor was the gusty winds.NTSB FTW03LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot misjudged his altitude and airspeed, and his failure to perform a go-around.NTSB LAX03LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · Early, TXThe student pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power while on approach to land, and subsequent off-airport landing.NTSB FTW03LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gainesville, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the prevailing crosswind and the pilot's failure to abort landing.NTSB LAX03LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Conroe, TXThe pilot's failure to attain/maintain sufficient airspeed, which resulted in a stall/mush.NTSB FTW03LA155Accident · No injuriesLimited investigationFinal reportOMF 100-160 · San Antonio, TXThe pilot's failure to land at the proper touchdown point, which resulted in the overrun of the runway.NTSB FTW03LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Conroe, TXthe student pilot's inadequate compensation for wind. A contributing factor was the gusting wind conditions.NTSB FTW03LA149Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Houston, TXThe flight instructor's poor decision to initiate a simulated emergency without having a suitable area for a forced landing.NTSB FTW03LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Roanoke, TXThe flight instructor's inadequate in-flight planning/decision resulting in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Moran, TXLanding short of the runway due to the pilot's failure to maintain a proper glide path, which resulted in the airplane impacting a tree. A contributing factor was the short runway.NTSB FTW03LA124Accident · No injuriesLimited investigationFinal reportRobinson R22 · Freer, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel en route. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB FTW03LA100Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's inadequate preflight planning and preparation for the flight which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.