# NTSB investigations: Piper PA-31-350, 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 CHI06FA026](https://openairdocs.org/ntsb/CHI06FA026.md): Piper PA-31-350 · Ankeny, IA · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2005 · N27177 · Destroyed
  > The pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…
- [NTSB CHI99LA114](https://openairdocs.org/ntsb/CHI99LA114.md): Piper PA-31-350 · Waterloo, IA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1999 · N812TB · Substantial damage
  > the pilot's failure to maintain directional control.
- [NTSB MKC90LA108](https://openairdocs.org/ntsb/MKC90LA108.md): Piper PA-31-350 · Dubuque, IA · Accident · No injuries · Limited investigation · Final report · May 16, 1990 · N111AY · Substantial damage
  > Weather evaluation misjudged resulting in uncontrolled descent by the pilot in command and aircraft control not maintained by the pilot in command.
- [NTSB MKC84LA031](https://openairdocs.org/ntsb/MKC84LA031.md): Piper PA-31-350 · Waterloo, IA · Accident · No injuries · Limited investigation · Final report · Nov 28, 1983 · N600TS · Substantial damage
  > After takeoff for an FAA part 135 check ride, the aircrew were unable to get a positive up indication for the landing gear. The gear was recycled & then the left main gear would not get a down & locked indication. Repeated attempts to extend the left main…
- [NTSB MKC83FA045](https://openairdocs.org/ntsb/MKC83FA045.md): Piper PA-31-350 · Dubuque, IA · Accident · 2 fatal · Field investigation · Final report · Dec 25, 1982 · N4091U · Destroyed
  > At 2015 the flt contacted ARTCC & requested Dubuque wx. They were advised that Dubuque was 500 ft indefinite ceiling, sky obscured, visibility 1/2 mi fog & they would be vectored for a back course rwy 13 apch. The flt then requested the front course apch to…
- [NTSB MKC83IA042](https://openairdocs.org/ntsb/MKC83IA042.md): Piper PA31-350 · Waterloo, IA · Incident · No injuries · Incident investigation · Final report · Dec 21, 1982 · N600TS · Minor damage
  > Prior to landing N600TS reportedly had an unsafe nose gear down indication. At landing touchdown, the nose gear collapsed. Examination revealed no evidence of mechanical malfunction however the bearing ends, p/n 452-412, showed evidence of overload failure.…

## 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 ('7103110', '7103125'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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