# NTSB investigations: Piper PA-38-112, KY

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 NYC04LA154](https://openairdocs.org/ntsb/NYC04LA154.md): Piper PA-38-112 · Lawrenceburg, KY · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2004 · N2364A · Substantial damage
  > The pilot's decision to perform a negative g maneuver, which resulted in a loss of engine power due to fuel starvation.
- [NTSB NYC92LA054](https://openairdocs.org/ntsb/NYC92LA054.md): Piper PA-38-112 · Falmouth, KY · Accident · No injuries · Limited investigation · Final report · Mar 10, 1992 · N2460C · Substantial damage
  > The failure of the pilot to adequately monitor his fuel consumption which resulted in a power loss from fuel exhaustion over unsuitable terrain. A factor related to the accident was the failure of the pilot to adequately determine the amount of fuel onboard…
- [NTSB ATL83LA364](https://openairdocs.org/ntsb/ATL83LA364.md): Piper PA-38-12 · Louisville, KY · Accident · No injuries · Limited investigation · Final report · Sep 10, 1983 · N2457N · Substantial damage
  > The acft collided with a sandbank on a private airstrip during landing. The weather was clear and the wind was calm. Therwy was 75 ft wide and dry. As the acft slowed during the rollout it drifted to the left, the plt overcorrected with right rudder and the…
- [NTSB IAD80FLQ05](https://openairdocs.org/ntsb/IAD80FLQ05.md): Piper PA-38 · Louisville, KY · Accident · No injuries · Closed · Nov 29, 1979 · N2459G · Substantial 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."eventStateOrRegion" = 'KY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103812'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103812&state=KY

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