Skip to content

NTSB investigations: Continental C90 series, MT

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

19652026

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" = 'MT' 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\" = 'MT' 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" = 'MT' 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 WPR13CA412Accident · Minor injuriesData collectionFinal reportPiper PA 11 · Bozeman, MTThe pilot's failure to maintain aircraft control and inadequate compensation for the high gusty wind conditions during taxi.Sep 16, 2013 · N4988M · Substantial damage NTSB SEA05LA176Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Helena, MTThe loss of engine power for undetermined reasons, which resulted in a forced landing and nose over. A factor contributing to the accident was the ground bordering the runway pavement.Aug 20, 2005 · N5467F · Substantial damage NTSB SEA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Alzada, MTThe student pilot's failure to maintain adequate flying airspeed in a turn while maneuvering close to the ground resulting in a stall condition. A contributing factor was the turbulent wind conditions.Jun 21, 2003 · N4565M · Destroyed NTSB SEA00LA126Accident · No injuriesLimited investigationFinal reportCessna 120 · Toston, MTThe pilot's failure to maintain sufficient altitude to avoid contact with the ground. Contributing factors were the downdraft conditions and the fence post.Jul 3, 2000 · N2146N · Substantial damage NTSB SEA00LA076Accident · No injuriesLimited investigationFinal reportCessna 140 · Red Lodge, MTA high density altitude and inadequate preflight planning/preparation. Not attaining a proper climb rate, not maintaining a proper runway alignment, and gusting wind conditions were factors.Apr 21, 2000 · N3579V · Substantial damage NTSB SEA98LA057Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Glendive, MTThe pilot's delayed remedial action and his inadvertent entry into a ground loop.Apr 1, 1998 · N4382C · Substantial damage NTSB SEA96LA203Accident · No injuriesLimited investigationFinal reportForney F-1 · Bozeman, MTthe pilot's failure to adequately service the engine with oil before flight, which resulted in a loss of oil pressure and a subsequent forced landing. The high vegetation and embankment at the forced landing site were related factors.Aug 25, 1996 · N7551C · Substantial damage NTSB SEA91LA123Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · St. Xavier, MTThe pilot's improper use of the fuel system, and the overfilling of the fuel tank. Contributing to the accident was: aerobatics performed, the pilot's inattention and the design of the fuel system.Jun 2, 1991 · N10527 · Destroyed NTSB SEA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wolf Point, MTThe inadequate preflight planning and preparation by the pilot in command, and his selection of unsuitable terrain for takeoff. A factor relating to the accident was the snowdrifts in the takeoff area.Jan 12, 1991 · N2787P · Substantial damage NTSB DEN89LA049Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Winnett, MTThe pilot was taking off from a farm strip with a 10 kt head wind. The plt said the sun was shining at the time of the acdt but there had been snow showers in the area. He said the liftoff was normal but at about 15 to 18 ft AGL the acft stalled and crashed.…Dec 23, 1988 · N5570H · Substantial damage NTSB SEA77FTA23Accident · No injuriesClosedBellanca 7CE · Baker, MTAug 5, 1977 · N7525E · Substantial damage NTSB SEA77FTA07Accident · No injuriesClosedPiper PA-18 · Miles City, MTJan 17, 1977 · N2989Z · Substantial damage NTSB SEA77FTA06Accident · No injuriesClosedPiper PA-18 · Glasgow, MTJan 3, 1977 · N5425H · Substantial damage NTSB SEA76FTA16Accident · No injuriesClosedPiper PA-11 · Ashland, MTMar 10, 1976 · N5010H · Substantial damage NTSB SEA76FTA10Accident · No injuriesClosedPiper PA-18 · Glasgow, MTDec 23, 1975 · N5425H · Substantial damage NTSB SEA75DTI21Accident · No injuriesClosedCessna 140A · Deer Lodge, MTFeb 27, 1975 · N1141D · Substantial damage NTSB SEA75FTA06Accident · Serious injuriesClosedPiper PA-11 · Hammond, MTAug 19, 1974 · N4992H · Substantial damage NTSB SEA72FTA18Accident · No injuriesClosedPiper PA-18 · Laurel, MTJun 28, 1972 · N5452H · Substantial damage NTSB SEA72DTI10Accident · No injuriesClosedAeronca 7EC · Malta, MTJan 21, 1972 · N7406B · Substantial damage NTSB SEA71DTI39Accident · No injuriesClosedLuscombe T-8F · Chinook, MTJun 13, 1971 · N2216B · Substantial damage NTSB SEA71DDA09Accident · No injuriesClosedAeronca 7AC · Opheim, MTNov 15, 1970 · N81782 · Substantial damage NTSB SEA70FDG05Accident · No injuriesClosedAlon A-2 · Great Falls, MTMay 23, 1970 · N5697F · Substantial damage NTSB SEA70FDA07Accident · No injuriesClosedChampion 7EC · Scobey, MTMay 2, 1970 · N4382C · Substantial damage NTSB SEA70D0058Accident · No injuriesClosedCessna 140A · Hingham, MTAug 1, 1969 · N9625A · Substantial damage NTSB SEA69F0003Accident · No injuriesClosedPiper PA-11 · Zurich, MTJun 10, 1968 · N4966H · Substantial damage NTSB SEA68D0313Accident · Minor injuriesClosedPiper PA-11 · Wolf Point, MTMay 18, 1968 · N78741 · Substantial damage NTSB SEA68F0300Accident · Serious injuriesClosedAlon A-2 · Billings, MTApr 29, 1968 · N6504Q · Substantial damage NTSB SEA68F0116Accident · No injuriesClosedChampion 7FC · Billings, MTAug 28, 1967 · N9886B · Substantial damage NTSB SEA68D0143Accident · No injuriesClosedForney F-1 · Jordan, MTAug 14, 1967 · N7551C · Substantial damage NTSB SEA67D0019Accident · No injuriesClosedChampion 7EC · Issoula, MTJun 6, 1966 · N4317C · Substantial damage NTSB SEA66F0035Accident · No injuriesClosedCessna 140A · Cut Bank, MTJun 8, 1965 · N9625A · Substantial damage NTSB SEA65D0016Accident · No injuriesClosedPiper PA-11 · Decker, MTFeb 6, 1965 · N5570H · Substantial damage