# NTSB investigations: Mooney M20E, IN

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 CHI08CA035](https://openairdocs.org/ntsb/CHI08CA035.md): Mooney M20E · Lafayette, IN · Accident · No injuries · Data collection · Final report · Nov 1, 2007 · N5912Q · Substantial damage
  > The improper installation of the connecting rod bolts during major overhaul, which resulted in the separation of the connecting rod from the crankshaft in flight. Contributing to the accident was the rising terrain encountered during touchdown and the…
- [NTSB CHI84FA027](https://openairdocs.org/ntsb/CHI84FA027.md): Mooney M20E · Newark, IN · Accident · 2 fatal · Field investigation · Final report · Oct 24, 1983 · N7144U · Destroyed
  > The acft had been recently purchased by the plt & this was the 2nd leg of a 3 leg trip which had originally departed hickory, NC. Two witnesses located about 5 mi sse of the accident site observed the acft. One witness stated the visibility was less than 1 mi…
- [NTSB CHI77EEX44](https://openairdocs.org/ntsb/CHI77EEX44.md): Mooney M20E · Greenwood, IN · Accident · No injuries · Closed · Aug 21, 1977 · N1307W · Substantial damage
- [NTSB CHI74FEA27](https://openairdocs.org/ntsb/CHI74FEA27.md): Mooney M20E · Tunnelton, IN · Accident · No injuries · Closed · Feb 15, 1974 · N2620W · Substantial damage
- [NTSB CHI69A0075](https://openairdocs.org/ntsb/CHI69A0075.md): Mooney M20E · Jeffersonvlle, IN · Accident · 1 fatal · Closed · Feb 28, 1969 · N1274X · Destroyed
- [NTSB CHI69D0250](https://openairdocs.org/ntsb/CHI69D0250.md): Mooney M20E · Mentone, IN · Accident · No injuries · Closed · Aug 21, 1968 · N9224M · Substantial damage
- [NTSB CHI69F0174](https://openairdocs.org/ntsb/CHI69F0174.md): Mooney M20E · Camden, IN · Accident · No injuries · Closed · Jul 22, 1968 · N6038Q · Substantial damage
- [NTSB CHI69F0087](https://openairdocs.org/ntsb/CHI69F0087.md): Mooney M20E · Gary, IN · Accident · Serious injuries · Closed · Jul 8, 1968 · N5506Q · Destroyed
- [NTSB CHI68F0217](https://openairdocs.org/ntsb/CHI68F0217.md): Mooney M20E · South Bend, IN · Accident · No injuries · Closed · Jul 3, 1967 · N3463X · Substantial damage
- [NTSB CHI67D0278](https://openairdocs.org/ntsb/CHI67D0278.md): Mooney M20E · Richmond, IN · Accident · No injuries · Closed · Sep 30, 1966 · N3368X · 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" = 'IN' 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 ('5870212'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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