Skip to content

NTSB investigations: Continental 0-300 series, MD

44 cases on aircraft whose registry engine model is Continental 0-300 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 ('17022')) 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 ('17022'))
  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 ('17022'))
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 ERA09CA297Accident · No injuriesData collectionFinal reportCessna 172 · Perryville, MDA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.May 20, 2009 · N3063U · Substantial damage NTSB IAD00LA061Accident · No injuriesLimited investigationFinal reportCessna 172H · Friendly, MDthe student pilot's inadequate compensation for winds that resulted in his failure to maintain runway alignment and a hard landing.Jul 1, 2000 · N1688F · Substantial damage NTSB IAD99LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Essex, MDA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and dark night conditions.Nov 16, 1998 · N5806A · Substantial damage NTSB IAD97LA072Accident · No injuriesLimited investigationFinal reportCessna 172H · Westminister, MDThe pilot misjudged landing distance on the runway and his failure to perform a go-around.May 5, 1997 · N3748F · Destroyed NTSB BFO90FA067Accident · No injuriesField investigationFinal reportCessna 150K · Clinton, MDImproper planning/decision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.Aug 2, 1990 · N6288G · Destroyed NTSB BFO90LA044Accident · No injuriesLimited investigationFinal reportCessna 172A · Pocomoke, MDThe pilot's misjudgement of distance and speed during the approach to land, and his failure to attain the proper touchdowwn point during the landing. The ditch was a related factor.May 7, 1990 · N7746T · Substantial damage NTSB BFO89LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Odenton, MDThe inflight collision with birds.Apr 3, 1989 · N8027L · Substantial damage NTSB BFO88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Oakland, MDAccording to the pilot the landing approach for runway 22 was made over power lines. He stated that during the approach the stall warning horn activated and he increased power to maintain 60 mph with 20 degs of flaps. Once estimating that his intended point…Aug 28, 1988 · N4156F · Substantial damage NTSB BFO88LA042Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Mechanicsville, MDThe acft was flown with the engine cowling plugs installed. The engine overheated and it lost power. The plt said he forgot to remove the plugs during the preflight. During the forced landing roll the acft collided with a berm and the rt main lndg gear was…May 1, 1988 · N4022V · Substantial damage NTSB BFO88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkton, MDDuring cruise flt at an alt of 1500 ft, the engine suddenly stopped producing power. The acft was landed on railroad tracks in order to avoid trees. The acft nosed over during the landing. Plt stated that the right fuel tank gauge indicated 1/4 tank and the…Apr 28, 1988 · N4255F · Substantial damage NTSB BFO86FA020Accident · No injuriesField investigationFinal reportCessna 172H · Upper Marlboro, MDSince the fuel gages in the acft were known not to be accurate, the plt measured the amount of fuel in each tank with a dipstick before departing. He determined that he had 18 gallons for the 2 hours of flying he planned to do and based on a fuel consumption…Mar 12, 1986 · N2780L · Substantial damage NTSB NYC84LA126Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Hagerstown, MDThe plt initiated a 5 mi straight-in approach. When the acft was within 2 mi of the arpt, the plt reduced power, appliedcarb heat & slowed the acft. When it appeared he was going to land short, he added power, but the eng would not respond. The acft was…Apr 1, 1984 · N2477L · Substantial damage NTSB ATL83FIG03Accident · 1 fatalFinal reportCessna 172F · Hancock, MDThe aircraft collided with the top two wires of a powerline during a low altitude sight-seeing flight along the potomac river. The pilot stated he was maintaining visual contact with the ground should an emergency landing become necessary. He was staying high…Jan 2, 1983 · N8515U · Substantial damage NTSB IAD77FIG27Accident · Minor injuriesClosedCessna 172C · Stevensville, MDJul 17, 1977 · N2029Y · Substantial damage NTSB IAD77FIG21Accident · Minor injuriesClosedCessna 172 · College Park, MDJun 25, 1977 · N2477L · Substantial damage NTSB IAD76FIG19Accident · Minor injuriesClosedCessna 172 · Laurel, MDJun 26, 1976 · N6315E · Substantial damage NTSB IAD75FIG05Accident · No injuriesClosedMaule M-4C · Easton, MDSep 26, 1974 · N9845M · Substantial damage NTSB IAD75FIA06Accident · No injuriesClosedCessna 172B · Clinton, MDSep 8, 1974 · N6918X · Substantial damage NTSB IAD74AI003Accident · No injuriesClosedLuscombe 8E · Pasadena, MDJul 8, 1973 · N1800K · 2 aircraft · Minor damage NTSB IAD73FIG25Accident · No injuriesClosedCessna 172A · Essex, MDMay 6, 1973 · N7706T · Substantial damage NTSB IAD71DIA22Accident · No injuriesClosedCessna 170B · Cobb Island, MDJun 13, 1971 · N3483D · Substantial damage NTSB IAD71FIG26Accident · Serious injuriesClosedCessna 172 · College Park, MDMar 28, 1971 · N3704R · Substantial damage NTSB IAD71FIG21Accident · Minor injuriesClosedCessna 172 · Reistertown, MDNov 14, 1970 · N1174F · Substantial damage NTSB IAD70DIG14Accident · No injuriesClosedCessna 172 · Friendsville, MDApr 19, 1970 · N1324F · Substantial damage NTSB IAD70D0070Accident · No injuriesClosedCessna 172 · Nanjemoy, MDSep 23, 1969 · N5642R · Substantial damage NTSB DIA70F0002Accident · Minor injuriesClosedCessna 172E · Laurel, MDMay 29, 1969 · N3885S · Substantial damage NTSB DIA69F0175Accident · Minor injuriesClosedCessna 172F · Gaithersburg, MDMar 24, 1969 · N7954U · Destroyed NTSB DIA68D0236Accident · Minor injuriesClosedCessna 172 · Sykesville, MDMay 30, 1968 · N7064A · Destroyed NTSB DIA68F0206Accident · Minor injuriesClosedCessna 172 · Queenstown, MDApr 14, 1968 · N6714A · Substantial damage NTSB DIA68F0027Accident · No injuriesClosedCessna 172G · Clinton, MDJul 5, 1967 · N3876L · Substantial damage NTSB DIA67D0083Accident · No injuriesClosedCessna 172 · Cambridge, MDApr 21, 1967 · N1713F · Substantial damage NTSB DIA67D0081Accident · No injuriesClosedCessna 172 · Pittsville, MDApr 3, 1967 · N8852B · Substantial damage NTSB NYC66F0598Accident · No injuriesClosedCessna 170B · Friendly, MDMar 20, 1966 · N2754C · Substantial damage NTSB NYC66F0440Accident · No injuriesClosedCessna 172F · Baltimore, MDJan 8, 1966 · N7950U · Substantial damage NTSB NYC66F0398Accident · No injuriesClosedCessna 172 · Gaithersburg, MDDec 11, 1965 · N6836X · Substantial damage NTSB NYC66F0388Accident · Serious injuriesClosedCessna 172 · Stevensville, MDDec 4, 1965 · N2560U · Destroyed NTSB NYC66D0342Accident · No injuriesClosedCessna 172 · College Park, MDNov 13, 1965 · N6225E · Substantial damage NTSB NYC66D0316Accident · No injuriesClosedCessna 170B · Baltimore, MDOct 18, 1965 · N3483D · Substantial damage NTSB NYC66D0149Accident · No injuriesClosedCessna 172 · Essex, MDAug 10, 1965 · N2553U · Substantial damage NTSB NYC65F0131Accident · No injuriesClosedCessna 172A · Westminster, MDApr 12, 1965 · N9787T · Substantial damage NTSB NYC65F0034Accident · Minor injuriesClosedCessna 172 · Mitchellville, MDJan 30, 1965 · N5656T · Destroyed NTSB UNK64X4047Accident · Minor injuriesClosedCessna 172 · Hagerstown, MDSep 19, 1964 · N3703S · Substantial damage NTSB UNK64X2913Accident · No injuriesClosedCessna 172 · Beltsville, MDJul 19, 1964 · N2434U · Substantial damage NTSB UNK64X2593Accident · Minor injuriesClosedCessna 172B · Ocean City, MDJul 1, 1964 · N8052X · Substantial damage