NTSB investigations: Continental IO-520 series, 2013

59 cases on aircraft whose registry engine model is Continental IO-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, newest first

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\") = 2013
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032'))
  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 WPR13LA189Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Santa Monica, CAThe left main wheel locking up during the landing roll, which resulted in the deflation of the tire, the left main landing gear collapse, and the subsequent loss of control during the runway exit.Apr 12, 2013 · N153NL · Substantial damageNTSB WPR13CA199Accident · No injuriesData collectionFinal reportCessna A185E · Cottonwood, IDThe pilot’s failure to see and avoid an object on the grass airstrip during the takeoff.Apr 7, 2013 · N2303Y · Substantial damageNTSB CEN13CA207Accident · No injuriesData collectionFinal reportBeech A36 · Fort Stockton, TXThe student pilot inadvertently switching the fuel selector to the OFF position and the flight instructor's failure to monitor the student pilot's actions.Mar 27, 2013 · N888TT · Substantial damageNTSB CEN13LA204Accident · No injuriesLimited investigationFinal reportBeech A36 · Cordova, ILA partial loss of engine power for reasons that could not be determined because a postaccident test run of the engine revealed no mechanical failures or malfunctions that would have precluded normal operation.Mar 23, 2013 · N6038R · Substantial damageNTSB ANC13LA032Accident · No injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe overstress fracture and failure of the right wheel/ski arm while taxiing in snow and water-overflow terrain conditions, which resulted in a noseover.Mar 8, 2013 · N185FK · Substantial damageNTSB ANC13LA029Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue fracturing, which resulted in a loss of engine power during cruise flight.Mar 6, 2013 · N1704U · Substantial damageNTSB CEN13LA164Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Morris, ILThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Feb 16, 2013 · N93747 · Substantial damageNTSB CEN13LA132Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Antlers, OKThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jan 7, 2013 · N222EG · Substantial damageNTSB ANC13CA020Accident · No injuriesData collectionFinal reportCessna A185E · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a main landing gear collapse.Jan 5, 2013 · N4538F · Substantial damage