NTSB investigations: Continental O-470 series, CA

7 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

19862026
NTSB investigations: Continental O-470 series, CA per year, 1986–2026: 7 cases
19862
19871
19921
19951
20031
20041

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 c.\"eventStateOrRegion\" = 'CA' 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')
      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.

NTSB LAX05FA054Accident · 2 fatalField investigationFinal reportCessna 182P · La Mirada, CAthe pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.Dec 19, 2004 · N9187G · Substantial damageNTSB LAX03LA096Accident · No injuriesLimited investigationFinal reportCessna 310 · Palmdale, CAThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude. Factors in the accident were the low ceilings and the dusk light illumination.Feb 24, 2003 · N5202A · Substantial damageNTSB LAX96LA040Accident · 2 fatalLimited investigationFinal reportCessna 180 · Placerville, CAthe pilot's intentional buzzing, his failure to identify an obstruction (inadequate visual lookout), and his failure to maintain adequate altitude/clearance from the obstruction (utility pole). Factors relating to the accident were: dust generated by farm…Nov 4, 1995 · N3358D · DestroyedNTSB LAX92LA210Accident · 1 fatalLimited investigationFinal reportCessna 182A · S.Lake Tahoe, CAThat the pilot-in-command used poor judgment by flying at an unwarranted low altitude and misjudged the clearance between the tree tops and the airplane.May 16, 1992 · N2031G · DestroyedNTSB LAX87FA077Accident · 1 fatalField investigationFinal reportCessna 182Q · Essex, CAUpon reaching his destination the pilot descended to make a message drop. He selected a flight path that was perpendicular to a 55 foot tall, unmarked, electrical power line. During the low pass for the drop the aircraft collided with the electrical wires.…Jan 7, 1987 · N28MB · DestroyedNTSB 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…Nov 23, 1986 · N66039 · DestroyedNTSB 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…Feb 27, 1986 · N7293B · Substantial damage