# NTSB investigations, MO: Aircraft inspection event

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 WPR23LA158](https://openairdocs.org/ntsb/WPR23LA158.md): Piper PA-18A 150 · Garrison, MO · Accident · No injuries · Class 3 · Limited · Final report · Apr 14, 2023 · N7278D · Substantial damage
  > The pilot’s inadequate fuel planning which resulted in fuel starvation, a loss of engine power and a subsequent impact with terrain.
- [NTSB CEN14LA194](https://openairdocs.org/ntsb/CEN14LA194.md): Cessna T210M · Lee's Summit, MO · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 2014 · N761BT · Substantial damage
  > The pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.
- [NTSB DFW08LA209](https://openairdocs.org/ntsb/DFW08LA209.md): Evektor Aerotechnik Sportstar · St Charles, MO · Accident · No injuries · Limited investigation · Final report · Aug 5, 2008 · N411EV · Substantial damage
  > The student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.
- [NTSB CHI08IA182](https://openairdocs.org/ntsb/CHI08IA182.md): Mcdonnell Douglas MD-81 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Jul 7, 2008 · N804ME · Minor damage
  > The inadvertent partial inflation of the evacuation slide within the tailcone during takeoff and subsequent binding of the elevator control cables. The partial inflation resulted from the tailcone evacuation slide cover failing to be secured to the floor…

## 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" = '050' 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/050/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.