NTSB investigations: Continental O-470 series, 1986
6 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 5 |
|---|---|
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 6 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 1 |
| 1998 | 6 |
| 1999 | 4 |
| 2001 | 6 |
| 2002 | 6 |
| 2003 | 9 |
| 2004 | 7 |
| 2005 | 1 |
| 2006 | 6 |
| 2007 | 7 |
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\") = 1986
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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") = 1986
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 LAX87LA352Accident · 2 fatalLimited investigationFinal reportCessna 180K · Lakeport, CAThe plt & his daughter were believed to have depd his pvt airstrip on 11/22/86 or 11/23/86. They were rprtd missing on 11/24/86 & a search was begun, but the acft was not fnd until 8/19/88, when the wreckage was discovered by hunters. The crash site was…NTSB SEA86LA235Accident · 2 fatalLimited investigationFinal reportCessna 182D · Stibnite, IDAfter taking off in mountainous terrain, the pilot prematurely turned on course to a northerly heading, intending to cross over a ridge line. Shortly after the turn, and while flying up a drainage area towards rising terrain, he encountered a downdraft…NTSB ATL86FA129Accident · 1 fatalField investigationFinal reportCessna 182P · Bay Minette, ALThe acft collided with trees during a descent. The plt was attempting to fly below the overcast to determine his location. The plt radioed just prior to his descent to announce his intentions to his destination UNICOM. There were no further communications…NTSB LAX86FUA01Accident · No injuriesFinal reportBeech J35 · Long Beach, CAThe acft collided with an object in flt. The plt reported that his right wing had been struck by what he thought was a large bird. After a safe landing at nearby Long Beach arpt the acft was examined. The rt wing had a hole aft of the leading edge and…NTSB FTW86LPA19Accident · No injuriesFinal reportCessna 182A · Decatur, TXThe acft was damaged in a collision with a power line during a low pass over a field. The acft was landed off arpt in a field after the collision with the wires. Half the rudder and vert fin were separated, the wing was torn and the prop nicked during the…NTSB DEN86LA078Accident · No injuriesLimited investigationFinal reportCessna 182 · Wray, COAccording to the plt, the acft contacted a twr with the nose gear while he was making a visual surveillance of a private airstrip prior to landing. The plt said he diverted to a nearby arpt to land. During landing, fuel from broken fuel lines ignited & the…