Skip to content

NTSB investigations: Let BLANIK L-13

129 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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 ('1360306')) 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 ('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."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

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 SEA78DYA09Accident · No injuriesClosedLet-Np-K L-13 · Driggs, IDJun 1, 1978 · N65378 · Substantial damage NTSB LAX78DUM18Accident · No injuriesClosedBlanik L-13 · San Diego, CAApr 7, 1978 · N125DW · Substantial damage NTSB OAK78DVD25Accident · Serious injuriesClosedBlanik L13 · Fremont, CAApr 2, 1978 · N99861 · Substantial damage NTSB MIA78FA008Accident · 2 fatalClosedLet-Np-K L-13 · Pensacola, FLOct 27, 1977 · N779 · Destroyed NTSB LAX78FUG03Accident · No injuriesClosedLet-Np-K L-13 · Perris, CAOct 14, 1977 · N99963 · Substantial damage NTSB SEA77DYK19Accident · No injuriesClosedBlanik L-13 · Sisters, ORJul 22, 1977 · N90846 · Substantial damage NTSB CHI77DET14Accident · No injuriesClosedLet-Np-K L-13 · Kendallville, INMay 15, 1977 · N2973 · Substantial damage NTSB FTW77DPJ18Accident · No injuriesClosedBlanik L-13 · Guymon, OKMay 8, 1977 · N101JJ · Substantial damage NTSB DEN77FTE33Accident · No injuriesClosedBlanik L-13 · Boulder, COApr 9, 1977 · N3458 · Substantial damage NTSB MIA77DLD88Accident · No injuriesClosedLet-Np-K L-13 · Land O Lakes, FLSep 19, 1976 · N14WG · Substantial damage NTSB SEA76FYG54Accident · No injuriesClosedLet-Np-K L-13 · Ephrata, WAJun 5, 1976 · N3460 · Substantial damage NTSB LAX76DUQ30Accident · No injuriesClosedLet-Np-K L-13 · California Cty, CAFeb 28, 1976 · N3463 · Substantial damage NTSB CHI76DEI14Accident · Minor injuriesClosedBlanik L-13 · Canton, OHOct 12, 1975 · N3467 · Destroyed NTSB DEN7LAD008Accident · 2 fatalClosedBlanik L-13 · Aspen, COAug 9, 1975 · N9915 · Destroyed NTSB LAX76DUJ14Accident · Minor injuriesClosedBlanik L-13 · Carefree, AZAug 7, 1975 · N99970 · Substantial damage NTSB IAD75DKW22Accident · No injuriesClosedBlanik L-13 · Benton Tn, TNJun 9, 1975 · N90639 · Substantial damage NTSB SEA7KDYE47Accident · Serious injuriesClosedBlanik L-13 · Issaquah, WAJun 8, 1975 · N93460 · Substantial damage NTSB MIA75DKT14Accident · Serious injuriesClosedLet-Np-K L-13 · Boca Raton, FLSep 15, 1974 · N15CB · Substantial damage NTSB MIA74FKG77Accident · No injuriesClosedLet-Np-K L-13 · Monroe, GAMay 11, 1974 · N90868 · Destroyed NTSB LAX74FUJ52Accident · No injuriesClosedLet-Np-K L-13 · Phoenix, AZApr 5, 1974 · N1NV · Destroyed NTSB NYC74DHA12Accident · No injuriesClosedBlanik L-13 · Erwinna, PAOct 7, 1973 · N90598 · Substantial damage NTSB LAX74DUJ12Accident · No injuriesClosedLet-Np-K L-13 · Tucson, AZAug 25, 1973 · N3460 · Substantial damage NTSB NYC74FNA10Accident · No injuriesClosedLet Blanik L-13 · Pepperell, MAAug 4, 1973 · N93220 · Substantial damage NTSB NYC73FNA48Accident · Serious injuriesClosedBlanik L-13 · Plymouth, MAMay 12, 1973 · N12YA · Substantial damage NTSB FTW73AF016Accident · No injuriesClosedPiper PA-18 · Friendswood, TXNov 5, 1972 · N4612Y · 2 aircraft · Minor damage NTSB NYC73FNA14Accident · No injuriesClosedBlanik L-13 · Plymouth, MAAug 20, 1972 · N11YA · Substantial damage NTSB OAK73DVG09Accident · No injuriesClosedBlanik L-13 · Angwin, CAAug 5, 1972 · N3457 · Substantial damage NTSB OAK72FVD52Accident · Serious injuriesClosedBlanik L-13 · Fremont, CAJun 12, 1972 · N3464 · Destroyed NTSB LAX72DUG19Accident · No injuriesClosedBlanik L-13 · San Jacinto, CAOct 1, 1971 · N11PX · Substantial damage