NTSB investigations: Continental TSIO-520 series, 1982

60 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, 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\") = 1982
    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 DEN82DA032Accident · Minor injuriesFinal reportCessna 210 · Blanding, UTThe pilot reported that the visibility was five miles when he landed. However, according to the airport manager, it was less than one mile with ground fog. During the landing, the left wing struck the ground when the plane touched down short of the runway…Feb 17, 1982 · N4814K · Substantial damageNTSB ATL82FID06Accident · No injuriesFinal reportCessna 402B · Newport News, VAThe pilot stated that during his first ILS approach, the localizer needle fluctuated to the left. He made corrective turns to the left. When he broke out of the clouds at the decision height (dh), he observed the runway to the right and made a missed…Feb 9, 1982 · N5218J · Substantial damageNTSB LAX82FA072Accident · 4 fatalField investigationFinal reportCessna P210N · 6 Nm North Of S, AZThe pilot was advised that VFR to flagstaff was not recommended. He advised the briefer that he had just recently flown from sedona and knew he could return VFR. At about 1938 MST, the plane departed phoenix with no flight plan. While en route, the pilot…Feb 8, 1982 · N731NQ · DestroyedNTSB 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 damageNTSB FTW82AA046Accident · 7 fatalFinal reportRobertson C-402B · Laredo, TXThe acft was observed to be extremely slow throughout the approach & that the plt appeared to be having some difficulty with over-controlling the acft. It then leveled out at 50-80 ft AGL on final over the threshold, entered a nose-high attitude & then…Jan 24, 1982 · N4244Z · DestroyedNTSB SEA82FA032Accident · 4 fatalField investigationFinal reportCessna P210N · Boise, IDAfter takeoff while climbing through 10,000 ft MSL the pilot declared an emergency. The pilot stated he was having vacuum problems and was on partial panel. Salt lake city ARTCC answered his request for guidance to a VFR landing with no gyro vector…Jan 21, 1982 · N4947K · DestroyedNTSB CHI82DA056Accident · No injuriesFinal reportCessna 340A · Near Lansing, MIDuring flight over lake Michigan at 13,000 feet, the pilot noticed that the throttle, mixture and propeller controls to one of the engines began binding. The controls to the other engine remained normal. He descended to 9000 feet and continued at reduced…Jan 19, 1982 · N4140G · Substantial damageNTSB DEN82FA018Accident · 3 fatalField investigationFinal reportCessna T210N · 28 Mi Ene Ogden, UTDuring an IFR flt at 12,000 ft the plt contacted ATC & requested a higher altitude to get out of IMC. He was cleared to climb & maintain 14,000 ft. the plt acknowledged the clearance at 1855 & was not heard from again. Radar contact was lost at 1859.…Jan 16, 1982 · N6520Y · DestroyedNTSB ATL82FKQ09Accident · Minor injuriesFinal reportCessna 414 · Aberdeen, MSThe non-instrument rated pilot crashed about 3 hrs after taking off with 4 1/2 hours of fuel on board. He crashed while attempting an off-airport landing in a large field. The field was located less than half way to his destination. The sheriff reported…Jan 12, 1982 · N7706 · DestroyedNTSB LAX82DVG12Accident · Serious injuriesFinal reportCessna P210N · Napa, CADuring his approach for landing, the pilot became concerned about other aircraft taxiing near the runway. He reported that his landing procedure was interrupted as he was waiting for one of the planes to stop short of the runway. Also, he reported aborting…Jan 9, 1982 · N731NZ · Substantial damage