NTSB investigations: Let L-13 BLANIK

7 cases on aircraft the registry lists as Let L-13 BLANIK. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19732026

NTSB investigations: Let L-13 BLANIK per year, 1973–2026: 7 cases
1973	1
1975	1
1976	2
1978	1
1992	1
2009	1

Where

Open the map

Latest cases

Query with SQL

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 ('1360305')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('1360305'))
  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 ('1360305'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA09CA434Accident · Serious injuriesData collectionFinal reportLet L13 · Sparta, NYThe student pilot's failure to maintain airspeed resulting in an aerodynamic stall.Aug 1, 2009 · N66FL · Substantial damage NTSB MIA92LA191Accident · Serious injuriesLimited investigationFinal reportLet L-13 · New Smyrna Bch, FLThe pilot's inadequate compensation for wind conditions. The downdraft was a factor in the accident.Sep 26, 1992 · N90861 · Substantial damage NTSB NYC78FHA39Accident · 1 fatalClosedBlanik L-3 · Pittstown, NJSep 23, 1978 · N90861 · Destroyed NTSB MIA77FLD23Accident · Minor injuriesClosedLet-Np-K L-13 · Clearwater, FLDec 31, 1976 · N65139 · Substantial damage NTSB LAX76AL065Accident · 1 fatalClosedLet-Np-K L-13 · Canyon Lake, CAMar 26, 1976 · N94612 · Destroyed NTSB NYC75FNE41Accident · No injuriesClosedBlanik L-13 · New Braintree, MAJun 21, 1975 · N2821H · Substantial damage NTSB LAX74DUJ03Accident · Minor injuriesClosedLet-Np-K L-13 · Phoenix, AZJul 9, 1973 · N5573 · Substantial damage