# Major NTSB investigations, 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 DCA93GA042](https://openairdocs.org/ntsb/DCA93GA042.md): Mitsubishi MU-2B-60 · Zwingle, IA · Accident · 8 fatal · Class 1 · Final report · Apr 19, 1993 · N86SD · Destroyed
  > The fatigue cracking and fracture of the propeller hub arm. The resultant separation of the hub arm and the propeller blade damaged the engine, nacelle, wing, and fuselage, thereby causing significant degradation to aircraft performance and control that made…
- [NTSB DCA89MA063](https://openairdocs.org/ntsb/DCA89MA063.md): Mcdonnell Douglas DC-10-10 · Sioux City, IA · Accident · 111 fatal · Class 1 · Major · Final report · Jul 19, 1989 · N1819U · Destroyed
  > The inadequate consideration given to human factors limitations in the inspection and quality control procedures used by united airlines' engine overhaul facility which resulted in the failure to detect a fatigue crack originating from a previously…
- [NTSB MKC86MA031](https://openairdocs.org/ntsb/MKC86MA031.md): Rockwell 500-S · Des Moines, IA · Accident · 7 fatal · Major investigation · Final report · Nov 25, 1985 · N81589 · Destroyed
  > N81589 was flwg a Boeing 727 on ILS apch in IFR conds. Aprx 2.5 mi fm rwy, N81589 suddenly deviated left nrly 90 deg. 39 sec later, plt rprtd he enctrd svr turbc, then said he was trying to clb. N81589 subsequently flew thru tree tops on rising trrn for aprx…
- [NTSB DCA69A0009](https://openairdocs.org/ntsb/DCA69A0009.md): Douglas DC- 9 · Sioux City, IA · Accident · Serious injuries · Closed · Dec 27, 1968 · N974Z · Destroyed

## 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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