# NTSB investigations: Lycoming 0-235 series, OR: On ground/water 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 SEA94FA199](https://openairdocs.org/ntsb/SEA94FA199.md): Piper PA-12 · Salem, OR · Accident · 2 fatal · Field investigation · Final report · Jul 31, 1994 · N2368M · Minor damage
  > Failure of the pilot to see-and-avoid the occupied canoe. Factors related to the accident were: the pilot's improper planning/decision and excessive taxi speed.
- [NTSB SEA87LA057](https://openairdocs.org/ntsb/SEA87LA057.md): Cessna 140 · Nyssa, OR · Accident · No injuries · Limited investigation · Final report · Feb 12, 1987 · N72166 · Substantial damage
  > During takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.

## 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 ('41505')
    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" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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