Skip to content

Schleicher ASW-19

NTSB investigations · 16

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('3801508') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('3801508')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('3801508')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA25LA181Accident · Serious injuriesClass 4 · LimitedFinal reportSchleicher ASW-19 · Zephyrhills, FLThe pilot’s inadequate inflight planning and an encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing and collision with a fence.Apr 2, 2025 · N37PL · Substantial damage NTSB GAA16CA244Accident · Minor injuriesData collectionFinal reportSchleicher ASW 19 · Frankton, INThe pilot's exceedance of the critical angle of attack on final approach in turbulent conditions, which resulted in an aerodynamic stall and collision with terrain.May 15, 2016 · N19VT · Substantial damage NTSB ERA12LA528Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Dansville, NYThe pilot’s failure to maintain glider control while maneuvering. Contributing to the accident was the pilot’s impairment due to an over-the-counter sedating antihistamine.Aug 25, 2012 · N438AS · Substantial damage NTSB NYC06CA083Accident · No injuriesData collectionFinal reportSchleicher ASW-19B · Blairstown, NJA loss of lift, which resulted in a forced landing.Mar 18, 2006 · N439AS · Substantial damage NTSB ATL05CA072Accident · No injuriesData collectionFinal reportSchleicher ASW19b · Henderson, NCThe pilot's misjudgment of the landing area which resulted in overshooting the touchdown point. A factor was the in-flight encounter with weather (No thermal lift).Apr 10, 2005 · N19HG · Substantial damage NTSB FTW02LA092Accident · Minor injuriesLimited investigationFinal reportSchleicher AS-W19 · Moriarty, NMThe pilot's attempt to perform a turn upwind at a altitude too low to complete the turn. A factor was the turbulance.Mar 12, 2002 · N333US · Substantial damage NTSB IAD02LA009Accident · No injuriesLimited investigationFinal reportSchleicher ASW-19 · Jersey Shore, PAThe pilot's in-flight encounter with weather, which led to a forced landing to unsuitable terrain.Nov 3, 2001 · N19KH · Substantial damage NTSB IAD99LA061Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Bedminster, NJthe pilot's medical incapacitation after suffering a massive stroke.Aug 29, 1999 · N19DQ · Destroyed NTSB SEA96LA147Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-19 · Salem, UTThe pilot's failure to attain a proper touchdown point during an off-airport landing. Factors relating to the accident were: loss of thermal lift, high obstructions (transmission wires) near the edge of the field that the pilot chose to land, and a bale of…Jul 5, 1996 · N19KH · Substantial damage NTSB NYC82DNC08Accident · Serious injuriesFinal reportSchleicher ASW-19 · Moultonboro, NHSeveral witnesses saw the glider circle over the airport before it crashed. One of the witnesses reported that the glider was about 50 to 100 ft high and was coming in normally when it suddenly nose-dived and headed almost vertically toward the ground. The…Apr 25, 1982 · N79RC · Destroyed NTSB FTW81DPA20Accident · No injuriesClosedSchleicher ASW-19 · Floyd, TXAug 3, 1981 · N19JE · Substantial damage NTSB LAX81FA111Accident · 1 fatalClosedSchleicher ASW-19 · California Cty, CAJul 28, 1981 · N59RA · Destroyed NTSB NYC80FGM32Accident · No injuriesClosedSchleicher ASW-19 · Tyronne, PASep 10, 1980 · N437AS · Substantial damage NTSB NYC80DHA24Accident · Minor injuriesClosedSchleicher ASW-19 · Franklin Forks, PAJul 10, 1980 · N78RC · Substantial damage NTSB FTW79DRG33Accident · No injuriesClosedSchleicher ASW-19 · Castroville, TXMay 24, 1979 · N438AS · Substantial damage NTSB SEA77DYP27Accident · Minor injuriesClosedSchleicher ASW-19 · Waterville, WAMay 29, 1977 · N19FZ · Substantial damage

Back to Schleicher ASW-19