# NTSB investigations: Kinner R5 series: 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 LAX01LA159](https://openairdocs.org/ntsb/LAX01LA159.md): Ryan ST3KR · Murrieta, CA · Accident · No injuries · Limited investigation · Final report · Apr 22, 2001 · N46503 · Substantial damage
  > The failure of the pilot to maintain an adequate visual lookout during taxi to avoid striking a post. A factor in the accident was the inadequate marking of the obstruction by airport personnel.
- [NTSB BFO90LA078](https://openairdocs.org/ntsb/BFO90LA078.md): de Havilland DH-82A · Bealeton, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 1990 · N9279 · 2 aircraft · Destroyed
  > The pilot's failure to maintain a vigilent watch for other aircraft operating on the uncontrolled airport. The uneven terrain on the airport restricted visibility and contributed to the accident. Another contributing factor was the improper signals given by…
- [NTSB FTW90LA121](https://openairdocs.org/ntsb/FTW90LA121.md): Cessna 140 · Fabens, TX · Accident · No injuries · Limited investigation · Final report · Jun 20, 1990 · N76728 · 2 aircraft · Substantial damage
  > Inadequate visual lookout by the pilots of both aircraft, which resulted in a failure of each pilot to see-and-avoid the other aircraft. A factor related to the accident was: failure of the ryan ST-3KR pilot to make traffic advizories while entering the…
- [NTSB FTW86LA170](https://openairdocs.org/ntsb/FTW86LA170.md): Ryan PT-22 · Kerrville, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1986 · N48331 · 2 aircraft · Substantial damage
  > While arriving for a 'fly-ing' at an uncontrolled arpt, the plt of a PT-22, N48331, turned onto final apch after the plt of a preceding acft had turned off of the rwy. At about the same time, the plt of an unregistered ultralight gyrocopter taxied onto 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 ('37504')
    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=37504&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.