NTSB investigations: Continental O-470 series, AZ

4 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of engine power”. 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, AZ per year, 1984–2026: 4 cases
19841
19871
19881
20021

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\" = 350))
  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 LAX02FA198Accident · Serious injuriesField investigationFinal reportCessna 182Q · Deer Valley, AZa loss of engine power for undetermined reasons during the takeoff initial climb, and, the pilot's failure to maintain an adequate airspeed while maneuvering to return to the runway, which resulted in a stall.Jun 15, 2002 · N33PA · Substantial damageNTSB LAX88LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Ajo, AZThe plt rprtd that while on final apch to land, the eng suddenly lost power. A forced landing was made about 400' short of the rwy. Drg the landing roll, the acft hit a ditch & nosed over. The airplane was disassembled & moved before it was examined by…Jul 18, 1988 · N6223A · Substantial damageNTSB LAX88LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Laveen, AZThe pilot stated that he was ferrying his aircraft three miles to a private strip. Shortly after takeoff, the engine began losing power. The pilot did not think he could make it to the private strip so he attempted a precautionary landing on a dirt road. He…Oct 31, 1987 · N3804D · Substantial damageNTSB LAX84LA185Accident · No injuriesLimited investigationFinal reportCessna 310 · Tucson, AZThe acft was for sale & the plt, who represented himself as being qualified to fly it, was performing a pre-purchase flt. He reported that he initially felt uncomfortable flying this acft although he had prevously owned a Cessna 310. He was unfamiliar with…Feb 20, 1984 · N667R · Substantial damage