NTSB investigations: Continental IO-520 series, GA
8 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 1992 | 2 |
| 2001 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 'GA' 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 ('17032')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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" = 'GA' 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 ('17032')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 ATL06CA131Accident · No injuriesData collectionFinal reportBeech A36 · Macon, GAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing.NTSB ATL05CA087Accident · No injuriesData collectionFinal reportBeech BE-36 · Dahlonega, GAThe pilot's mismanagment of the fuel supply which resulted in fuel starvation and subsequent loss of engine power.NTSB ATL01LA033Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Augusta, GAThe pilot's failure to properly preflight fuel required for the flight that resulted in fuel exhaustion and the lost of engine power.NTSB ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.NTSB ATL92LA088Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Alto, GAThe pilot's mismangement of the fuel in that he delayed selection of a fuel tank with usable fuel, and the excessive final landing speed. Factors were the pilot's failure to extend the flaps and the rough/uneven terrain because of the railroad spur.NTSB ATL88DKG10Accident · No injuriesFinal reportCessna 188 · Douglas, GANTSB ATL86FA057Accident · Serious injuriesField investigationFinal reportCessna 210M · Tucker, GADuring a night VFR flt the acft experienced a total loss of power and made a forced landing in a small parking lot in a business area. When rescue personnel asked the plt what had happened he stated that the acft ran out of fuel. Inspection of the wreckage…NTSB ATL83LA075Accident · No injuriesLimited investigationFinal reportCessna 210 · Valdosta, GAPlt stated he departed adel with 12 gals of fuel. Purpose of flt was to refuel at Valdosta (25 mi). Eng quit due to fuel exhaustion 1/2 mi short of Valdosta arpt.