# NTSB investigations: Lycoming 0-145B series, OH

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 CEN14CA282](https://openairdocs.org/ntsb/CEN14CA282.md): Luscombe 8B · Galion, OH · Accident · No injuries · Data collection · Final report · May 29, 2014 · N39092 · Substantial damage
  > The pilot's misapplication of brakes after landing, which resulted in the airplane nosing over.
- [NTSB BFO95LA065](https://openairdocs.org/ntsb/BFO95LA065.md): Aeronca 65-LB · Grand River, OH · Accident · No injuries · Limited investigation · Final report · Jun 18, 1995 · N33719 · Substantial damage
  > The pilot selected unsuitable terrain for the takeoff.
- [NTSB CHI88LA222](https://openairdocs.org/ntsb/CHI88LA222.md): Piper J-3 · Youngstown, OH · Accident · Serious injuries · Limited investigation · Final report · Aug 27, 1988 · N38346 · Substantial damage
  > The aircraft experienced a total loss of engine power due to fuel exhaustion while on final approach to the runway. The aircraft sustained substantial damage, and the pilot was seriously injured when the aircraft impacted the ground approximately 25' short of…
- [NTSB CHI79DEI24](https://openairdocs.org/ntsb/CHI79DEI24.md): Piper J-3 · Galion, OH · Accident · Minor injuries · Closed · May 7, 1979 · N33242 · Substantial damage
- [NTSB CHI74FEI10](https://openairdocs.org/ntsb/CHI74FEI10.md): Corben ACE · Brookfield, OH · Accident · Serious injuries · Closed · Sep 14, 1973 · N1298V · Substantial damage
- [NTSB CHI68F0738](https://openairdocs.org/ntsb/CHI68F0738.md): Luscombe 8B · Wadsworth, OH · Accident · Serious injuries · Closed · Apr 12, 1968 · N37003 · Destroyed

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

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

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