Final NTSB investigations: Lockheed 18

12 cases on aircraft the registry lists as Lockheed 18. 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

19652026

Final NTSB investigations: Lockheed 18 per year, 1965–2026: 12 cases
1965	1
1971	1
1972	1
1973	1
1975	2
1977	1
1979	2
1980	1
1982	1
1983	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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5261602')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5261602'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5261602'))
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 ATL83FA237Accident · 2 fatalField investigationFinal reportLockheed L-18 · Millhaven, GAThe acft collided with trees during an attempted off arpt landing at night for marijuana unloading. The acft was being followed by a u.s customs helicopter, the occupants of this helicopter said the acft had made one missed approach and during the go-around…Jun 23, 1983 · N333FB · Destroyed NTSB ATL83FA021Accident · 3 fatalField investigationFinal reportLockheed 18 · Kosciusko, MSThe acft was observed without lights making repeated low altitude passes over a pipeline right-of-way at night. The acftwas equipped with an internal aux fuel tank, non-standard internal plumbing, a large lever-operated petroleum products pump, an inflatable…Oct 18, 1982 · N1040G · Destroyed NTSB LAX80DJA08Accident · Serious injuriesClosedLockheed 18 · Palmyra Island, HIJan 5, 1980 · N163R · Substantial damage NTSB FTW79FRD27Accident · No injuriesClosedLockheed 18 · Melville, LAMay 7, 1979 · N513V · Substantial damage NTSB MIA79FKG31Accident · Serious injuriesClosedLockheed L-18 · Lincolton, GAApr 12, 1979 · N250W · Destroyed NTSB FTW77FA061Accident · Minor injuriesClosedLockheed L-18 · Austin, TXJun 10, 1977 · N333FB · Substantial damage NTSB OAK76DJY01Accident · No injuriesClosedLockheed L-18 · Puerto Princes, RPJul 4, 1975 · N100DK · Substantial damage NTSB IAD75AI062Accident · 2 fatalClosedLockheed 18 · Rockwood, TNMay 29, 1975 · N75G · Destroyed NTSB MIA73AM029Accident · No injuriesClosedLockheed 18 · Boca Raton, FLApr 23, 1973 · N7611 · Substantial damage NTSB MIA72AM122Accident · 8 fatalClosedLockheed MK-1 · Indiantown, FLMay 12, 1972 · N211L · Destroyed NTSB FTW72AF038Accident · No injuriesClosedLockheed 18 · Hobart, OKDec 22, 1971 · N10P · Substantial damage NTSB MIA65A0090Accident · 2 fatalClosedLoockheed L-18 · Miami, FLMar 5, 1965 · N300N · Destroyed