NTSB investigations: Schweizer SGS 1-26E, 1984
3 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
| 1971 | 2 |
|---|---|
| 1972 | 2 |
| 1973 | 2 |
| 1975 | 7 |
| 1976 | 6 |
| 1977 | 5 |
| 1978 | 1 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 3 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2013 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2021 | 1 |
| 2023 | 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 year(c.\"eventDate\") = 1984
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 year(c."eventDate") = 1984
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 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 NYC84LA265Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Plymouth, MAThe plt stated that when he released his glider at 2500 feet, soaring conditions were good. Conditions deteriorated which resulted in no lift and altitude was insufficient to safely return to the departure airport. The pilot attempted to land off the airport…NTSB MIA84FA181Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-26E · Williston, FLThe acft was observed to enter a left base leg for rwy 4. The plt continued to fly the base leg heading & flew thru the final apch leg. The acft then entered a right bank, & after 180 deg of turn, it stalled & went into a right spin at an estimated 600 to 800…