# NTSB investigations: Cessna 172G: On ground/water collision with object

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 NYC01LA014](https://openairdocs.org/ntsb/NYC01LA014.md): Cessna 172G · Steubenville, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 14, 2000 · N4352L · Substantial damage
  > The pilot's failure to maintain directional control while landing with a crosswind. Factors in the accident were the pilot's lack of familiarity in the make and model airplane, and the crosswind conditions.
- [NTSB CHI99LA201](https://openairdocs.org/ntsb/CHI99LA201.md): Cessna 172G · Union, IN · Accident · No injuries · Limited investigation · Final report · Jun 28, 1999 · N5869R · Substantial damage
  > The pilot's failure to maintain clearance with the sign. Factors associated with the accident were the low ceilings and the sign which was contacted.
- [NTSB MIA98LA234](https://openairdocs.org/ntsb/MIA98LA234.md): Cessna 172G · Leesburg, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1998 · N5797R · Substantial damage
  > The pilot's decision to leave the engine running with no one at the controls as he exited the aircraft to check for wheel chocks in place. This resulted in the aircraft moving uncontrolled and eventually colliding with a fence.
- [NTSB CHI97LA298](https://openairdocs.org/ntsb/CHI97LA298.md): Cessna 172G · Chicago, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 1997 · N4375L · Substantial damage
  > the pilot's selection of the wrong taxi route (service road) and not maintaining clearance between his airplane's wing and a bus.
- [NTSB NYC92LA182](https://openairdocs.org/ntsb/NYC92LA182.md): Cessna 172H · New Cumberland, WV · Accident · No injuries · Limited investigation · Final report · Aug 25, 1992 · N1109F · Substantial damage
  > The pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…
- [NTSB LAX92LA286](https://openairdocs.org/ntsb/LAX92LA286.md): Cessna 172G · Tonopah, NV · Accident · No injuries · Limited investigation · Final report · Jul 3, 1992 · N4417L · Substantial damage
  > The failure of the pilot to adequately identify and compensate for the existing tailwind conditions, and, his failure to initiate a go around when he became aware of being high with a fast ground speed.
- [NTSB LAX92LA248](https://openairdocs.org/ntsb/LAX92LA248.md): Cessna 172L · Safford, AZ · Accident · No injuries · Limited investigation · Final report · May 31, 1992 · N4163L · Substantial damage
  > The airplane colliding with animals which ran on to the runway during the pilot's takeoff roll. A factor in this accident was the pilot not being able to take remedial action and avoid the animals.
- [NTSB ATL87LA056](https://openairdocs.org/ntsb/ATL87LA056.md): Cessna 172G · New Philadelphi, OH · Accident · No injuries · Limited investigation · Final report · Dec 23, 1986 · N380LA · Substantial damage
  > The acft right wing tip struck a hangar door while taxiing. The plt reported that he initially estimated the damage to be limited to the fiberglass wing tip fairing. He subsequently flew the aircraft back to his original departure point. Further examination…

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

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

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