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

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, 2014, 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\") = 2014
    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 WPR15CA047Accident · No injuriesData collectionFinal reportCessna 182Q · San Luis Obispo, CAThe pilot's failure to maintain airplane control during the landing flare with a crosswind.Nov 23, 2014 · N97347 · Substantial damageNTSB WPR14CA268Accident · Minor injuriesData collectionFinal reportCessna L19 - A · Firebaugh, CAThe pilot's inadequate compensation for the wind conditions in the landing area, which resulted in a loss of directional control and encounter with soft terrain and vegetation.Jun 25, 2014 · N5264G · Substantial damageNTSB WPR14CA241Accident · No injuriesData collectionFinal reportCessna 180H · Hesperia, CAThe pilot's failure to maintain directional control during the landing roll.Jun 7, 2014 · N73BT · Substantial damageNTSB WPR14LA208Accident · No injuriesLimited investigationFinal reportCessna 182P · Mammoth Lakes, CAThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to carburetor icing.May 24, 2014 · N21048 · Substantial damageNTSB WPR14CA184Accident · No injuriesData collectionFinal reportCessna 180D · Murieta, CAThe pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.May 3, 2014 · N8603X · Substantial damageNTSB WPR14LA117Accident · Serious injuriesLimited investigationFinal reportBeech A45 · Hollister, CAThe total loss of engine power during initial climb due to fuel starvation and the pilot’s inadequate preflight inspection and improper fuel management.Feb 22, 2014 · N666 · Substantial damage