Fatal NTSB investigations: Schleicher ASW-20
10 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
| 1980 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2015 | 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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 CEN15LA376Accident · 1 fatalLimited investigationFinal reportSchleicher ASW 20 · Hempstead, TXThe pilot’s failure to maintain clearance from power lines during an attempted off-airport landing.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 CEN10LA368Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Pocahontas, ILThe pilot's failure to maintain a wings-level attitude prior to impacting high vegetation and terrain during the off-field landing.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 LAX04LA203Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Reno, NVthe pilot's failure to maintain an adequate airspeed margin while performing a return to runway maneuver, which led to a stall and spin. Factors in the accident were: 1) the deteriorated condition of the glider towrope, which resulted in towrope failure…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 NYC88LA125Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Fairfield, PAFailure of the pilot-in-command of N34JH to see and avoid N311DP.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…NTSB FTW81FQA32Accident · 1 fatalClosedSchleicher ASW-20 · Las Vegas, NMNTSB CHI80FEK15Accident · 1 fatalClosedSchleicher ASW-20 · Mt.Sterling, OH