# NTSB investigations: Lycoming O-320-D2J, OK

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 FTW85LA016](https://openairdocs.org/ntsb/FTW85LA016.md): Cessna 172P · Stillwater, OK · Accident · No injuries · Limited investigation · Final report · Oct 16, 1984 · N55350 · Substantial damage
  > Pilot had returned to his home airport after aborting a business flight due to weather. After landing, the pilot was taxiing from the active runway when the aircraft flipped inverted due to strong gusting winds. The wind was reported by the pilot to be…
- [NTSB FTW84LA241](https://openairdocs.org/ntsb/FTW84LA241.md): Cessna 172P · Stillwater, OK · Accident · No injuries · Limited investigation · Final report · May 24, 1984 · N55350 · Substantial damage
  > Plt stated the acft nose raised up before takeoff speed had been reached. Control of the acft was lost and it descended into a field aprx 500 ft off the end of the rwy in an area of unimproved terrain. Plt later reported the elevator trim was set in the full…

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

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

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