# NTSB investigations: Continental IO-520-F: Airframe/component/system failure/malfunction

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 ANC98FA069](https://openairdocs.org/ntsb/ANC98FA069.md): Cessna 207A · Juneau, AK · Accident · No injuries · Field investigation · Final report · Jun 9, 1998 · N96AK · Substantial damage
  > The failure of company maintenance personnel to properly install a wire bundle clamp; chafing, electrical arcing, and subsequent leaking of a fuel line, which resulted in an in-flight fire. A factor associated with the accident was company maintenance…
- [NTSB ANC86LA158](https://openairdocs.org/ntsb/ANC86LA158.md): Cessna 207A · Mountain Villag, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1986 · N9736M · Substantial damage
  > The airline transport pilot who is also a certificated airframe and powerplant mechanic elected to defer brake repairs until the end of the flying day. The fatigued right brake line failed before the end of the day's flying activity. During lndg the brakes…
- [NTSB ANC85IA083](https://openairdocs.org/ntsb/ANC85IA083.md): Cessna 207A · Cape Simpson, AK · Incident · No injuries · Incident investigation · Final report · May 13, 1985 · N9943M · Minor damage
  > # 6 Cyl exploded in flt due to connecting rod coming apart. Post-accident insp revealed that nut had back off due to inadequate torque & no cotter key installed in nut.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17237')
    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" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17237&occurrence=130

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