# NTSB investigations: Lycoming 0-235 series, 2002, AZ

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 LAX03LA055](https://openairdocs.org/ntsb/LAX03LA055.md): Lipscomb Lancair 235 · Payson, AZ · Accident · 1 fatal · Limited investigation · Final report · Dec 28, 2002 · N777KL · Substantial damage
  > the pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in an inadvertent stall/spin. A contributing factor in the accident was the pilot's lack of familiarity with the airplane.
- [NTSB LAX03LA002](https://openairdocs.org/ntsb/LAX03LA002.md): Kline KSE5A · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · Oct 7, 2002 · N589D · Substantial damage
  > the pilot's failure to compensate for the wind conditions resulting in a loss of directional control during the takeoff roll. A contributing factor was the pilot's incorrect installation of the left wheel, which resulted in a locked left wheel when the brakes…
- [NTSB LAX02LA170](https://openairdocs.org/ntsb/LAX02LA170.md): Piper PA-38-112 · Kingman, AZ · Accident · No injuries · Limited investigation · Final report · May 28, 2002 · N4326E · Substantial damage
  > the CFI's failure to obtain/maintain an adequate airspeed during an attempted go-around, which resulted in a stall/mush condition. The high density altitude, tailwind, inadequate supervision, and overgross weight condition were factors.

## 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") = 2002
  AND c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41505&state=AZ&year=2002

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
