# NTSB investigations, ID: 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 SEA01LA069](https://openairdocs.org/ntsb/SEA01LA069.md): Cessna 180H · Coeur d'Alene, ID · Accident · No injuries · Limited investigation · Final report · Mar 27, 2001 · N2780X · Substantial damage
  > The pilot's failure to maintain aircraft control during the aborted takeoff. A factor was gusty crosswinds.
- [NTSB SEA99LA137](https://openairdocs.org/ntsb/SEA99LA137.md): Cessna 180J · Council, ID · Accident · No injuries · Limited investigation · Final report · Aug 10, 1999 · N7739K · Substantial damage
  > The pilot's inadequate recovery from a bounced landing. Gusting wind conditions and a dirt bank adjacent to the runway edge were factors.
- [NTSB SEA98LA043](https://openairdocs.org/ntsb/SEA98LA043.md): Piper PA-38-112 · Dubois, ID · Accident · No injuries · Limited investigation · Final report · Mar 11, 1998 · N2438L · Substantial damage
  > The student pilot's misjudgment of altitude/clearance and overloading of the nose gear. A contributing factor was the snow-covered turf runway.
- [NTSB SEA98LA010](https://openairdocs.org/ntsb/SEA98LA010.md): Luscombe 8F · Boise, ID · Accident · No injuries · Limited investigation · Final report · Nov 4, 1997 · N1895B · Substantial damage
  > The student pilot's failure to maintain directional control due to excessive taxispeed. Pressure perceived by the student pilot to expedite clearing the runway after landing in order to facilitate an aircraft departure was a contributing factor.
- [NTSB SEA96IA027](https://openairdocs.org/ntsb/SEA96IA027.md): Boeing 727-232 · Boise, ID · Incident · No injuries · Incident investigation · Final report · Dec 8, 1995 · N543DA · Minor damage
  > the pilot-in-command's misjudgment of the remedial action necessary to correct the aircraft's misalignment with the runway. The dark night conditions, fog, and the pilot-in-command's failure to maintain proper alignment with the runway were factors.
- [NTSB SEA91LA195](https://openairdocs.org/ntsb/SEA91LA195.md): Grumman G-164A · Genesee, ID · Accident · No injuries · Limited investigation · Final report · Jul 28, 1991 · N48599 · Destroyed
  > The pilot's failure to maintain alignment with the strip. Contributing to the accident was the glare of a bright horizon at dawn.
- [NTSB SEA86LA223](https://openairdocs.org/ntsb/SEA86LA223.md): Ayres S2R-600 · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Aug 24, 1986 · N4077X · Substantial damage
  > During an aerial application flight, the plt entered a right turn during a 'border pass.' While in the right turn, the right wing struck the ground and the aircraft cartwheeled & crashed.

## 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" = 'ID' 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=ID

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