Skip to content

NTSB investigations: Continental C90 series, CO

22 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" = 'CO' 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\" = 'CO' 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" = 'CO' 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 GAA16CA394Accident · No injuriesData collectionFinal reportAlon A2 · Alamosa, COThe pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.Jul 27, 2016 · N5690F · Substantial damage NTSB CEN10LA472Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain directional control during takeoff in gusting crosswind conditions.Aug 11, 2010 · N350CC · Substantial damage NTSB CEN09CA544Accident · No injuriesData collectionFinal reportPiper PA-18 · Aspen, COThe pilot's failure to maintain adequate separation behind a preceding large business jet, which resulted in an encounter with wake turbulence.Aug 9, 2009 · N350CC · Substantial damage NTSB DEN01LA089Accident · No injuriesLimited investigationFinal reportCessna 140A · Greeley, COtotal failure of the right main landing gear spring due to fatigue.Apr 25, 2001 · N666TC · Substantial damage NTSB DEN00LA031Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · San Luis, COThe pilot's inadequate in-flight decision, and the subsequent inadvertent stall/mush. Factors were the pilot's lack of total experience in mountain flying, the high density altitude, and downdraft weather conditions.Dec 25, 1999 · N1941B · Substantial damage NTSB DEN87LA223Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Longmont, COThe plt was attempting to land his rented acft on runway 29 at Longmont municipal airport when the acft touched down, bounced, veered off of the runway, struck a VASI light, and nosed over.Aug 20, 1987 · N4700M · Substantial damage NTSB DEN86LA108Accident · Minor injuriesLimited investigationFinal reportLuscombe T-8F · Watkins, COWhile practicing ground reference maneuvers at 500 ft AGL a total loss of engine power was experienced. The pilot rated passenger in the rear seat performed the emergency landing while the PIC attempted to restart the engine. The landing was made on open…Mar 31, 1986 · N1593B · Destroyed NTSB DEN82DA124Accident · No injuriesFinal reportLuscombe 8F · Calhan, COThe pilot took off from an airport with a density altitude of about 9500 ft. after lift-off, the aircraft reached an altitude of about 100 ft AGL and then stopped climbing. The pilot initiated emergency procedures which included leaning the mixture and…Jul 1, 1982 · N1370B · Substantial damage NTSB DEN78FTE50Accident · Minor injuriesClosedLuscombe 8F · Monte Vista, COMay 3, 1978 · N3545G · Destroyed NTSB DEN73DTE43Accident · No injuriesClosedCessna 140A · Calhan, COMay 14, 1977 · N9694A · Substantial damage NTSB DEN75DTE09Accident · No injuriesClosedLuscombe 8F · Del Norte, COJul 29, 1974 · N3545G · Substantial damage NTSB DEN72DTE30Accident · No injuriesClosedLuscombe 8F · Greeley, COOct 2, 1971 · N1370B · Substantial damage NTSB DEN69D0151Accident · No injuriesClosedLuscombe 8F · Aurora, CODec 5, 1968 · N812B · Substantial damage NTSB DEN69D0061Accident · No injuriesClosedChampion 7FC · Grover, COJul 21, 1968 · N7509B · Substantial damage NTSB DEN68D0150Accident · No injuriesClosedChampion 7EC · Cheyene Well, CONov 15, 1967 · N9872B · Substantial damage NTSB DEN67D0228Accident · No injuriesClosedCessna 140 · Glenwood Spg, COFeb 23, 1967 · N2167V · Substantial damage NTSB DEN67D0164Accident · No injuriesClosedCessna 140 · Aurora, CONov 26, 1966 · N3532V · Substantial damage NTSB DEN67D0008Accident · No injuriesClosedAlon A-2 · Pueblo, COJun 18, 1966 · N6534Q · Substantial damage NTSB DEN65D0020Accident · No injuriesClosedLuscombe 8F · Littleton, COJan 30, 1965 · N3550G · Substantial damage NTSB UNK65X0292Accident · No injuriesClosedForney 18 · Delta, COOct 16, 1964 · N7534C · Destroyed NTSB UNK64X2895Accident · Minor injuriesClosedLuscombe 8F · Boulder Creek, COJul 18, 1964 · N9933C · Destroyed NTSB UNK64X0105Accident · No injuriesClosedCessna 140 · Littleton, COJan 1, 1964 · N3736V · Substantial damage