Skip to content

NTSB investigations: Continental C90 series, WA

21 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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 GAA15CA283Accident · No injuriesData collectionFinal reportStinson HW75 · Bremerton, WAThe pilot's failure to maintain directional control during the landing roll, resulting in the left main landing gear collapse and substantial damage to the left wing strut attachment points.Sep 25, 2015 · N22548 · Substantial damage NTSB WPR12CA095Accident · No injuriesData collectionFinal reportAlon A2 · Forks, WAThe pilot's incorrect placement of the throttle prior to starting the airplane by hand. Contributing to the accident was that the pilot did not ensure that the airplane was restrained in a manner that would keep it from moving forward.Feb 4, 2012 · N5687F · Substantial damage NTSB WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.Jul 2, 2011 · N23TT · Destroyed NTSB SEA05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Spanaway, WAThe pilot's misjudgment of distance/altitude during final approach to land which resulted in an undershoot and in flight collision with a fence. A factor was the pilot's alcohol impairment.Dec 6, 2004 · N3571V · Substantial damage NTSB SEA03LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Bremerton, WAAircraft control was not maintained during the landing roll which resulted in the aircraft nosing over.Sep 24, 2003 · N9913C · Substantial damage NTSB SEA01LA114Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mattawa, WAThe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors were the gusty crosswind condition and the high vegetation (sage brush) which the aircraft rolled into before nosing over.Jun 8, 2001 · N7415B · Substantial damage NTSB SEA97LA073Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arlington, WALanding long (improper touchdown point) and collapse of the main landing gear during an intentional swerve or groundloop. Factors include excessive airspeed on approach.Mar 22, 1997 · N1184K · Substantial damage NTSB SEA94FA221Accident · 1 fatalField investigationFinal reportChampion 7FC · Tacoma, WAPilot incapacitation due to a heart attack.Aug 24, 1994 · N7598B · Substantial damage NTSB SEA93LA164Accident · No injuriesLimited investigationFinal reportChampion 7EC · Chewelah, WAThe failure of the PIC to maintain directional control and correct for ground loop/swerve.Jul 27, 1993 · N4394C · Substantial damage NTSB SEA90LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Palouse, WAThe pilots poorly planned approach for landing.Jun 1, 1990 · N5895D · Substantial damage NTSB SEA90LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Vancouver, WAEngine loss of power was due to moisture damage to the coils in the magnetoes. During the forced landing in an open field, the airplane collided with a fence which resulted in substantial damage. The airplane had not undergone current maintenance inspections…Feb 25, 1990 · N2197V · Substantial damage NTSB SEA86LA224Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kent, WAThe plt lost control of the acft during landing roll and a ground loop to the right occurred despite the plts attempt to regain control of the acft. The plt stated his ability to use the heel brakes was delayed due to the type of shoes he was wearing.Aug 24, 1986 · N23TT · Substantial damage NTSB SEA86LA180Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Colville, WAWhile making a power off approach to simulate a forced landing an over shoot was assured. The plt added pwr and the engine ceased operating. In order to avoid trees at the end of the runway the pilot made a 90 degree turn to land in a plowed field. The acft…Jul 27, 1986 · N9425A · Substantial damage NTSB SEA84LA089Accident · No injuriesLimited investigationFinal reportFornaire F-1 · Everett, WAThe acft made a hard landing and bounced. The plt said he thinks he hit a downdraft. The acft went off the rwy into the grass and damaged the nose gear and the fuselage.Apr 14, 1984 · N7535C · Substantial damage NTSB SEA76DYE03Accident · No injuriesClosedLuscombe 8F · Bremerton, WAJul 19, 1975 · N1489B · Substantial damage NTSB SEA75DYG40Accident · No injuriesClosedChampion 7FC · Ellensburg, WAMay 30, 1975 · N9093B · Substantial damage NTSB SEA74DYE11Accident · No injuriesClosedCessna 140A · Tacoma, WASep 7, 1973 · N5396C · Substantial damage NTSB SEA74FYE02Accident · No injuriesClosedChampion 7EC · Tacoma, WAJul 4, 1973 · N7439B · Substantial damage NTSB SEA73DYG23Accident · Minor injuriesClosedLuscombe T-8F · Cashmere, WAMar 3, 1973 · N1827B · Substantial damage NTSB SEA71DWG33Accident · No injuriesClosedMooney M10 · Wenatchee, WADec 4, 1970 · N9515V · Substantial damage NTSB SEA66D0110Accident · No injuriesClosedAeronca 7CCM · Bremerton, WASep 3, 1965 · N6436C · Substantial damage