# NTSB investigations: Continental TSIO-550-C, TX

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN20LA174](https://openairdocs.org/ntsb/CEN20LA174.md): Cessna T240 · Gonazales, TX · Accident · No injuries · Class 3 · Limited · Final report · May 6, 2020 · N25HE · Substantial damage
  > The pilot's failure to retract the speedbrakes during a delayed go-around attempt, which resulted in a runway excursion.
- [NTSB CEN18LA315](https://openairdocs.org/ntsb/CEN18LA315.md): Columbia Aircraft Mfg LC41-550FG · Dallas, TX · Accident · No injuries · Limited investigation · Final report · Aug 3, 2018 · N2546B · Substantial damage
  > The pilot's inability to maintain directional control during taxi due to excessively worn brake pads and a deflated right main tire.
- [NTSB CEN15LA392](https://openairdocs.org/ntsb/CEN15LA392.md): Cessna T240 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Aug 31, 2015 · N452CS · Substantial damage
  > The total loss of engine power due to fuel starvation, which resulted from the pilot’s inadequate fuel management and the flight instructor’s failure to verify the fuel level and fuel selector position in flight.
- [NTSB CEN11FA141](https://openairdocs.org/ntsb/CEN11FA141.md): Columbia Aircraft Mfg LC41-550FG · Midlothian, TX · Accident · 2 fatal · Field investigation · Final report · Jan 5, 2011 · N1393T · Substantial damage
  > The engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.
- [NTSB CEN11IA146](https://openairdocs.org/ntsb/CEN11IA146.md): Columbia LC41 · Milsap, TX · Incident · No injuries · Incident investigation · Final report · Dec 24, 2010 · N921DZ · Minor damage
  > A total loss of engine power in flight due to a loss of engine oil for reasons that could not be determined during a postaccident teardown examination of the engine.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

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

This list as a web page: https://openairdocs.org/ntsb?engine=17246&state=TX

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
