# NTSB investigations: Lycoming IO-360-L2A, 2003

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 LAX04LA060](https://openairdocs.org/ntsb/LAX04LA060.md): Cessna 172S · Watsonville, CA · Accident · No injuries · Limited investigation · Final report · Dec 7, 2003 · N396TA · Substantial damage
  > loss of engine power for undetermined reasons.
- [NTSB MIA04CA028](https://openairdocs.org/ntsb/MIA04CA028.md): Cessna 172S · Orlando, FL · Accident · No injuries · Data collection · Final report · Nov 21, 2003 · N378FA · Substantial damage
  > The student pilots improper landing flare and his improper recovery from a bounced landing resulting in a hard landing and damage to the airplane.
- [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 LAX03LA186](https://openairdocs.org/ntsb/LAX03LA186.md): Cessna 172S · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Jun 8, 2003 · N519ER · Substantial damage
  > The student pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight in allowing the student to perform a solo flight with a strong,…
- [NTSB LAX03LA170](https://openairdocs.org/ntsb/LAX03LA170.md): Cessna 172S · Kapolei, HI · Accident · No injuries · Limited investigation · Final report · May 29, 2003 · N5329L · Substantial damage
  > The pilot's misjudged landing flare, and improper recovery from a bounced landing, which resulted in the collapse of the nose landing gear and structural damage to the airplane.
- [NTSB MIA03LA096](https://openairdocs.org/ntsb/MIA03LA096.md): Cessna 172S · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Apr 12, 2003 · N52903 · Substantial damage
  > The student pilot's improper throttle setting during the braking test, resulting in a collision with a parked airplane.
- [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 year(c."eventDate") = 2003
  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&year=2003

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