NTSB investigations: Continental O-470 series, 1997, TX
4 cases on aircraft whose registry engine model is Continental O-470 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 | 24 |
|---|---|
| 1965 | 16 |
| 1966 | 27 |
| 1967 | 20 |
| 1968 | 14 |
| 1969 | 10 |
| 1970 | 16 |
| 1971 | 7 |
| 1972 | 7 |
| 1973 | 7 |
| 1974 | 7 |
| 1975 | 12 |
| 1976 | 15 |
| 1977 | 12 |
| 1978 | 13 |
| 1979 | 6 |
| 1980 | 13 |
| 1981 | 5 |
| 1982 | 8 |
| 1983 | 11 |
| 1984 | 4 |
| 1985 | 8 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 6 |
| 1989 | 4 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 6 |
| 2001 | 6 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 4 |
| 2008 | 7 |
| 2009 | 4 |
| 2010 | 11 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 6 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 10 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 4 |
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 ('17026'))
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 ('17026'))
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 FTW98LA077Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Worth, TXthe pilot's improper planning/decision, by allowing the airplane to get in a situation, where he could not compensate for wind conditions. A related factor was the gusty crosswind.NTSB FTW98LA026Accident · No injuriesLimited investigationFinal reportCessna 182P · Thompsons, TXThe loss of engine power resulting from a disconnected carburetor float due to improper maintenance. A factor was the lack of suitable terrain for a forced landing.NTSB FTW97LA093Accident · No injuriesLimited investigationFinal reportCessna 180K · Valentine, TXThe pilot's failure to attain the proper touchdown point, and the excessive airspeed during the approach and landing. A factor was the dirt bank paralleling the airstrip.NTSB FTW97TA075Accident · No injuriesFinal reportCessna 182Q · Cleburne, TXthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane. Factors relating to the accident were: the crosswind, and the dirt bank which was parallel to the runway.