# Fatal NTSB investigations: Piper PA-28-235: Collision with terr/obj (non-CFIT)

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 WPR22FA264](https://openairdocs.org/ntsb/WPR22FA264.md): Piper PA-28-235 · Seguin, TX · Accident · 2 fatal · Class 3 · Field · Final report · Jul 22, 2022 · N8542W · Destroyed
  > The pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude after being distracted when the engine cowling opened during flight, which led to a loss of control and subsequent impact with terrain. Contributing to the accident was the…
- [NTSB CEN20LA374](https://openairdocs.org/ntsb/CEN20LA374.md): Piper PA28 · Walker, MN · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 2, 2020 · N8957W · Substantial damage
  > The pilot’s impairment from the effects of an undiagnosed brain tumor.
- [NTSB CEN20LA201](https://openairdocs.org/ntsb/CEN20LA201.md): Piper PA28 · Carlinville, IL · Accident · 4 fatal · Class 3 · Limited · Final report · May 31, 2020 · N8991W · Destroyed
  > The pilot’s attempted recovery from a steep descent which inadvertently exceeded the ultimate load factor of the airframe and resulted in a low-level inflight breakup.
- [NTSB ERA15FA066](https://openairdocs.org/ntsb/ERA15FA066.md): Piper PA28 · Sommerville, TN · Accident · 1 fatal · Field investigation · Final report · Dec 2, 2014 · N8607W · Destroyed
  > The noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…
- [NTSB CEN12FA101](https://openairdocs.org/ntsb/CEN12FA101.md): Piper PA-28-235D · Chickasha, OK · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2011 · N999RR · Substantial damage
  > The non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…
- [NTSB CHI08FA146](https://openairdocs.org/ntsb/CHI08FA146.md): Piper PA28 · Hillsboro, OH · Accident · 2 fatal · Field investigation · Final report · May 30, 2008 · N9376W · Substantial damage
  > The pilot's failure to maintain control of the airplane due to an in-flight fire as a result of a corrosion hole in the muffler that was not identified by the mechanic. Contributing to the accident was the improper emergency procedure performed for an…

## 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."highestInjuryLevel" = 'Fatal'
  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')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/470/sequence?fatal=1&model=7102810

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
