# NTSB investigations: Lycoming 0-290 series: Controlled flight into terr/obj (CFIT)

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 WPR22LA238](https://openairdocs.org/ntsb/WPR22LA238.md): Piper PA20 · Challis, ID · Accident · 2 fatal · Class 3 · Limited · Final report · Jun 27, 2022 · N1231C · Substantial damage
  > The pilot's turn towards rising terrain with limited climb performance and his subsequent failure to maintain clearance from terrain that resulted in an impact with terrain.
- [NTSB CEN21LA060](https://openairdocs.org/ntsb/CEN21LA060.md): Piper PA22 · Salem, IN · Accident · No injuries · Class 4 · Limited · Final report · Nov 12, 2020 · N3535A · Substantial damage
  > The pilot’s failure to avoid an obstacle during his approach to land.
- [NTSB WPR15LA190](https://openairdocs.org/ntsb/WPR15LA190.md): Piper PA 20 · Yellow Pine, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 2015 · N6939K · Substantial damage
  > The pilot's delayed decision to go around after realizing that the airplane’s airspeed and altitude were too high, which resulted in an inadequate flare and bounced landing and a subsequent go-around in high-density altitude conditions.
- [NTSB CEN11FA663](https://openairdocs.org/ntsb/CEN11FA663.md): Thorp T-18 · Plainwell, MI · Accident · 1 fatal · Field investigation · Final report · Sep 23, 2011 · N54WB · Substantial damage
  > The pilot did not maintain clearance from a semitrailer along the approach path.
- [NTSB WPR11FA319](https://openairdocs.org/ntsb/WPR11FA319.md): Piper PA-22-135 · Verlot, WA · Accident · 2 fatal · Field investigation · Final report · Jul 8, 2011 · N8721C · Substantial damage
  > The non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.
- [NTSB CEN11CA439](https://openairdocs.org/ntsb/CEN11CA439.md): Barker A E B-2 · Sisterdale, TX · Accident · No injuries · Data collection · Final report · Jun 30, 2011 · N6917 · Substantial damage
  > The pilot's failure to maintain clearance from obstacles.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41506')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '120'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/120/cases?engine=41506

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