# NTSB investigations: Piper PA-28R-201, 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 CHI93LA285](https://openairdocs.org/ntsb/CHI93LA285.md): Piper PA-28 · Crookston, MN · Accident · No injuries · Limited investigation · Final report · Jul 27, 1993 · N172ND · Substantial damage
  > The pilot in command's delayed in-flight decision. A factor to the accident is the pilot in command's failure to attain a proper touchdown point.
- [NTSB MKC90LA105](https://openairdocs.org/ntsb/MKC90LA105.md): Piper PA-28R · Starbuck, MN · Accident · No injuries · Limited investigation · Final report · May 7, 1990 · N1633H · Substantial damage
  > Compensation for wind conditions were misjudged and aircraft control was not maintained by the pilot in command.
- [NTSB CHI83LA210](https://openairdocs.org/ntsb/CHI83LA210.md): Piper PA-28R · Mora, MN · Accident · No injuries · Limited investigation · Final report · May 11, 1983 · N36804 · Substantial damage
  > The acft ran off the departure end of the rwy into a cornfield during an aborted takeoff. The pilot stated that after liftoff the stall warning came on and the acft would not accelerate or climb. He pulled the power off and aborted the takeoff. The acft…
- [NTSB MKC79DER86](https://openairdocs.org/ntsb/MKC79DER86.md): Cessna 421B · Crystal, MN · Accident · No injuries · Closed · Aug 10, 1978 · N110SW · 2 aircraft · Minor 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 ('7102816', '7102833'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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