NTSB investigations: Schweizer SGS 2-33A
5 cases on aircraft the registry lists as Schweizer SGS 2-33A, where the first occurrence was “Hard landing”. 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
| 1986 | 1 |
|---|---|
| 1988 | 1 |
| 1998 | 1 |
| 1999 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8051606')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8051606')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 LAX04CA310Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-33A · Maricopa, AZthe pilot's encounter with a dust devil during landing flare, which resulted in a hard touchdown.NTSB LAX99LA232Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Wailua, HIThe failure of the pilot to adequately compensate for the existing gusty wind conditions and his improper recovery from a bounced landing.NTSB CHI98LA268Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Indianapolis, INthe delayed in-flight decision of the pilot in command to take control of the aircraft and the proper airspeed not obtained/maintained by the pilot in command which resulted in a stall. A factor to the accident was the runway light.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 NYC86LA137Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-32A · Kurtztown, PAAfter flying in thermals for about 45 minutes, the plts returned to the arpt to land. The instructor (CFI) stated they came over the initial approach point at about 1000 ft for a landing on runway 30. The glider passed over the end of the runway at about 150…