NTSB investigations: Schleicher AS-K13
11 cases on aircraft the registry lists as Schleicher AS-K13. 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
| 1968 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1996 | 1 |
| 2006 | 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 ('38015GS'))
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 ('38015GS'))
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 CHI07CA040Accident · No injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's unexpected encounter with wind shear and his inability to remain clear of the trees while on final approach to land.NTSB CHI96LA279Accident · No injuriesLimited investigationFinal reportSchleicher ASK-13 · Thompsonville, MIan evasive maneuver necessitated by the tow plane's aborted takeoff.NTSB ATL86LA262Accident · No injuriesLimited investigationFinal reportAlexander AS-K13 · Tullahoma, TNDuring an automobile tow/launch, the auto experienced a loss of power before the glider reached a safe release altitude. The pilot had steered the glider off of the paved rwy and was unable to return to the rwy. The glider pilot was forced to land in high…NTSB ATL83LA243Accident · No injuriesLimited investigationFinal reportSchleicher AS-K13 · Tullahoma, TNThe pilot stated that his approach was too fast and he bounced the acft during the landing. The glider drifted left and collided with a hayroll. The collision caused another swerve and a subsequent collision with another hayroll.NTSB CHI79FEC37Accident · Serious injuriesClosedSchleicher AS-K13 · Adrian, MINTSB CHI78FA033Accident · 1 fatalClosedSchleicher ASK-13 · Adrian, MINTSB CHI75FEC19Accident · Serious injuriesClosedSchleicher AS-K13 · Adrian, MINTSB CHI73AC036Accident · 1 fatalClosedSchleicher AS-K13 · Oxford, MINTSB CHI72AC098Accident · 1 fatalClosedSchleicher AS-K13 · No.Canton, OHNTSB SEA71DWD27Accident · No injuriesClosedSchlicher ASK-13 · Arlington, WANTSB MIA69D0219Accident · Minor injuriesClosedSchleicher AS-K13 · Homestead, FL