# NTSB investigations, 2012, MO: Runway excursion

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 CEN12LA642](https://openairdocs.org/ntsb/CEN12LA642.md): Aeropro CZ A240 · Greenfield, MO · Accident · No injuries · Limited investigation · Final report · Aug 19, 2012 · N812S · Substantial damage
  > The pilot's failure to attain a proper takeoff speed or pitch attitude during takeoff, which resulted in the airplane settling on the runway and impacting trees.
- [NTSB CEN12CA450](https://openairdocs.org/ntsb/CEN12CA450.md): Cessna 195B · Camdenton, MO · Accident · No injuries · Data collection · Final report · Jul 14, 2012 · N3092B · Substantial damage
  > The pilot's loss of directional control on landing, which resulted in a runway excursion.
- [NTSB CEN12CA399](https://openairdocs.org/ntsb/CEN12CA399.md): Edson Robert W Pietenpol AIR Camper · Point Lookout, MO · Accident · No injuries · Data collection · Final report · Jun 21, 2012 · N53WE · Substantial damage
  > The pilot's failure to maintain directional control during landing, resulting in a ground-loop.
- [NTSB CEN12CA361](https://openairdocs.org/ntsb/CEN12CA361.md): Cessna 172H · Moscow Mills, MO · Accident · No injuries · Data collection · Final report · Jun 10, 2012 · N3736R · Substantial damage
  > The pilot's failure to maintain control of the airplane during takeoff in a gusty crosswind, which resulted in a runway excursion.
- [NTSB CEN12CA293](https://openairdocs.org/ntsb/CEN12CA293.md): Cessna 152 · Lee's Summit, MO · Accident · No injuries · Data collection · Final report · Apr 9, 2012 · N25212 · Substantial damage
  > The student pilot’s loss of directional control while landing.
- [NTSB CEN12CA193](https://openairdocs.org/ntsb/CEN12CA193.md): Bellanca 17-30A · Branson, MO · Accident · No injuries · Data collection · Final report · Mar 17, 2012 · N801RC · Substantial damage
  > The pilot did not maintain directional control of the airplane while landing with a gusting crosswind.
- [NTSB CEN12LA147](https://openairdocs.org/ntsb/CEN12LA147.md): Bellanca 17-30 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Feb 2, 2012 · N6564V · Substantial damage
  > The failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.

## 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 year(c."eventDate") = 2012
  AND 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" = '300' 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/300/sequence?state=MO&year=2012

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
