NTSB investigations: Schweizer SGS 2-33A, 1988
5 cases on aircraft the registry lists as Schweizer SGS 2-33A. 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
| 1968 | 1 |
|---|---|
| 1969 | 6 |
| 1970 | 5 |
| 1971 | 5 |
| 1972 | 6 |
| 1973 | 8 |
| 1974 | 5 |
| 1975 | 11 |
| 1976 | 7 |
| 1977 | 17 |
| 1978 | 12 |
| 1979 | 6 |
| 1980 | 6 |
| 1981 | 7 |
| 1982 | 3 |
| 1983 | 9 |
| 1984 | 5 |
| 1985 | 5 |
| 1986 | 7 |
| 1987 | 5 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 5 |
| 2008 | 4 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 5 |
| 2024 | 1 |
| 2025 | 2 |
| 2026 | 2 |
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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8051606'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8051606'))
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 CHI88LA236Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Hinckley, ILDuring the initial climbout on the dual instructional flight, as the glider was towed through approximately 50-100' AGL, the tow rope failed. The instructor pilot executed a hard forced landing at the edge of a cornfield located to the right side of the…NTSB MKC88LA117Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Warrensburg, MODuring a student pilot's first solo in a glider, the plt said he misread the altimeter by 1000 feet. Attempting to land on the airport during the low approach, he struck trees, then a fence, before ground contact.NTSB NYC88LA159Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33 · Erwinna, PAAccident was a loss of directional control during landing which followed a hard landing. Contributing was the improper use of spoiler control by the private pilot and the failure of the flight instructor to adequately supervise the actions of the private…NTSB LAX88LA209Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Vacaville, CAAt the end of a pleasure flt, the plt extended the downwind leg for landing, thinking that the touchdown altitude was 12 ft instead of, in actuality, 220 ft. the plt normally flew out of another airport with an alt of 12 ft. from the extended downwind, the…NTSB LAX88LA145Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CA