# Final NTSB investigations: Istenes OLDFIELD BABY LAKES

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 CHI84LA215](https://openairdocs.org/ntsb/CHI84LA215.md): Istenes Oldfield Baby Lakes · Middlefield, OH · Accident · Serious injuries · Limited investigation · Final report · May 27, 1984 · N120R · Destroyed
  > It was reported that the acft had performed two tight left traffic pattern turns after takeoff. On the downwind turn the acft banked 60 degrees. The plt lost control of the acft and crashed in a wooded area. It was reported that the plt had no previous…
- [NTSB CHI82DA172](https://openairdocs.org/ntsb/CHI82DA172.md): Oldfield Baby Lakes · Middlefield, OH · Accident · No injuries · Final report · May 16, 1982 · N120R · Substantial damage
  > The aircraft quit during takeoff climb. The pilot reversed course and the engine started again for a short period then stopped. The pilot attempted to land on a taxiway but hit the raised lip of the taxiway. The right main landing gear failed. No preimpact…

## 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."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 ('0564523'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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