NTSB investigations: Continental GO-300 series, AK
15 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
| 1965 | 1 |
|---|---|
| 1967 | 3 |
| 1970 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2007 | 1 |
| 2013 | 1 |
| 2014 | 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.\"eventStateOrRegion\" = 'AK' 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" = 'AK' 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 GAA19CA555Accident · Serious injuriesData collectionFinal reportCessna 175 · Toklat, AKThe pilot's loss of airplane control and his subsequent exceedance of the airplane's critical angle of attack during takeoff in variable, gusting wind conditions, which resulted in an aerodynamic stall.NTSB ANC14CA083Accident · No injuriesData collectionFinal reportCessna 175 · Ambler, AKThe pilot's decision to takeoff from a rough airstrip in gusty wind conditions, which resulted in a loss of control.NTSB ANC13LA059Accident · No injuriesLimited investigationFinal reportCessna 175 · Skwentna, AKThe partial loss of engine power for reasons that could not be determined because the postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation. .NTSB ANC07CA052Accident · No injuriesData collectionFinal reportCessna 175 · Stoney River, AKThe pilot's failure to maintain altitude/clearance during takeoff-initial climb, which resulted in the airplane colliding with a tree, and an uncontrolled descent.NTSB ANC01LA120Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Kenai, AKThe total loss of engine power during takeoff for an undetermined reason.NTSB ANC97LA044Accident · No injuriesLimited investigationFinal reportCessna 175 · Naknek, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. Factors associated with the accident were the pilot's inadequate preflight preparation and planning by failing to obtain information about the out of service runway lighting, and the rough…NTSB ANC87LA132Accident · No injuriesLimited investigationFinal reportCessna 175 · Yellow Jacket, AKThe pilot stated he bounced hard on the gravel runway causing him to lose directional control and the airplane nosed over on its back.NTSB ANC80FAA13Accident · No injuriesClosedCessna 175 · Fairbanks, AKNTSB ANC75DAA32Accident · No injuriesClosedCessna 175A · North Pole, AKNTSB ANC74DAH19Accident · No injuriesClosedCessna 175 · Kenai, AKNTSB ANC70DAA09Accident · No injuriesClosedCessna 175B · Rampart, AKNTSB ANC68F0093Accident · Serious injuriesClosedCessna 175 · Pilot Point, AKNTSB ANC68D0027Accident · No injuriesClosedCessna 175 · Farewell, AKNTSB ANC68D0009Accident · No injuriesClosedCessna 175 · Nenana, AKNTSB ANC66D0002Accident · No injuriesClosedCessna 175 · Clear, AK