Skip to content

NTSB investigations: Continental C90 series, OH

32 cases on aircraft whose registry engine model is Continental C90 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" = 'OH' 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 ('17009')) 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\" = 'OH' 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 ('17009'))
  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" = 'OH' 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 ('17009'))
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 CEN09CA556Accident · No injuriesData collectionFinal reportAlon A2 · Richmond Hts., OHThe pilot's failure to maintain control of the airplane during the landing flare.Aug 31, 2009 · N6363V · Substantial damage NTSB CHI08LA166Accident · 1 fatalLimited investigationFinal reportHelton Lark 95 · West Carrollton, OHThe improper installation of spark plugs during the annual inspection which resulted in a loss of engine power shortly after takeoff. Contributing to the accident was the lack of suitable terrain during the forced landing.Jun 17, 2008 · N86657 · Destroyed NTSB CHI07LA096Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Ravenna, OHThe pilot's failure to use carburetor heat in cruise flight. Carburetor icing conditions and a ditch were factors.Mar 28, 2007 · N992DC · Substantial damage NTSB NYC00LA194Accident · No injuriesLimited investigationFinal reportCessna 140 · Alliance, OHThe pilot's improper decision to abort the takeoff. A factor in this accident was the dark night conditions.Jul 9, 2000 · N3583V · Substantial damage NTSB NYC94LA124Accident · No injuriesLimited investigationFinal reportCessna 140 · Mount Vernon, OHThe pilot's inadequate handling which resulted in the airplane nosing over during the takeoff roll.Jun 23, 1994 · N3627V · Destroyed NTSB CHI90LA150Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hillsboro, OHFailure of the pilot to maintain directional control during initial climb after takeoff. The pilot's lack of experience in the airplane is a factor.Jun 11, 1990 · N9836Y · Substantial damage NTSB CHI90LA133Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hamilton, OHFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.May 11, 1990 · N4352C · Substantial damage NTSB CHI89LA003Accident · No injuriesLimited investigationFinal reportChampion 7EC · Bainbridge, OHOct 9, 1988 · N9836Y · Substantial damage NTSB ATL87FA006Accident · No injuriesField investigationFinal reportCessna 140A · Hamilton, OHThe Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft…Oct 19, 1986 · N9612A · 2 aircraft · Substantial damage NTSB CHI85LA190Accident · No injuriesLimited investigationFinal reportPiper PA-11-494 · Alliance, OHThe acft approach was high and fast. The landing was made with 500-600 ft of runway remaining. The acft brakes were not sufficient to stop on the runway. The pilot added power and veered left off the end of the runway to avoid a heavily traveled road, the…May 7, 1985 · N4707H · Substantial damage NTSB CHI77FEK27Accident · No injuriesClosedChampion 7FC · Columbus, OHAug 20, 1977 · N9039B · Substantial damage NTSB CHI73FEG29Accident · Minor injuriesClosedLuscombe 8F · New Lebanon, OHJun 17, 1973 · N1382B · Substantial damage NTSB CHI72FEG36Accident · No injuriesClosedForney F1A · Batavia, OHMay 5, 1972 · N3028G · Substantial damage NTSB CHI72FEG27Accident · No injuriesClosedForney F-1A · Phillipsburg, OHFeb 8, 1972 · N3028G · Minor damage NTSB CHI71FGG32Accident · No injuriesClosedLuscombe 8F · Findlay, OHApr 19, 1971 · N1475B · Substantial damage NTSB CHI70DGG08Accident · No injuriesClosedCessna 140 · Lancaster, OHFeb 18, 1970 · N2421V · Substantial damage NTSB CHI68D0656Accident · No injuriesClosedPiper PA-18 · Chagrin Flls, OHFeb 24, 1968 · N1650P · Substantial damage NTSB CHI68F0114Accident · No injuriesClosedCessna 120 · Columbus, OHJul 22, 1967 · N72256 · Substantial damage NTSB CHI68F0134Accident · No injuriesClosedCessna 140A · North Canton, OHJul 1, 1967 · N3789V · Substantial damage NTSB CHI67F0480Accident · Minor injuriesClosedAeronca 7FC · Walbridge, OHJan 13, 1967 · N7504B · Destroyed NTSB CHI67D0210Accident · No injuriesClosedCessna 170 · Canton, OHJun 29, 1966 · N9404A · Destroyed NTSB CHI66D0729Accident · No injuriesClosedLuscombe 8F · Canton, OHApr 17, 1966 · N1394B · Substantial damage NTSB CHI66F0607Accident · No injuriesClosedChampion 7FC · Circleville, OHMar 14, 1966 · N9890B · Substantial damage NTSB CHI66F0572Accident · Minor injuriesClosedChampion 7FC · Bryan, OHFeb 12, 1966 · N7540E · Substantial damage NTSB CHI66F0450Accident · Minor injuriesClosedPiper J3 · Finneytown, OHDec 4, 1965 · N6661H · Substantial damage NTSB CHI66D0119Accident · No injuriesClosedLuscombe 8E · Wellsville, OHJul 11, 1965 · N1444B · Substantial damage NTSB CHI65F0205Accident · No injuriesClosedCessna 140 · Chesapeake, OHJun 6, 1965 · N1693V · Substantial damage NTSB CHI65D0008Accident · No injuriesClosedCessna 140A · Stow, OHJan 21, 1965 · N5389C · Substantial damage NTSB UNK64X3974Accident · No injuriesClosedChampion 7FC · Reynoldsburg, OHSep 13, 1964 · N9868Y · Substantial damage NTSB UNK64X3039Accident · No injuriesClosedChampion 7FC · Dayton, OHJul 25, 1964 · N8951R · Substantial damage NTSB UNK64X1316Accident · No injuriesClosedChampion 7FC · Miamisburg, OHApr 14, 1964 · N7566B · Substantial damage NTSB UNK64X0215Accident · No injuriesClosedCessna 140A · Painsville, OHJan 11, 1964 · N5389C · Substantial damage