Fatal NTSB investigations: Lake LA-4

8 cases on aircraft the registry lists as Lake LA-4. 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

19682026

Fatal NTSB investigations: Lake LA-4 per year, 1968–2026: 8 cases
1968	1
1970	1
1972	1
1978	2
1979	1
1981	1
1990	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5110302')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5110302'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5110302'))
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 SEA90FA171Accident · 3 fatalField investigationFinal reportLake LA-4 · Onalaska, WAImproper in-flight planning/decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather and terrain conditions.Jun 9, 1990 · N68DG · Destroyed NTSB NYC81FA025Accident · 1 fatalClosedLake LA-4 · Middleboro, MAFeb 7, 1981 · N1125L · Destroyed NTSB NYC79FA040Accident · 1 fatalClosedLake LA-4 · Jonesboro, MEApr 20, 1979 · N7639L · Destroyed NTSB MIA78FA053Accident · 1 fatalClosedLake LA-4 · Pierson, FLMar 14, 1978 · N2038L · Destroyed NTSB OAK78FA014Accident · 1 fatalClosedLake LA-4 · Hawthorne, NVJan 9, 1978 · N6678L · Destroyed NTSB NYC73AN027Accident · 2 fatalClosedLake LA-4 · Cairo, NYAug 14, 1972 · N1163L · Destroyed NTSB IAD71AI016Accident · 2 fatalClosedLake LA-4 · New Cumbrlnd, WVOct 24, 1970 · N7633L · Destroyed NTSB NYC68A0113Accident · 2 fatalClosedLake LA-4 · Sanford, MEMar 29, 1968 · N7601L · Destroyed