# NTSB investigations: Lycoming AEIO-360 series, 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 CHI03LA232](https://openairdocs.org/ntsb/CHI03LA232.md): American Champion 8KCAB · Stephen, MN · Accident · No injuries · Limited investigation · Final report · Jul 28, 2003 · N67ND · Substantial damage
  > The pilot's failure to maintain clearance from the transmission line and the pilot's continued operation with known deficiencies in equipment. Factors to the accident were the power lines and the low altitude the pilot was flying at.
- [NTSB CHI98LA157](https://openairdocs.org/ntsb/CHI98LA157.md): Great Lakes 2T-1A-2 · Tower, MN · Accident · No injuries · Limited investigation · Final report · May 17, 1998 · N3803F · Substantial damage
  > the pilot's inadequate preflight of the airplane's fuel system, and fuel exhaustion, which resulted in a loss of engine power, due to an inadequate supply of fuel.
- [NTSB MKC90LA077](https://openairdocs.org/ntsb/MKC90LA077.md): Bellanca 8KCAB · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Mar 30, 1990 · N12KD · Substantial damage
  > Failure of the pilot to maintain directional control of the aircraft during the landing. The failed (flat) right main tire was a related factor.

## 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 ('41522', '41601'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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