# NTSB investigations: Lycoming R680: 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 NYC00LA010](https://openairdocs.org/ntsb/NYC00LA010.md): Boeing Stearman E75 · Fredericksburg, PA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1999 · N52951 · 2 aircraft · Minor damage
  > Was the inadequate visual lookout by the pilot of the Stearman.
- [NTSB NYC94LA141](https://openairdocs.org/ntsb/NYC94LA141.md): Boeing Stearman PT-13 · Readington, NJ · Accident · No injuries · Limited investigation · Final report · Jul 31, 1994 · N2313 · 2 aircraft · Minor damage
  > The failure of both pilots to maintain adequate visual lookout.
- [NTSB CHI91LA194](https://openairdocs.org/ntsb/CHI91LA194.md): Boeing A75N1 · Mundelein, IL · Accident · No injuries · Limited investigation · Final report · Jun 16, 1991 · N59791 · 2 aircraft · Substantial damage
  > The pilot in command's not maintaining visual contact with the previously identified airplane.
- [NTSB LAX87LA122](https://openairdocs.org/ntsb/LAX87LA122.md): Boeing PT-13D · Vacaville, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 1987 · N620BD · 2 aircraft · Substantial damage
  > The aircraft were in the holding area short of runway 19 at the uncontrolled nut tree airport. The Cessna pilot taxied into position behind landing traffic and allowed his aircraft to roll slowly forward while waiting for the landing aircraft to clear the…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41540')
    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=41540&occurrence=310

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