# NTSB investigations: Lycoming IO-360-L2A

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.

Page 9 of 9 · 404 cases

## Cases, newest first

- [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.
- [NTSB LAX02LA192](https://openairdocs.org/ntsb/LAX02LA192.md): Cessna 172S · Goldfield, NV · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 2002 · N480DW · Substantial damage
  > The pilot's failure to maintain control of the airplane during a high density altitude takeoff. Contributing factors were the pilot's lack of experience in the type of operation and a wind gust.
- [NTSB LAX01LA267](https://openairdocs.org/ntsb/LAX01LA267.md): Cessna 172S · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Jul 29, 2001 · N3532T · Substantial damage
  > The pilot's misjudged landing flare, which lead to a hard landing, inadvertent porpoise, and his improper recovery from a bounced landing.
- [NTSB CHI01LA173](https://openairdocs.org/ntsb/CHI01LA173.md): Cessna 172S · Cambridge, NE · Accident · No injuries · Limited investigation · Final report · Jun 16, 2001 · N494SP · Substantial damage
  > the pilot's high airspeed and improper emergency procedures during the emergency landing. Factors relating to this accident were the fractured engine exhaust valve push rod, the bent intake valve push rod, and oil exhaustion during cruise flight, the…

## 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."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&page=9

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