Fatal NTSB investigations: Continental O-470 series, 2008

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
Fatal NTSB investigations: Continental O-470 series, 2008 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\") = 2008
    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 ERA09FA068Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T4 · Whites Creek, TNThe pilot's failure to feather the left propeller and secure the left engine following the total loss of left engine power, and his subsequent failure to maintain airspeed, lateral, and directional control of the airplane. Contributing to the accident was the…Nov 24, 2008 · N412ES · DestroyedNTSB CEN09LA056Accident · 1 fatalLimited investigationFinal reportCessna 182M · Basalt, COThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in his loss of control of the airplane in flight.Nov 11, 2008 · N71276 · Substantial damageNTSB ANC08FA133Accident · 2 fatalField investigationFinal reportCessna 182 · Juneau, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was the…Aug 10, 2008 · N9350X · DestroyedNTSB SEA08FA175Accident · 2 fatalField investigationFinal reportCessna 180K · Garden City, UTThe pilot's failure to maintain adequate airspeed, which led to an aerodynamic stall/spin.Aug 9, 2008 · N63217 · Substantial damageNTSB DFW08FA131Accident · 1 fatalField investigationFinal reportCessna 182 · Black Hawk, COThe loss of engine power due to induction icing. A contributing factor was the pilot's decision to continue flight in conditions favorable for structural and induction-system icing.May 8, 2008 · N8553S · Substantial damage