# NTSB investigations: Piper PA-28R-180, 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 CEN20CA052](https://openairdocs.org/ntsb/CEN20CA052.md): Piper PA28R · Onaga, KS · Accident · No injuries · Data collection · Final report · Dec 31, 2019 · N3849T · Substantial damage
  > The pilot's improper decision to take off with the airplane at a high gross weight from a short, turf runway, which degraded its climb performance and led to a delayed aborted takeoff, a runway excursion, and impact with terrain.
- [NTSB CEN15LA146](https://openairdocs.org/ntsb/CEN15LA146.md): Piper PA 28R-180 · Haviland, KS · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 2015 · N3918T · Substantial damage
  > The loss of torque on the No. 4 cylinder through bolts, which led to the subsequent failure of the piston, the liberation of the connecting rod, the separation of the No. 4 cylinder from the crankcase in cruise flight, and the airplane’s subsequent impact…
- [NTSB MKC86LA044](https://openairdocs.org/ntsb/MKC86LA044.md): Piper PA-28R-180 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jan 1, 1986 · N4682J · Substantial damage
  > The pilot stated that he was given landing instuctions for runway 17 to include winds from 220 degrees at 15 knots, gusting to 20 to 25 knots. He said that he touched down on the main wheels and a wind gust lifted the airplane and it drifted to the left. He…
- [NTSB MKC81DCQ20](https://openairdocs.org/ntsb/MKC81DCQ20.md): Piper PA-28R · Baxter Springs, KS · Accident · No injuries · Closed · Apr 5, 1981 · N3857T · Substantial damage
- [NTSB MKC78DCQ28](https://openairdocs.org/ntsb/MKC78DCQ28.md): Piper PA-28R · Smith Center, KS · Accident · Minor injuries · Closed · Jun 25, 1978 · N3850T · Substantial damage
- [NTSB MKC71AK058](https://openairdocs.org/ntsb/MKC71AK058.md): Piper PA-28R · Medicine Lge, KS · Accident · 1 fatal · Closed · Jun 13, 1971 · N7416J · Destroyed
- [NTSB MKC71DCQ16](https://openairdocs.org/ntsb/MKC71DCQ16.md): Piper PA-28R · Concordia, KS · Accident · Minor injuries · Closed · Aug 28, 1970 · N7608J · Substantial damage
- [NTSB MKC70F0042](https://openairdocs.org/ntsb/MKC70F0042.md): Piper PA-28R · Olathe, KS · Accident · Minor injuries · Closed · May 15, 1969 · N7684J · Substantial damage
- [NTSB MKC69F0210](https://openairdocs.org/ntsb/MKC69F0210.md): Piper PA-28 · Bonner Sprgs, KS · Accident · Serious injuries · Closed · Aug 29, 1968 · N4917J · 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 ('7102809'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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