# NTSB investigations: Piper PA-28-235, NE

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 CEN20CA137](https://openairdocs.org/ntsb/CEN20CA137.md): Piper PA-28-235C · Omaha, NE · Accident · No injuries · Data collection · Final report · Mar 31, 2020 · N9468W · Substantial damage
  > The student pilot’s improper landing flare, which resulted in a bounced landing, subsequent loss of directional control, and the airplane going down an embankment.
- [NTSB CHI04CA195](https://openairdocs.org/ntsb/CHI04CA195.md): Piper PA-28-235 · Omaha, NE · Accident · No injuries · Data collection · Final report · Jul 25, 2004 · N9290W · Substantial damage
  > The pilot's failure to attain a proper touchdown point on the runway during landing. Contributing factors were the pilot's failure to perform a go-around, the ditch and the roadway encountered during the overrun.
- [NTSB MKC82DA127](https://openairdocs.org/ntsb/MKC82DA127.md): Piper PA-28-235D · Falls City, NE · Accident · No injuries · Final report · Jul 18, 1982 · N8532N · Substantial damage
  > The pilot reported that while he was landing with a 6 to 7 kt crosswind, the plane was blown toward the left side of the runway. In order to avoid the runway lights, he intentionally maneuvered the aircraft off the side of the runway, into the grass. When he…
- [NTSB MKC78FA050](https://openairdocs.org/ntsb/MKC78FA050.md): Piper PA-28 · Columbus, NE · Accident · 2 fatal · Closed · Jun 23, 1978 · N8993W · Destroyed
- [NTSB MKC77DCJ25](https://openairdocs.org/ntsb/MKC77DCJ25.md): Piper PA-28 · Gothenburg, NE · Accident · Minor injuries · Closed · Jun 22, 1977 · N57301 · Substantial damage
- [NTSB MKC69F0236](https://openairdocs.org/ntsb/MKC69F0236.md): Piper PA-28 · Western, NE · Accident · No injuries · Closed · Oct 17, 1968 · N9419W · Substantial damage
- [NTSB MKC69D0100](https://openairdocs.org/ntsb/MKC69D0100.md): Piper PA-28 · Clearwater, NE · Accident · No injuries · Closed · Jul 30, 1968 · N9150W · Substantial damage
- [NTSB MKC66F0390](https://openairdocs.org/ntsb/MKC66F0390.md): Piper PA-28 · Grand Island, NE · Accident · No injuries · Closed · Oct 18, 1965 · N8667W · 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" = 'NE' 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=NE

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