NTSB investigations: Let BLANIK L-13, TX
6 cases on aircraft the registry lists as Let BLANIK L-13. 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
| 1972 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1987 | 2 |
| 1998 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1360306'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1360306'))
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 FTW98LA264Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Hempstead, TXThe pilot's failure to maintain the proper rate of descent. Factor were the pilot's inadvertent lowering of the flaps instead of extending the spoilers, and his lack of experience in gliders.NTSB FTW87LA199Accident · No injuriesLimited investigationFinal reportLet L-13 · Littlefield, TXThe pilot activated the flaps while on final approach instead of the spoilers. When the glider did not descend as he expected, a left 360 degree turn was initiated to lose altitude. The pilot stated that he then unintentionally stalled the aircraft while in…NTSB FTW87LA186Accident · No injuriesLimited investigationFinal reportLet L-13 · Hempstead, TXAcft landed short of threshold following a low release shortly after t/o. release was low due to tow plane's being unable to climb above 200' AGL due to the glider's spoilers being deployed inadvertently during the t/o. the plt stated that he executed a 270…NTSB FTW79FRA09Accident · Serious injuriesClosedBlanik L-13 · Cypress, TXNTSB FTW79DRA01Accident · No injuriesClosedLet-Np-K L-13 · Cypress, TXNTSB FTW73AF016Accident · No injuriesClosedPiper PA-18 · Friendswood, TX