# NTSB investigations: Mooney M20F, NC

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 MIA99LA191](https://openairdocs.org/ntsb/MIA99LA191.md): Mooney M20F · Liberty, NC · Accident · No injuries · Limited investigation · Final report · Jun 29, 1999 · N7114V · Substantial damage
  > Improper inspection of the muffler assembly resulting in erosion going undetected and the rupture of the muffler and shroud while in cruise flight. The condition caused melting of portions of the air induction system, loss of engine power, and the pilot's…
- [NTSB NYC72FKM35](https://openairdocs.org/ntsb/NYC72FKM35.md): Mooney M20F · Shelby, NC · Accident · No injuries · Closed · May 6, 1972 · N9310V · Substantial damage
- [NTSB IAD71FLJ20](https://openairdocs.org/ntsb/IAD71FLJ20.md): Mooney M20F · Pinehurst, NC · Accident · No injuries · Closed · Apr 18, 1971 · N9390V · Substantial damage
- [NTSB IAD71DKM06](https://openairdocs.org/ntsb/IAD71DKM06.md): Mooney M20G · Hickory, NC · Accident · No injuries · Closed · Jul 25, 1970 · N9310V · Substantial damage
- [NTSB IAD71DKM02](https://openairdocs.org/ntsb/IAD71DKM02.md): Mooney M20F · Winston-Salem, NC · Accident · No injuries · Closed · Jul 16, 1970 · N3417N · Substantial damage
- [NTSB IAD70D0109](https://openairdocs.org/ntsb/IAD70D0109.md): Mooney M20F · Hendersonville, NC · Accident · No injuries · Closed · Nov 27, 1969 · N9396M · Substantial damage
- [NTSB DIA68F0177](https://openairdocs.org/ntsb/DIA68F0177.md): Mooney M20F · Concord, NC · Accident · No injuries · Closed · Feb 18, 1968 · N2921L · 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" = 'NC' 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 ('5870214'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=5870214&state=NC

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