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

9 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, 2005, 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\") = 2005
    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 LAX06LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAThe failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.Nov 27, 2005 · N3936D · Substantial damageNTSB LAX06CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Torrance, CAthe pilot's excessive taxi speed, and his failure to maintain an adequate clearance from objects.Nov 4, 2005 · N182HG · Substantial damageNTSB LAX06CA010Accident · No injuriesData collectionFinal reportCessna 182B · Mokelumne Hill, CAthe pilot's improper flare resulting in a hard landing. A related factor was gusty wind conditions.Oct 15, 2005 · N2728B · Substantial damageNTSB LAX05CA219Accident · Minor injuriesData collectionFinal reportCessna 180A · Big Bend, CAthe pilot misjudged his clearance altitude above the surface of the lake, resulting in a collision with water.Jun 29, 2005 · N2929C · Substantial damageNTSB LAX05FA175Accident · 2 fatalField investigationFinal reportCessna 182M · Palm Springs, CAThe pilot's inadequate in-flight planning/decision, and his failure to maintain clearance while maneuvering in rising terrain, resulting in an in-flight collision with terrain.May 15, 2005 · N333LP · DestroyedNTSB LAX05LA125Accident · No injuriesLimited investigationFinal reportCessna 182 · Sacramento, CAa fatigue failure of the right side steering link rod for the nose landing gear steering system.Mar 27, 2005 · N5748B · Substantial damageNTSB LAX05FA079Accident · 1 fatalField investigationFinal reportCessna 180 · Adelanto, CAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an attempted go-around, resulting in a loss of control and collision with terrain.Jan 31, 2005 · N2882A · Substantial damageNTSB LAX05LA077Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Chico, CAA loss of engine power during approach to land for undetermined reasons.Jan 27, 2005 · N7337S · Substantial damageNTSB LAX05FA076Accident · Minor injuriesField investigationFinal reportBeech P35 · Willits, CAThe pilot's failure to maintain control of the airplane during an instrument landing approach, resulting in an in-flight collision with trees and terrain. Factors contributing to the accident were turbulence, and the pilot's diverted attention.Jan 26, 2005 · N222V · Substantial damage