# NTSB investigations: Deberry STARDUSTER SA100

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 NYC88DHA03](https://openairdocs.org/ntsb/NYC88DHA03.md): Debarry/Starduster SA100 · Slatington, PA · Accident · No injuries · Final report · Aug 21, 1988 · N22GT · Substantial damage
  > As the homebuilt acft was climbing thru about 300 ft AGL during initial climb after takeoff, the eng lost power. The plt was able to restart the eng (once), but as he turned the acft back toward the arpt, the eng lost power again. During an emerg landing, the…
- [NTSB NYC76AHD20](https://openairdocs.org/ntsb/NYC76AHD20.md): Starduster SA-100 · Hammonton, NJ · Accident · No injuries · Closed · Mar 27, 1976 · N22GT · 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('86601AP'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=86601AP

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