NTSB investigations: Continental Copters TOMCAT MK6B

7 cases on aircraft the registry lists as Continental Copters TOMCAT MK6B. 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

19822026

NTSB investigations: Continental Copters TOMCAT MK6B per year, 1982–2026: 7 cases
1982	1
1988	1
1992	2
2003	1
2010	1
2016	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 ('2390202')) 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 ('2390202'))
  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 ('2390202'))
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 CEN16CA321Accident · Serious injuriesData collectionFinal reportContinental Copters Tomcat MK6B · Sparland, ILThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.Aug 7, 2016 · N17H · Substantial damage NTSB CEN10CA411Accident · Minor injuriesData collectionFinal reportContinental Copters Tomcat MK6B · Blackstone, ILThe helicopter encountered a dust devil at a low altitude during the aerial application flight.Jul 15, 2010 · N17H · Substantial damage NTSB CHI03LA204Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Ft. Yates, NDThe inadvertent settling with power and unsuccessful remedial action by the pilot. A factor to the accident was the potato crop.Jul 9, 2003 · N9080T · Substantial damage NTSB MIA92T#A01Accident · No injuriesClass 3Final reportContinental Copters Tomcat MK6B · Punta Gorda, FLJun 25, 1992 · N17H · Substantial damage NTSB BFO92LA062Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Middleboro, MAThe pilot's failure to release a tie down strap from the helicopter's skid during the preflight.May 14, 1992 · N9012T · Substantial damage NTSB MIA88LA186Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Callahan, FLWhile maneuvering the helicopter during an aerial application flt the eng quit. During the autorotative landing the helicopter landed hard. Examination of the eng revealed the accessory drive gear, which is attached to the crankshaft by 6 AN-4A bolts with the…Jun 1, 1988 · N9080T · Substantial damage NTSB ATL83LA011Accident · No injuriesLimited investigationFinal reportTomcat MK68 · Cope, SCBefore starting his takeoff from a trailer, the pilot failed to insure that his helper had released the right rear tiedown chain. During lift-off, the helicopter raised the trailer about 2 to 3 ft before the chain. Broke. Simultaneously, the helicopter was…Oct 15, 1982 · N9080T · Destroyed