# NTSB investigations: Lycoming IO-360-L2A, 2012, FL

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 ERA12FA572](https://openairdocs.org/ntsb/ERA12FA572.md): Cessna 172S · Land O'Lakes, FL · Accident · 1 fatal · Field investigation · Final report · Sep 22, 2012 · N21750 · Substantial damage
  > The pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.
- [NTSB ERA12CA560](https://openairdocs.org/ntsb/ERA12CA560.md): Cessna 172S · Sebring, FL · Accident · No injuries · Data collection · Final report · Sep 3, 2012 · N9965P · Substantial damage
  > The student pilot's improper flare, which resulted in a hard landing.
- [NTSB ERA12CA419](https://openairdocs.org/ntsb/ERA12CA419.md): Cessna 172S · West Palm Beach, FL · Accident · No injuries · Data collection · Final report · Jun 26, 2012 · N961MC · Substantial damage
  > The flight instructor’s failure to maintain airplane control during the takeoff in gusting crosswind conditions. Contributing to the accident was the flight instructor’s decision to conduct takeoffs and landings in conditions exceeding the airplane’s maximum…
- [NTSB ERA12CA330](https://openairdocs.org/ntsb/ERA12CA330.md): Cessna 172R · Immokalee, FL · Accident · No injuries · Data collection · Final report · May 11, 2012 · N5253B · Substantial damage
  > The student pilot’s failure to maintain directional control during a touch-and-go landing.
- [NTSB ERA12LA274](https://openairdocs.org/ntsb/ERA12LA274.md): Cessna 172S · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 9, 2012 · N375LP · Substantial damage
  > A total loss of engine power due to a catastrophic engine failure, the origin of which could not be determined during postaccident examination.
- [NTSB ERA12FA193](https://openairdocs.org/ntsb/ERA12FA193.md): Cessna 172S · Key West, FL · Accident · 2 fatal · Field investigation · Final report · Feb 24, 2012 · N53589 · Substantial damage
  > The non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.

## 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 year(c."eventDate") = 2012
  AND c."eventStateOrRegion" = 'FL' 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=FL&year=2012

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