# NTSB investigations: Warner SS165 series: In flight collision with terrain/water

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 CHI88DEX10](https://openairdocs.org/ntsb/CHI88DEX10.md): Williams Waco · Madison, IN · Accident · No injuries · Final report · Jul 24, 1988 · N810TW · Substantial damage
  > The plt made svrl hi speed taxi checks, then took off on his 1st flt in this make & model of acft. He climbed to alt to check the stall characteristics, then returned to the arpt. However, as he was landing, the acft contacted the ground near the end of the…
- [NTSB FTW86FPA02](https://openairdocs.org/ntsb/FTW86FPA02.md): Homebuilt Fokker DR-1 Replica · Denton, TX · Accident · Minor injuries · Final report · Nov 2, 1985 · N152DR · Destroyed
  > The pilot stated he was making his fourth fly-by at 400 feet AGL when the aircraft developed a high sink rate. He then lowered the nose and gained airspeed for recovery. While leveling off he had to turn left to avoid impact with a small tree. At this time…

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

This list as a web page: https://openairdocs.org/ntsb?engine=64504&occurrence=230

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