# NTSB investigations: Piper PA-30, MN

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 CHI00FA185](https://openairdocs.org/ntsb/CHI00FA185.md): Piper PA-30 · Duluth, MN · Accident · 3 fatal · Field investigation · Final report · Jul 8, 2000 · N7213Y · Destroyed
  > loss of control in flight for undetermined reason(s).
- [NTSB CHI91FA108](https://openairdocs.org/ntsb/CHI91FA108.md): Piper PA-30 · Thief River Fls, MN · Accident · 4 fatal · Field investigation · Final report · Mar 18, 1991 · N8290Y · Destroyed
  > Improper IFR procedure of the pilot, while intercepting the ILS localizer, by not maintianing the minimum descent altitude (mda) for that segment of the approach.
- [NTSB CHI87LA024](https://openairdocs.org/ntsb/CHI87LA024.md): Piper PA-30 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Nov 13, 1986 · N7668Y · Substantial damage
  > The pilot flew for an hour trying to get the gear extended, but was unable. After making a gear up landing, an exam revealed the centering cam on the left side of the nose gear was bent and broken. This could have caused the gear to jam and not extend.
- [NTSB MKC78FER12](https://openairdocs.org/ntsb/MKC78FER12.md): Piper PA-30 · Ely, MN · Accident · Minor injuries · Closed · Nov 25, 1977 · N8739Y · Substantial damage
- [NTSB MKC73DER31](https://openairdocs.org/ntsb/MKC73DER31.md): Piper PA-30 · Morris, MN · Accident · No injuries · Closed · Dec 27, 1972 · N8387Y · Substantial damage
- [NTSB MKC72FER68](https://openairdocs.org/ntsb/MKC72FER68.md): Piper PA-30 · Fergus Fls, MN · Accident · No injuries · Closed · Jun 15, 1972 · N7573Y · Substantial damage
- [NTSB MKC72FER05](https://openairdocs.org/ntsb/MKC72FER05.md): Piper PA-30 · Eden Prairie, MN · Accident · No injuries · Closed · Jul 1, 1971 · N8626Y · Substantial damage
- [NTSB MKC70D0118](https://openairdocs.org/ntsb/MKC70D0118.md): Piper PA-30 · Owatonna, MN · Accident · No injuries · Closed · Jul 12, 1969 · N8181Y · Substantial damage
- [NTSB MKC66F0095](https://openairdocs.org/ntsb/MKC66F0095.md): Piper PA-30 · Maple Lake, MN · Accident · No injuries · Closed · Jul 11, 1965 · N7235Y · 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" = 'MN' 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 ('7103002'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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