# NTSB investigations: Piper PA-28-236: Loss of control in flight

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 CEN24LA144](https://openairdocs.org/ntsb/CEN24LA144.md): Piper PA28 · Muncie, IN · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 1, 2024 · N8438B · Destroyed
  > The pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…
- [NTSB ERA22LA043](https://openairdocs.org/ntsb/ERA22LA043.md): Piper PA-28-236 · Orleans, MA · Accident · 1 fatal · Class 3 · Limited · Final report · Oct 31, 2021 · N2186U · Destroyed
  > The pilot’s spatial disorientation and subsequent loss of airplane control while maneuvering over water in dark night conditions.
- [NTSB WPR19FA022](https://openairdocs.org/ntsb/WPR19FA022.md): Piper PA28 · Guthrie Center, IA · Accident · 4 fatal · Class 2 · Field · Final report · Nov 9, 2018 · N91770 · Substantial damage
  > Pilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.
- [NTSB WPR17FA052](https://openairdocs.org/ntsb/WPR17FA052.md): Piper PA 28-236 · Port Orford, OR · Accident · 1 fatal · Field investigation · Final report · Jan 13, 2017 · N81839 · Substantial damage
  > The pilot's loss of vision during cruise flight, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to fly with a known medical condition.
- [NTSB WPR09FA150](https://openairdocs.org/ntsb/WPR09FA150.md): Piper PA28-236 · Pomona, CA · Accident · 2 fatal · Field investigation · Final report · Mar 14, 2009 · N129AB · Destroyed
  > The pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102815')
    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" = '240' 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/240/sequence?model=7102815

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