Final NTSB investigations: Schleicher ASW-15
8 cases on aircraft the registry lists as Schleicher ASW-15. 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
| 1970 | 1 |
|---|---|
| 1971 | 2 |
| 1973 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 2013 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('38015HZ'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('38015HZ'))
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 CEN13LA369Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-15 · Navasota, TXAn inadvertent aerodynamic stall during the approach for landing.NTSB NYC84LA237Accident · No injuriesLimited investigationFinal reportSchleicher ASW-15 · Fairfield, PAThe glider was landed off arpt during a return from a round robin flt after experiencing a high sink rate. During the landing approach power lines hidden in a tree line were not cleared and the collision caused the acft to yaw about 45 degrees. The acft…NTSB NYC82DA106Accident · No injuriesFinal reportSchleicher ASW-15 · Plymouth, CTThe pilot stated that he thought he heard the rudder pedals click into their detented/locked position when they were adjusted before takeoff. However, while being towed for takeoff, the rudder pedals slipped forward about 1 to 2 inches. The pilot reached down…NTSB CHI81DEK18Accident · No injuriesClosedSchleicher ASW15 · London, OHNTSB SEA74FYA01Accident · 1 fatalClosedSchleicher ASW-15 · Eagle, IDNTSB FTW72DQD14Accident · No injuriesClosedSchleicher ASW-15 · Marfa, TXNTSB DEN71AD044Accident · 1 fatalClosedSchleicher AS-W15 · Boulder, CONTSB MIA71DLG06Accident · Minor injuriesClosedSchleicher ASW-15 · Chester, SC