NTSB investigations: Continental IO-520 series, 1987

6 cases on aircraft whose registry engine model is Continental IO-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 per year

19822026
NTSB investigations: Continental IO-520 series, 1987 per year, 1982–2026: 213 cases
19828
198314
198414
19856
198610
19876
19888
19898
19906
19914
19928
19936
19945
19958
199613
19975
199812
199911
20008
20015
20027
200310
200411
200511
20064
20075

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\") = 1987
    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')
      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 DEN87DTE04Accident · No injuriesFinal reportCessna A188B · Stonington, COThe plt reported that he had completed an aerial application flt and landed on a road to visit with a customer. He said that the left MLG tire blew out during landing and the acft ground looped. The left MLG collapsed during the ground loop and both wings…Aug 25, 1987 · N731GG · Substantial damageNTSB ANC87LA099Accident · No injuriesLimited investigationFinal reportCessna 185 · King Salmon, AKThe pilot stated that during takeoff on the river he lost directional control of the aircraft causing the aircraft to collide with a boat dock.Jul 18, 1987 · N1977U · Substantial damageNTSB ANC87LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Pt. Mackenzie, AKThe pilot stated that during the takeoff roll on the beach the aircraft struck a sand bar causing the aircraft to nose over on the beach.Apr 30, 1987 · N51205 · Substantial damageNTSB ANC87LA063Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe pilot stated that during the landing roll he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 28, 1987 · N2223T · Substantial damageNTSB DEN87LA072Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Greeley, CODuring landing roll, after a normal pattern, an unusual noise was heard by the pilot. He described it as a 'thud' or a loud 'pop' noise. The pilot lost directional control and departed the runway to the left. The landing gear was severely damaged. No prempact…Mar 26, 1987 · N8793V · Substantial damageNTSB ANC87LA042Accident · No injuriesLimited investigationFinal reportCessna 185F · Anchorage, AKThe pilot was unable to start his airplane due to a weak battery and elected to start the unsecured acft's engine by hand-propping. The engine started and the airplane accelerated away from its tie-down area and into a building before the pilot could reenter…Mar 1, 1987 · N2449J · Substantial damage