NTSB investigations: Schweizer SGS 1-34, CA
15 cases on aircraft the registry lists as Schweizer SGS 1-34. 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2009 | 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 ('8050146'))
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 ('8050146'))
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 WPR09LA449Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-34 · Lake Elsinore, CAThe pilot's failure to maintain control of the glider after the tow line released during the initial climb.NTSB LAX03LA133Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · San Diego, CAthe pilot's misjudgment of the landing flare and descent rate. A contributing factor was the pilot's misjudged speed and distance.NTSB LAX01LA174Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Adelanto, CAThe pilot's stall/mush as a result of his inadequate airspeed and improperly planned final approach.NTSB LAX96LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Inyokern, CAthe pilot misjudged altitude while maneuvering in mountainous terrain. Contributing factors were: the pilot's inadequate in-flight planning and the lack of available thermal lift over the rapidly rising rough terrain.NTSB LAX94LA210Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-34 · Hemet, CAthe pilot's failure to maintain an adequate airspeed while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin. A factor in the accident was the pilot's low total flight time.NTSB LAX90LA325Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Hemet, CAImproper compensation for wind conditions.NTSB LAX80FVG33Accident · Serious injuriesClosedSchweizer SGS134 · Calistoga, CANTSB LAX79FUQ31Accident · No injuriesClosedSchweizer SGS134 · Llano, CANTSB LAX76FUG12Accident · Serious injuriesClosedSchweizer SGS134 · Adelanto, CANTSB LAX75DUG51Accident · No injuriesClosedSchweizer SGS134 · Adelanto, CANTSB LAX75DUG05Accident · No injuriesClosedSchweizer SGS134 · Helendale, CANTSB LAX73FUQ30Accident · Minor injuriesClosedSchweizer SGS134 · Tehachapi, CANTSB OAK72FVD39Accident · Serious injuriesClosedSchweizer 1-34 · Fremont, CANTSB LAX72DUG07Accident · No injuriesClosedSchweizer 1-34 · Adelanto, CANTSB OAK70DVW23Accident · No injuriesClosedSchweizer 1-34 · Bishop, CA