Final NTSB investigations: Continental Copters TOMCAT MK6C
7 cases on aircraft the registry lists as Continental Copters TOMCAT MK6C. 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.
Cases per year
| 1981 | 1 |
|---|---|
| 1982 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 2019 | 1 |
Where
Open the mapLatest cases
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_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 ('2390204'))
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 ('2390204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA19TA213Accident · Minor injuriesClass 3Final reportContinental Copters Tomcat MK6C · Franklin, KYThe pilot’s failure to maintain main rotor rpm after takeoff, which resulted in a collision with terrain.NTSB CHI90DET04Accident · Serious injuriesFinal reportContinental Copters MK 5A Tomcat · Constantine, MIThe pilot's failure to see and avoid power lines in his area of operation.NTSB MIA89LA221Accident · Serious injuriesLimited investigationFinal reportContinental Copters Tomcat MK6C · Quitman, MSFailure of the tail boom attachment.NTSB CHI88DEX08Accident · No injuriesFinal reportContinental Copters Tomcat MK-6 · Straughn, INAerial application helicopter struck power lines in field on first swath run. This was the first time the pilot had sprayed this field. Prior to spraying the field he questioned the farmer regarding power lines or other obstructions. The farmer replied that…NTSB NYC86FGM02Accident · Minor injuriesFinal reportContinental Copters OH13H Tomcat Mark 5A · Indiana, PAThe acft collided with wires during a spray run and crashed out of control. The plt tried to fly under the wires that were sighted too late to clear. During his survey of the field the plt had failed to see the wires that were struck. The collision broke off…NTSB FTW82FRJ10Accident · 1 fatalFinal reportContinental Tomcat MK6C · Cottonport, LAThe plt was familiarizing himself with the acft & the local area. The plt's log book showed only one hour of flt time logged between 9/23/81 & the date of the accident. Witnesses observed the acft flying for some time over the city at 300-400 ft AGL making…NTSB FTW81DRD48Accident · No injuriesClosedTom Cat 47-MK6 · Ramah, LA