# NTSB investigations: Lycoming TI0-540 series, OR: In flight collision with object

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 SEA00LA162](https://openairdocs.org/ntsb/SEA00LA162.md): Piper PA-32-300 · Birkenfeld, OR · Accident · No injuries · Limited investigation · Final report · Jul 29, 2000 · N934PH · Substantial damage
  > The pilot's delayed go-around, which resulted in the aircraft not clearing the fence posts. A contributing factor was the fence posts.
- [NTSB SEA95LA039](https://openairdocs.org/ntsb/SEA95LA039.md): Piper PA-31-350 · La Grande, OR · Accident · No injuries · Limited investigation · Final report · Jan 21, 1995 · N36PB · Substantial damage
  > Failure of the pilot to maintain proper altitude/clearance from higher terrain that was located near the airport. Factors related to the accident were: low ceiling, fog, false/incorrect indication of the NDB, failure of other personnel to properly issue a…
- [NTSB SEA87LA040](https://openairdocs.org/ntsb/SEA87LA040.md): Piper PA-32-300 · Gates, OR · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1986 · N4116R · Destroyed
  > The plt was attempting to land the aircraft at night on an unlit grass airstrip. Prior to reaching the airstrip the plt collided with an apple tree. Both wings were severed from the aircraft and it went inverted before striking the ground in a slightly nose…

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41533')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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