NTSB investigations: Continental TSIO-520 series, 2008, CA

6 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

19662026
NTSB investigations: Continental TSIO-520 series, 2008, CA per year, 1966–2026: 245 cases
19661
19691
19711
19721
19742
19751
19767
19774
19784
19799
198010
19818
19829
19837
19847
19857
19863
19877
19885
19894
19903
19915
19922
19932
19941
19953
19964
19971
19982
19993
20002
20017
20026
20039
20044
20055
20069
20079
20086
20094
20103
20115
20127
20134
20152
20162
20177
20185
20193
20204
20212
20223
20238
20242
20251
20262

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.\"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 ('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 WPR09CA044Accident · No injuriesData collectionFinal reportCessna T210M · Hanford, CAThe failure of the pilot to use the before-landing checklist and extend the landing gear prior to landing.Nov 22, 2008 · N732XS · Substantial damageNTSB LAX08LA292Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CAA loss of engine power while maneuvering due to the disintegration of the number two main bearing, which resulted in a fracture of the crankshaft. Contributing to the accident was inadequate maintenance.Sep 10, 2008 · N6278C · Substantial damageNTSB OPS08IA013Incident · No injuriesIncident investigationFinal reportPiper PA-46 · Fresno, CAThe tower controller's failure to ensure the runway was clear before allowing Skywest 69R to land. Factors contributing to the incident were the Malibu pilot's and tower controller's unfamiliarity with the airport layout.Aug 29, 2008 · N9219T · 2 aircraft · No damageNTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.Aug 20, 2008 · N818CT · Substantial damageNTSB SEA08LA084Accident · Serious injuriesLimited investigationFinal reportRaytheon B36TC · Mammoth, CAA loss of engine power for undetermined reasons. Contributing to the accident was dense snow covering the level terrain.Mar 3, 2008 · N234MT · Substantial damageNTSB 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 · Destroyed