Skip to content

NTSB investigations: Schweizer SGS 2-33A, MA

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19752026

Where

Latest cases

Query with 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 ('8051606')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = '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 ('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" = '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 ('8051606'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 IAD03LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe student pilot's misjudgment of his traffic pattern altitudes, which resulted in a premature descent into a tree.Apr 19, 2003 · N1241S · Substantial damage NTSB IAD00LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe pilot's failure to attain a proper touchdown point.May 29, 2000 · N1225S · Substantial damage NTSB NYC96LA016Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Barre, MAThe pilot's improper inflight planning/decision, which resulted in his failure to return to the airport after encountering an area of no thermal lift, and his failure to maintain adequate airspeed, while maneuvering to avoid an obstruction during an off…Oct 22, 1995 · N65852 · Substantial damage NTSB NYC91LA066Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Williamstown, MAThe failure of the pilot to retract the speed brakes during the preflight, which resulted in the tow airplane being unable to attain sufficient altitude prior to releasing the glider, and the subsequent landing of the glider on unsuitable terrain.Jan 26, 1991 · N5763S · Substantial damage NTSB NYC90LA168Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Gt. Barrington, MAThe pilot's failure to maintain adequate clearance from tree during the precautionary landing. Factor was a loss of thermal lift.Jul 21, 1990 · N2724H · Substantial damage NTSB NYC88LA014Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Mansfield, MAThe Schweizer SGS-2-33A was in the traffic pattern with a student pilot and flight instructor. In the right turn from base to final, the nose dropped and control was lost. The flight instructor took control of the aircraft, and regained control, however,…Oct 24, 1987 · N5775S · Substantial damage NTSB NYC86LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Plymouth, MAShortly after takeoff, the tow was released from the glider when its nose started rising uncontrollably. The glider thencollided with the ground & was substantially damaged. The plt rprted the accident could have been avoided by more info &emphasis on the…Jul 22, 1986 · N33985 · Substantial damage NTSB NYC85LA191Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Plymouth, MAThe aircraft was towed to an alt of 3000 ft. the plt set up for landing and entered the pattern at the initial point at about 1200 ft. the apch went normally until the base leg. After turning onto the base leg, the plt experienced a high sink rate. The plt…Jul 24, 1985 · N2039T · Substantial damage NTSB NYC81FNE17Accident · No injuriesClosedSchweizer 2-33A · New Braintree, MAMay 3, 1981 · N5765S · Substantial damage NTSB NYC78FNA29Accident · 1 fatalClosedSchweizer 233A · Plymouth, MAJun 10, 1978 · N17958 · Substantial damage NTSB NYC77FNE02Accident · Serious injuriesClosedSchweizer SGS233 · Pittsfield, MAOct 17, 1976 · N33977 · Destroyed NTSB NYC76FNE07Accident · No injuriesClosedSchweizer SGS233 · North Adams, MAOct 4, 1975 · N33981 · Substantial damage NTSB NYC75FNE39Accident · Serious injuriesClosedSchweizer SGS233 · Sterling, MAJun 26, 1975 · N1222S · Substantial damage