# NTSB investigations, ID: Wheels up landing

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 SEA06CA097](https://openairdocs.org/ntsb/SEA06CA097.md): Rupp Rutan Defiant · Coeur d'Alene, ID · Accident · No injuries · Data collection · Final report · May 5, 2006 · N726RD · Substantial damage
  > The pilot's failure to put the nose wheel landing gear down for landing.
- [NTSB SEA03LA079](https://openairdocs.org/ntsb/SEA03LA079.md): Cessna P210N · Boise, ID · Accident · No injuries · Limited investigation · Final report · May 10, 2003 · N711BG · Substantial damage
  > The landing gear extension was not performed by the pilot for landing. Contributing factors included the pilot's failure to perform the Before Landing checklist and his unfamiliarity with the landing gear warning horn system.
- [NTSB SEA96LA141](https://openairdocs.org/ntsb/SEA96LA141.md): Piper PA-24-250 · Paris, ID · Accident · No injuries · Limited investigation · Final report · Jul 2, 1996 · N5246P · Substantial damage
  > the pilot forgot to extend the landing gear before landing. Factors relating to the accident were: an interuption of the pilot's habit pattern, when he circled to provide time for another airplane to takeoff as he entered the traffic pattern; and his failure…
- [NTSB SEA94LA232](https://openairdocs.org/ntsb/SEA94LA232.md): Cessna 210D · Paris, ID · Accident · No injuries · Limited investigation · Final report · Sep 3, 1994 · N3759Y · Substantial damage
  > An inadvertent wheels up landing.
- [NTSB ANC93FA128](https://openairdocs.org/ntsb/ANC93FA128.md): Convair 240 · Boise, ID · Accident · No injuries · Field investigation · Final report · Jul 27, 1993 · N156PA · Substantial damage
  > The pilot's failure to extend the landing gear, and the check pilot's inadequate supervisiion. A factor in the accident was the pilot's inadequate upgrade training by the company.

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

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