# NTSB investigations: Continental IO-520-BB

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 CEN20LA421](https://openairdocs.org/ntsb/CEN20LA421.md): Beech A36 · Lago Vista, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 28, 2020 · N104RK · Substantial damage
  > The pilot’s mismanagement of the fuel system which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to maintain airspeed which resulted in the airplane exceeding its critical angle of attack…
- [NTSB ERA17FA115](https://openairdocs.org/ntsb/ERA17FA115.md): Ryan Navion · Westhampton Beach, NY · Accident · 2 fatal · Field investigation · Final report · Feb 26, 2017 · N4529K · Destroyed
  > The flight instructor's exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall/spin. Contributing to the accident was the flight instructor's failure to familiarize himself with the flight characteristics of the…
- [NTSB WPR16LA028](https://openairdocs.org/ntsb/WPR16LA028.md): Beech A36 · Lancaster, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 2015 · N78CR · Substantial damage
  > The flight instructor's failure to comply with published instrument approach procedures during an instrument approach in dark night, visual meteorological conditions, which resulted in impact with terrain. Contributing to the accident was the controller's…

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

This list as a web page: https://openairdocs.org/ntsb?engine=17231

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