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

5 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, 2001, 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\") = 2001
    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 LAX02FA041Accident · 2 fatalField investigationFinal reportCessna 182E · Prescott, AZthe pilot's failure to adequately deice the airplane prior to takeoff, which resulted in the airplane's degraded aerodynamic and climb performance capability, failure to maintain an adequate airspeed, and a stall/spin. Contributing factors were the pilot's…Dec 5, 2001 · N3049Y · DestroyedNTSB LAX01LA300Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Cottonwood, AZThe pilot's failure to obtain/maintain a proper descent rate, as well as prematurely starting his decent during nighttime operations, subsequently colliding with 60-foot power lines 4 miles from the airport.Sep 5, 2001 · N3250S · Substantial damageNTSB LAX01LA224Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZThe pilot's improper use of the rudder control to correct for torque and P-factor effects, which resulted in a loss of directional control and an inadvertent ground loop/swerve.Jun 29, 2001 · N7336Q · Substantial damageNTSB LAX01LA155Accident · No injuriesLimited investigationFinal reportCessna 180K · Glendale, AZThe pilot's loss of directional control during the landing roll resulting in a ground loop/swerve and collision with a runway marker sign.Apr 22, 2001 · N66033 · Substantial damageNTSB LAX01LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZthe pilot's failure to attain and maintain a sufficient airspeed, which resulted in an inadvertent stall/mush.Apr 3, 2001 · N21394 · Substantial damage