# NTSB investigations: Cessna 172S: Overrun

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 NYC06CA159](https://openairdocs.org/ntsb/NYC06CA159.md): Cessna 172S · White Plains, NY · Accident · No injuries · Data collection · Final report · Jun 21, 2006 · N968SP · Substantial damage
  > The pilot's misjudged speed/distance which resulted in an overrun.
- [NTSB SEA06CA081](https://openairdocs.org/ntsb/SEA06CA081.md): Cessna 172 S · Malad City, ID · Accident · No injuries · Data collection · Final report · Apr 23, 2006 · N679SP · Substantial damage
  > The private pilot's improper touchdown point during landing and the certified flight instructors delayed remedial action. Ditches and fences were factors in the accident.
- [NTSB NYC06CA077](https://openairdocs.org/ntsb/NYC06CA077.md): Cessna 172S · Atlantic City, NJ · Accident · No injuries · Data collection · Final report · Mar 6, 2006 · N680SP · Substantial damage
  > The pilot's failure to obtain a proper touchdown point, which resulted in an overrun of the runway.
- [NTSB LAX04CA288](https://openairdocs.org/ntsb/LAX04CA288.md): Cessna 172S · Chandler, AZ · Accident · No injuries · Data collection · Final report · Aug 8, 2004 · N5327G · Substantial damage
  > the student pilot's failure to abort the takeoff. A contributing factor was the pilot's failure to maintain directional control.
- [NTSB MIA02LA112](https://openairdocs.org/ntsb/MIA02LA112.md): Cessna 172S · Kill Devil Hill, NC · Accident · No injuries · Limited investigation · Final report · Jun 13, 2002 · N793SP · Substantial damage
  > the pilot's failure to maintain control of the airplane after an attempted aborted landing, and while braking during the landing roll, which resulted in the airplane departing the end of the runway and impacting with a ditch.
- [NTSB LAX02LA092](https://openairdocs.org/ntsb/LAX02LA092.md): Cessna 172S · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 2002 · N327ME · Substantial damage
  > The pilot's selection of the wrong landing runway due to his failure to correctly interpret wind indicators, which resulted in his landing with a tailwind.
- [NTSB NYC00LA243](https://openairdocs.org/ntsb/NYC00LA243.md): Cessna 172 · Dunkirk, NY · Accident · No injuries · Limited investigation · Final report · Aug 29, 2000 · N803SP · Substantial damage
  > The pilot's improper recovery from a bounced 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072439', '2072442')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072439&occurrence=340

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