# NTSB investigations: Lycoming IO-360-L2A, 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 ERA23FA001](https://openairdocs.org/ntsb/ERA23FA001.md): Cessna 172S · Hermantown, MN · Accident · 3 fatal · Class 3 · Field · Final report · Oct 2, 2022 · N262TA · Substantial damage
  > The pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…
- [NTSB CEN21LA083](https://openairdocs.org/ntsb/CEN21LA083.md): Cessna 172 · Glencoe, MN · Accident · Serious injuries · Class 4 · Limited · Final report · Dec 10, 2020 · N1956V · No damage
  > A bystander’s inadvertent contact with the propeller while the engine was running.
- [NTSB GAA18CA085](https://openairdocs.org/ntsb/GAA18CA085.md): Cessna 172 · Park Rapids, MN · Accident · No injuries · Data collection · Final report · Dec 2, 2017 · N524ND · Substantial damage
  > The student pilot’s improper landing flare, which resulted in the propeller striking the ground.
- [NTSB CEN11CA624](https://openairdocs.org/ntsb/CEN11CA624.md): Cessna 172S · Bemidji, MN · Accident · No injuries · Data collection · Final report · Sep 5, 2011 · N548ND · Substantial damage
  > The student pilot's improper flare, which resulted in a hard landing.
- [NTSB CEN09LA579](https://openairdocs.org/ntsb/CEN09LA579.md): Cessna 172S · Park Rapids, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 2009 · N523ND · Substantial damage
  > The pilot's failure to maintain a proper climb rate during a night takeoff.
- [NTSB CEN09LA586](https://openairdocs.org/ntsb/CEN09LA586.md): Cessna 172S · Duluth, MN · Accident · No injuries · Limited investigation · Final report · Sep 7, 2009 · N568ND · Substantial damage
  > The pilot's failure to maintain aircraft control during landing, resulting in a hard landing and a propeller strike with the ground.
- [NTSB CHI03FA284](https://openairdocs.org/ntsb/CHI03FA284.md): Cessna 172S · Lake Elmo, MN · Accident · 3 fatal · Field investigation · Final report · Aug 22, 2003 · N53033 · 2 aircraft · Destroyed
  > Both pilots failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft.
- [NTSB CHI03LA061](https://openairdocs.org/ntsb/CHI03LA061.md): Cessna 172 · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · Jan 31, 2003 · N670CS · Substantial damage
  > The pilot's inadequate removal of ice and snow during the airplane preflight, and the subsequent loss of control due to the airplane being covered with ice.

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

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