NTSB investigations: Continental O-470 series, 2003, AZ

6 cases on aircraft whose registry engine model is Continental O-470 series. 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

19642026
NTSB investigations: Continental O-470 series, 2003, AZ per year, 1964–2026: 187 cases
19646
19654
196610
19678
19683
19695
19702
19714
19724
19733
19746
19752
19767
19772
19786
19795
19802
19813
19825
19836
19841
19853
19861
19874
19885
19891
19903
19912
19924
19934
19945
19951
19971
19982
20002
20015
20024
20036
20042
20064
20073
20082
20092
20101
20113
20121
20132
20142
20152
20162
20171
20183
20191
20201
20211
20221
20232
20252
20262

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.\"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'))
  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 LAX03CA272Accident · No injuriesData collectionFinal reportCessna 182J · Marble Canyon, AZthe failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.Aug 31, 2003 · N2898F · Substantial damageNTSB LAX03CA249Accident · No injuriesData collectionFinal reportCessna 180 · St. Johns, AZThe pilot's inadequate compensation for a crosswind condition that resulted in a loss of directional control and ground loop. The crosswind was a contributing factor.Jul 31, 2003 · N2935A · Substantial damageNTSB 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 LAX03LA143Accident · No injuriesLimited investigationFinal reportCessna 180A · Scottsdale, AZThe failure of a main landing gear axle bolt, and the subsequent separation of the right main landing gear wheel from the gear strut during the landing roll, which resulted in a collapse of the right main landing gear.Apr 26, 2003 · N9759B · Substantial damageNTSB LAX03FA066Accident · 2 fatalField investigationFinal reportCessna 182H · Parker, AZfailure of both pilot's to see and avoid one another while maneuvering in the traffic pattern. A factor in the accident was the inability of the Cessna pilot to communicate on the CTAF frequency due to the limitations of his radios.Jan 11, 2003 · N8567S · 2 aircraft · Destroyed