# NTSB investigations: Piper PA-28-235, 2000

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 FTW01LA018](https://openairdocs.org/ntsb/FTW01LA018.md): Piper PA-28-235 · Almyra, AR · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 2000 · N8710W · Substantial damage
  > the loss of engine power due to the crankshaft idler gear's loose lower retaining screw, which resulted in the fatigue failure of the crankshaft idler gear's upper retaining screw.
- [NTSB DEN00LA178](https://openairdocs.org/ntsb/DEN00LA178.md): Piper PA-28-235 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Sep 26, 2000 · N9281W · Substantial damage
  > The pilot's failure to maintain adequate clearance from a vehicle parked beside the ramp while he was taxiing the aircraft from landing.
- [NTSB ATL00LA093](https://openairdocs.org/ntsb/ATL00LA093.md): Piper PA-28-235 · Adel, GA · Accident · No injuries · Limited investigation · Final report · Sep 26, 2000 · N33735 · Substantial damage
  > The pilot's selection of a closed runway for landing. Contributing factors were his inadequate inflight planning/decision and the wood block on the runway..
- [NTSB CHI00LA264](https://openairdocs.org/ntsb/CHI00LA264.md): Piper PA-28-235 · Mackinac Island, MI · Accident · No injuries · Limited investigation · Final report · Aug 19, 2000 · N9174W · Substantial damage
  > the pilot not maintaining aircraft control in response to the uncommanded roll, and the excessive descent to the runway resulting in the hard landing. Factors relating to the accident were the pilot's attempted recovery from the uncommanded roll, the high…
- [NTSB NYC00LA221](https://openairdocs.org/ntsb/NYC00LA221.md): Piper PA28-235 · Chester, CT · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 2000 · N8809W · Substantial damage
  > The CFI's delayed remedial action.
- [NTSB CHI00LA164](https://openairdocs.org/ntsb/CHI00LA164.md): Piper PA-28-235 · Sully, IA · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 2000 · N9315W · Substantial damage
  > The pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…
- [NTSB FTW00LA202](https://openairdocs.org/ntsb/FTW00LA202.md): Piper PA-28-235 · Sugar Land, TX · Accident · No injuries · Limited investigation · Final report · Jun 8, 2000 · N9407W · Substantial damage
  > The pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.

## 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 year(c."eventDate") = 2000
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102810&year=2000

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