# NTSB investigations: Continental IO-240-B, 2008

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 WPR09FA062](https://openairdocs.org/ntsb/WPR09FA062.md): Diamond DA 20-C1 · Alamo Lake State Park, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 20, 2008 · N4196M · Substantial damage
  > The pilot's failure to maintain control during the performance of a maneuver and his failure to recover from the subsequent aerodynamic stall and spin.
- [NTSB DFW08TA225](https://openairdocs.org/ntsb/DFW08TA225.md): Diamond Aircraft Industries DA-20-C-1 · Pueblo, CO · Accident · Serious injuries · Final report · Sep 8, 2008 · N939DA · Substantial damage
  > The student pilot's inability to maintain aircraft control due to an encounter with wake turbulence from a preceding larger aircraft. Contributing to the accident was the instructor pilot's failure to intervene.
- [NTSB DEN08CA067](https://openairdocs.org/ntsb/DEN08CA067.md): Diamond Aircraft Industries DA 20-C1 · Pueblo, CO · Accident · No injuries · Data collection · Final report · Mar 21, 2008 · N954DA · Substantial damage
  > the failure of the student pilot, and then the flight instructor to maintain aircraft control during the landing. Contributing factors were the flight instructor's delayed remedial action, and the crosswind conditions.
- [NTSB NYC08LA116](https://openairdocs.org/ntsb/NYC08LA116.md): Diamond Aircraft Industries DA 20 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Mar 1, 2008 · N859MS · Substantial damage
  > A loss of engine power for undetermined reasons.

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

This list as a web page: https://openairdocs.org/ntsb?engine=17177&year=2008

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