# NTSB investigations: Piper PA-28R-200, IA

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 CHI98FA309](https://openairdocs.org/ntsb/CHI98FA309.md): Piper PA-28R-200 · New Hampton, IA · Accident · 3 fatal · Field investigation · Final report · Aug 10, 1998 · N9350N · Destroyed
  > The pilot's inadequate preflight/planning inspection and his continued flight into known adverse weather conditions that led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the airplane causing…
- [NTSB MKC84LA009](https://openairdocs.org/ntsb/MKC84LA009.md): Piper PA-28R-200 · Carlisle, IA · Accident · No injuries · Limited investigation · Final report · Oct 16, 1983 · N2825T · Substantial damage
  > The pilot said the fuel gauges read full on the ground but as he leveled off in cruise they dropped to a reading of much less than full. The acft ran out of fuel short of destination. The pilot blamed the flu and fatigue for his oversight.
- [NTSB MKC82FA161](https://openairdocs.org/ntsb/MKC82FA161.md): Piper PA-28R-200 · Mediapolis, IA · Accident · 4 fatal · Field investigation · Final report · Aug 30, 1982 · N56373 · Destroyed
  > During the 1725 CDT wx briefing the plt was informed that the Kansas city area would be 1600 ft broken, occassional 800 ft broken, 3/4 mi visibility with thunderstorms & moderate rain with strong surface winds about 35K. The forecast was valid to 2200 CDT.…
- [NTSB MKC81FA044](https://openairdocs.org/ntsb/MKC81FA044.md): Piper PA-28R · Colo, IA · Accident · 5 fatal · Closed · Jul 25, 1981 · N16328 · Destroyed
- [NTSB MKC80DCD27](https://openairdocs.org/ntsb/MKC80DCD27.md): Piper PA-28R · Humboldt, IA · Accident · No injuries · Closed · Jul 30, 1980 · N2CL · Substantial damage
- [NTSB MKC80FCD11](https://openairdocs.org/ntsb/MKC80FCD11.md): Piper PA-28R · Ankeny, IA · Accident · No injuries · Closed · Jan 27, 1980 · N57305 · Substantial damage
- [NTSB MKC78FCD31](https://openairdocs.org/ntsb/MKC78FCD31.md): Piper PA-28R · Iowa City, IA · Accident · No injuries · Closed · May 30, 1978 · N2895T · Substantial damage
- [NTSB MKC76FCD02](https://openairdocs.org/ntsb/MKC76FCD02.md): Piper PA-28R · Council Bluffs, IA · Accident · No injuries · Closed · Jul 17, 1975 · N4970S · Substantial damage
- [NTSB MKC75PCD31](https://openairdocs.org/ntsb/MKC75PCD31.md): Piper PA-28R · Burlington, IA · Accident · No injuries · Closed · Jan 3, 1975 · N2989R · 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" = 'IA' 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 ('7102811'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102811&state=IA

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