NTSB investigations: Continental IO-520 series, 2006

62 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\") = 2006
    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 LAX06FA129Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Monica, CAThe failure of an aviation maintenance technician to properly torque and cotter pin the number 2 connecting rod bolts at their attach point to the crankshaft, which resulted in the separation of the connecting rod in flight, and complete power loss.Mar 13, 2006 · N16JR · Substantial damageNTSB CHI06FA090Accident · 2 fatalField investigationFinal reportBeech J35 · Holland, MIA lossof engine power due to fuel starvation as a result of the pilot's improper fuel system management and failure to select a tank containing fuel. A factor was the dark night conditions.Mar 7, 2006 · N8271D · Substantial damageNTSB ANC06LA024Accident · No injuriesLimited investigationFinal reportCessna 185 · Ely, NVThe pilot's inadequate compensation for a quartering tailwind while taxiing, which resulted in a loss of control and an on ground encounter with terrain. A factor in the accident was the quartering crosswind.Mar 6, 2006 · N120KM · Substantial damageNTSB SEA06CA059Accident · No injuriesData collectionFinal reportBeech V35B · Burns, ORThe pilot's failure to maintain clearance from the terrain during the takeoff sequence. Factors include his inadequate removal of snow and ice from the wings prior to takeoff, his improper decision to retract the landing gear before it had been positively…Mar 4, 2006 · N3511V · Substantial damageNTSB DFW06LA073Accident · No injuriesLimited investigationFinal reportBeech V35 · San Antonio, TXThe pilot's loss of control while on approach to the runway. Contributing factors were the downdraft and the lack of suitable terrain for the off-airport landing.Feb 20, 2006 · N510LM · Substantial damageNTSB LAX06FA113Accident · Serious injuriesField investigationFinal reportCessna 210M · Long Beach, CAan erroneous low fuel quantity indication that led the pilot to attempt a precautionary landing in a congested and less than ideal location. The erroneous fuel level indication was due to multiple anomalies with the alternator installation that precipitated a…Feb 13, 2006 · N6895B · DestroyedNTSB LAX06FA099Accident · 1 fatalField investigationFinal reportBeechcraft F33A · Buckeye, AZThe student pilot's failure to maintain aircraft control for undetermined reasons.Feb 1, 2006 · N1563A · DestroyedNTSB SEA06CA048Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, IDThe failure of the left main landing gear attaching bolt, which resulted in the left main gear collapsing during the landing roll.Jan 30, 2006 · N2303Y · Substantial damageNTSB ANC06LA017Accident · No injuriesLimited investigationFinal reportCessna TU206G · Cordova, AKThe pilot's selection of unsuitable terrain for takeoff, and his delay in aborting the takeoff, which resulted an overrun and subsequent collision with an embankment. A factor contributing to the accident was the snow-covered airstrip.Jan 18, 2006 · N5371U · Substantial damageNTSB NYC06LA054Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Lexington, KYFailure of the throttle cable. Contributing to the accident was unsuitable terrain for a forced landing.Jan 12, 2006 · N308M · Substantial damageNTSB CHI06LA060Accident · No injuriesLimited investigationFinal reportCessna 310R · St. Charles, MOThe in-flight collision with a duck during cruise flight resulting in a ruptured fuel tank and the strobe/light assembly electrical short resulting in a fire to the right wing tip tank. Contributing factors were the dusk light conditions.Jan 9, 2006 · N310CK · Substantial damageNTSB NYC06FA048Accident · 2 fatalField investigationFinal reportBeech D55 · Dawson, GAThe pilot's failure to maintain sufficient airspeed to preclude a stall, which resulted in an inadvertent stall and loss of control while circling to land. Factors associated with the accident were the pilot's inadequate in-flight planning and weather…Jan 1, 2006 · N8165W · Substantial damage