NTSB investigations: Continental IO-520 series, VT
17 cases on aircraft whose registry engine model is Continental IO-520 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 2 |
| 1975 | 1 |
| 1976 | 2 |
| 1978 | 3 |
| 1979 | 2 |
| 1982 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 2018 | 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\" = 'VT' 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'))
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" = 'VT' 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'))
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 ERA18LA111Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelburne, VTThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB NYC90FA054Accident · 3 fatalField investigationFinal reportCessna 310R · Burlington, VTFor an unknown reason, the aircraft entered a descent and crashed in a lake.NTSB NYC88LA002Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Newport, VTShortly after takeoff, the eng lost power as the acft was climbing thru about 75' AGL. Subsequently, the acft was damaged during an emerg landing. An exam revealed the acft had a very loosely fitting fuel cap & water was found in the fuel lines & sumps. The…NTSB NYC82DA219Accident · No injuriesFinal reportBeech 35 · Topsham, VTEngine quit and pilot made forced landing in open field. Fuel selector was found on right tank which was empty. Left tank was full. Fuel lines were dry.NTSB NYC79FA105Accident · 3 fatalClosedBeech 35C33A · Warren, VTNTSB NYC79FNC46Accident · Minor injuriesClosedBellanca 17-30 · Panton, VTNTSB NYC78FNC43Accident · Serious injuriesClosedBeech A-36 · Burlington, VTNTSB NYC78DNC40Accident · No injuriesClosedCessna 185 · St Albans, VTNTSB NYC78DNC20Accident · No injuriesClosedCessna 206 · Warren, VTNTSB NYC76DNC49Accident · No injuriesClosedCessna A188B · W Cornwall, VTNTSB NYC76DNC42Accident · Minor injuriesClosedBeech A36 · Stowe, VTNTSB NYC76FNC25Accident · No injuriesClosedCessna 210H · Newport, VTNTSB NYC72DNC26Accident · No injuriesClosedBeech V35 · St.Johnsbury, VTNTSB NYC72DNC25Accident · No injuriesClosedCessna 206P · West Dover, VTNTSB NYC71DFA30Accident · No injuriesClosedCessna 320E · Lyndonville, VTNTSB NYC69F0311Accident · No injuriesClosedBeech 95-D55 · Burlington, VTNTSB NYC69F0058Accident · Serious injuriesClosedBeech 95-C55 · Vergennes, VT