NTSB investigations: Continental IO-520 series, TX

8 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Loss of control - in flight”. 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

19862026
NTSB investigations: Continental IO-520 series, TX per year, 1986–2026: 8 cases
19861
19891
19911
19951
19961
19981
20011
20051

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 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')
      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\" = 250))
  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 DFW05LA139Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Arcola, TXThe pilot's failure to maintain directional control and airspeed which resulted in an inadvertent stall while attempting a go-around. A contributing factor was the quartering tailwind.May 30, 2005 · N2015A · Substantial damageNTSB FTW01LA187Accident · Serious injuriesLimited investigationFinal reportBeech F33C · Sugarland, TXthe pilot's inadvertent stall of the airplane during the base/final approach for landing which resulted in a collision with terrain. A contributing factor was the pilot's diverted attention to an open cockpit door.Aug 21, 2001 · N133DA · Substantial damageNTSB FTW98FA192Accident · 3 fatalField investigationFinal reportBeech BE-58 · Kerrville, TXThe non-instrument rated pilot's failure to maintain aircraft control due to spatial disorientation. Factors were the dark night conditions, overcast skies, and the pilot's inadequate preflight planning.Apr 26, 1998 · N60UU · DestroyedNTSB FTW96FA120Accident · 1 fatalField investigationFinal reportBeech A36 · Katy, TXa loss of control due to pilot incapacitation for undetermined reasons. A factor related to the pilot's injuries was the lack of shoulder harness restraint.Feb 20, 1996 · N2TC · Substantial damageNTSB FTW95LA193Accident · No injuriesLimited investigationFinal reportBeech F33A · Houston, TXThe pilot's inadequate compensation for the wind conditions. A factor was the crosswind.May 7, 1995 · N18413 · Substantial damageNTSB DEN91FA037Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Olton, TXThe pilot exceeded the design stress limits of the airframe and the performance of aerobatics at an altitude insufficient for recovery.Jan 26, 1991 · N4035B · DestroyedNTSB FTW89DRG07Accident · No injuriesFinal reportCessna A188B · La Coste, TXThe pilot's failure to attain sufficient airspeed for flight at departure.May 20, 1989 · N731ST · Substantial damageNTSB 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