# Fatal NTSB investigations: Mooney M-18C

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 ATL88FA025](https://openairdocs.org/ntsb/ATL88FA025.md): Mooney M-18C-55 · Camden, OH · Accident · 1 fatal · Field investigation · Final report · Nov 1, 1987 · N4157 · Destroyed
  > The pilot took off downwind and did not use all of the available runway. With insufficient airspeed, the aircraft stalled shortly after takeoff. The pilot was unable to recover within the altitude remaining and collided with an oncoming train.
- [NTSB MIA84FA164](https://openairdocs.org/ntsb/MIA84FA164.md): Mooney M-18C · Sugar Loaf Key, FL · Accident · 1 fatal · Field investigation · Final report · May 10, 1984 · N487M · Destroyed
  > The acft was observed making several passes over a friends house. At the end of the third pass during, a climbing left turn, the right wing separated from the acft. Inspection of the wreckage revealed wood rot in the main wing spar. The last known inspection…
- [NTSB FTW80FA054](https://openairdocs.org/ntsb/FTW80FA054.md): Mooney M-18C · Saginaw, TX · Accident · 1 fatal · Closed · Mar 9, 1980 · N4156 · Destroyed
- [NTSB DEN72AD047](https://openairdocs.org/ntsb/DEN72AD047.md): Mooney M-18C · West Point, UT · Accident · 1 fatal · Closed · Apr 16, 1972 · N336M · Destroyed
- [NTSB MKC67A0075](https://openairdocs.org/ntsb/MKC67A0075.md): Mooney M-18C · Anoka, MN · Accident · 1 fatal · Closed · Jun 1, 1967 · N4100 · Destroyed
- [NTSB MIA66A0072](https://openairdocs.org/ntsb/MIA66A0072.md): Mooney M-18C · Newbern, AL · Accident · 1 fatal · Closed · Dec 25, 1965 · N4190 · Destroyed
- [NTSB UNK65X0662](https://openairdocs.org/ntsb/UNK65X0662.md): Mooney M18C · Perry, OK · Accident · 1 fatal · Closed · Nov 11, 1964 · N484M · Destroyed
- [NTSB UNK64X2270](https://openairdocs.org/ntsb/UNK64X2270.md): Mooney M18C · Grants, NM · Accident · 1 fatal · Closed · Jun 13, 1964 · N4067 · Destroyed
- [NTSB UNK64X1121](https://openairdocs.org/ntsb/UNK64X1121.md): Mooney M-18C · Roanoke Rapids, NC · Accident · 1 fatal · Closed · Mar 31, 1964 · N345M · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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