NTSB investigations: Schweizer SGS 1-26B, CA
15 cases on aircraft the registry lists as Schweizer SGS 1-26B. 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
| 1966 | 3 |
|---|---|
| 1967 | 1 |
| 1968 | 2 |
| 1970 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1983 | 2 |
| 1990 | 1 |
| 2011 | 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 ('8050118'))
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 ('8050118'))
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 WPR12CA072Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Murrieta, CAThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.NTSB LAX90LA208Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Truckee, CAThe pilot's improper decision to release from the tow airplane at an insufficient altitude on the lee side of the mountains.NTSB LAX83LA347Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Phelan, CAWhile on a local flt, thermal activity decreased, so the glider plt headed back to the arpt. On the way back, he encounted an area of sinking air & lost 1500 to 2000 ft of alt. He elected to land on a road. During the roll-out, the left wing hit a dirt…NTSB LAX83LA209Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Chula Vista, CAThe plt reported that he was soaring along the west slope of a small mountain when he inadvertently entered an area where the wind was obstructed by terrain features. His airspeed deteriorated & he tried to turn toward an area where he could obtain lift.…NTSB LAX78DUG04Accident · No injuriesClosedSchweizer SGS126 · San Jacinto, CANTSB LAX76AL087Accident · 1 fatalClosedSchweizer SGS126 · Adelanto, CANTSB OAK75FVA56Accident · Serious injuriesClosedSchweizer SGS126 · Tulare, CANTSB LAX73AL010Accident · 1 fatalClosedSchweizer SGS126 · Jamul, CANTSB LAX71FUM07Accident · Serious injuriesClosedSchweizer 1-26B · Chula Vista, CANTSB OAK69D0087Accident · No injuriesClosedSchweizer SGS126 · Fremont, CANTSB LAX69F0048Accident · Serious injuriesClosedSchweizer SGS126 · Adelanto, CANTSB OAK68D3157Accident · No injuriesClosedSchweizer SGS126 · Fremont, CANTSB OAK67D0299Accident · Serious injuriesClosedSchweitzer SGS126 · Calistoga, CANTSB OAK67D0158Accident · No injuriesClosedSchweizer SGS126 · Truckee, CANTSB OAK66D0219Accident · Minor injuriesClosedSchweitzer SGS126 · Fremont, CA