Skip to content

NTSB investigations: Schweizer SGS 2-32, CA

23 cases on aircraft the registry lists as Schweizer SGS 2-32. 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

19682026

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" = 'CA' 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 ('8050206')) 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\" = 'CA' 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 ('8050206'))
  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" = 'CA' 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 ('8050206'))
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 WPR22LA007Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-32 · San Juan Baptista, CAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which necessitated a forced landing.Oct 9, 2021 · N87R · Substantial damage NTSB WPR11CA411Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Warner Springs, CAThe pilot’s inadequate altitude to clear a ridgeline while maneuvering over a mountainous area.Aug 28, 2011 · N5840V · Substantial damage NTSB WPR09CA272Accident · No injuriesData collectionFinal reportSchweizer SGS 2-32 · Warner Springs, CAThe pilot's failure to maintain clearance from a tree while maneuvering in flight.May 30, 2009 · N5826V · Substantial damage NTSB SEA08LA067Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Hollister, CAThe dual student's failure to maintain aircraft control while taxiing from the active runway and the delayed remedial action by the flight instructor. A contributing factor was the unfavorable high wind condition.Jan 25, 2008 · N87R · Substantial damage NTSB LAX98FA007Accident · 1 fatalField investigationFinal reportSchweizer 2-32 · Warner Springs, CAthe pilot's inadvertent flight into instrument meteorological conditions after inadvertently encountering mountain wave and associated downdraft conditions. The obscuration and high/mountainous terrain were related factors.Oct 11, 1997 · N242DB · Substantial damage NTSB LAX87LA224Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Fremont, CAWhile on final apch to lnd on rwy 28, a glider (Schweizer sgs 2-32, N242DB) & a tow plane (Bellanca 7KCAB, N88314) collided in flt at an alt of about 200' AGL. The tow plane was returning fm a LCL tow mission & the glider was returningfm a LCL sightseeing…May 30, 1987 · N88314 · 2 aircraft · Substantial damage NTSB LAX87LA109Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Vacaville, CADuring a local sightseeing flight, the pilot was flying south approximately 300-500 ft above the ridge looking for lift. The pilot could not find sufficient lift in the area east of the ridge so he flew to the west side where the glider encountered a strong…Feb 7, 1987 · N17871 · Substantial damage NTSB LAX86LA335Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Fremont, CAThe glider tow pilot stated that he noticed the glider's spoilers in the open position shortly after takeoff. He brought the glider to the traffic pattern. The glider pilot released from the tow and made a sharp turn during which the glider pitched up,…Aug 28, 1986 · N9845E · Substantial damage NTSB LAX86LA202Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Vacaville, CAAccording to the plt, the acft encountered a downdraft after being released from the tow plane. The plt selected a field in which to land, however, the glider contacted a tree while maneuvering to the field.Apr 30, 1986 · N2750Z · Substantial damage NTSB LAX82FVG33Accident · 1 fatalFinal reportSchweizer 232 · Calistoga, CAThe acft crashed approximately 3 mi sw of the Calistoga arpt while returning from a local flt. The plt stated to a calif hwy patrol officer at the scene that he lost rudder control & had gone into a spin as a result in air change. The rudder cables were found…Sep 10, 1982 · N2450W · Destroyed NTSB LAX81DVG45Accident · Minor injuriesClosedSchweizer 2-32 · Calistoga, CAJun 21, 1981 · N2450W · Substantial damage NTSB LAX80DVG76Accident · No injuriesClosedSchweizer 2-32 · Vacaville, CAAug 23, 1980 · N2774Z · Substantial damage NTSB LAX76DUG69Accident · No injuriesClosedSchweizer SGS232 · Adelanto, CAJun 19, 1976 · N697U · Substantial damage NTSB OAK75AP032Accident · 4 fatalClosedSchweizer SGS232 · Fremont, CAJan 18, 1975 · N1243S · 2 aircraft · Destroyed NTSB OAK75DVD20Accident · No injuriesClosedSchweizer SGS232 · Fremont, CAOct 13, 1974 · N9845E · Substantial damage NTSB OAK75FXQ14Accident · No injuriesClosedSchweizer SGS232 · Truckee, CAAug 18, 1974 · N2466W · Substantial damage NTSB LAX74DUG41Accident · Minor injuriesClosedSchweizer SGS232 · Llano, CAFeb 6, 1974 · N7622 · Destroyed NTSB OAK72DVG44Accident · No injuriesClosedSchweizer SGS232 · Fairfield, CAMar 17, 1972 · N28DD · Substantial damage NTSB OAK72DVD13Accident · Serious injuriesClosedSchweizer 2-32 · Fremont, CAAug 28, 1971 · N9858E · Substantial damage NTSB LAX71AL036Accident · 2 fatalClosedSchweizer SGS232 · Elsinore, CADec 7, 1970 · N7934J · Substantial damage NTSB OAK69D0235Accident · Minor injuriesClosedSchweizer SGS232 · Fremont, CAFeb 15, 1969 · N2466W · Substantial damage NTSB LAX69D0257Accident · No injuriesClosedSchweizer 2-32 · Adelanto, CAFeb 13, 1969 · N5826V · Substantial damage NTSB OAK69D0011Accident · No injuriesClosedSchweizer SGS232 · Fremont, CAJun 5, 1968 · N2466W · Substantial damage