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

6 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, 2009, 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\") = 2009
    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 CEN10FA069Accident · 1 fatalField investigationFinal reportBeech A36 · Eagle Pass, TXThe pilot's decision to continue the approach below minimums without visual references, and subsequent collision with the perimeter fence/terrain.Dec 9, 2009 · N1105N · DestroyedNTSB CEN10LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Refugio, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management. Contributing to the accident was the pilot's failure to follow the correct engine restart checklist.Oct 2, 2009 · N991PP · Substantial damageNTSB CEN09CA347Accident · Minor injuriesData collectionFinal reportCessna 210 · Fredericksburg, TXA total loss of engine power for undetermined reasons.Jun 10, 2009 · N8280M · Substantial damageNTSB CEN09CA342Accident · No injuriesData collectionFinal reportBeech S35 · Decatur, TXBoth pilots' inadequate preflight inspection and failure to identify the presence of dirt and insect larvae in the pitot tube, and the owner-pilot's attempt to turn off the runway and onto the taxiway at an excessive speed during the aborted takeoff.Jun 5, 2009 · N8636Q · Substantial damageNTSB CEN09CA336Accident · No injuriesData collectionFinal reportBeech F33A · Midland, TXThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the inadequate oversight of the flight by the instructor pilot.Jun 3, 2009 · N33UB · Substantial damageNTSB CEN09LA227Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Laredo, TXThe certificated flight instructor's improper fuel management resulting in an engine failure due to fuel starvation. Contributing to the accident was the flight instructor's failure to properly complete the restart checklist.Mar 21, 2009 · N8120R · Substantial damage