NTSB investigations: Continental O-470 series, 1985, SC
3 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 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 3 |
| 1969 | 2 |
| 1970 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 3 |
| 1981 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 3 |
| 1988 | 1 |
| 1989 | 4 |
| 1992 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2004 | 2 |
| 2007 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2019 | 2 |
| 2023 | 1 |
| 2026 | 1 |
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\" = 'SC' 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" = 'SC' 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 ATL86LA035Accident · No injuriesLimited investigationFinal reportCessna 182J · Bishopville, SCDuring an attempt to make a direct crosswind landing at a private grass airstrip, the plt allowed the acft to drift off the left side of the rwy where it nosed over in a plowed fld.NTSB ATL85LA212Accident · No injuriesLimited investigationFinal reportCessna 182C · Lugoff, SCThe plt transported a load of skydivers to alt & was returning to the airstrip. During arrival, he decided to practice a simulated eng out landing. While on an apch with full flaps, the plt elected to slip the acft. As he was transitioning from a side slip to…NTSB ATL85LA152Accident · No injuriesLimited investigationFinal reportCessna 305A · No.Myrtle Bch, SCAfter a banner pickup the plt was instructed by company group and crew to release the banner due to a fouled pickup. The banner was released during a steep climb out altitude. As the banner was released the plt lost directional control of the acft & crashed…