# NTSB investigations: Onan ALL MDLS A/B, TX

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 FTW87DRG07](https://openairdocs.org/ntsb/FTW87DRG07.md): Nixon Quickie 1 · Del Rio, TX · Accident · Serious injuries · Final report · Sep 27, 1987 · N67SN · Destroyed
  > Earlier in the day, the plt had flown the home built acft on its maiden flt of 0.2 hrs with no rprtd problems. He stated that after taking off on the 2nd flt, he was climbing at aprx 200' AGL when the acft seemed to hit a gust of wind & roll left. He applied…
- [NTSB FTW86FRG05](https://openairdocs.org/ntsb/FTW86FRG05.md): Adams William C Quickie Q1 · Beeville, TX · Accident · No injuries · Final report · Dec 15, 1985 · N220WA · Substantial damage
  > The acft crashed during a forced lndg after a power loss at 200 ft AGL during takeoff. The acft crashed on the arpt in a run-up area adjacent to the rwy. The only discrepancy noted during post acc exam was a very weak spark produced by the battery coil…
- [NTSB FTW81DRG18](https://openairdocs.org/ntsb/FTW81DRG18.md): Quickie 01 · New Braunfels, TX · Accident · Minor injuries · Closed · Feb 10, 1981 · N716MH · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?engine=47850&state=TX

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