# NTSB investigations: Mooney M20A, 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 NYC03LA198](https://openairdocs.org/ntsb/NYC03LA198.md): Mooney M20A · Rockford, OH · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 2003 · N1072B · Destroyed
  > The pilot's failure to maintain the proper altitude/clearance, which resulted in an in-flight collision with a utility wire. The owner's improper decision to allow the airplane to be operated by an uncertificated pilot was also causal.
- [NTSB ATL87LA172](https://openairdocs.org/ntsb/ATL87LA172.md): Mooney M20A · Middlefield, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1987 · N8391E · Substantial damage
  > The acft struck a fence during a forced ldg, following a loss of engine pwr in flight. The plt reported that he had topped off both main fuel tanks prior to departure. About 10 minutes after departure at about 4000 ft MSL, he smelled fuel fumes in the…
- [NTSB CHI74AC035](https://openairdocs.org/ntsb/CHI74AC035.md): Mooney M20A · Summitville, OH · Accident · 1 fatal · Closed · Oct 10, 1973 · N6034X · Destroyed
- [NTSB CHI72FEG03](https://openairdocs.org/ntsb/CHI72FEG03.md): Mooney M20A · Springboro, OH · Accident · Minor injuries · Closed · Jul 23, 1971 · N1057B · Substantial damage
- [NTSB CHI67D0533](https://openairdocs.org/ntsb/CHI67D0533.md): Mooney M20A · Cincinnatti, OH · Accident · No injuries · Closed · Mar 19, 1967 · N8379E · Substantial damage
- [NTSB CHI66D0617](https://openairdocs.org/ntsb/CHI66D0617.md): Mooney 20A · Cleveland, OH · Accident · No injuries · Closed · Feb 26, 1966 · N6034X · Substantial damage
- [NTSB CHI66F0387](https://openairdocs.org/ntsb/CHI66F0387.md): Mooney M20A · Marion, OH · Accident · No injuries · Closed · Oct 23, 1965 · N1081B · Substantial damage
- [NTSB CHI66F0316](https://openairdocs.org/ntsb/CHI66F0316.md): Mooney M20A · W Carrollton, OH · Accident · No injuries · Closed · Sep 23, 1965 · N6090X · Substantial damage
- [NTSB UNK64X2562](https://openairdocs.org/ntsb/UNK64X2562.md): Mooney M20A · Chagrin Falls, OH · Accident · Serious injuries · Closed · Jun 29, 1964 · N1071C · Destroyed
- [NTSB UNK64X0669](https://openairdocs.org/ntsb/UNK64X0669.md): Mooney M20A · Columbus, OH · Accident · Serious injuries · Closed · Feb 23, 1964 · N8149E · 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 ('5870204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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