NTSB investigations: Continental O-470 series, 2017, CA

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, 2017, CA per year, 1964–2026: 657 cases
196427
196533
196627
196737
196817
196923
197024
197123
197216
197318
197416
197522
197612
197715
197821
197921
198015
198110
19828
198314
198414
19854
198610
19879
19887
19896
199014
199114
19928
19935
19943
19956
19967
199710
19986
19993
20002
20011
200210
20039
20046
20059
20067
20077
20082
20094
20107
20114
20125
20135
20146
20154
20169
20175
20186
20195
20203
20211
20223
20233
20258
20261

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\") = 2017
    AND c.\"eventStateOrRegion\" = 'CA' 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 GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.Sep 27, 2017 · N9346G · Substantial damageNTSB WPR17LA160Accident · No injuriesLimited investigationFinal reportCessna 182L · Arbuckle, CAThe pilot’s delayed decision to abort the takeoff and his failure to properly conduct a rejected takeoff, which resulted in a runway overrun.Jul 22, 2017 · N42143 · Substantial damageNTSB GAA17CA367Accident · Minor injuriesData collectionFinal reportCessna 182 · San Martin, CAThe pilot’s failure to attain a proper glidepath on approach for landing, which resulted in an impact with a guard rail and post. Contributing to the accident was the pilot’s failure to ensure that sufficient fuel was onboard for nonlevel flight, which…Jun 25, 2017 · N524BF · Substantial damageNTSB WPR17FA117Accident · 1 fatalField investigationFinal reportCessna 180 · Ventura, CAThe pilot's abrupt and substantial pullup maneuver while flying the airplane above the maneuvering speed, which resulted in an in-flight breakup. The reason for the pilot's maneuver could not be determined based on the available evidence.Jun 1, 2017 · N3683C · DestroyedNTSB GAA17CA230Accident · No injuriesData collectionFinal reportCessna 180 · Manchester, CAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the total loss of engine power.Apr 12, 2017 · N7945V · Substantial damage