# NTSB investigations: Diamond Aircraft Ind DA20-A1, 1999

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 MIA99FA246](https://openairdocs.org/ntsb/MIA99FA246.md): Diamond Aircraft Industries DA20-A1 · Cedar Key, FL · Accident · No injuries · Field investigation · Final report · Sep 4, 1999 · N196DA · Substantial damage
  > The pilot's failure to follow the checklist (turn Fuel Valve-On, and activate electric fuel boost pump) and the pilot's decision to continue flight with a known unairworthy condition (illumination of low fuel pressure warning light on takeoff roll) with…
- [NTSB LAX99LA264](https://openairdocs.org/ntsb/LAX99LA264.md): Diamond Aircraft Industries Katana DA 20-A1 · San Carlos, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1999 · N854DF · Substantial damage
  > The release of the aircraft's left canopy latch following takeoff resulting in the subsequent opening of the canopy in flight. The opened canopy resulted in a degradation of aircraft control and the subsequent hard landing.
- [NTSB NYC99LA176](https://openairdocs.org/ntsb/NYC99LA176.md): Diamond Aircraft Industries DA 20-A1 · Sanford, ME · Accident · No injuries · Limited investigation · Final report · Jul 15, 1999 · N404EC · Substantial damage
  > The pilot's failure to maintain control of the airplane
- [NTSB DEN99LA060](https://openairdocs.org/ntsb/DEN99LA060.md): Diamond Aircraft Industries DA 20-A1 · Coyote, NM · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 1999 · N528SS · Destroyed
  > The pilot-in-command's inadvertent flight into adverse weather, and his continued flight into instrument meteorological conditions. Factors were his failure to obtain an updated recorded weather briefing, the existing weather conditions which included snow,…
- [NTSB DEN99LA048](https://openairdocs.org/ntsb/DEN99LA048.md): Piper PA-28-235 · Provo, UT · Accident · Serious injuries · Limited investigation · Final report · Mar 6, 1999 · N4312A · 2 aircraft · Destroyed
  > The pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…

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

This list as a web page: https://openairdocs.org/ntsb?model=2990000&year=1999

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