# NTSB investigations: Cessna 172G: In flight 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 IAD05CA117](https://openairdocs.org/ntsb/IAD05CA117.md): Cessna C-172G · Eustis, ME · Accident · Minor injuries · Data collection · Final report · Aug 5, 2005 · N5924R · Substantial damage
  > The pilot's failure to maintain clearance from a bush during the aborted landing.
- [NTSB CHI03LA303](https://openairdocs.org/ntsb/CHI03LA303.md): Cessna 172G · Greenville, MI · Accident · No injuries · Limited investigation · Final report · Sep 7, 2003 · N3811L · Substantial damage
  > The pilot's inadequate takeoff procedure with the use of 20 degrees of flaps. Contributing factors were the interrelated effects of high aircraft weight, the density altitude, and the relative humidity. An additional factor was the trees.
- [NTSB NYC03LA025](https://openairdocs.org/ntsb/NYC03LA025.md): Cessna 172G · Stow, MA · Accident · No injuries · Limited investigation · Final report · Nov 23, 2002 · N1152F · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.
- [NTSB IAD98LA096](https://openairdocs.org/ntsb/IAD98LA096.md): Cessna 172G · Williamson, NY · Accident · No injuries · Limited investigation · Final report · Aug 15, 1998 · N1308F · Substantial damage
  > Directional control not maintained by one of the pilot's on board the airplane.
- [NTSB SEA96LA166](https://openairdocs.org/ntsb/SEA96LA166.md): Cessna 172G · Kettle Falls, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1996 · N4478L · Destroyed
  > the pilot's inadequate preflight planning. Factors relating to the accident were: high ambient temperatures; departing from a short, grass runway; and tall trees off the departure end of the airstrip.
- [NTSB CHI96LA193](https://openairdocs.org/ntsb/CHI96LA193.md): Cessna 172 · Lowell, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 1996 · N1106F · Substantial damage
  > was inadequate initial training of the pilot and inadequate flight test procedures by the FAA Designated Pilot Examiner when he reportedly had the pilot demonstrate 12 pilot operations from the FAA's practical flight test standards in 35 minutes during the…
- [NTSB BFO95LA088](https://openairdocs.org/ntsb/BFO95LA088.md): Cessna 172G · Put-In-Bay, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 1995 · N3680L · Substantial damage
  > The pilot's delay in aborting the landing after selecting the wrong runway. Factors relating to the accident were: garbled radio transmissions on the UNICOM frequency, and the resultant tailwind for landing.
- [NTSB LAX95LA101](https://openairdocs.org/ntsb/LAX95LA101.md): Cessna 172G · Pope Valley, CA · Accident · 1 fatal · Limited investigation · Final report · Feb 9, 1995 · N4345L · Destroyed
  > the pilot's poor judgment to buzz the lake and his inadequate visual lookout.
- [NTSB ATL93FA025](https://openairdocs.org/ntsb/ATL93FA025.md): Cessna 172 · Brownsboro, AL · Accident · 3 fatal · Field investigation · Final report · Nov 20, 1992 · N5952R · Substantial damage
  > The pilot failed to evaluate the wind conditions and took off with a tailwind which resulted in the collision with a tree on the departure end of the runway. Factors were dark night and tailwind.
- [NTSB SEA92FA002](https://openairdocs.org/ntsb/SEA92FA002.md): Cessna 172G · Miltonfreewater, OR · Accident · 4 fatal · Field investigation · Final report · Oct 6, 1991 · N1372F · Destroyed
  > Inadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.
- [NTSB SEA89LA078](https://openairdocs.org/ntsb/SEA89LA078.md): Cessna 172 · Lynden, WA · Accident · No injuries · Limited investigation · Final report · May 4, 1989 · N6064R · Substantial damage
  > The pilot delayed in aborting the landing and failed obtain or maintain sufficient airspeed to keep the aircraft from mushing after lift-off. Factors related to the accident were: obstructions near the approach end of the runway, failure of the pilot to…
- [NTSB SEA83LA074](https://openairdocs.org/ntsb/SEA83LA074.md): Cessna 172G · Near Homedale, ID · Accident · No injuries · Limited investigation · Final report · Apr 5, 1983 · N3658L · Substantial damage
  > The flt originated before sunset, but the student plt practiced in the local area until the onset of darkness. While attempting to land on his private strip, he made 2 go-arounds. On the second go-around, the acft collided with an electrical wire, then flew…

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

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

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