# NTSB investigations: Schweizer SGS 1-34, NY

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 ERA14CA274](https://openairdocs.org/ntsb/ERA14CA274.md): Schweizer SGS 1 34 · Middletown, NY · Accident · No injuries · Data collection · Final report · Jun 1, 2014 · N7638 · Substantial damage
  > The pilot's failure to maintain directional control during a bounced landing.
- [NTSB NYC87LA233](https://openairdocs.org/ntsb/NYC87LA233.md): Schweizer SGS-1-34 · Dansville, NY · Accident · No injuries · Limited investigation · Final report · Aug 15, 1987 · N7653 · Substantial damage
  > The plt stated that as he was adjusting his seat belt with the canopy open, the glider began being pulled by the tow pilots acft. He maneuvered the wing tip clear of some parked acft, grabbed the canopy hatch, and held it shut during the tkof. The cockpit…
- [NTSB NYC81DFJ02](https://openairdocs.org/ntsb/NYC81DFJ02.md): Schweizer 1-34R · Dansville, NY · Accident · Serious injuries · Closed · Nov 22, 1980 · N7700S · Substantial damage
- [NTSB NYC79DFJ17](https://openairdocs.org/ntsb/NYC79DFJ17.md): Schweizer SGS134 · Elmira, NY · Accident · Serious injuries · Closed · May 5, 1979 · N76JP · 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" = 'NY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8050146'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=8050146&state=NY

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