Skip to content

NTSB investigations: Continental TSIO-520 series, IN

20 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

Where

Latest cases

Query with SQL

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" = 'IN' 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 ('17040')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'IN' 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 ('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.

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" = 'IN' 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 ('17040'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN19LA225Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T188 · Knox, INThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control.Jul 14, 2019 · N2863J · Substantial damage NTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…Dec 17, 2017 · N761YZ · Destroyed NTSB CEN14LA327Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Indianapolis, INA loss of engine power due to fuel starvation, which resulted from the pilot's failure to monitor the fuel level and switch tanks in a timely fashion.Jun 27, 2014 · N207AB · Substantial damage NTSB CEN10LA450Accident · No injuriesLimited investigationFinal reportCessna T188C · Montezuma, INThe total loss of engine power due to an insufficient fastener preload that led to the failure of the No. 2 connecting rod assembly.Jul 29, 2010 · N2085J · Substantial damage NTSB CHI07FA022Accident · 5 fatalField investigationFinal reportCessna T303 · Mill Creek, INThe pilot became spatially disoriented and as a result failed to maintain control of the airplane. Factors associated with the accident were the instrument meteorological conditions aloft and the pilot being fatigued.Nov 14, 2006 · N611BB · Destroyed NTSB CHI06CA118Accident · No injuriesData collectionFinal reportCessna T210L · Henryville, INThe pilot selected an empty fuel tank during the approach which resulted in fuel starvation and subsequent loss of engine power. A factor associated with the accident were the trees that the airplane contacted during the forced landing.Apr 21, 2006 · N732AN · Substantial damage NTSB CHI06LA080Accident · No injuriesLimited investigationFinal reportCessna 421C · Indianapolis, INThe main landing gear malfunctioned and failed to extend during the landing approach for an undetermined reason, which resulted in a main gear up landing.Feb 18, 2006 · N98507 · Substantial damage NTSB CHI03FA291Accident · 3 fatalField investigationFinal reportBeech B36TC · Uniondale, INThe pilot's inaccurate preflight planning which resulted in an inadequate fuel supply and subsequent fuel exhaustion. Factors associated with the accident were the low ceiling, dark night conditions, and the utility pole which the airplane contacted during…Sep 2, 2003 · N8018J · Destroyed NTSB CHI94LA047Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Ashley, INInadequate aircraft preflight by the pilot-in-command. A factor relating to this accident is the dark night.Dec 9, 1993 · N210MD · Substantial damage NTSB CHI91LA101Accident · No injuriesLimited investigationFinal reportCessna T210N · Elwood, INThe pilot's improper use of the fuel selector which resulted in fuel starvation. A related factor was: soft terrain in the emergency landing area.Feb 27, 1991 · N210MS · Substantial damage NTSB CHI89LA037Accident · No injuriesLimited investigationFinal reportCessna P210R · Grovertown, INDec 27, 1988 · N5457A · Substantial damage NTSB CHI88LA072Accident · No injuriesLimited investigationFinal reportCessna P210 · Indianapolis, INWhile landing on the ice-covered runway, the pilot failed to stop his aircraft before the end of the runway. The aircraft ran off the departure end of the runway, encountered soft terrain and nosed over. The pilot had received two partial weather briefings,…Mar 3, 1988 · N4741K · Substantial damage NTSB CHI87LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Evansville, INDuring landing roll-out the left main and nose gear collapsed. The pilot stated in his report that he does not recall touching any switches on roll-out. However, upon exiting the aircraft, the pilot reported that the landing gear relay was tripped open and…May 2, 1987 · N6401H · Substantial damage NTSB CHI85LA147Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Flora, INPilot dept danville, IL no flt plan for indianapolis, IN enroute he encountered IFR conditions and reversed course. The pilot then lost all electrical power on acft. Flying north, pilot saw Flora muni thru breaks in overcast. Pumped gear down and only…Mar 23, 1985 · N732RX · Destroyed NTSB CHI84IA404Incident · No injuriesIncident investigationFinal reportBeech A36TC · Lafayette, INThe plt reported that when he leveled off at 3000 ft MSL, the aux fuel boost switch was still on, so he switched it 'off.' When the switch was turned off, the eng began to run with a bit of vibration, so he returned the switch to 'on' & left it in that…Sep 24, 1984 · N305MM · Minor damage NTSB CHI83LA335Accident · No injuriesLimited investigationFinal reportCessna T210L · Indianapolis, INDuring landing the acft reportedly porpoised two times on the nose gear. The flange on the nose gear tire rim had piecesbroken off of the flange in several places. The landing was also made with full tip tanks. The fuel selector is placarded prohibiting this…Jun 10, 1983 · N30115 · Substantial damage NTSB CHI82DA190Accident · No injuriesFinal reportCessna 310R · Evansville, INAfter the aircraft had touched down from an ILS approach, tower personnel asked the pilot if he could make the first turnoff. Shortly after that, the right gear collapsed when the landing gear rod assembly, pn 0840125-15, failed. A metallurgical examination…May 25, 1982 · N3232M · Substantial damage NTSB CHI79FEX22Accident · No injuriesClosedCessna 340 · Columbus, INApr 21, 1979 · N69546 · Substantial damage NTSB CHI78FEX27Accident · Serious injuriesClosedCessna 402B · Indianapolis, INJul 28, 1978 · N4167G · Destroyed NTSB CHI78FEX15Accident · No injuriesClosedCessna T210M · Belle Union, INMay 8, 1978 · N732TC · Substantial damage