NTSB investigations: Continental IO-520 series, 2005
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 | 21 |
|---|---|
| 1983 | 10 |
| 1984 | 14 |
| 1985 | 14 |
| 1986 | 7 |
| 1987 | 11 |
| 1988 | 14 |
| 1989 | 8 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 8 |
| 1993 | 9 |
| 1994 | 4 |
| 1995 | 7 |
| 1996 | 4 |
| 1997 | 7 |
| 1998 | 2 |
| 1999 | 4 |
| 2000 | 6 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 8 |
| 2006 | 7 |
| 2007 | 3 |
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 year(c.\"eventDate\") = 2005
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 year(c."eventDate") = 2005
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 MIA06LA037Accident · No injuriesLimited investigationFinal reportCessna P206C · Lake Wales, FLThe loss of engine power during takeoff-initial climb due to fuel starvation, which resulted in a hard, off-airport forced landing.NTSB DFW06CA034Accident · No injuriesData collectionFinal reportCessna 210M · Kirbyville, TXThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05LA233Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A (L-17B) · Zeeland, MIThe loss of engine power after takeoff due to a fuel selector valve leak and low altitude and low airspeed at the time of power loss. A factor was the recommended maintenance service for the fuel selector not performed by the airplane owner/pilot.NTSB ATL05FA135Accident · 2 fatalField investigationFinal reportBeech V35B · Rock Hill, SCThe pilot's mismanagement of the fuel supply , which resulted in fuel starvation and subsequent loss of engine power.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 DFW05CA128Accident · Serious injuriesData collectionFinal reportBellanca 17-30A · Houston, TXThe pilot's mismanagement of the fuel and his inadequate monitoring of the fuel supply which resulted in fuel starvation.NTSB ATL05CA056Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Eagleville, TNThe pilot's mismanagement of the fuel supply by his failure to switch the fuel selector position , which resulted in a loss of engine power due to fuel starvation.NTSB MIA05LA063Accident · No injuriesLimited investigationFinal reportCessna T207A · West Palm Beach, FLThe pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation and subsequent impact with an embankment during an emergency landing.