Lake LA-4-200

NTSB investigations · 71

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('5110310')
  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.

NTSB ANC76AA046Accident · 2 fatalClosedLake LA-4 · Skagway, AKOct 17, 1975 · N5037L · DestroyedNTSB SEA75FYG45Accident · No injuriesClosedLake LA-4 · Spokane, WAJun 27, 1975 · N6693L · Substantial damageNTSB MIA75DLD84Accident · No injuriesClosedLake LA-4 · Orlando, FLJun 8, 1975 · N1072L · Substantial damageNTSB IAD75DKM22Accident · No injuriesClosedLake 4P-200 · Waynesville, NCMar 23, 1975 · N1052L · Substantial damageNTSB MIA75DKT66Accident · Minor injuriesClosedLake LA-4 · Marathon, FLMar 15, 1975 · N1061L · DestroyedNTSB MIA75FKT64Accident · Serious injuriesClosedLake LA-4 · Wellingtn Lake, FLMar 9, 1975 · N5025L · DestroyedNTSB IAD75FLT08Accident · No injuriesClosedLake LA4200 · Dyersburg, TNJan 18, 1975 · N5027L · Substantial damageNTSB IAD75DID08Accident · Serious injuriesClosedLake LA4200 · Weems, VAOct 13, 1974 · N5045L · Substantial damageNTSB NYC75FNC13Accident · No injuriesClosedLake LA-4 · Lancaster, NHOct 4, 1974 · N65713 · Substantial damageNTSB FTW75DPG15Accident · No injuriesClosedLake LA-4 · Redfield, ARAug 22, 1974 · N5020L · Substantial damageNTSB MIA74AM054Accident · 3 fatalClosedLake L4-200 · Bimini, Burkina FasoDec 20, 1973 · N39385 · DestroyedNTSB IAD74FIG08Accident · Serious injuriesClosedLake 4-200 · Betterton, MDSep 2, 1973 · N39365 · DestroyedNTSB CHI73DEI29Accident · No injuriesClosedLake LA-4 · Pemberville, OHMar 1, 1973 · N5007L · Substantial damageNTSB MIA73RKT44Accident · Minor injuriesClosedLake LA-4 · Governors Hrbr (Atlantic Ocean)Dec 31, 1972 · N39384 · DestroyedNTSB MIA73DLD37Accident · No injuriesClosedLake LA-4 · Ft Pierce, FLNov 26, 1972 · N5025L · Substantial damageNTSB NYC73FIG15Accident · No injuriesClosedLake LA-4 · Rockville, MDSep 14, 1972 · N39375 · Substantial damageNTSB FTW73FPD07Accident · No injuriesClosedLake LA-4 · Saginaw, TXAug 28, 1972 · N5021L · Substantial damageNTSB OAK72FXO37Accident · No injuriesClosedLake LA-4 · Homewood, CAJun 24, 1972 · N5023L · Substantial damageNTSB CHI72FEP46Accident · No injuriesClosedLake LA-4 · Waukesha, WIJun 6, 1972 · N5034L · Substantial damageNTSB SEA72DYG17Accident · Minor injuriesClosedLake LA-4 · Coeur D'Alene, IDOct 24, 1971 · N6679L · Substantial damageNTSB MIA71FKW51Incident · No injuriesClosedLake LA-4 · Blountville, TNMay 21, 1971 · N6679L · Minor damage
Back to Lake LA-4-200