NTSB investigations: Continental O-470 series, 1985, FL
7 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 | 8 |
|---|---|
| 1965 | 9 |
| 1966 | 7 |
| 1967 | 9 |
| 1968 | 9 |
| 1969 | 5 |
| 1970 | 9 |
| 1971 | 6 |
| 1972 | 10 |
| 1973 | 9 |
| 1974 | 8 |
| 1975 | 5 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 8 |
| 1980 | 4 |
| 1981 | 2 |
| 1982 | 8 |
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 7 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 10 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 6 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 1 |
| 2025 | 2 |
Where
Open the mapLatest 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\") = 1985
AND c.\"eventStateOrRegion\" = 'FL' 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") = 1985
AND c."eventStateOrRegion" = 'FL' 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 MIA86LA007Accident · No injuriesLimited investigationFinal reportCessna C-182P · Lake City, FLThe plt stated that while on a VFR flt from west palm beach FL to atlnata ga the acft lost power. While making forced landing on interstate 75 the left main wheel struck a car, & on landing rollout the right wing struck a utility pole. Investigation revealed…NTSB MIA85LA221Accident · No injuriesLimited investigationFinal reportCessna 182P · Davisville, FLThe pilot stated that on landing roll out at the agricultural airstrip, the aircraft struck a ditch causing the nose gear to collapse.NTSB MIA85LA167Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Winter Haven, FLA Schempp-Hirth ventus b, N40EE, was positioned on rwy 29 to be towed on a competition glider flt. The plt reported that before starting his takeoff, the tow plane was positioned to the left of the glider. The wind was from 030 deg at 8 KTS. As the takeoff…NTSB MIA85LA160Accident · No injuriesLimited investigationFinal reportCessna C-182J · Loughman, FLThe acft was towing a banner at 500 ft alt when the engine lost power. The pilot amde an emergency landing in a sandy field and the acft nosed over. The acft had flown 1 hr 15 min with the fuel tank selector on 'both'. The acft took off with a total of aprx…NTSB MIA85LA119Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Sugar Loaf Key, FLThe engine failed just after takeoff and the acft landed in a field north of the arpt, collided with trees and nosed over. Post accident examination of the fuel system shows that the acft micron fuel filter was contaminated to the extent that it caused…NTSB MIA85FA098Accident · Serious injuriesField investigationFinal reportCessna 182A · Williston, FLThe plt took off with the fuel selector on 'both' and at 300 feet AGL switched the fuel selector to 'left'. The selector was still on 'left' when engine lost power at the beginning of the base leg. The plt tried to reach the rwy but collided with edge of…NTSB MIA85LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Wesley Chapel, FLThe student plt flying N94560 was making her 1st solo touch and go landing when control of the acft was lost. Upon touchdown, N94560 veered left, departed the rwy and collided with N3854D which was being taxied on the grass aprx 20 ft from the rwy.