# NTSB investigations: Lycoming 0-320 series, MN: Overrun

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 CHI05CA034](https://openairdocs.org/ntsb/CHI05CA034.md): Cessna 172N · Lakeville, MN · Accident · No injuries · Data collection · Final report · Nov 20, 2004 · N737CR · Substantial damage
  > The pilot misjudged his distance and speed which resulted in an overrun.. Factors were the wet runway, the grass and the berm.
- [NTSB CHI02LA031](https://openairdocs.org/ntsb/CHI02LA031.md): Piper PA-28-161 · New Ulm, MN · Accident · No injuries · Limited investigation · Final report · Nov 6, 2001 · N523PU · Substantial damage
  > The student and flight instructor not using all of the available runway, the inadequate supervision by the flight instructor and the unsuccessful remedial action by the flight instructor. The student not attaining the proper touchdown point and the plowed…
- [NTSB CHI98LA315](https://openairdocs.org/ntsb/CHI98LA315.md): Piper PA-28-151 · Redwood Falls, MN · Accident · No injuries · Limited investigation · Final report · Aug 15, 1998 · N4576F · Substantial damage
  > the pilot's not following proper short field landing procedures.
- [NTSB CHI94LA305](https://openairdocs.org/ntsb/CHI94LA305.md): Piper PA-28-140 · Jackson, MN · Accident · No injuries · Limited investigation · Final report · Aug 28, 1994 · N1197X · Substantial damage
  > the pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were the soft terrain and the ditch.
- [NTSB CHI83LA409](https://openairdocs.org/ntsb/CHI83LA409.md): Cessna 172M · Grand Marais, MN · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N1857V · Substantial damage
  > The plt took off from the departure point after an unexpected 1/2 hr delay. By the time he arrived at his destination, it was dark. No rwy lighting sys was installed, so someone at the arpt drove a car to rwy 27 to light up the approach end with the head…

## 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.engine_model_code IN ('41508')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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