Skip to content

NTSB investigations: Continental I0-470 series, VA

27 cases on aircraft whose registry engine model is Continental I0-470 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'VA' 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 ('17027')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'VA' 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 ('17027'))
  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" = 'VA' 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 ('17027'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA24LA139Accident · No injuriesClass 3 · LimitedFinal reportBeech K35 · Front Royal, VAA total loss of engine power due to fuel starvation as a result of the pilot’s mismanagement of the airplane’s fuel supply.Mar 12, 2024 · N59MK · Substantial damage NTSB ERA16FA288Accident · 6 fatalField investigationFinal reportBeech 95 B55 (T42A) · Fredericksburg, VAThe pilot(s) failure to maintain adequate airspeed during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.Aug 12, 2016 · N128VB · Substantial damage NTSB ERA15FA215Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Saltville, VAThe pilot’s flight into developing rain showers and updrafts, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident were the pilot’s continued flight into forecast adverse weather conditions, and his reliance on…May 18, 2015 · N5816S · Destroyed NTSB ERA14CA185Accident · No injuriesData collectionFinal reportCessna 205A · Leesburg, VAThe pilot's inadequate compensation for the wind conditions during landing, resulting in a runway excursion and impact with terrain. Contributing to the accident was the pilot's inadequate evaluation of the wind conditions.Apr 8, 2014 · N4862U · Substantial damage NTSB NYC07LA136Accident · No injuriesLimited investigationFinal reportBeech K35 · Cross Junction, VAThe loss of engine power for undetermined reasons.Jun 11, 2007 · N615T · Substantial damage NTSB IAD02LA022Accident · No injuriesLimited investigationFinal reportCessna 310H · Tappahannock, VAThe pilot's inadequate compensation for the gusty wind conditions. Factors in the accident were the gusty wind conditions and the total loss of left engine power due to the alternate air valve becoming disconnected and embedded in the fuel injector servo.Dec 30, 2001 · N10MS · Substantial damage NTSB IAD00LA063Accident · No injuriesLimited investigationFinal reportBeech BE-55 (T42A) · Chesapeake, VAthe pilot's misjudgment of his altitude/clearance above the runway during the aborted takeoff which resulted in an improper flare for landing. A factor in the accident was the pilot's premature rotation during the takeoff roll.Jul 18, 2000 · N26DS · Substantial damage NTSB BFO94FA096Accident · 2 fatalField investigationFinal reportCessna 210B · Culpepper, VAthe pilot's continued VFR flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control of the aircraft. Contributing factors were the low ceilings and clouds.Jun 11, 1994 · N210M · Destroyed NTSB NYC93LA144Accident · No injuriesLimited investigationFinal reportBeech A55 · Norfolk, VAThe pilot's improper compesnation for wind conditions and failure to maintain firectional control. A factor was adverse wind conditions.Aug 3, 1993 · N30JM · Substantial damage NTSB BFO87LA029Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Midland, VAThe plt stated that this was the first time he had ever landed on rwy 32. During the lndg apch, about 15 secs before touchdown, his eyeglasses broke and fell off his face. He reached for his spare eyeglasses that were on top of the instrument panel; however,…Apr 9, 1987 · N8381Z · Substantial damage NTSB BFO86FA038Accident · 4 fatalField investigationFinal reportBeech 95-B 55 · Lynchburg, VAThe non-instrument rated pilot filed an IFR flight plan into known and forecast IFR weather. During his second ILS approach to the airport, after the control tower had closed, he failed to utilize the aircraft radio to illuminate the approach lighting system.…Jul 2, 1986 · N133P · Destroyed NTSB IAD79FA036Accident · 1 fatalClosedCessna 310 · Bristol, VAFeb 27, 1979 · N5927M · Destroyed NTSB IAD79DIA17Accident · No injuriesClosedCessna 210 · Basye, VAAug 21, 1978 · N6579X · Substantial damage NTSB IAD76II020Incident · No injuriesClosedCessna 310F · Nokesville, VAOct 1, 1975 · N250PP · Minor damage NTSB IAD73FIA17Accident · No injuriesClosedNavion G · West Haymarket, VAJun 30, 1973 · N2428T · Substantial damage NTSB IAD71AI038Accident · 1 fatalClosedBellanca 14-193 · Jamesville, VAJan 28, 1971 · N8815R · Substantial damage NTSB DIA69D0198Accident · No injuriesClosedBeech K35 · Chatham, VAMay 11, 1969 · N9569R · Substantial damage NTSB DIA68F0092Accident · No injuriesClosedBeech 35-B33 · Weyers Cave, VASep 25, 1967 · N8956M · Substantial damage NTSB DIA67F0047Accident · No injuriesClosedNavion G · Leesburg, VAFeb 12, 1967 · N2476T · Substantial damage NTSB DIA67A0002Accident · No injuriesClosedCessna 310F · Chantilly, VANov 30, 1966 · N6778X · Substantial damage NTSB DIA67F0072Accident · No injuriesClosedCessna 185 · Baileys Xroad, VANov 20, 1966 · N9851X · Substantial damage NTSB NYC67F0134Accident · No injuriesClosedCessna 310F · Chantilly, VAAug 13, 1966 · N6778X · Substantial damage NTSB NYC66D0595Accident · No injuriesClosedBeech K35 · Newport News, VAMar 16, 1966 · N6086E · Substantial damage NTSB NYC66D0576Accident · No injuriesClosedCessna 210 · Clinchco, VAMar 13, 1966 · N9447T · Destroyed NTSB NYC66F0268Accident · Minor injuriesClosedBeech 35 · Union Hall, VASep 17, 1965 · N143X · Substantial damage NTSB NYC65F0030Accident · No injuriesClosedBeechcraft M-35 · Burkeville, VAFeb 15, 1965 · N658V · Substantial damage NTSB UNK64X0137Accident · No injuriesClosedBeechcraft J35 · Norfolk, VAJan 3, 1964 · N340Q · Substantial damage