# NTSB investigations: Lycoming O-320-E2D, CA

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 WPR23LA146](https://openairdocs.org/ntsb/WPR23LA146.md): Cessna 172M · Santa Ana, CA · Accident · No injuries · Class 4 · Limited · Final report · Apr 1, 2023 · N1399U · Substantial damage
  > The flight instructor’s failure to maintain clearance from a commercial airliner which resulted in an encounter with wake turbulence and subsequent loss of control resulting in impact with terrain.
- [NTSB GAA18CA523](https://openairdocs.org/ntsb/GAA18CA523.md): Eggleston Daniel S-18 Thorp · Porterville, CA · Accident · Minor injuries · Data collection · Final report · Sep 1, 2018 · N575DG · Substantial damage
  > The pilot’s failure to maintain directional control during the takeoff roll.
- [NTSB WPR13LA224](https://openairdocs.org/ntsb/WPR13LA224.md): Cessna 172M · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Apr 29, 2013 · N20800 · Substantial damage
  > Loss of engine power during climb due to a failure of the No. 2 piston assembly; the reason for the failure could not be determined because of the extent of damage to the piston assembly.
- [NTSB WPR12LA141](https://openairdocs.org/ntsb/WPR12LA141.md): Grimm RV-9A · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Mar 20, 2012 · N629BJ · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.
- [NTSB LAX04CA242](https://openairdocs.org/ntsb/LAX04CA242.md): Vans RV-9A · The Sea Ranch, CA · Accident · No injuries · Data collection · Final report · Jun 17, 2004 · N93AZ · Substantial damage
  > the pilot's inadequate compensation for gusty crosswind conditions and failure to maintain proper runway alignment, resulting in a collision with trees.
- [NTSB OAK79DVG09](https://openairdocs.org/ntsb/OAK79DVG09.md): Cessna 150 · Grass Valley, CA · Accident · No injuries · Closed · Dec 31, 1978 · N9124U · Substantial damage
- [NTSB LAX77DVA53](https://openairdocs.org/ntsb/LAX77DVA53.md): Cessna 172 · Lost Hills, CA · Accident · No injuries · Closed · Aug 20, 1977 · N1399U · Substantial damage

## 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" = 'CA' 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 ('42123'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=42123&state=CA

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