NTSB investigations: Schleicher ASW-20
4 cases on aircraft the registry lists as Schleicher ASW-20, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1986 | 2 |
| 1987 | 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 ('3801506')
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\" = 250))
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 ('3801506')
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" = 250))
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 NYC87LA163Accident · No injuriesLimited investigationFinal reportSchweizer ASW-20 · Middletown, NYThe glider pilot failed to hook up the elevator control cable before launch and during takeoff there was no pitch control. The aircraft pitched up uncontrollably overstressing the rope. The rope broke and the glider impacted hard on a road bouncing 150 feet…NTSB FTW86FRG30Accident · Serious injuriesFinal reportSchleicher ASW-20 · Uvalde, TXAcft was competing in the natl soaring championships and had just crossed the finish line at 50' AGL and 85 kns a/s when it entered a maneuver to reverse direction and climb to pattern alt for landing. During the turn the acft stalled and struck a power line…NTSB LAX86LA144Accident · No injuriesLimited investigationFinal reportCentrair Schleicher ASW-20 · Phoenix, AZThe plt elected to abort the takeoff because the acft was veering off the rwy. After release from the tow plane the acft wing tip struck a bush causing the afct to ground loop. The plt reported that the winds at the time of the accident were from 200 deg at 5…NTSB LAX83LVG02Accident · No injuriesFinal reportSchleicher ASW-20 · Calistoga, CAThe pilot stated that he forgot to connect the elevator control when he assembled the glider for the flight. He also stated that he did not become aware of this situation until he tried to use the control during takeoff. The aircraft crashed in a nose down…