# NTSB investigations: Piper PA-31-350, KS

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 CEN15LA117](https://openairdocs.org/ntsb/CEN15LA117.md): Piper PA-31-350 · Goodland, KS · Accident · No injuries · Limited investigation · Final report · Jan 21, 2015 · N66906 · Substantial damage
  > The pilot's improper fuel management and failure to conduct the engine failure emergency procedures and his improper conduct of the forced landing, which resulted in fuel starvation, a total loss of engine power, and the subsequent high-energy impact with…
- [NTSB CHI03IA069](https://openairdocs.org/ntsb/CHI03IA069.md): Piper PA-31-350 · Goodland, KS · Incident · No injuries · Incident investigation · Final report · Feb 13, 2003 · N9247L · Minor damage
  > The partial loss of engine power to both engines for undetermined reasons, and the pilot's improper in-flight decision to not land at the nearest available airport.
- [NTSB CHI99LA256](https://openairdocs.org/ntsb/CHI99LA256.md): Piper PA-31-350 · Salina, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1999 · N97MA · Substantial damage
  > the inadequate preflight inspection by the pilot. Factors to the accident were fuel exhaustion and the operation of the aircraft with known deficiencies in equipment by the pilot.
- [NTSB MKC86LA032](https://openairdocs.org/ntsb/MKC86LA032.md): Piper PA-31-350 · Topeka, KS · Accident · No injuries · Limited investigation · Final report · Dec 10, 1985 · N4NP · Substantial damage
  > N4NP diverted from the original destination forbes field Topeka,Kansas to billard field,b NM away, due to weather. Billard ATCT advised the flight during initial contact, before N4NP reached the ILS fof, of the runway braking action. The pilot said braking…

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

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

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