# NTSB investigations: Franklin 6A4165 series, OH

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 GAA16CA221](https://openairdocs.org/ntsb/GAA16CA221.md): Stinson 108 · Batavia, OH · Accident · No injuries · Data collection · Final report · May 6, 2016 · N8068K · Substantial damage
  > The pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing to the accident was the pilot's incorrect brake application during the runway excursion, which resulted in a nose over.
- [NTSB ATL87LA015](https://openairdocs.org/ntsb/ATL87LA015.md): Stinson 108-2 · Ada, OH · Accident · No injuries · Limited investigation · Final report · Nov 2, 1986 · N996D · Substantial damage
  > Plt stated that elevator control was lost during the landing roll. Acft nosed over inverted and received substantial damage. Investigation revealed that the lower cable to elevator bellcrank forward turnbuckle was fractured. Bellcrank was badly corroded. Last…
- [NTSB CHI76FEK17](https://openairdocs.org/ntsb/CHI76FEK17.md): Stinson 108-3 · Delaware, OH · Accident · No injuries · Closed · Jun 2, 1976 · N6898M · Substantial damage
- [NTSB CHI76FEI27](https://openairdocs.org/ntsb/CHI76FEI27.md): Univ Acft 108-2 · Thompson, OH · Accident · No injuries · Closed · Apr 7, 1976 · N442C · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?engine=27025&state=OH

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