# NTSB investigations: Lycoming O-360-J2A, MO

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 CEN25LA063](https://openairdocs.org/ntsb/CEN25LA063.md): Robinson Helicopter R22 Beta · Springfield, MO · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 21, 2024 · N3104U · Destroyed
  > The student pilot’s failure to maintain control of the helicopter while turning on the blower fan switch after landing that resulted in a dynamic rollover sequence.
- [NTSB CEN19FA009](https://openairdocs.org/ntsb/CEN19FA009.md): Robinson R22 · Fulton, MO · Accident · 1 fatal · Class 2 · Field · Final report · Oct 17, 2018 · N923SH · Destroyed
  > A total loss of engine power due to carburetor icing, the pilot's delayed application of carburetor heat, and the pilot's delay in entering an autorotation following the loss of engine power, which resulted in a main rotor stall due to low rotor rpm and an…
- [NTSB CHI07CA281](https://openairdocs.org/ntsb/CHI07CA281.md): Robinson R-22 Beta · St. Clair Rgnl., MO · Accident · No injuries · Data collection · Final report · Aug 28, 2007 · N143SH · Substantial damage
  > The pilot overcorrected following a loss of control while practicing a hovering turn.

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

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

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