NTSB investigations: Continental IO-520 series, 1986, TX

4 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 per year

19642026
NTSB investigations: Continental IO-520 series, 1986, TX per year, 1964–2026: 344 cases
19642
19653
19666
19679
19685
19698
19705
19715
19724
19736
197413
197510
197611
197711
19788
19799
198015
198113
198210
19833
19847
19854
19864
19876
19885
19897
19904
19915
19935
19943
19959
19967
19972
19983
19991
20006
20016
20023
20033
20045
20059
20064
20075
20082
20096
20106
20115
20126
20134
20147
20154
20163
20172
20186
20192
20204
20214
20222
20233
20242
20255
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\") = 1986
    AND c.\"eventStateOrRegion\" = 'TX' 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 ('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 FTW86LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Matagorda Is., TXThe pilot was making a beach landing when the nose wheel struck an object in the sand, causing the nose wheel to collapse and the aircraft to nose over into an inverted position.Aug 17, 1986 · N147ED · Substantial damageNTSB FTW86LA109Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Tahoka, TXThe acft nosed over during a forced landing in a fld following a loss of pwr due to fuel exhaustion. The plt reported that after aprx 9 minutes of flt a total loss of pwr was experienced. The plt selected an open fld in which to land. The nose gear sunk in…Jun 12, 1986 · N5195U · Substantial damageNTSB FTW86LA070Accident · Serious injuriesLimited investigationFinal reportBellanca 17-300 · El Paso, TXThe eng quit due to fuel starvation. The acft had been flown 2.6 hours on the main tanks. Normal operating time on the main tanks is 2.5 hours according to the owner's manual of the Bellanca viking 300 series. At the crash site the main tanks were found empty…Apr 18, 1986 · N4881V · DestroyedNTSB FTW86FRG16Accident · Minor injuriesFinal reportCessna U206F · Mcallen, TXOn 03-05-86 at 0854 CST a Cessna U206F, N8502Q, was substantially damaged on landing rollout at miller international airport in Mcallen, Texas. There was no fire and the pilot received minor injuries when the electronics cargo fell upon him as the aircraft…Mar 5, 1986 · N8502Q · Destroyed