NTSB investigations: Continental O-470 series, CA

12 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Overrun”. 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

19842026
NTSB investigations: Continental O-470 series, CA per year, 1984–2026: 12 cases
19841
19862
19871
19921
19931
19941
19951
19961
20021
20031
20071

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\" = 340))
  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 SEA07CA236Accident · No injuriesData collectionFinal reportCessna 182R · Redding, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun and collision with a fence.Aug 27, 2007 · N8280E · Substantial damageNTSB LAX03LA293Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAthe pilot's misjudged speed and distance, and his failure to perform a go-around which resulted in a runway overrun.Sep 20, 2003 · N9921B · Substantial damageNTSB LAX02LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Diego, CAThe pilot's failure to apply continuous brake pressure. Sun glare is a contributing factor.May 17, 2002 · N9031U · Substantial damageNTSB LAX97LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Fallbrook, CAthe pilot's selection of a runway with a tailwind component and his maintaining an excessive airspeed on final approach, which resulted in a late touchdown and a high ground speed.Nov 28, 1996 · N70967 · Substantial damageNTSB LAX96LA079Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fallbrook, CAthe pilot's inadequate preflight planning/preparation (failure to ensuring the flight information publication was current); his selection of the wrong runway for landing; his failure to achieve the proper touchdown point during the landing; and his failure to…Dec 26, 1995 · N97196 · Substantial damageNTSB LAX94LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Watsonville, CAThe pilot's inadequate preflight inspection by failing to remove the pitot tube cover and delay in his remedial action by not beginning to stop the airplane until it was about 1,000 feet before the end of the runway. The soft terrain and the collapsed nose…Jan 31, 1994 · N21106 · Substantial damageNTSB LAX94LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Redding, CAthe pilot's use of an excessive airspeed on final approach, the failure to attain the proper touchdown point on the runway, and, the failure to initiate a go around when it became clear that the aircraft would excessively overshoot the intended touchdown…Oct 31, 1993 · N1085M · Substantial damageNTSB LAX92LA221Accident · No injuriesLimited investigationFinal reportCessna 182E · Lone Pine, CAThe pilot's encounter with a sudden and strong quartering tailwind after landing on a short dirt runway, and the failure of the pilot to select the other airport runway, which was longer and more aligned with the wind, for the approach and landing.May 27, 1992 · N9340X · Substantial damageNTSB LAX87LA166Accident · No injuriesLimited investigationFinal reportCessna 310 · Agua Dulce, CAThe non-multiengine rated pilot attempted to land his multiengine airplane on a 4600 foot runway. The aircraft touched down approximately half way down the runway and slid off the departure end. The aircraft impacted trees after departing the runway.Mar 28, 1987 · N223H · Substantial damageNTSB LAX86LA257Accident · No injuriesLimited investigationFinal reportCessna 182L · Lodi, CAA acft collided with a gravel pile after overrunning the 2,070 ft asphalt rwy. The plt indicated that the wind sock at the arpt was indicating a variable wind direction from 200 deg to 230 deg. The plt elected to land on rwy 12. He stated he would have had…Jun 14, 1986 · N3496R · Substantial damageNTSB LAX86LA116Accident · No injuriesLimited investigationFinal reportCessna 182M · Healdsburg, CAOn February 8, 1986, at 1430 PST a Cessna 182, N91614, overran the landing surface and nosed over at a dirt strip. VMC prevailed at the time. The winds were generally calm with sporadic gusts from the north at approximately 10 knots. There was no indication…Feb 8, 1986 · N91614 · Substantial damageNTSB LAX84FA389Accident · 4 fatalField investigationFinal reportCessna 180 · Randsburg, CAPlt attempted to land on a 1200 ft long airstrip. He landed the acft with a tailwind and touched down aprx 600 ft from the apch end of the rwy. The acft skidded off the right side of the rwy and collided with a caterpillar tractor. The four occupants were…Jul 12, 1984 · N4697B · Destroyed