NTSB investigations: Let BLANIK L-13
7 cases on aircraft the registry lists as Let BLANIK L-13, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 2 |
|---|---|
| 1997 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
Where
Latest 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 ('1360306')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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 ('1360306')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 CHI06CA252Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hampshire, ILThe pilot's inadequate approach for landing and his failure to attain a proper descent rate.NTSB DEN04CA085Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Durango, COthe pilot's improper in-flight planning and decision and his failure to maintain adequate terrain clearance. Contributing to the accident was the lack of suitable terrain, and the low approach.NTSB DEN03LA001Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Morgan, UTthe pilot's inadequate inflight planning and decision which resulted in an unsuitable off-field landing site. A contributing factor was downdraft weather conditions.NTSB MIA99LA227Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Perry, SCan in-flight collision with the ground due to inadequate liftoff airspeed, and the pilot's improper use of flaps, which resulted in too low of an altitude to sustain flight.NTSB FTW97LA256Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Pagosa Springs, COThe pilot's improper inflight planning in that he allowed the glider to descend to too low an altitude and stray too far from the airport, exceeding the aircraft's glide capabilities. A factor was his failure to utilize maximum braking action.NTSB LAX82DVG32Accident · Serious injuriesFinal reportBlanik L-13 · Chico, CAThe glider pilot reported that after he disengaged from the aerial tow, he was unable to find any of the expected conditions of lift. As altitude was lost, he elected to land in a vineyard. During the landing, the glider was damaged and the pilot received a…NTSB SEA82DA092Accident · No injuriesFinal reportBlanik L-13 · Driggs, IDThe pilot held a commercial, airline transport certificate, but had only a student glider certificate. During a towed takeoff, witnesses observed the spoilers extend after about 200 ft of ground roll. The tow pilot gave an arm signal to indicate a problem.…