# NTSB investigations: Thrash Frank J 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 MIA89LA079](https://openairdocs.org/ntsb/MIA89LA079.md): Stolp-Adams SA100 · Indian Rocks, FL · Accident · No injuries · Limited investigation · Final report · Feb 4, 1989 · N511U · Substantial damage
  > The pilot's attempt to perform aerobatic maneuvers in an aircraft that was not equipped with fuel and oil systems that would continue to operate in inverted positions. This action resulted in a loss of power and the pilot having to ditch the aircraft.
- [NTSB ANC86LAG06](https://openairdocs.org/ntsb/ANC86LAG06.md): Star Duster SA-100 · Anchorage, AK · Accident · Serious injuries · Final report · Sep 26, 1986 · N578A · Destroyed
  > Shortly after departure of a Boeing 747 jet, this aircraft was cleared for takeoff. At an altitude of 200 feet the pilot lost directional control of aircraft causing the aircraft to crash next to the runway. Just prior to takeoff the pilot was issued wake…
- [NTSB IAD78DKM26](https://openairdocs.org/ntsb/IAD78DKM26.md): Starduster SA-100 · Franklinville, NC · Accident · No injuries · Closed · Sep 27, 1978 · N33BG · Destroyed
- [NTSB LAX75FUA08](https://openairdocs.org/ntsb/LAX75FUA08.md): Starduster SA100 · Long Beach, CA · Accident · No injuries · Closed · Aug 18, 1974 · N163G · 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 ('8660104'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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