# NTSB investigations: Boeing 737-3H4, MO

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 ENG14IA005](https://openairdocs.org/ntsb/ENG14IA005.md): Boeing 737 3H4 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Dec 23, 2013 · N360SW · Minor damage
  > The initial damage to the fan blades was caused by the ingestion of two mallard ducks that caused one or more fan blades to fracture, striking the fan shroud, as well as other passing fan blades, producing various sized blades fragments that created a…
- [NTSB CHI93IA354](https://openairdocs.org/ntsb/CHI93IA354.md): Boeing 737-300 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Sep 8, 1993 · N350SW · Minor damage
  > a failure of the left outboard foreflap due to the loss of the bolts that hold the inboard sequencing carriage to the foreflap attach lug.
- [NTSB FTW92LA200](https://openairdocs.org/ntsb/FTW92LA200.md): Boeing 737-300 · Springfield, MO · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 1992 · N357SW · No damage
  > The encounter with severe turbulence while deviating around convective activity.

## 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" = 'MO' 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 ('138447K'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=138447K&state=MO

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