# Final NTSB investigations: Lycoming IO-360-L2A, ND

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 CEN22LA281](https://openairdocs.org/ntsb/CEN22LA281.md): Cessna 172S · Fargo, ND · Accident · No injuries · Class 4 · Limited · Final report · Jun 19, 2022 · N5256S · Substantial damage
  > The flight instructor’s failure to adequately monitor the pilot flying, which resulted in a nose-wheel first hard landing.
- [NTSB CEN14CA187](https://openairdocs.org/ntsb/CEN14CA187.md): Cessna 172 · Larimore, ND · Accident · No injuries · Data collection · Final report · Apr 5, 2014 · N510ND · Substantial damage
  > Failure of the pilot to attain and maintain sufficient control inputs to compensate for the crosswind. Contributing to the accident was the flight instructor's failure to adequately monitor the pilot and the flight.
- [NTSB CEN13LA348](https://openairdocs.org/ntsb/CEN13LA348.md): Cessna 172S · Grand Forks, ND · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 2013 · N552ND · Substantial damage
  > The student pilot’s inadequate recovery from a bounced landing, which resulted in an aerodynamic stall during the go-around.
- [NTSB CEN12CA426](https://openairdocs.org/ntsb/CEN12CA426.md): Cessna 172S · Grand Forks, ND · Accident · No injuries · Data collection · Final report · Jul 10, 2012 · N548ND · Substantial damage
  > The student pilot’s inadequate landing flare, which resulted in a hard landing.
- [NTSB CEN11LA386](https://openairdocs.org/ntsb/CEN11LA386.md): Cessna 172S · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Jun 13, 2011 · N539ND · Substantial damage
  > The flight instructor’s delayed remedial action to the student pilot’s bounced landing and subsequent loss of aircraft control.
- [NTSB CEN10CA025](https://openairdocs.org/ntsb/CEN10CA025.md): Cessna 172S · Grand Forks, ND · Accident · No injuries · Data collection · Final report · Oct 20, 2009 · N519ND · Substantial damage
  > The student pilot's improper landing flare and recovery from a bounced landing.
- [NTSB CEN09CA404](https://openairdocs.org/ntsb/CEN09CA404.md): Cessna 172S · Grand Forks, ND · Accident · No injuries · Data collection · Final report · Jul 2, 2009 · N538ND · Substantial damage
  > The student pilot's improper landing flare that resulted in a hard landing.
- [NTSB CEN09CA402](https://openairdocs.org/ntsb/CEN09CA402.md): Cessna 172S · Grand Forks, ND · Accident · No injuries · Data collection · Final report · Jul 2, 2009 · N525ND · Substantial damage
  > The student pilot's improper landing flare and recovery from a bounced landing.

## 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" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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=ND&status=final

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