NTSB investigations: Continental IO-520 series, 1995, TX
9 cases on aircraft whose registry engine model is Continental IO-520 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 | 2 |
|---|---|
| 1965 | 3 |
| 1966 | 6 |
| 1967 | 9 |
| 1968 | 5 |
| 1969 | 8 |
| 1970 | 5 |
| 1971 | 5 |
| 1972 | 4 |
| 1973 | 6 |
| 1974 | 13 |
| 1975 | 10 |
| 1976 | 11 |
| 1977 | 11 |
| 1978 | 8 |
| 1979 | 9 |
| 1980 | 15 |
| 1981 | 13 |
| 1982 | 10 |
| 1983 | 3 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 4 |
| 1991 | 5 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 9 |
| 1996 | 7 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 9 |
| 2006 | 4 |
| 2007 | 5 |
| 2008 | 2 |
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 6 |
| 2013 | 4 |
| 2014 | 7 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 6 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 5 |
| 2026 | 2 |
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\") = 1995
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 ('17032'))
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") = 1995
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 ('17032'))
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 FTW96LA022Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Tahoka, TXthe pilot's failure to maintain clearance from wires. Factors were the loss of aileron control and the lack of suitable terrain for a forced landing.NTSB FTW95LA367Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Whitesboro, TXThe pilot's improper flare, which resulted in a hard landing.NTSB FTW95FA319Accident · No injuriesField investigationFinal reportBoeing 737-3A4 · Dallas, TXFailure of the flightcrews of the Boeing 737, N675AA, and the Cessna 401, N31DB, to see and avoid each other. Factors were: the failure of 737 flightcrew to respond to the traffic advisory given by the ground controller identifying potentially conflicting…NTSB FTW95LA273Accident · No injuriesLimited investigationFinal reportCessna A188A · Pharr, TXThe pilot's inadequate aircraft preflight which failed to purge the aircraft fuel system of contaminants. A factor was the unsuitable terrain in the emergency landing area.NTSB FTW95LA252Accident · No injuriesLimited investigationFinal reportCessna A188B · Weslaco, TXThe inadequate visual lookout by both pilots. A factor was the inability of the pilots to communicate by radio due to the incompatible equipment installed in the two airplanes.NTSB FTW95LA208Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Conroe, TXThe failure of both pilots to maintain adequate visual lookout. A factor relating to the accident was: failure of the Bellanca pilot to adequately communicate his intentions on the UNICOM frequency.NTSB FTW95LA193Accident · No injuriesLimited investigationFinal reportBeech F33A · Houston, TXThe pilot's inadequate compensation for the wind conditions. A factor was the crosswind.NTSB FTW95LA157Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Midland, TXThe pilot's failure to maintain directional control.NTSB FTW95LA095Accident · No injuriesLimited investigationFinal reportBeech 33-A · Lago Vista, TXThe pilot's failure to execute a missed approach at minimums for the non-precision approach and an excessive rate of descent during the circle to land maneuver.