# NTSB investigations, OR: 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 LAX07CA159](https://openairdocs.org/ntsb/LAX07CA159.md): Cessna T210L · The Dalles, OR · Accident · No injuries · Data collection · Final report · May 11, 2007 · N66CE · Substantial damage
  > The pilot's failure to extend the landing gear.
- [NTSB SEA07LA030](https://openairdocs.org/ntsb/SEA07LA030.md): Cessna P210N · Burns, OR · Accident · No injuries · Limited investigation · Final report · Dec 6, 2006 · N6006P · Substantial damage
  > The pilot's failure to put the landing gear down for landing.
- [NTSB SEA05CA078](https://openairdocs.org/ntsb/SEA05CA078.md): Shannon Lancair Legacy 2000 · Bend, OR · Accident · No injuries · Data collection · Final report · Apr 8, 2005 · N115YP · Substantial damage
  > The pilot's failure to put the landing gear down for landing.
- [NTSB SEA01LA177](https://openairdocs.org/ntsb/SEA01LA177.md): Cessna 172RG · Newberg, OR · Accident · No injuries · Limited investigation · Final report · Sep 30, 2001 · N6515R · Substantial damage
  > The pilot's failure to lower the landing gear. A factor was the pilot's failure to follow checklist procedures.
- [NTSB SEA98LA186](https://openairdocs.org/ntsb/SEA98LA186.md): Beech A35 · Christmasvalley, OR · Accident · No injuries · Limited investigation · Final report · Sep 23, 1998 · N516B · Substantial damage
  > A jammed nose gear. A corroded cable and the failure of the owner to have an annual inspection performed on the airplane were factors.
- [NTSB SEA97LA144](https://openairdocs.org/ntsb/SEA97LA144.md): Beech N35 · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Jun 16, 1997 · N1382Z · Substantial damage
  > the pilot's failure to ensure the landing gear was down and locked for landing. The unlatched passenger door, the uphill (unidirectional) landing area, and trees off the departure end of the landing runway were related factors.
- [NTSB SEA96LA121](https://openairdocs.org/ntsb/SEA96LA121.md): Beech 35 · Aurora, OR · Accident · No injuries · Limited investigation · Final report · Jun 10, 1996 · N2145D · Substantial damage
  > failure of the non-certificated pilot to ensure that the landing gear was properly extended for landing. The non-certificated pilot's diverted attention was a related factor.

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

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