NTSB investigations: Continental GO-300 series, NC

7 cases on aircraft whose registry engine model is Continental GO-300 series. 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

19642026

NTSB investigations: Continental GO-300 series, NC per year, 1964–2026: 7 cases
1964	1
1967	1
1973	1
1980	2
1989	1
2001	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."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17024')) 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.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17024'))
  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."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17024'))
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 MIA01LA185Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mooresville, NCthe pilot's improper fuel consumption calculations, inadequate preflight planning, and failure to refuel the airplane before takeoff, which resulted in a loss of engine power due to fuel exhaustion, and a forced landing in trees.Jul 15, 2001 · N8861E · Destroyed NTSB ATL89LA208Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Spruce Pine, NCA loss of power for undetermined reasons. The power loss may have been due to a sticking valve(s).Sep 2, 1989 · N7174M · Substantial damage NTSB IAD80DKM15Accident · Minor injuriesClosedCessna 175 · Morgantown, NCApr 7, 1980 · N7077M · Substantial damage NTSB IAD80FKM08Accident · No injuriesClosedCessna 175 · Thomasville, NCJan 29, 1980 · N7617M · Substantial damage NTSB IAD74DKM15Accident · No injuriesClosedCessna 175 · Charlotte, NCAug 19, 1973 · N6692E · Substantial damage NTSB DIA68F0090Accident · Serious injuriesClosedCessna 175 · Winston Salem, NCSep 17, 1967 · N7359M · Destroyed NTSB UNK64X2052Accident · No injuriesClosedCessna 175 · High Point, NCMay 31, 1964 · N8075T · No damage