NTSB investigations: Schweizer SGS 2-33A, MO
6 cases on aircraft the registry lists as Schweizer SGS 2-33A. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1975 | 1 |
|---|---|
| 1977 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 2004 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\" = 'MO' 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 ('8051606'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" = 'MO' 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 ('8051606'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI07CA232Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Warrensburg, MOThe flight instructor's failure to maintain adequate airspeed and aircraft control, which resulted in a stall while on final approach. A factor in the accident were the two fences.NTSB CHI04CA200Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33 · Warrensburg, MOThe pilot's inadequate compaensation for the winds, and his inability to maintain directional control of the glider after encountering tall grass during the landing roll. The reported wind gust, tall grass, and the fence were contributing factors.NTSB MKC88LA117Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Warrensburg, MODuring a student pilot's first solo in a glider, the plt said he misread the altimeter by 1000 feet. Attempting to land on the airport during the low approach, he struck trees, then a fence, before ground contact.NTSB MKC83LA227Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Warrensburg, MOThe glider landed short of the rwy hitting a rough hump which was an old fence line. The glider bounced & landed hard on the rwy. The pax was hospitalized for 4 days for observation & treatment.NTSB MKC77FCA20Accident · No injuriesClosedSchweizer 2-33A · St Charles, MONTSB MKC75FCA26Accident · No injuriesClosedSchweizer 2-33A · St Charles, MO