OpenAirDocs.org

NTSB investigations: Continental TSIO-520 series

60 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Loss of control - on ground/water”. 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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 LAX84LA030Accident · No injuriesLimited investigationFinal reportCessna 402B · Twentynine Palm, CAThe acft was landed in a westerly direction on a state highway. During the landing roll, the acft's right main gear went off the pavement onto a soft, sandy shoulder area. Subsequently, the plt lost control, the acft hit a berm & the gear collapsed. The plt…Oct 23, 1983 · N52LL · Substantial damageNTSB ANC83LA057Accident · No injuriesLimited investigationFinal reportCessna TU206G · Glennallen, AKThe acft collided with a snowbank and ground looped during landing on a snow covered narrow runway. The pilot had been inactive in flying for several years and had recently purchased the accident acft. He had 9 hours dual and 3 hours solo in this acft. He…Mar 13, 1983 · N5102X · Substantial damageNTSB CHI83LA132Accident · No injuriesLimited investigationFinal reportCessna 210 · Huntley, ILThe pilot stated he was aware of the cross wind so he used only 10 degrees of flaps. The acft began to drift while landing on runway 31. The pilot said he was holding 80 KTS on approach and as he started to flare the acft touched down hard on the rt main gear…Mar 10, 1983 · N2558S · Substantial damageNTSB CHI83LA053Accident · No injuriesLimited investigationFinal reportCessna T210 · Frankfort, ILAfter touchdown the right wing of the aircraft suddenly lifted, directional control was lost and the aircraft struck a row of trees.Dec 8, 1982 · N6195Y · Substantial damageNTSB DEN83LA028Accident · No injuriesLimited investigationFinal reportCessna T188C · Santa Rita, MTAircraft nosed over during landing. Aircraft was swerving left after brake application. More braking was used and aircraft nosed over.Dec 1, 1982 · N2066J · Substantial damageNTSB FTW82DA303Accident · No injuriesFinal reportCessna T21OM · Los Lunas, NMDuring arrival, the pilot landed on a wet runway while in a light crosswind from the right. During the landing roll-out, the aircraft drifted off the left side of the runway. After departing the runway, the nose and left main gear hit a concrete gutter and…Jul 29, 1982 · N761JP · Substantial damageNTSB LAX82DA251Accident · No injuriesFinal reportCessna P-210N · Reno, NVThe aircraft veered off the runway during landing. The weather was VMC and no flight plan was filed. The landing was on runway 16 and the wind was from 300 degrees at 14 knots. The pilot did not file an accident report.Jul 10, 1982 · N732XH · Substantial damageNTSB ATL82DA172Accident · No injuriesFinal reportCessna 402C · North Myrtle Be, SCThe pilot made a VOR approach to runway 05, but was unable to see well enough at the mda to land. He was informed that other aircraft had previously landed on runway 23 and had reported better visibility. The pilot then requested and was vectored for an ILS…Jun 18, 1982 · N69SC · Substantial damageNTSB DEN82DA096Accident · No injuriesFinal reportCessna TU206G · Price, UTThe aircraft encountered a dust devil shortly after touchdown during a landing on an unimproved area. The pilot reported that the dust devil moved the aircraft to the right and into a ditch.May 25, 1982 · N878AH · Substantial damageNTSB SEA82DA021Accident · No injuriesFinal reportCessna 340A · Sunriver, ORThe instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…Jan 28, 1982 · N4604N · Substantial damage