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

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 DEN87LA128](https://openairdocs.org/ntsb/DEN87LA128.md): Cessna 172I · Taos, NM · Accident · No injuries · Limited investigation · Final report · May 20, 1987 · N46231 · Substantial damage
  > The private plt and his CFI rated pax were practicing touch and go landings at the local arpt. During landing a wind gust pushed the acft off the runway centerline to the right. The runway shoulder was soft, a go-around attempt was unsuccessful and the acft…
- [NTSB ATL87LA125](https://openairdocs.org/ntsb/ATL87LA125.md): Cessna 150J · Waverly, TN · Accident · No injuries · Limited investigation · Final report · Apr 20, 1987 · N60696 · Substantial damage
  > The plt reported that he was taxiing to the rwy when the 'rudder failed to turn the (airplane) onto the rwy and the left brake failed.' The airplane subsequently ran off the end of the taxiway, traveled approx. 50 ft., went over a steep dropoff and collided…

## 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") = 1987
  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&year=1987

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