# NTSB investigations: Piper PA-32-260, 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 CHI91LA025](https://openairdocs.org/ntsb/CHI91LA025.md): Piper PA-32-260 · Latham, KS · Accident · No injuries · Limited investigation · Final report · Nov 8, 1990 · N5536J · Substantial damage
  > Failure of the pilot to maintain a proper altitude.
- [NTSB MKC86LA175](https://openairdocs.org/ntsb/MKC86LA175.md): Piper PA-32-260 · Wilson, KS · Accident · No injuries · Limited investigation · Final report · Aug 26, 1986 · N3442W · Substantial damage
  > The pilot stated that before the flight the spark plugs were cleaned and inspected and the engine was serviced with eleven quarts of oil. Three hours into the flight instrument meteorological conditions (IMC) with rain was encountered and shortly thereafter…
- [NTSB MKC82DA147](https://openairdocs.org/ntsb/MKC82DA147.md): Piper PA-32-260 · Manhattan, KS · Accident · Minor injuries · Final report · Aug 19, 1982 · N3436W · Substantial damage
  > The pilot departed Manhattan, KS and flew to minneapolis, MN. At minneapolis, he refueled with 10 gal added to the left main tank. He said both main tanks were full, the right auxiliary tank was empty, and he estimated there was 5 gal in the left auxiliary…
- [NTSB MKC80DCQ23](https://openairdocs.org/ntsb/MKC80DCQ23.md): Piper PA-32 · Kiowa, KS · Accident · No injuries · Closed · Jul 1, 1980 · N3532W · Substantial damage
- [NTSB MKC74AK024](https://openairdocs.org/ntsb/MKC74AK024.md): Piper PA-32 · Topeka, KS · Accident · No injuries · Closed · Nov 16, 1973 · N3412W · Substantial damage
- [NTSB MKC73AKO25](https://openairdocs.org/ntsb/MKC73AKO25.md): Piper PA-32 · Lawrence, KS · Accident · No injuries · Closed · Oct 5, 1972 · N3655W · Substantial damage
- [NTSB MKC67D0059](https://openairdocs.org/ntsb/MKC67D0059.md): Piper PA-32 · Hugoton, KS · Accident · No injuries · Closed · Jun 19, 1966 · N3481W · 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" = '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 ('7103206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103206&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.
