# NTSB investigations, IN: Dragged wing,rotor,pod,float or tail/skid

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 CHI04CA246](https://openairdocs.org/ntsb/CHI04CA246.md): Utterback Mustang II · Kendallville, IN · Accident · Minor injuries · Data collection · Final report · Sep 4, 2004 · N91622 · Substantial damage
  > The pilot's improper recovery from a bounced landing and his failure to maintain aircraft control.
- [NTSB CHI02LA008](https://openairdocs.org/ntsb/CHI02LA008.md): Bell 47G-2 · Jeffersonville, IN · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 2001 · N840WA · Substantial damage
  > The dual student pilot's failure to maintain control of the helicopter, his failure to maintain altitude/clearance from the terrain, and the inadequate supervision by the flight instructor. A factor was the gusty wind condition.
- [NTSB CHI00LA297](https://openairdocs.org/ntsb/CHI00LA297.md): Piper PA-22/20 · Marion, IN · Accident · No injuries · Limited investigation · Final report · Sep 1, 2000 · N3383A · Substantial damage
  > the pilot failed to maintain directional control during landing. A factor was the dust devil.
- [NTSB CHI98LA206](https://openairdocs.org/ntsb/CHI98LA206.md): Parker Rotorway 162-F · Manchester, IN · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 1998 · N311RM · Substantial damage
  > the pilot misjudged the flare.
- [NTSB CHI98LA152](https://openairdocs.org/ntsb/CHI98LA152.md): Read Rotorway Executive · Valparaiso, IN · Accident · No injuries · Limited investigation · Final report · May 13, 1998 · N4561C · Substantial damage
  > the pilot not maintaining adequate clearance with the ground during hover. Factors which contributed to this accident were the pilot's execution of a hovering turn at too low of an altitude, inadequate preflight preparation, and failing to remove the…
- [NTSB CHI98LA038](https://openairdocs.org/ntsb/CHI98LA038.md): Cessna 150 · Plymouth, IN · Accident · No injuries · Limited investigation · Final report · Nov 17, 1997 · N50579 · Substantial damage
  > the pilot's failure to maintain control of the airplane during the crosswind, soft field takeoff. Factors in this accident were the pilot not following the airplane manufacturer's recommended takeoff procedures by lowering the flaps, and the crosswind.
- [NTSB CHI95LA199](https://openairdocs.org/ntsb/CHI95LA199.md): Cessna 310L · Crawfordsville, IN · Accident · No injuries · Limited investigation · Final report · Jun 24, 1995 · N3298X · Substantial damage
  > the pilot's failure to maintain adequate airspeed during final approach to landing. A factor in the accident was the pilot's delayed action of aborting the landing.
- [NTSB CHI86FET02](https://openairdocs.org/ntsb/CHI86FET02.md): Piper PA-28-180 · Syracuse, IN · Accident · 1 fatal · Final report · Jun 23, 1986 · N8226W · Destroyed
  > The acft crashed into a lake while making a farewell low pass at friends on the lakeshore. He came over the lake toward his friends at such a low alt that he had to pull up to get over the trees. He commenced a steep rt turn which progressed into a descent…
- [NTSB CHI83LA098](https://openairdocs.org/ntsb/CHI83LA098.md): Gulfstream American AA-5B · Warsaw, IN · Accident · No injuries · Limited investigation · Final report · Feb 1, 1983 · N209JA · Substantial damage
  > The plt reported that during arrival, he contacted UNICOM for an advisory. Reportedly, the wind at that time was from 090 deg at 15 KTS, within the x-wind capability of the acft. During the approach and landing, the plt slipped the plane to a normal…

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

This list as a web page: https://openairdocs.org/ntsb?occurrence=160&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.
