NTSB investigations: Continental GO-300 series, AZ

10 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

19672026

NTSB investigations: Continental GO-300 series, AZ per year, 1967–2026: 10 cases
1967	1
1976	1
1977	1
1987	1
1992	1
1993	1
2003	1
2006	1
2009	1
2022	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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 WPR22LA186Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P172D · Prescott, AZThe loss of engine power for reasons that could not be determined based on the available evidence.May 22, 2022 · N8540X · Substantial damage NTSB WPR09CA285Accident · No injuriesData collectionFinal reportCessna 175A · Polacca, AZThe pilot’s failure to adequately estimate the required distance to avoid obstructions while taking off from a road.Jun 12, 2009 · N7979T · Substantial damage NTSB LAX06LA240Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Show Low, AZthe pilot's failure to maintain directional control during landing.Jul 20, 2006 · N6516E · Substantial damage NTSB LAX03LA185Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Ash Fork, AZThe pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall mush condition. Factors were the loose and uneven dirt runway surface, the known tailwind with gusts, and high density altitude.Jun 7, 2003 · N6902E · Substantial damage NTSB LAX94LA082Accident · 2 fatalLimited investigationFinal reportCessna 175 · Peoria, AZthe pilot's failure to attain sufficient altitude following takeoff. A factor in the accident was the pilot's failure to use all available runway for takeoff.Dec 26, 1993 · N6623E · Destroyed NTSB LAX92FA305Accident · 4 fatalField investigationFinal reportCessna 175A · Overgaard, AZThe pilot's improper preflight performance planning and decision to operate the airplane over the maximum certified gross weight at a high density altitude airport which resulted in an inadvertent stall. Contributing to the accident was inadequate maintenance…Jul 19, 1992 · N8048T · Destroyed NTSB LAX87LA348Accident · No injuriesLimited investigationFinal reportCessna 175 · Camp Verde, AZWhen both passengers became air sick the pilot decided to land on a dirt road. Upon touchdown, the pilot heard a loud pop and assumed that a tire had blown. Because of this, he used the brakes sparingly and could not stop the aircraft in time to avoid trees.…Sep 27, 1987 · N7495M · Substantial damage NTSB LAX78FUJ13Accident · Minor injuriesClosedCessna 175A · Flagstaff, AZNov 22, 1977 · N6871E · Substantial damage NTSB LAX76DUJ77Accident · No injuriesClosedCessna 175 · Bullhead City, AZMay 8, 1976 · N8109T · Substantial damage NTSB LAX68D0232Accident · No injuriesClosedCessna 172 · Cibola, AZNov 7, 1967 · N1432Y · Substantial damage