# NTSB investigations: Schweizer SGS 2-33: In flight collision with object

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 MIA06CA045](https://openairdocs.org/ntsb/MIA06CA045.md): Schewizer 233 · Immokalee, FL · Accident · No injuries · Data collection · Final report · Jan 15, 2006 · N5728S · Substantial damage
  > The pilot's failure to maintain clearance during the final approach to land, which resulted in an impact with trees, and a hard landing.
- [NTSB NYC95LA189](https://openairdocs.org/ntsb/NYC95LA189.md): Schweizer SGS 2-33A · Erwinna, PA · Accident · No injuries · Limited investigation · Final report · Aug 13, 1995 · N5750S · Substantial damage
  > the flight instructor's inadequate supervision during the final approach which resulted in the student flying a low approach and a subsequent collision with the trees. A factor relating to the accident was the student pilot's failure to maintain a proper…
- [NTSB ATL86LA258](https://openairdocs.org/ntsb/ATL86LA258.md): Schweizer SGS 2-33 · Chardon, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1986 · N5722S · Substantial damage
  > During final landing approach to runway 14, the sutdent pilot deployed spoilers and attempted to maintain altitude. The glider collided with trees and descended out of control to the ground 200 feet short of the runway. The student pilot had a total flight…

## 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 ('8051604')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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