# NTSB investigations: Diamond Aircraft Ind DA20-C1, 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 NYC08CA313](https://openairdocs.org/ntsb/NYC08CA313.md): Diamond Aircraft Industry DA 20-C1 · Stevensville, MD · Accident · No injuries · Data collection · Final report · Sep 11, 2008 · N644DC · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff.
- [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 MIA08LA156](https://openairdocs.org/ntsb/MIA08LA156.md): Diamond DA-20-C1 · Peachtree City, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 1, 2008 · N227RD · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB MIA08CA148](https://openairdocs.org/ntsb/MIA08CA148.md): Diamond DA20-C1 · Norfolk, VA · Accident · No injuries · Data collection · Final report · Jul 13, 2008 · N956CT · Substantial damage
  > The flight instructor's inadequate supervision of the student pilot while taxiing for takeoff. A factor contributing to the accident was the student pilot's failure to maintain a visual lookout.
- [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 SEA08LA090](https://openairdocs.org/ntsb/SEA08LA090.md): Diamond Aircraft Industries DA 20-C1 · Spanish Fork, UT · Accident · No injuries · Limited investigation · Final report · Mar 9, 2008 · N765DC · Substantial damage
  > The fatigue failure of the nose wheel fork assembly attachment stud/bolt during takeoff initial climb, and the collapse of the nose gear during landing.
- [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.aircraft_model_code IN ('2990001'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2990001&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.
