NTSB investigations: Schweizer SGS 1-26D, CA
13 cases on aircraft the registry lists as Schweizer SGS 1-26D. 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 |
|---|---|
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1977 | 2 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1991 | 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 ('8050122'))
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 ('8050122'))
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 LAX91LA155Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26-D · Warner Springs, CAThat the pilot used poor planning/decision and failed to maintain flying speed. Contributing to his accident was the loss of thermal lift and lack of experience in this type of aircraft.NTSB LAX84LA369Accident · No injuriesLimited investigationFinal reportSchweizer SGS-126D · Lucerne Valley, CAThe student plt reported that during a winch launch with a left x-wind, the wind lifted the left wing & the right wing contacted the ground. The glider then veered to the right & the right wing hit a wind sock & a vehicle. He reported that a wind-shift had…NTSB LAX84LA327Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS1-26D · Lucerne Valley, CAThe plt reported that his glider was the 3rd to launch (using an auto tow) on a distance completion flt. He released the tow cable at about 900 ft & began searching for lift. No lift was found. After a short time, he attempted to return to the departure…NTSB LAX84LA276Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26D · Vacaville, CAThe student, glider plt stated that he encountered a loss of lift while on the downwind side of a hill. Subsequently, he selected a field for an off-arpt landing. On final apch, the plt noticed a fence in the middle of the field & was unable to avoid it. He…NTSB LAX84LA061Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26D · Lucerne Valley, CAThe student plt was on his 1st solo launch using an auto tow & a nose hook. During the launch, the glider became airborne at about 42 mph. Thereafter, the student climbed successfully to an estimated alt of aprx 200 ft. at about that time, the student's…NTSB LAX81FUG33Accident · 1 fatalClosedSchweizer 1-26D · Hemet, CANTSB LAX77FUG62Accident · Serious injuriesClosedSchweizer 1-26D · Hemet, CANTSB OAK77DVG25Accident · No injuriesClosedSchweizer SGS126 · Vacaville, CANTSB OAK74DVA65Accident · No injuriesClosedSchweizer SGS126 · Del Piedra, CANTSB LAX74DUG28Accident · No injuriesClosedSchweizer SGS126 · Llano, CANTSB OAK73DVD18Accident · No injuriesClosedSchweizer SGS126 · Freemont, CANTSB LAX73DUG11Accident · No injuriesClosedSchweizer 1-26D · Adelanto, CANTSB LAX70AL070Accident · 2 fatalClosedSchleicher K7 · Tehachapi, CA