# NTSB investigations: Cessna 140A, 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 ATL87FA006](https://openairdocs.org/ntsb/ATL87FA006.md): Cessna 140A · Hamilton, OH · Accident · No injuries · Field investigation · Final report · Oct 19, 1986 · N9612A · 2 aircraft · Substantial damage
  > The Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft…
- [NTSB CHI68F0134](https://openairdocs.org/ntsb/CHI68F0134.md): Cessna 140A · North Canton, OH · Accident · No injuries · Closed · Jul 1, 1967 · N3789V · Substantial damage
- [NTSB CHI67D0210](https://openairdocs.org/ntsb/CHI67D0210.md): Cessna 170 · Canton, OH · Accident · No injuries · Closed · Jun 29, 1966 · N9404A · Destroyed
- [NTSB CHI65D0008](https://openairdocs.org/ntsb/CHI65D0008.md): Cessna 140A · Stow, OH · Accident · No injuries · Closed · Jan 21, 1965 · N5389C · Substantial damage
- [NTSB UNK64X0215](https://openairdocs.org/ntsb/UNK64X0215.md): Cessna 140A · Painsville, OH · Accident · No injuries · Closed · Jan 11, 1964 · N5389C · 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.aircraft_model_code IN ('2071604'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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