NTSB investigations: Schweizer SGS 1-26E, TX
7 cases on aircraft the registry lists as Schweizer SGS 1-26E. 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
| 1972 | 1 |
|---|---|
| 1975 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1994 | 1 |
| 2004 | 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\" = 'TX' 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 ('8050124'))
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" = 'TX' 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 ('8050124'))
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 DFW05CA004Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1-26E · El Paso, TXThe pilot's misjudgment of distance and altitude during a local soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB FTW94LA237Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Littlefield, TXAn inadvertent stall. Factors were low altitude and airspeed at the beginning of the downwind turn.NTSB FTW84LA352Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Mineral Wells, TXThe glider was destroyed during ground contact after stalling at aprx 250 ft AGL. The plt reported that conflicting traffic resulted in an acceleration of the tow truck and a premature release of the towed acft. After the release the ascending acft stalled…NTSB FTW83LA374Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26F · Caddo Mills, TXThe student plt saw a small thunderstorm moving toward the arpt, so he returned to land before it arrived. He stated he was 2 to 3 min too late. While in the traffic pattern, he encountered turbulence, downdrafts & winds reportedly gusting to 30 KTS. As the…NTSB FTW81DQD18Accident · No injuriesClosedSchweizer 1-26E · Dell City, TXNTSB FTW76FPA03Accident · Serious injuriesClosedSchweizer SGS126 · Lancaster, TXNTSB FTW73DPA01Accident · No injuriesClosedSchweizer SGS1-2 · Rockwell, TX