# NTSB investigations: Piper PA-28-235, 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 CHI01FA291](https://openairdocs.org/ntsb/CHI01FA291.md): Piper PA-28-235 · Crestline, KS · Accident · 1 fatal · Field investigation · Final report · Aug 25, 2001 · N16405 · Destroyed
  > The airplane's departure from level flight and subsequent impact with the terrain as a result of a maneuver initiated by the pilot, and the pilot's failure to maintain clearance from the terrain. The reason for the pilot's actions were not determined.
- [NTSB CHI98LA224](https://openairdocs.org/ntsb/CHI98LA224.md): Piper PA-28-235 · Liberal, KS · Accident · 1 fatal · Limited investigation · Final report · Jun 27, 1998 · N8903W · Destroyed
  > the inadvertent stall, the pilot's inadequate preflight planning, which led to performing a takeoff with insufficient distance to clear the utility pole. A factor which contributed to this accident was the utility pole.
- [NTSB CHI98LA034](https://openairdocs.org/ntsb/CHI98LA034.md): Piper PA-28-235 · Ulysses, KS · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1997 · N9404W · Destroyed
  > the pilot's continued flight into adverse weather conditions, his failure to activate the pitot heat system, and his failure to maintain clearance from the terrain. Factors associated with this accident were: the pilot did not obtain a preflight weather…
- [NTSB CHI93LA235](https://openairdocs.org/ntsb/CHI93LA235.md): Piper PA-28-235 · Bloom, KS · Accident · No injuries · Limited investigation · Final report · Jul 6, 1993 · N8633W · Substantial damage
  > improper refueling by a person or persons unknown. A factor was deteriorated fuel.
- [NTSB MKC81DCQ19](https://openairdocs.org/ntsb/MKC81DCQ19.md): Piper PA-28 · Hugoton, KS · Accident · No injuries · Closed · Mar 29, 1981 · N9097W · Substantial damage
- [NTSB MKC78FA038](https://openairdocs.org/ntsb/MKC78FA038.md): Piper PA-28 · Scott City, KS · Accident · 1 fatal · Closed · May 19, 1978 · N9395W · Destroyed
- [NTSB MKC70DCQ19](https://openairdocs.org/ntsb/MKC70DCQ19.md): Piper PA-28 · Hill City, KS · Accident · No injuries · Closed · May 3, 1970 · N9312W · Substantial damage
- [NTSB MKC70D0060](https://openairdocs.org/ntsb/MKC70D0060.md): Piper PA-28 · Olathe, KS · Accident · No injuries · Closed · Jun 18, 1969 · N9418W · Substantial damage
- [NTSB MKC67A0021](https://openairdocs.org/ntsb/MKC67A0021.md): Piper PA-28 · Kansas City, KS · Accident · 3 fatal · Closed · Sep 3, 1966 · N9074W · Destroyed
- [NTSB MKC66D0299](https://openairdocs.org/ntsb/MKC66D0299.md): Piper PA-28 · Wichita, KS · Accident · No injuries · Closed · Oct 23, 1965 · N8746W · Substantial damage
- [NTSB UNK65X0291](https://openairdocs.org/ntsb/UNK65X0291.md): Piper PA28 · Topeka, KS · Accident · Minor injuries · Closed · Oct 16, 1964 · N8703W · Destroyed
- [NTSB UNK64X1703](https://openairdocs.org/ntsb/UNK64X1703.md): Piper PA-28 · Marysville, KS · Accident · Minor injuries · Closed · May 10, 1964 · N8755W · 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 ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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