NTSB investigations: Let BLANIK L-13
8 cases on aircraft the registry lists as Let BLANIK L-13, where the first occurrence was “On ground/water collision with object”. 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 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 1999 | 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 ('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\" = 310))
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" = 310))
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 CHI99LA220Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Sylvania, WIthe misjudged planned approach and the evasive maneuver attempted by the pilot-in-command. A factor was the presence of trees.NTSB SEA99LA087Accident · No injuriesLimited investigationFinal reportLet L-13 · Belgrade, MTThe pilot in command's failure to maintain clearance from a parked airplane during his attempt to avoid a person on the runway.NTSB SEA97LA194Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hamilton, MTThe pilot's excessive speed taxispeed and failure to maintain wing clearance from a taxiway sign.NTSB SEA93LA216Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Clinton, MTTotal failure of the tow equipment.NTSB DEN91LA118Accident · No injuriesLimited investigationFinal reportLet L-13 · Aspen, COThe pilot turning off the runway with excessive speed.NTSB LAX89LA145Accident · No injuriesLimited investigationFinal reportLet L-13 · Hemet, CAInadequate crew coordination between the ground lineman and the blanik pilot, and failure of the blanik pilot to maintain clearance between his aircraft and the parked glider. A factor related to the accident was the proximity of the parked glider to the…NTSB DEN87LA236Accident · No injuriesLimited investigationFinal reportLet L-13 · Buena Vista, COThe plt was ferrying the glider to Buena Vista, Colorado & had previously obtained permission to land on a closed rwy. After being towed to the Buena Vista area, he released the glider from the tow plane & flew in the local area for about 40 min. He then…NTSB FTW82FQA18Accident · 1 fatalFinal reportBlanik L-13 · Los Lunas, NMDuring landing the left wing struck a bystander who wandered onto the edge of the asphalt overrun taking photographs of the landing. There is a caution sign posted on the north access road of the runway.