NTSB investigations: Continental O-470 series, AZ

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

19822026
NTSB investigations: Continental O-470 series, AZ per year, 1982–2026: 6 cases
19821
19881
19931
20001
20021
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\" = 'AZ' 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\" = 200))
  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 LAX04CA200Accident · No injuriesData collectionFinal reportCessna 182K · Phoenix, AZthe pilot's inadequate flare, which resulted in a hard landing. Also causal was the pilot's inadequate recovery from a bounced landing, which resulted in an inadvertent porpoise and collision with a sign.May 1, 2004 · N2493Q · Substantial damageNTSB LAX02LA194Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's inadequate recovery from a bounced landing.Jun 6, 2002 · N94986 · Substantial damageNTSB LAX01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Tucson, AZThe pilot's misjudged landing flare and improper recovery from the bounced landing resulting in the overload failure of the nose gear and the airplane nosing over.Nov 9, 2000 · N9187G · Substantial damageNTSB LAX94LA067Accident · No injuriesLimited investigationFinal reportCessna 182Q · Grand Canyon, AZthe pilot's use of an excessive approach airspeed and an improper bounced landing recovery technique.Dec 2, 1993 · N94596 · Substantial damageNTSB LAX88LA219Accident · No injuriesLimited investigationFinal reportCessna 182M · Flagstaff, AZAt the end of a local flight, the plt was landing in gusting conditions in excess of 30 knots. According to the pilot the approach was faster than normal due to a sick passenger. On touchdown the nosewheel touched first and the airplane began a porpoising…May 27, 1988 · N70618 · Substantial damageNTSB LAX82DA277Accident · No injuriesFinal reportCessna 180 · Goodyear, AZThe left main landing gear of the aircraft broke off during a touch and go landing and the aircraft was damaged further on a subsequent landing. The weather was VMC and no flight plan was filed. The landing gear bolts failed in overload and showed no evidence…Jul 25, 1982 · N2223C · Substantial damage