OpenAirDocs.org

NTSB investigations: Continental O-470 series, 2003

9 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

19822026

Where

Open the map

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\") = 2003
    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 LAX03CA296Accident · No injuriesData collectionFinal reportCessna 182K · Young, AZthe collision with a bull during takeoff.Sep 17, 2003 · N2646R · Substantial damageNTSB SEA03LA190Accident · 2 fatalLimited investigationFinal reportCessna 182 · Challis, IDThe pilot's failure to maintain clearance from trees while maneuvering. Factors include mountainous terrain and trees.Sep 13, 2003 · N5547B · DestroyedNTSB DEN03FA137Accident · 1 fatalField investigationFinal reportCessna 182P · Antonito, COThe pilot's improper in-flight planning/decision and his failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the trees, and the mountainous terrain.Aug 5, 2003 · N1344S · DestroyedNTSB LAX03LA240Accident · Minor injuriesLimited investigationFinal reportCessna 180C · Punkin Center, AZThe pilot's inadequate preflight planning and failure to attain adequate climb rate to ensure clearance from obstacles. The tailwind and high density altitude were factors.Jul 23, 2003 · N767RK · Substantial damageNTSB CHI03LA205Accident · No injuriesLimited investigationFinal reportCessna 182Q · Empire, MIThe pilot's failure to abort the takeoff. A contributing factor to the accident included the pilot not utilizing all available engine power during the entire takeoff. Additional factors were the improper wing flap setting and the cherry-tree orchard.Jul 9, 2003 · N95890 · Substantial damageNTSB SEA03FA092Accident · 1 fatalField investigationFinal reportCessna 180H · Yellow Pine, IDThe pilot's failure to maintain clearance while maneuvering. Trees, a box canyon and rising terrain were factors.May 25, 2003 · N767 · 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 NYC03LA054Accident · 1 fatalLimited investigationFinal reportCessna 182P · So. Charleston, WVThe pilot's failure to perform a go-around prior to touchdown. Factors in the accident were the rising terrain and tail wind.Feb 22, 2003 · N21408 · Substantial damageNTSB FTW03LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Wildorado, TXThe airplane collided with an animal that wandered onto the runway. A contributing factor was sun glare impairing the pilot's view on final approach.Jan 31, 2003 · N3535Y · Substantial damage