# Final NTSB investigations: Lycoming O235N2C

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 WPR17FA128](https://openairdocs.org/ntsb/WPR17FA128.md): Prescot E. Wilkie RV-3 · Payette, ID · Accident · 1 fatal · Field investigation · Final report · Jun 17, 2017 · N177TT · Destroyed
  > The in-flight failure of the left wing due to the owner's use of improper hardware and his improper assembly of the airplane, which reduced the strength of the left wing and resulted in its subsequent failure following a sharp pullup maneuver.
- [NTSB CEN12CA277](https://openairdocs.org/ntsb/CEN12CA277.md): Cessna 152 · San Antonio, TX · Accident · No injuries · Data collection · Final report · May 1, 2012 · N94500 · Substantial damage
  > The student pilot's misjudgment of the landing flare, which resulted in a hard/bounced landing and subsequent impact with the runway.
- [NTSB CEN11LA542](https://openairdocs.org/ntsb/CEN11LA542.md): T&T Falcon LS · Lee's Summit, MO · Accident · No injuries · Limited investigation · Final report · Aug 1, 2011 · N785TT · Substantial damage
  > A binding condition in the left rudder cable which resulted in a loss of directional control during landing.
- [NTSB ATL94LA167](https://openairdocs.org/ntsb/ATL94LA167.md): Cessna 152 · W. Columbia, SC · Accident · No injuries · Limited investigation · Final report · Aug 27, 1994 · N94194 · Substantial damage
  > The student pilot's failure to properly flare the aircraft, resulting in a hard landing.
- [NTSB CHI84LA019](https://openairdocs.org/ntsb/CHI84LA019.md): Cessna 152 · Elyria, OH · Accident · No injuries · Limited investigation · Final report · Oct 10, 1983 · N94500 · Substantial damage
  > During final the acft ballooned. The plt added power for a go-around but the acft settled to the rwy nose gear first. Gear, prop & firewall 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42166'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=42166&status=final

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