NTSB investigations: Schleicher ASW-20, CA
8 cases on aircraft the registry lists as Schleicher ASW-20. 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 | 2 |
|---|---|
| 1991 | 1 |
| 1992 | 1 |
| 2003 | 2 |
| 2005 | 1 |
| 2011 | 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\" = 'CA' 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 ('3801506'))
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" = 'CA' 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 ('3801506'))
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 WPR11FA302Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Lone Pine, CAThe glider encountered a strong downward orographic wind flow and turbulence that forced it into terrain. Also causal was the pilot’s decision to operate the glider very close to the terrain.NTSB LAX05LA224Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude and his decision to turn toward higher terrain.NTSB LAX03CA201Accident · Minor injuriesData collectionFinal reportSchleicher ASW-20 · Idyllwild, CAThe combined effects of a loss of thermal lift and a gust induced loss of airspeed at a low above ground altitude, which resulted in a descent to impact with trees. The pilot's failure to maintain an adequate terrain clearance margin while cruising in…NTSB LAX03LA114Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · San Diego, CAthe pilot's use of an inadequate climb attitude during takeoff resulting in the proper climb rate not being established.NTSB LAX92LA400Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Middletown, CAThe pilot's failure to connect the elevator control during assembly and failure to perform an adequate aircraft preflight check. Contributing to the accident was the pilots distraction by performing other tasks during the assembly procedure.NTSB LAX91LA231Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Julian, CAThe pilot's failure to maintain control of his experimental glider during takeoff. A contributing factor was the pilot's encounter with gusty winds.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…NTSB LAX82FA136Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Tulare, CAThe glider pilot entered a thermal with three other sailplanes and began to climb. Two of the sailplanes were about 1000 ft below him and the other plane was about 500 ft above. As the pilot was climbing to about 4000 ft MSL, he lost sight to the sailplane…