NTSB investigations: Schempp-Hirth DISCUS B
4 cases on aircraft the registry lists as Schempp-Hirth DISCUS B. 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
| 1988 | 2 |
|---|---|
| 2006 | 2 |
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 ('38019VN'))
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 ('38019VN'))
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 CHI06CA219Accident · Serious injuriesData collectionFinal reportShempp-Hirth Discuss B · Tipton, INThe glider pilot's improper in-flight decision to continue searching for thermal lift, instead of landing when the glider was in range of a suitable landing area. Contributing factors to the accident was the lack of thermal lift which resulted in a hard…NTSB LAX06LA151Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Discus B · Minden, NVthe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall. A factor was the loss of thermal lift.NTSB ATL89LA016Accident · No injuriesLimited investigationFinal reportSchempp-Hirth DISCUS-B · Whitwell, TNThe plt rprtd that thermal lift deteriorated drg the return leg of a x-country flt & he elected to make an off aprt lndg in a hay field. As he was on final apch on a westerly hdg, he saw a previously undetected power line across the field, which reqd a rapid…NTSB SEA88LA128Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Discus B · Minden, NVAcft were ascending in the same thermal during national soaring competition and collided in flight. N554T sustained loss of the horizontal tail in collision, followed by loss of control in flight. The pilot parachuted safely. N130JB sustained minor damage and…