NTSB investigations: Schweizer SGS 2-33AK

6 cases on aircraft the registry lists as Schweizer SGS 2-33AK. 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

NTSB investigations: Schweizer SGS 2-33AK per year, 1975–2026: 6 cases
1975	1
1976	2
1982	1
1996	1
2010	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8050210')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8050210'))
  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 ('8050210'))
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 ERA10LA387Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33AK · Windsor, VAThe unauthorized installation of a battery and associated wiring and electrical components, which resulted in an in-flight electrical fire of undetermined origin.Jul 30, 2010 · N17965 · Substantial damage NTSB CHI96TA260Accident · No injuriesFinal reportSchweizer SGS 2-33AK · Mattoon, ILthe pilot's failure to maintain directional control of the glider. Factors were the runway sign and the failure of the pilot to maintain a visual lookout.Jun 19, 1996 · N65809 · Substantial damage NTSB NYC83LA011Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33AK · Mecklenburg, NYDuring approach the pilot misjudged the wind velocity and failed to allow for strong downdrafts. The glider lost altitude 4-500 feet short of the field over a wooden area and came to rest in a nosed over position in the trees.Oct 17, 1982 · N17965 · Substantial damage NTSB FTW76FPA22Accident · No injuriesClosedSchweizer SGS233 · Cedar Hill, TXMay 1, 1976 · N17959 · Substantial damage NTSB NYC76DFJ17Accident · Minor injuriesClosedSchweizer SGS233 · Elmira, NYMar 14, 1976 · N17965 · Substantial damage NTSB NYC76FFJ05Accident · No injuriesClosedSchweizer 2-33A · Ithaca, NYAug 27, 1975 · N17965 · Substantial damage