Fatal NTSB investigations: Continental O-470 series, 2005

7 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
Fatal NTSB investigations: Continental O-470 series, 2005 per year, 1964–2026: 527 cases
19649
19655
19662
196710
19682
19696
19707
19712
19725
19734
19742
19754
19766
197710
197825
197915
198012
198112
198215
198319
198416
198512
198613
198712
19886
19898
19909
199110
19926
19936
19947
19959
19963
19973
19988
199910
20003
20018
200211
200319
200415
20057
200616
200719
20085
200911
20105
201112
20127
20137
20146
201512
20168
20174
20185
20197
20203
20216
20224
20235
20246
20252
20264

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.\"highestInjuryLevel\" = 'Fatal'
    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 ANC05FA116Accident · 2 fatalField investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain sufficient altitude/clearance from objects and terrain during cruise flight, which resulted in an in-flight collision with tree-covered terrain.Jul 30, 2005 · N3188C · DestroyedNTSB NYC05FA109Accident · 4 fatalField investigationFinal reportCessna 182Q · Groton, CTThe pilot's failure to maintain aircraft control while executing an ILS (Instrument Landing System) approach to minimums.Jun 27, 2005 · N5155N · DestroyedNTSB NYC05FA100Accident · 1 fatalField investigationFinal reportCessna 182Q · Stockholm, NJThe pilot's failure to maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the ground. Factors in this accident were clouds, and the pilot's spatial disorientation.Jun 19, 2005 · N21005 · DestroyedNTSB 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 IAD05FA040Accident · 2 fatalField investigationFinal reportCessna 182P · West Milford, NJThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel ice, during the initial climb after takeoff.Feb 27, 2005 · N6685M · DestroyedNTSB 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 SEA05FA034Accident · 2 fatalField investigationFinal reportCessna 182R · Monroe, LAThe failure of the pilot manipulating the controls to maintain aircraft control during a night missed approach in instrument meteorological conditions. Factors include a dark night and low ceilings.Jan 11, 2005 · N9474E · Destroyed