# NTSB investigations: Diamond Aircraft Ind DA20-A1: Miscellaneous/other

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 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 FTW99LA062](https://openairdocs.org/ntsb/FTW99LA062.md): Diamond Aircraft Industries DA 20-A1 · Tomball, TX · Accident · No injuries · Limited investigation · Final report · Oct 1, 1998 · N527SS · Substantial damage
  > The pilot's failure to follow the checklist and secure the canopy, which resulted in the canopy separating from the airplane during takeoff initial climb. A factor was the pilot's failure to detect the canopy warning light prior to takeoff.
- [NTSB MIA97LA240](https://openairdocs.org/ntsb/MIA97LA240.md): Diamond Aircraft Industries DA 20-A1 · Concord, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1997 · N560SS · Substantial damage
  > The failure of the pilot to latch the canopy closed prior to takeoff. This resulted in the canopying opening while on approach to land and the pilot was unable to maintain altitude due to the excessive drag.

## 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.aircraft_model_code IN ('2990000')
    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" = 430))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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