Skip to content

NTSB investigations: Continental C90 series, NY

18 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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA22LA242Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7EC · Putnam Valley, NYA total loss of engine power during cruise flight due to fuel starvation resulting from obstructed forward and aft vent outlets in the left fuel tank.May 25, 2022 · N7410B · Substantial damage NTSB ERA21LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Warwick, NYThe pilot’s failure to attain a proper touchdown point, which resulted in the airplane contacting the ground short of the runway.Jun 5, 2021 · N1899N · Substantial damage NTSB ERA21LA060Accident · No injuriesClass 4 · LimitedFinal reportChampion 7EC · Northhampton, NYThe pilot’s loss of airplane control during an off-airport landing on soft sand, which resulted in a nose over.Nov 29, 2020 · N9721N · Substantial damage NTSB ERA14LA261Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Cooperstown, NYThe pilot’s delayed use of carburetor heat during the approach to landing, which resulted in the formation of carburetor ice, a partial loss of engine power, and the airplane’s subsequent inability to sustain flight.May 26, 2014 · N4550M · Substantial damage NTSB ERA13LA224Accident · No injuriesLimited investigationFinal reportCessna 140A · Newburgh, NYThe pilot’s failure to maintain directional control when the brakes bound and a subsequent ground loop. Contributing to the accident was the inadequate maintenance of the brakes by the pilot/owner.Apr 26, 2013 · N5314C · Substantial damage NTSB ERA09LA467Accident · No injuriesLimited investigationFinal reportCessna 140A · White Plains, NYThe failure of the right main landing gear due to a preexisting crack adjacent to a weld line.Aug 17, 2009 · N9467A · Substantial damage NTSB NYC07CA028Accident · Minor injuriesData collectionFinal reportPiper PA-11 · Van Hornsville, NYThe pilot's failure to maintain clearance from trees during landing.Nov 11, 2006 · N4549M · Substantial damage NTSB NYC89LA144Accident · Minor injuriesLimited investigationFinal reportAlon Aircoupe A-2 · Cattaraugus, NYEngine power loss due to fuel starvation resulting from the installation of an improper fuel pump. A factor related to the accident was: trees in the emergency landing area.Jun 2, 1989 · N6589Q · Destroyed NTSB NYC84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Hastings, NYThe acft dragged a wing during landing after a ski had failed during takeoff. The plt stated that after takeoff he noticed that the left ski had turned over or dropped down in front. He landed the acft on the rwy and the ski tore off digging the landing gear…Feb 12, 1984 · N3264P · Substantial damage NTSB NYC79FFA24Accident · No injuriesClosedPiper PA-11 · Alplaus, NYJun 23, 1979 · N143R · Substantial damage NTSB NYC79DFA03Accident · No injuriesClosedLuscombe 8F · Saratoga Spgs, NYNov 19, 1978 · N1917B · Substantial damage NTSB NYC77DFA19Accident · No injuriesClosedCessna 140 · Monticello, NYApr 9, 1977 · N2752N · Substantial damage NTSB NYC72FFA38Accident · No injuriesClosedPiper PA-18 · Oneonta, NYMay 6, 1972 · N1209A · Substantial damage NTSB NYC71FFJ14Accident · Serious injuriesClosedWittman W8 · Medina, NYSep 6, 1970 · N8638E · Substantial damage NTSB NYC70D0219Accident · No injuriesClosedChampion 7FC · Castleton, NYNov 23, 1969 · N7589B · Substantial damage NTSB NYC67F0068Accident · No injuriesClosedWhitman W-8 · Buffalo, NYJun 30, 1966 · N8638E · Substantial damage NTSB NYC66D0279Accident · No injuriesClosedChampion 7AC · Jordanville, NYSep 26, 1965 · N85294 · Substantial damage NTSB NYC65F0209Accident · No injuriesClosedPiper J3C · W Winfield, NYMay 6, 1965 · N42782 · Substantial damage