# NTSB investigations, IN: On ground/water encounter 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 CHI06CA130](https://openairdocs.org/ntsb/CHI06CA130.md): Robinson R22 Beta · Brook, IN · Accident · No injuries · Data collection · Final report · Apr 25, 2006 · N7197K · Substantial damage
  > The pilot's intentional decision to leave the helicopter unattended with the engines running which resulted in a dynamic rollover. The inadvertent dynamic rollover was a factor.
- [NTSB CHI04CA102](https://openairdocs.org/ntsb/CHI04CA102.md): Schweizer SGS 2-33A · Lake Village, IN · Accident · No injuries · Data collection · Final report · Apr 4, 2004 · N17882 · Substantial damage
  > The unsuitable terrain the Certified Flight Instructor encountered during the off-field landing. The low altitude, the downdraft or "sink" experienced during flight, and the soft terrain conditions were factors to the accident.
- [NTSB CHI00LA061](https://openairdocs.org/ntsb/CHI00LA061.md): Piper PA-22-150 · Plymouth, IN · Accident · No injuries · Limited investigation · Final report · Jan 23, 2000 · N3814P · Substantial damage
  > the pilot's disregard of the unsafe runway condition, his decision to operate the airplane on unsuitable terrain, and the failure to maintain runway centerline alignment which resulted in the landing gear contacting deeper snow. Factors associated with the…
- [NTSB CHI98LA195](https://openairdocs.org/ntsb/CHI98LA195.md): Cessna 172E · Demotte, IN · Accident · No injuries · Limited investigation · Final report · Jun 10, 1998 · N3933S · Substantial damage
  > The pilot's inadequate preflight planning that failed to ensure takeoff could be attained. Other related factors were the aborted takeoff, grass, and a dirt bank.
- [NTSB CHI96LA071](https://openairdocs.org/ntsb/CHI96LA071.md): Piper PA-31-350 · Zionsville, IN · Accident · No injuries · Limited investigation · Final report · Jan 4, 1996 · N111UC · Substantial damage
  > the pilot's failure to properly align the airplane for a safe landing on the runway. Related factors were: the pilot's inadequate preflight planning/preparation, snow, the snow-covered runway, and snowbanks on the sides of the runway.
- [NTSB CHI90LA088](https://openairdocs.org/ntsb/CHI90LA088.md): Mitsubishi MU-300 · Gary, IN · Accident · No injuries · Limited investigation · Final report · Feb 23, 1990 · N368PU · Substantial damage
  > Failure of snow removal personnel to recognize the potential hazard of the snow ridge on the runway and communicate this information to the control tower. Factors related to the accident were: the runway/terrain/light conditions, and failure of airport…
- [NTSB CHI89DET07](https://openairdocs.org/ntsb/CHI89DET07.md): Good Varieze · Spencerville, IN · Accident · No injuries · Final report · Jun 7, 1989 · N79SG · Substantial damage
  > The pilot's failure to maintain proper runway alignment during the soft field landing.
- [NTSB CHI87LA071](https://openairdocs.org/ntsb/CHI87LA071.md): Cessna 152II · West Middleton, IN · Accident · No injuries · Limited investigation · Final report · Jan 25, 1987 · N6179Q · Substantial damage
  > During the landing roll the left main gear struck a snowbank. The nose wheel then got caught in snow and the acft tipped up on the prop and left wing.
- [NTSB CHI84LA129](https://openairdocs.org/ntsb/CHI84LA129.md): Cessna 150M · Hagerstown, IN · Accident · No injuries · Limited investigation · Final report · Mar 3, 1984 · N714MC · Substantial damage
  > During the rollout after a normal landing the acft collided with a snowdrift on the sod rwy. The collision collapsed theacft nose gear and damaged the propeller and firewall of the acft.
- [NTSB CHI83LA363](https://openairdocs.org/ntsb/CHI83LA363.md): Cessna 172 · Grandview, IN · Accident · No injuries · Limited investigation · Final report · Aug 6, 1983 · N8164B · Substantial damage
  > The acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…
- [NTSB CHI82DA133](https://openairdocs.org/ntsb/CHI82DA133.md): Cessna 182 · Brazil, IN · Accident · No injuries · Final report · Apr 25, 1982 · N6308A · Substantial damage
  > The pilot elected to land on the grass adjacent to a paved runway. While on landing roll the landing gear contacted the edge of a paved taxiway that ran perpendicular to the runway. The aircraft nosed over and came to rest inverted.

## 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."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=320&state=IN

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