NTSB investigations: Schweizer SGS 1-36, CA
5 cases on aircraft the registry lists as Schweizer SGS 1-36. 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
| 1981 | 1 |
|---|---|
| 1985 | 1 |
| 1992 | 1 |
| 2000 | 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\" = '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 ('8050153'))
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 ('8050153'))
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 WPR12CA278Accident · No injuriesData collectionFinal reportSchweizer SGS 1-36 · Bishop, CAThe glider’s encounter with insufficient atmospheric lift to maintain soaring flight, which resulted in an off-airport landing.NTSB LAX01LA038Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Lake Elsinore, CAThe pilot's misjudged altitude approaching the airstrip and his failure to maintain airspeed resulted in the glider's collision with trees.NTSB LAX92LA285Accident · No injuriesLimited investigationFinal reportSchweizer 1-36 · Hemet, CAThe pilot's inadvertent selection of unsuitable terrain for the precautionary landing. A factor in the accident was his failure to obtain a preflight weather briefing.NTSB LAX85LA233Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-36 · Hemet, CAThis was the first flight after a cockpit check-out in the Schweizer sgc 1-36. The pilot released from the tow plane when he realized that the spoilers were deployed and landed short of the runway. The pilot reported that the spoiler handle in this model…NTSB LAX81DVG25Accident · No injuriesClosedSchweizer SGS136 · Calistoga, CA