NTSB investigations: Continental O-470 series, 2004, 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, 2004, 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\") = 2004
    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 LAX05FA054Accident · 2 fatalField investigationFinal reportCessna 182P · La Mirada, CAthe pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.Dec 19, 2004 · N9187G · Substantial damageNTSB LAX05FA023Accident · 4 fatalField investigationFinal reportCessna 182Q · Lebec, CAthe pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.Oct 31, 2004 · N95902 · DestroyedNTSB LAX04LA283Accident · No injuriesLimited investigationFinal reportCessna 182A · Petaluma, CAthe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a collapse of the nose landing gear.Jul 11, 2004 · N4094D · Substantial damageNTSB LAX04LA210Accident · Minor injuriesLimited investigationFinal reportDowner Bellanca 14-19-2 · Lancaster, CAThe pilot's fuel mismanagement by his failure to follow the recommended procedures for operation of the auxiliary fuel tank, which resulted in fuel starvation and loss of engine power during cruise flight.May 14, 2004 · N7658B · Substantial damageNTSB LAX04CA183Accident · No injuriesData collectionFinal reportCessna 182C · Garberville, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane. Factors in the accident were the terrain induced turbulent conditions, wind shear, a sudden wind shift, and a tailwind.Apr 12, 2004 · N8872T · Substantial damageNTSB LAX04CA147Accident · No injuriesData collectionFinal reportCessna 182E · Sonora, CAthe pilot's inadequate preflight inspection and failure to ensure adequate fuel was aboard, which resulted in fuel exhaustion and loss of engine power.Mar 6, 2004 · N2819Y · Substantial damage