NTSB investigations: Schweizer SGS 2-33A
5 cases on aircraft the registry lists as Schweizer SGS 2-33A, where the first occurrence was “Forced landing”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8051606')
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\" = 180))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8051606')
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" = 180))
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 SEA06CA125Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Hood River, ORA loss of lift, which resulted in a forced landing. Trees in the landing area were a contributing factor.NTSB NYC01LA020Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Shirley, NYThe pilot's improper in-flight decision to abort the glide toward the airport. A factor was the pilot's failure to comply with the published best glide speed.NTSB FTW96LA201Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-233A · Odessa, TXthe pilot's failure to obtain the required airspeed resulting in a hard landing. A factor was the lack of thermal lift.NTSB SEA85LA118Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Wenatchee, WAWhile returning to the arpt to land, the acft encountered strong downdrafts of 600 to 800 fpm. An off arpt landing was made and while turning from base to final, the left wing tip struck the ground. A groundloop then occurred.NTSB NYC84LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Perkasie, PAThe sailplane lost lift and during a forced landing wires were spotted on the approach. In attempting to fly under the wires the acft was flown into an embankment.