Skip to content

NTSB investigations: Continental O-470 series, VT

20 cases on aircraft whose registry engine model is Continental O-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

19732026

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" = '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 ('17026')) 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\" = '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 ('17026'))
  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 ('17026'))
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 ERA26LA250Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182 · Charlotte, VTJun 11, 2026 · N70933 · Substantial damage NTSB ERA20CA224Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Burlington, VTThe pilot’s failure to maintain directional control during landing roll in crosswind conditions.Jun 22, 2020 · N7955V · Substantial damage NTSB ERA16CA128Accident · Serious injuriesData collectionFinal reportCessna 180 · South Burlington, VTThe pilot's failure to maintain airplane control during takeoff roll, which resulted in a nose over.Mar 13, 2016 · N9925N · Substantial damage NTSB ERA13CA427Accident · Minor injuriesData collectionFinal reportCessna 182E · Middletown Springs, VTThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Sep 21, 2013 · N3152Y · Substantial damage NTSB ERA12CA322Accident · No injuriesData collectionFinal reportCessna 182N · Newport, VTThe pilot’s failure to maintain adequate airspeed during the approach, which resulted in an aerodynamic stall and hard landing.May 6, 2012 · N9217G · Substantial damage NTSB DEN07CA117Accident · No injuriesData collectionFinal reportCessna 182R · Montpelier, VTThe pilot's improper flare and subsequent hard landing.Jul 10, 2007 · N9890H · Substantial damage NTSB IAD02LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rutland, VTThe pilot's failure to attain the proper touchdown point. A factor was the crosswindJun 1, 2002 · N97996 · Substantial damage NTSB IAD99FA004Accident · 1 fatalField investigationFinal reportCessna 305A · Warren, VTThe glider pilot's failure to perform the emergency tow release and abort the takeoff. A factor in the accident was the glider pilot's improper decision to make repeated attempts to close the canopy in flight.Oct 5, 1998 · N5213G · 2 aircraft · Destroyed NTSB NYC95LA067Accident · No injuriesLimited investigationFinal reportCessna 180J · West Dover, VTA loss of power for undetermined reasons. The frozen snow covered terrain was a factor.Mar 3, 1995 · N180BF · Substantial damage NTSB NYC89LA201Accident · No injuriesLimited investigationFinal reportCessna 182R · Warren, VTImproper flare by the pilot, and his improper recovery from a bounced landing.Aug 19, 1989 · N9335E · Substantial damage NTSB NYC82DA146Accident · No injuriesFinal reportCessna 305A · Morrisville, VTThe pilot reported that he landed on runway 19 with a wind from 250 deg at 15, gusting 20 knots. He reported that as the aircraft rolled out, a severe gust of wind was encountered that put the plane on the left gear only. Subsequently, the left gear failed…Jul 9, 1982 · N22SU · Substantial damage NTSB NYC81DNC05Accident · No injuriesClosedCessna 182 · Middlebury, VTOct 12, 1980 · N3491U · Substantial damage NTSB NYC78FA007Accident · 3 fatalClosedCessna 180 · Jay, VTNov 6, 1977 · N9298C · Destroyed NTSB NYC76FNC46Accident · No injuriesClosedCessna 305A · Warren, VTApr 16, 1976 · N5264G · Substantial damage NTSB NYC76DNC36Accident · No injuriesClosedCessna 180 · Warren, VTMar 15, 1976 · N5110E · Substantial damage NTSB NYC76DNC33Accident · No injuriesClosedCessna 182 · Rutland, VTDec 25, 1975 · N2342R · Substantial damage NTSB NYC75FNC28Accident · No injuriesClosedBeech B24R · Morrisville, VTApr 12, 1975 · N2195W · Substantial damage NTSB NYC74FNC24Accident · No injuriesClosedCessna 180 · Warren, VTOct 8, 1973 · N5110E · 2 aircraft · Substantial damage NTSB NYC73FNC62Accident · No injuriesClosedCessna 310B · Burlington, VTMar 24, 1973 · N310B · Substantial damage NTSB NYC73DNC61Accident · No injuriesClosedCessna 182N · Montpelier, VTMar 23, 1973 · N92472 · Substantial damage