# NTSB investigations: Continental 0-300 series: In flight collision with terrain/water

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 SEA07FA165](https://openairdocs.org/ntsb/SEA07FA165.md): Cessna 172 · Yellow Pine, ID · Accident · 1 fatal · Field investigation · Final report · Jun 14, 2007 · N6233E · Substantial damage
  > The pilot's selection of the wrong routing through mountainous terrain and his failure to maintain adequate terrain clearance.
- [NTSB SEA06CA148](https://openairdocs.org/ntsb/SEA06CA148.md): Cessna 172F · American Falls, ID · Accident · No injuries · Data collection · Final report · Jul 29, 2006 · N8707U · Substantial damage
  > The pilot's failure to maintain an airspeed above stall speed. Factors include his improper decision to takeoff with a tailwind, and the effects of the tailwind upon the aircraft's takeoff performance.
- [NTSB SEA04FA191](https://openairdocs.org/ntsb/SEA04FA191.md): Cessna 172D · Mountain Home, ID · Accident · 1 fatal · Field investigation · Final report · Sep 19, 2004 · N2650U · Substantial damage
  > The pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.
- [NTSB ANC04LA112](https://openairdocs.org/ntsb/ANC04LA112.md): Cessna 170 · Teller, AK · Accident · No injuries · Limited investigation · Final report · Sep 8, 2004 · N3492C · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, and his inadequate evaluation of the wind conditions, which resulted in a collision with an embankment during takeoff-initial climb. Factors contributing to the accident was the presence of a sand…
- [NTSB ATL04CA163](https://openairdocs.org/ntsb/ATL04CA163.md): Cessna 172 · Inman, SC · Accident · Minor injuries · Data collection · Final report · Jul 29, 2004 · N3967F · Substantial damage
  > The pilot's failure to maintain clearance from the ground while maneuvering for a visual approach to land.
- [NTSB MIA03LA099](https://openairdocs.org/ntsb/MIA03LA099.md): Cessna 172D · South Ponotoc, MS · Accident · No injuries · Limited investigation · Final report · Apr 27, 2003 · N2371U · Substantial damage
  > the pilot's failure to maintain altitude and aircraft control during a low pass over a grass runway, which resulted in the airplane impacting the ground.
- [NTSB FTW02LA084](https://openairdocs.org/ntsb/FTW02LA084.md): Cessna 172A · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Feb 22, 2002 · N6845X · Substantial damage
  > the pilot's delay in executing a go-around while conducting a simulated emergency landing, which resulted in an in flight collision with terrain.
- [NTSB NYC02LA024](https://openairdocs.org/ntsb/NYC02LA024.md): Cessna 172D · Argyle, NY · Accident · No injuries · Limited investigation · Final report · Nov 2, 2001 · N36SK · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering.
- [NTSB SEA02LA001](https://openairdocs.org/ntsb/SEA02LA001.md): Cessna 172 · Lindsay, MT · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 2001 · N3910F · Destroyed
  > The pilot's failure to maintain an altitude clear of terrain. A factor was intentional low altitude flight.
- [NTSB LAX99FA162](https://openairdocs.org/ntsb/LAX99FA162.md): Globe GC-1B · Trona, CA · Accident · 2 fatal · Field investigation · Final report · Apr 25, 1999 · N80720 · Destroyed
  > The pilot's failure to maintain an adequate terrain clearance altitude while performing intentional low altitude passes over a campground.
- [NTSB FTW98LA116](https://openairdocs.org/ntsb/FTW98LA116.md): Cessna 172 · Laramie, WY · Accident · No injuries · Limited investigation · Final report · Jan 30, 1998 · N6926A · Substantial damage
  > The pilot's improper flare and subsequent improper go-around in that he failed to use compensating elevator control, and his loss of directional control.
- [NTSB MIA98LA022](https://openairdocs.org/ntsb/MIA98LA022.md): Cessna 172 · Crystal River, FL · Accident · No injuries · Limited investigation · Final report · Nov 3, 1997 · N4105F · Substantial damage
  > The certified flight instructors improper supervision of the rated pilot during a crosswind landing resulting in an in-flight collision with the left wing of the airplane and the runway, subsequent loss of directional control on landing rollout, and collision…
- [NTSB NYC98FA020](https://openairdocs.org/ntsb/NYC98FA020.md): Cessna 172E · Elkton, VA · Accident · 1 fatal · Field investigation · Final report · Oct 26, 1997 · N3097U · Destroyed
  > The pilot's intention VFR flight into instrument meteorological conditions. Contributing factors were clouds and mountainous/hilly terrain..
- [NTSB ANC97LA061](https://openairdocs.org/ntsb/ANC97LA061.md): Cessna 172 · Ninilchik, AK · Accident · No injuries · Limited investigation · Final report · Apr 22, 1997 · N5407R · Substantial damage
  > failure of the pilot to maintain altitude/clearance from a closed runway, while making a low pass, which resulted in an inadvertent touchdown.
- [NTSB ANC96LA127](https://openairdocs.org/ntsb/ANC96LA127.md): Cessna 170B · Cantwell, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1996 · N3546C · Substantial damage
  > A failure of the pilot to provide sufficient takeoff distance from the edge of the departure lake and his premature liftoff.
- [NTSB MIA96FA089](https://openairdocs.org/ntsb/MIA96FA089.md): Cessna 172D · Hawthorne, FL · Accident · 2 fatal · Field investigation · Final report · Mar 2, 1996 · N2456U · Destroyed
  > the pilot's failure to maintain the proper glidepath during an instrument approach.
- [NTSB LAX95LA181](https://openairdocs.org/ntsb/LAX95LA181.md): Cessna 172A · Colusa, CA · Accident · Minor injuries · Limited investigation · Final report · May 7, 1995 · N7358T · Destroyed
  > the pilot's selection of an inadequate en route cruise altitude for the aerial observation flight, and his failure to identify and stop an inadvertent descent while flying over flooded terrain at a very low altitude. Lack of pilot experience in low level…
- [NTSB SEA95LA071](https://openairdocs.org/ntsb/SEA95LA071.md): Cessna 172D · Lake Oswego, OR · Accident · No injuries · Limited investigation · Final report · Mar 25, 1995 · N6600T · Substantial damage
  > The pilot's improper touchdown on the surface of the water.
- [NTSB ANC94LA039](https://openairdocs.org/ntsb/ANC94LA039.md): Cessna 170B · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Mar 7, 1994 · N4310B · Substantial damage
  > The pilot-in-command's improper inflight decision making. Factors contributing to the accident were the mountainous terrain and the downdraft weather conditions.
- [NTSB LAX93LA243](https://openairdocs.org/ntsb/LAX93LA243.md): Cessna 172 · Montgomery Pass, NV · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1993 · N6185E · Destroyed
  > The pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the downdraft, low ceiling, rain, obscuration, and the mountainous terrain
- [NTSB CHI92LA212](https://openairdocs.org/ntsb/CHI92LA212.md): Cessna 172H · Chenoa, IL · Accident · No injuries · Limited investigation · Final report · Jul 26, 1992 · N8262L · Substantial damage
  > Inadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…
- [NTSB SEA91LA016](https://openairdocs.org/ntsb/SEA91LA016.md): Cessna 172A · Brigham City, UT · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1990 · N5030A · Substantial damage
  > The pilot did not maintain a proper climb rate.
- [NTSB CHI90LA153](https://openairdocs.org/ntsb/CHI90LA153.md): Cessna 172 · Millersburg, OH · Accident · No injuries · Limited investigation · Final report · Jun 13, 1990 · N7955U · Substantial damage
  > Failure of the pilot to maintain directional control during a go-around attempt. The pilots lack of total aviation experience and his motion sickness are factors associated with the accident.
- [NTSB DEN89LA168](https://openairdocs.org/ntsb/DEN89LA168.md): Cessna 172H · Hatton, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1989 · N3269L · Destroyed
  > Improper in-flight planning/decision by the pilot and his failure to maintain sufficient clearance above the ground. The tailwind, high obstruction (shelter belt), and downdraft were contributing factors.
- [NTSB MKC89LA019](https://openairdocs.org/ntsb/MKC89LA019.md): Cessna 172 · Linn, MO · Accident · No injuries · Limited investigation · Final report · Nov 3, 1988 · N6287E · Substantial damage
  > While attempting to land crosswind on a 900 foot long dirt runway, the pilot decided he was too high and had excessive airspeed. He attempted to make a go around. However, he was unable to clear a dirt embankment and struck the nose wheel. Unaware of the…
- [NTSB LAX85FVA02](https://openairdocs.org/ntsb/LAX85FVA02.md): Cessna 172 · Santa Nella, CA · Accident · Serious injuries · Final report · May 19, 1985 · N5982A · Destroyed
  > Witnesses stated the acft was circling over farm land at a low altand while in a left turn, it descended to ground impact.
- [NTSB MIA85LA005](https://openairdocs.org/ntsb/MIA85LA005.md): Cessna 172 · Miles City, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1984 · N8336B · Substantial damage
  > The acft collided with heavy brush and the ground during a takeoff from a wet sod rwy. The plt reported that the rwy hadbeen furrowed by wild hogs and he and his 13 year old son had tried to repair the damage prior to takeoff. A takeoff wasattempted using…
- [NTSB DEN84LA083](https://openairdocs.org/ntsb/DEN84LA083.md): Maule M-4S · Three Forks, MT · Accident · Minor injuries · Limited investigation · Final report · Feb 5, 1984 · N9832M · Substantial damage
  > The plt was flying low toward rising terrain. The airspeed slowed to the point that the point that the acft mushed into the ground and cartwheeled. The plt said he had not removed all the frost on the wings prior to flt and he thought the stall speed was…
- [NTSB FTW83LA348](https://openairdocs.org/ntsb/FTW83LA348.md): Cessna 172 · Marshall, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 1983 · N8095L · Substantial damage
  > The aircraft collided with an unmarked pile of dirt off the appraoch end of the runway at the harrison county airport. The runway was being extended and 5 1/2 to 6 foot tall mounds of fill dirt were left in the approach path of the runway. The pilot stated he…
- [NTSB ANC82DAG15](https://openairdocs.org/ntsb/ANC82DAG15.md): Cessna 170B · Tuluksak, AK · Accident · No injuries · Final report · Jan 17, 1982 · N3574D · Substantial damage
  > The pilot reported that on returning to bethel the weather was bad so he landed at Tuluksak. The weather cleared and the pilot attempted to return to bethel. After takeoff the pilot stated that he lost visual contact with the ground during a 180 degree turn…

## 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.engine_model_code IN ('17022')
    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" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17022&occurrence=230

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