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

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 GAA19CA113](https://openairdocs.org/ntsb/GAA19CA113.md): Cessna 172 · Reno, NV · Accident · No injuries · Data collection · Final report · Jan 29, 2019 · N670CS · Substantial damage
  > The student pilot's failure to maintain directional control during a rejected takeoff, which resulted in a runway excursion and impact with a ditch.
- [NTSB WPR18LA002](https://openairdocs.org/ntsb/WPR18LA002.md): Cessna 172S · Tonopah, NV · Accident · No injuries · Limited investigation · Final report · Oct 2, 2017 · N5311H · Substantial damage
  > The pilot's failure to enrich the mixture during the descent, as required by the Pilot's Operating Handbook (POH), and his subsequent failure to follow the POH emergency procedures, which resulted in an excessively lean fuel/air mixture and subsequent loss of…
- [NTSB LAX08FA261](https://openairdocs.org/ntsb/LAX08FA261.md): Cessna 172S · Incline Village, NV · Accident · 1 fatal · Field investigation · Final report · Aug 8, 2008 · N15963 · Substantial damage
  > The pilot's decision to initiate a flight for which he was neither approved nor qualified and his failure to maintain terrain clearance during the flight. Contributing to the accident were the dark night, the mountainous terrain, and the pilot's medical…
- [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.

## 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" = 'NV' 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=NV

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