Fatal NTSB investigations: Continental TSIO-520 series, 2008

8 cases on aircraft whose registry engine model is Continental TSIO-520 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

19682026
Fatal NTSB investigations: Continental TSIO-520 series, 2008 per year, 1968–2026: 397 cases
19681
19721
19731
19741
19762
19772
197810
197910
198011
198111
198213
198310
19849
198510
198611
19879
198810
19892
19903
19919
19925
19934
19948
19956
19964
19978
19984
19994
20004
200111
200212
200320
200413
200510
200616
200711
20088
20093
201013
20118
20129
20139
20146
20153
20167
20179
20187
20194
20208
20217
20223
20236
20245
20255
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\") = 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 ('17040'))
  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 CEN09FA098Accident · 2 fatalField investigationFinal reportPiper PA-46 · Hayden, COThe pilot's loss of situational awareness while maneuvering in adverse weather conditions, resulting in spatial disorientation.Dec 22, 2008 · N46SB · DestroyedNTSB DFW08FA237Accident · 2 fatalField investigationFinal reportCessna 320D · Collinsville, OKThe crews' failure to maintain adequate airspeed, which resulted in an aerodynamic stall close to the ground.Sep 28, 2008 · N4165T · Substantial damageNTSB NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.Sep 27, 2008 · N770CA · DestroyedNTSB MIA08FA177Accident · 1 fatalField investigationFinal reportCessna T310R · Latrobe, PAThe pilot's impairment/incapacitation (cardiovascular) resulting in the pilot being unable to control the airplane.Aug 31, 2008 · N3180M · Substantial damageNTSB DFW08FA080Accident · 2 fatalField investigationFinal reportCessna T210M · Abbeville, LAThe pilot's failure to maintain aircraft control for undetermined reasons. Contributing to the accident were the prevailing clouds, rain, and turbulence.Mar 11, 2008 · N732RR · DestroyedNTSB DEN08FA059Accident · 2 fatalField investigationFinal reportCessna 414A · Benton, KSThe pilot's failure to maintain clearance from the trees. Contributing to the accident was the pilot's flight into known adverse weather conditions and the low clouds and visibility.Feb 17, 2008 · N41LP · DestroyedNTSB LAX08FA058Accident · 4 fatalField investigationFinal reportCessna 340A · Cabazon, CAThe pilot's continued visual flight into instrument meteorological conditions and failure to maintain terrain clearance while en route. Contributing to the accident were clouds and mountainous terrain.Feb 2, 2008 · N354TJ · DestroyedNTSB DEN08WA052Accident · 2 fatalForeign investigationBeech 58P · Cherbourg, FranceJan 23, 2008 · N2326Y · Destroyed