# NTSB investigations, IA: Miscellaneous/other

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 CHI98FA244](https://openairdocs.org/ntsb/CHI98FA244.md): Stubbe-Kitfox Classic · Traer, IA · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1998 · N494S · 2 aircraft · Destroyed
  > the failure of the pilot of the Kitfox to maintain flying speed (Vs).
- [NTSB CHI96LA102](https://openairdocs.org/ntsb/CHI96LA102.md): Balloon Works Firefly 7-15 · Brighton, IA · Accident · Serious injuries · Limited investigation · Final report · Feb 25, 1996 · N2598H · No damage
  > The pilot's bone condition, which resulted in a fractured ankle during a normal touchdown.
- [NTSB MKC89LA031](https://openairdocs.org/ntsb/MKC89LA031.md): Bellanca 17-30 · Martelle, IA · Accident · No injuries · Limited investigation · Final report · Dec 7, 1988 · N198V · Substantial damage
  > Anticipating a fuel shortage on a personal cross country flight, the plt requested the nearest airport from approach control. The nearest apt was within five miles of his destination apt so continued on course. About 15 miles from his destination, and having…
- [NTSB MKC85FA217](https://openairdocs.org/ntsb/MKC85FA217.md): Piper PA-28-181 · What Cheer, IA · Accident · Serious injuries · Field investigation · Final report · Sep 16, 1985 · N8262U · Substantial damage
  > The acft was observed flying through the top of a tree, then through a four strand high voltage pwr line. Final impact was relatively flat in a soy-bean field. The plt later stated that he had become disoriented in flt and hallucinated that he was in a Piper…
- [NTSB MKC85LA029](https://openairdocs.org/ntsb/MKC85LA029.md): Sikorsky S58J · Storm Lake, IA · Accident · 1 fatal · Limited investigation · Final report · Nov 28, 1984 · N62243 · No damage
  > A passenger was being transported from a boat to shore. The plt lowered a wheel strut to the boat for the boarding and says he received a radio call from the passenger saying, 'ok I'm ready let's go.' The plt assumed that he was inside the acft and a climb…
- [NTSB MKC82DA102](https://openairdocs.org/ntsb/MKC82DA102.md): Balloon Works Firefly 6 · Hudson, IA · Accident · No injuries · Final report · Jun 13, 1982 · N2067F · Substantial damage
  > The Balloon was in a descent and was approaching the landing area when the burner pilot-light went out. Without the burner, the pilot was forced to land short of his selected field. He spilled the air from the Balloon and touched down just short of an 8000…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 430)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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