# NTSB investigations, MO: Fire/smoke (post-impact)

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 CEN15FA164](https://openairdocs.org/ntsb/CEN15FA164.md): Airbus Helicopters (Eurocopte EC-130-B4 · St Louis, MO · Accident · 1 fatal · Field investigation · Final report · Mar 7, 2015 · N356AM · Destroyed
  > The pilot's decision to land during unfavorable wind conditions, which resulted in a loss of control due to settling with power. Contributing to the accident were the lack of an adequate approach path due to numerous obstructions and the lack of available…
- [NTSB CEN11FA008](https://openairdocs.org/ntsb/CEN11FA008.md): Grumman American AA-5A · Springfield, MO · Accident · 1 fatal · Field investigation · Final report · Oct 6, 2010 · N9695U · Substantial damage
  > The pilot's failure to maintain control of the airplane during an attempted go-around, which led to an aerodynamic stall.
- [NTSB CEN10CA185](https://openairdocs.org/ntsb/CEN10CA185.md): Air Tractor AT-301 · Malden, MO · Accident · Minor injuries · Data collection · Final report · Apr 2, 2010 · N3653T · Substantial damage
  > The pilot's failure to maintain clearance from a tree during an aerial application flight.
- [NTSB CEN10LA034](https://openairdocs.org/ntsb/CEN10LA034.md): Piper PA-18-135 · Sikeston, MO · Accident · 2 fatal · Limited investigation · Final report · Oct 31, 2009 · N1198C · Substantial damage
  > The pilot's failure to maintain directional control during a crosswind takeoff.
- [NTSB CEN09CA004](https://openairdocs.org/ntsb/CEN09CA004.md): Cessna 182P · Mount Vernon, MO · Accident · No injuries · Data collection · Final report · Oct 8, 2008 · N21544 · Destroyed
  > The pilot failed to maintain a proper landing aim point. Contributing to the accident were the setting sun and the uneven terrain approaching the runway.
- [NTSB DFW08FA218](https://openairdocs.org/ntsb/DFW08FA218.md): Robinson R44 II · Ridgedale, MO · Accident · 2 fatal · Field investigation · Final report · Aug 29, 2008 · N41411 · Destroyed
  > An in-flight loss of control for undetermined reasons.
- [NTSB DFW08FA204](https://openairdocs.org/ntsb/DFW08FA204.md): Cessna 182 · Cassville, MO · Accident · 1 fatal · Field investigation · Final report · Aug 10, 2008 · N214MT · Destroyed
  > The pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing to the accident was the pilot's self-induced pressure to conduct the…
- [NTSB DFW08LA178](https://openairdocs.org/ntsb/DFW08LA178.md): Grumman G-164 · Stotesbury, MO · Accident · No injuries · Limited investigation · Final report · Jul 3, 2008 · N520Y · Destroyed
  > Fracture of the engine's number eight cylinder barrel resulting in a loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '170' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/170/sequence?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.