Skip to content

NTSB investigations: Continental GO-300 series, TX

30 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

Where

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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 CEN23LA249Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Mesquite, TXThe pilot’s inability to maintain directional control during the landing roll due to corroded brake caliper pins.Jun 21, 2023 · N9354B · Substantial damage NTSB CEN12LA609Accident · No injuriesLimited investigationFinal reportCessna 175B · Hamilton, TXThe partial loss of engine power due to an exhaust valve that was stuck in the open position.Sep 5, 2012 · N8260T · Substantial damage NTSB DFW05FA240Accident · 3 fatalField investigationFinal reportCessna 175B · Cleveland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A contributing factor was the low altitude.Sep 15, 2005 · N8285T · Destroyed NTSB FTW99LA139Accident · No injuriesLimited investigationFinal reportCessna 175B · Spur, TXThe total loss of engine power during cruise flight for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.May 13, 1999 · N8133T · Substantial damage NTSB FTW98LA062Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Houston, TXThe total loss of engine power resulting from detonation and the ensuing failure of the engine piston and connecting rod components. Factors were: the instructor's decision to take off with a known deficiency (magneto drop over limit), the flight instructor's…Dec 13, 1997 · N6846E · Substantial damage NTSB FTW97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 175B · Mount Pleasant, TXThe total loss of engine power due to the #3 connecting rod separation resulting in engine seizure. Factors were the dark night and the lack of suitable terrain for the forced landing.Oct 7, 1996 · N8171T · Substantial damage NTSB FTW88FA005Accident · Serious injuriesField investigationFinal reportCessna 175 · Crystal City, TXThe plt was attempting a night visual apch to his unlighted pvt strip when the acft struck trees, flew under a pwr line,struck additional trees & subsequently impacted the gnd. The acdnt occurred aprx 2.5 miles short of the threshold. Samples of the plt's…Oct 13, 1987 · N6512E · Destroyed NTSB FTW87LA055Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Jacksonville, TXThe pilot stated that he had added oil to the engine prior to his departure on a sight seeing flight, but on scene investigation revealed that the engine froze from oil starvation. No evidence of leakage was found. The aircraft had been owner-maintained for…Jan 31, 1987 · N175RF · Substantial damage NTSB FTW84LA384Accident · No injuriesLimited investigationFinal reportCessna 175 · Corsicana, TXThe plt stated the acft lost eng power & he attempted an emerg landing in a field. During the landing roll the acft collided with a wire fence due to darkness. The exact amount of fuel remaining in the acft was not determined during removal of the acft from…Sep 9, 1984 · N7483M · Substantial damage NTSB FTW82DA225Accident · Minor injuriesFinal reportCessna 175 · Fort Worth, TXDuring a go-around the aircraft's engine quit. The pilot attempted an off-airport emergency landing; however, collided with bushes and nosed over. Investigation revealed there was a minimum amount of fuel onboard.Jun 13, 1982 · N9419B · Substantial damage NTSB FTW76FPA24Accident · Minor injuriesClosedCessna 175 · Dallas, TXJun 8, 1976 · N9259B · Substantial damage NTSB FTW75DRJ14Accident · No injuriesClosedCessna 172D · Wells, TXSep 20, 1974 · N8547X · Substantial damage NTSB FTW73DPD43Accident · No injuriesClosedCessna 175 · Poolville, TXJun 10, 1973 · N7229M · Substantial damage NTSB FTW72DQG15Accident · No injuriesClosedCessna 175 · Seminole, TXAug 10, 1971 · N9446B · Substantial damage NTSB FTW70FRA18Accident · No injuriesClosedCessna 175A · Houston, TXMay 20, 1970 · N6850E · Substantial damage NTSB FTW70D0126Accident · No injuriesClosedCessna 175 · Hitchcock, TXJul 21, 1969 · N8330T · Substantial damage NTSB FTW69D0165Accident · No injuriesClosedCessna 175 · Longview, TXAug 16, 1968 · N6848E · Substantial damage NTSB FTW68D0253Accident · Minor injuriesClosedCessna 175 · Merit, TXJul 16, 1967 · N7030E · Substantial damage NTSB FTW66F0649Accident · No injuriesClosedCessna 175C · Rosharon, TXMay 1, 1966 · N8330T · Substantial damage NTSB FTW66F0536Accident · No injuriesClosedCessna 175 · Dallas, TXMar 4, 1966 · N9446B · Substantial damage NTSB FTW66F0213Accident · Minor injuriesClosedCessna 175 · Kerrville, TXJul 31, 1965 · N7076E · Substantial damage NTSB FTW66D0158Accident · No injuriesClosedCessna 175A · El Campo, TXJul 21, 1965 · N6790E · Substantial damage NTSB FTW66D0099Accident · No injuriesClosedCessna 175 · Ft Stockton, TXJun 12, 1965 · N7475M · Substantial damage NTSB FTW66F0208Accident · No injuriesClosedCessna 172D · Amarillo, TXApr 20, 1965 · N8528X · Substantial damage NTSB FTW65F0018Accident · No injuriesClosedCessna 175A · Perryton, TXApr 11, 1965 · N6986E · Substantial damage NTSB UNK65X1346Accident · No injuriesClosedCessna 175A · El Paso, TXJan 25, 1965 · N6833E · Substantial damage NTSB UNK65X1303Accident · No injuriesClosedCessna 175 · Matagorda Is, TXJan 17, 1965 · N8049T · Substantial damage NTSB UNK64X4003Accident · No injuriesClosedCessna 175 · Beumont, TXSep 16, 1964 · N7446M · Substantial damage NTSB UNK64X0860Accident · No injuriesClosedCessna 175 · Dallas, TXMar 9, 1964 · N9442B · Substantial damage NTSB UNK64X0177Accident · No injuriesClosedCessna 175 · Abernathy, TXJan 6, 1964 · N8258T · Substantial damage