Skip to content

NTSB investigations: Continental I0-470 series, MD

18 cases on aircraft whose registry engine model is Continental I0-470 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" = 'MD' 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 ('17027')) 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\" = 'MD' 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 ('17027'))
  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" = 'MD' 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 ('17027'))
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 ERA24LA037Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Frederick, MDA failure of a hydraulic filter, which preluded normal extension of the landing gear. Also causal was the pilot’s failure to confirm that he landing gear was extended before landing, which resulted in a gear up landing.Nov 13, 2023 · N9515X · Substantial damage NTSB ERA20CA091Accident · No injuriesData collectionFinal reportCessna 185 · Laytonsville, MDThe failure of the tailwheel attachment tube during the takeoff roll, which resulted in a loss of directional control, a runway excursion, and the left main landing gear collapsing.Jan 17, 2020 · N1557F · Substantial damage NTSB ERA18LA181Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35B33 · Berlin, MDThe failure of the No. 3 cylinder exhaust valve, which resulted in the total loss of engine power during takeoff.Jun 29, 2018 · N9745Y · Substantial damage NTSB ERA10LA375Accident · No injuriesLimited investigationFinal reportCessna 182 · Crisfield, MDThe pilot's delayed decision to abort the takeoff, which resulted in a runway excursion.Jul 17, 2010 · N777RM · Substantial damage NTSB ERA10FA154Accident · 1 fatalField investigationFinal reportBeech P35 · Edgewater, MDThe pilot's failure to maintain adequate airspeed while on approach, which resulted in an inadvertent stall. Contributing to the accident was the pilot's likely impairment due to back pain, symptoms of opiate withdrawal, or both.Feb 27, 2010 · N1521S · Substantial damage NTSB IAD99FA070Accident · Serious injuriesField investigationFinal reportCessna 310Q · Salisbury, MDThe improper installation of the #2 cylinder that resulted in a fractured crankshaft and a total loss of engine power. Factors in the accident were the premature deployment of the landing gear and flaps by the pilot.Sep 28, 1999 · N69945 · Substantial damage NTSB BFO96LA002Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Annapolis, MDthe pilot's improper planning/decision, and/or failure to go around while there sufficient airspeed and runway remaining during the approach/landing. Factors relating to the accident were: standing water on the runway, and resultant hydroplaning conditions.Oct 5, 1995 · N6648W · Substantial damage NTSB BFO89LA046Accident · No injuriesLimited investigationFinal reportCessna 210A · Ocean City, MDFailure of the pilot to go around after landing long & recovering from a bounced landing. Contributing factors were: the pilot's excessive airspeed on the apch, his improper flare for the landing, his failure to attain the proper touchdown point, and the…Jun 19, 1989 · N9520X · Substantial damage NTSB ATL81FIG06Accident · No injuriesClosedCessna 310G · Mitchellville, MDFeb 9, 1981 · N8919Z · Destroyed NTSB ATL80FIG17Accident · Minor injuriesClosedNavion G · Chester, MDAug 31, 1980 · N2353T · Substantial damage NTSB IAD79FA069Accident · 2 fatalClosedCessna 310K · Cresaptown, MDAug 20, 1979 · N7060L · Destroyed NTSB IAD71FIG14Accident · No injuriesClosedCessna 210 · Churchville, MDAug 26, 1970 · N7366E · Substantial damage NTSB DIA69F0059Accident · No injuriesClosedBeech 35-B33 · Ocean City, MDJul 30, 1968 · N1782G · Substantial damage NTSB NYC66F0544Accident · Minor injuriesClosedAero Comdr 500-B · Hagerstown, MDFeb 24, 1966 · N9388R · Substantial damage NTSB NYC66F0359Accident · No injuriesClosedCessna 210B · Clinton, MDOct 26, 1965 · N9741X · Substantial damage NTSB NYC66F0004Accident · No injuriesClosedCuster CCW-5 · Hagerstown, MDApr 29, 1965 · N5855V · Substantial damage NTSB NYC65F0141Accident · No injuriesClosedCessna 210B · Gaithersburg, MDApr 8, 1965 · N9624X · Substantial damage NTSB UNK64X3543Accident · No injuriesClosedBeechcraft A55 · Baltimore, MDAug 22, 1964 · N7501S · Substantial damage