# Fatal, Final NTSB investigations: Aerovodochody L-29 DELFIN

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 WPR22FA350](https://openairdocs.org/ntsb/WPR22FA350.md): Aerovodochody L-29 Delfin · Reno, NV · Accident · 1 fatal · Class 3 · Field · Final report · Sep 18, 2022 · N129MM · Destroyed
  > The pilot’s in-flight incapacitation due to G-induced loss of consciousness, which resulted in a subsequent impact with terrain.
- [NTSB CEN13FA100](https://openairdocs.org/ntsb/CEN13FA100.md): Aerovodochody L-29 Delfin · Combine, TX · Accident · 2 fatal · Field investigation · Final report · Dec 13, 2012 · N29NR · Substantial damage
  > The airplane's impact with terrain for reasons that could not be determined during examination of the available evidence because of extensive impact damage and postimpact fire.
- [NTSB WPR09LA325](https://openairdocs.org/ntsb/WPR09LA325.md): Aero Vodochody L-29 · Tehachapi, CA · Accident · 2 fatal · Limited investigation · Final report · Jul 4, 2009 · N97869 · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while performing a low altitude maneuver.
- [NTSB NYC08LA224](https://openairdocs.org/ntsb/NYC08LA224.md): Aero Vodochody Aero. Works L-29 Delfin · Millville, NJ · Accident · 2 fatal · Limited investigation · Final report · Jun 22, 2008 · N29DJ · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a clogged fuel filter that was not identified due to the pilot's inadequate preflight inspection.
- [NTSB SEA97LA011](https://openairdocs.org/ntsb/SEA97LA011.md): Aero Vodochody Aero. Works L-29 · Tillamook, OR · Accident · 2 fatal · Limited investigation · Final report · Oct 11, 1996 · N7150A · Destroyed
  > failure of the pilot to maintain control of the aircraft, while maneuvering behind an F4F aircraft. The lack of altitude for a recovery was a related factor.
- [NTSB FTW74AF009](https://openairdocs.org/ntsb/FTW74AF009.md): Aero Comdr 690A · Alex, OK · Accident · 2 fatal · Closed · Aug 22, 1973 · N333CA · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=0564310&status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
