NTSB investigations: Schweizer SGS 2-32, CO
7 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.
Cases per year
| 1971 | 1 |
|---|---|
| 1975 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1985 | 1 |
| 2010 | 1 |
| 2012 | 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\" = 'CO' 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" = 'CO' 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" 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 CEN13CA079Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-32 · Boulder, COThe glider pilot's inability to locate an area of thermal lift.NTSB CEN10FA115Accident · 3 fatalField investigationFinal reportPiper PA-25-235 · Boulder, COThe failure of both pilots to see and avoid the other resulting in a midair collision. Contributing to the accident was the lack of perceived visual relative motion of the Piper and the Cirrus to the pilot of each airplane, the terrain background, and the…NTSB DEN85LA128Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Colorado Spring, COThe glider collided with a parked acft following a loss of directional control during the landing roll. The plt reported the left wing dipped during the landing roll because of the x-wind. The left wing tip wheel dug into an area of soft sand beside the rwy…NTSB DEN81FTE07Accident · Minor injuriesClosedSchweizer SG5-2 · Boulder, CONTSB DEN79FTE57Accident · Serious injuriesClosedSchweizer SGS232 · Colorado Spgs, CONTSB DEN75ID056Incident · No injuriesClosedMcdonnell RF-4C · Colorado Sprgs, CONTSB DEN72AD007Accident · 2 fatalClosedSchweizer SGS232 · Colo.Springs, CO