# Fatal NTSB investigations: Schweizer SGS 1-26A

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 LAX88LA247](https://openairdocs.org/ntsb/LAX88LA247.md): Schweizer SGS-1-26A · Montague, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 1988 · N2726Z · Destroyed
  > During a pleasure flight, the last transmission by the pilot stated he was going to see what the glider could do besides straight and level flight. Witnesses in the area reported that they heard a loud pop and observed the glider, minus the left wing, in a…
- [NTSB OAK74AP028](https://openairdocs.org/ntsb/OAK74AP028.md): Schweizer SGS126 · Piedra, CA · Accident · 1 fatal · Closed · Jan 12, 1974 · N3833A · Destroyed
- [NTSB LAX71AL003](https://openairdocs.org/ntsb/LAX71AL003.md): Schweizer SGS126 · Romoland, CA · Accident · 1 fatal · Closed · Jul 18, 1970 · N8681R · Destroyed
- [NTSB OAK70AP045](https://openairdocs.org/ntsb/OAK70AP045.md): Schweizer SGS126 · Fremont, CA · Accident · 1 fatal · Closed · Mar 8, 1970 · N2711Z · Destroyed
- [NTSB CHI66F0407](https://openairdocs.org/ntsb/CHI66F0407.md): Schweizer SGS126 · Ramsey, IN · Accident · 1 fatal · Closed · Oct 31, 1965 · N8633R · Substantial damage
- [NTSB UNK64X0606](https://openairdocs.org/ntsb/UNK64X0606.md): Schweizer 126A · Elsinore, CA · Accident · 1 fatal · Closed · Feb 19, 1964 · N3876A · Destroyed

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8050116'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=8050116

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