NTSB investigations: Continental GO-300 series, FL
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.
Cases per year
| 1966 | 1 |
|---|---|
| 1972 | 2 |
| 1973 | 1 |
| 1976 | 1 |
| 1978 | 2 |
| 1983 | 1 |
| 1988 | 1 |
| 1992 | 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.\"eventStateOrRegion\" = 'FL' 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" = 'FL' 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" 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 MIA92LA125Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Yulee, FLLoss of engine power due to undetermined reasons shortly after takeoff.NTSB MIA89LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Okeechobee, FLThe student pilot reported that during preflight inspection, he did not replace the oil cap after he checked the oil. Subsequently, oil was vented overboard during flight & the engine lost power. The nose gear collapsed during a forced landing.NTSB MIA84LA008Accident · No injuriesLimited investigationFinal reportCessna 175 · Ft. Mccoy, FLAbout 10 min after departing ft Mccoy, FL, the plt realized he had forgotten his flt bag, so he returned to land at the airstrip. During the landing, the acft floated, & after touching down, there was insufficient rwy remaining to safely stop or go around.…NTSB MIA79DLD30Accident · No injuriesClosedCessna 175 · Clearwater, FLNTSB MIA78DKJ45Accident · No injuriesClosedCessna 175 · Pensacola, FLNTSB MIA76FKT86Accident · No injuriesClosedCessna 175 · W.Palm Beach, FLNTSB MIA74DLA27Accident · No injuriesClosedCessna 175 · Cherry Lake, FLNTSB MIA73DKT21Accident · Serious injuriesClosedCessna 175 · Miami, FLNTSB MIA73FLA01Accident · No injuriesClosedCessna 175R · Tallahassee, FLNTSB MIA67D0124Accident · No injuriesClosedCessna 175 · Howey-In-Hill, FL