# NTSB investigations: Schweizer SGS 2-33, MA

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 BFO95LA046](https://openairdocs.org/ntsb/BFO95LA046.md): Schweizer SC2-33A · North Adams, MA · Accident · No injuries · Limited investigation · Final report · Apr 15, 1995 · N5725S · Substantial damage
  > the failure of the tow rope during the initial climb. Related factors are the gusty wind conditions, the low altitude at which the failure occurred, the tailwind during the emergency landing roll, and the CFI's intentional ground loop due to the obstacle…
- [NTSB NYC78FNA47](https://openairdocs.org/ntsb/NYC78FNA47.md): Schweitzer 233A · Plymouth, MA · Accident · Minor injuries · Closed · Sep 16, 1978 · N2461W · Substantial damage
- [NTSB NYC78FNA15](https://openairdocs.org/ntsb/NYC78FNA15.md): Schweizer SGS233 · Norfolk, MA · Accident · No injuries · Closed · Apr 8, 1978 · N2480W · Substantial damage
- [NTSB NYC74FNA41](https://openairdocs.org/ntsb/NYC74FNA41.md): Schweizer 2-33 · Plymouth, MA · Accident · Serious injuries · Closed · Apr 21, 1974 · N2489W · Substantial damage
- [NTSB NYC70DFD22](https://openairdocs.org/ntsb/NYC70DFD22.md): Schweizer 2-33 · Shirley, MA · Accident · No injuries · Closed · Jun 28, 1970 · N2489W · 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" = 'MA' 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 ('8051604'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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