# NTSB investigations: Lycoming 0-320 series, 2003, OR

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 SEA04LA013](https://openairdocs.org/ntsb/SEA04LA013.md): Cessna 172M · Bandon, OR · Accident · No injuries · Limited investigation · Final report · Oct 28, 2003 · N80628 · Substantial damage
  > The pilot's failure to maintain clearance from objects while on final approach. Dark night conditions, trees and a low glidepath were factors.
- [NTSB SEA04LA012](https://openairdocs.org/ntsb/SEA04LA012.md): Garnett-Robert Barnett J4B · Prineville, OR · Accident · No injuries · Limited investigation · Final report · Oct 27, 2003 · N9565A · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall during the initial takeoff climb. A factor was the lack of pilot certification.
- [NTSB SEA03LA055](https://openairdocs.org/ntsb/SEA03LA055.md): Piper PA-22 · Lexington, OR · Accident · No injuries · Limited investigation · Final report · Apr 7, 2003 · N4857A · Substantial damage
  > The pilot's inadequate compensation for the cosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.
- [NTSB SEA03LA053](https://openairdocs.org/ntsb/SEA03LA053.md): Piper PA-28-140 · Troutdale, OR · Accident · No injuries · Limited investigation · Final report · Mar 30, 2003 · N4961T · Substantial damage
  > Aircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.
- [NTSB SEA03LA036](https://openairdocs.org/ntsb/SEA03LA036.md): Cessna 172N · McMinnville, OR · Accident · No injuries · Limited investigation · Final report · Feb 8, 2003 · N734KU · Substantial damage
  > The pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds and soft terrain in the area where the aircraft departed the side of the runway.

## 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") = 2003
  AND c."eventStateOrRegion" = 'OR' 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 ('41508'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41508&state=OR&year=2003

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