Skip to content

NTSB investigations: Continental 0-300 series, SC

40 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

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" = 'SC' 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\" = 'SC' 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" = 'SC' 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 ERA24LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orangeburg, SCThe student pilot’s failure to maintain adequate clearance from a fuel truck while taxiing. Also contributing was the flight instructor’s inadequate monitoring of the student pilot.Oct 21, 2023 · N7607T · Substantial damage NTSB GAA19CA477Accident · No injuriesData collectionFinal reportCessna 172 · Greer, SCThe pilot's improper decision to continue a steep and fast approach to landing, which resulted in a runway overrun and collision with a drainage culvert.Jun 29, 2019 · N724BC · Substantial damage NTSB ERA16LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Campobello, SCThe pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.Oct 18, 2015 · N6636A · Substantial damage NTSB ERA09LA527Accident · 2 fatalLimited investigationFinal reportCessna 172 · Lowndesville, SCThe pilot's inadequate preflight planning and improper decision to continue flight into deteriorating weather conditions, which resulted in spatial disorientation after entering instrument flight conditions.Sep 19, 2009 · N5845A · Substantial damage NTSB ATL04CA163Accident · Minor injuriesData collectionFinal reportCessna 172 · Inman, SCThe pilot's failure to maintain clearance from the ground while maneuvering for a visual approach to land.Jul 29, 2004 · N3967F · Substantial damage NTSB ATL03LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Camden, SCThe pilot's inadequate preflight planning which resulted in fuel exhaustion, subsequent loss of engine power and an in-flight collision with terrain.Mar 8, 2003 · N3287L · Substantial damage NTSB MIA02LA087Accident · No injuriesLimited investigationFinal reportCessna 172H · Ehrhardt, SCthe pilot's failure to attain proper touchdown point while landing on a wet grass runway, resulting in the airplane departing the runway and impacting with trees.Apr 21, 2002 · N2815L · Substantial damage NTSB MIA02LA006Accident · No injuriesLimited investigationFinal reportCessna 170 · Bennettsville, SCThe blockage of the fuel vent and also the collapsed fuel supply line resulting in the total loss of engine power due to fuel starvation.Oct 5, 2001 · N4180V · Substantial damage NTSB MIA96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Jonesville, SCthe pilot's inadequate visual lookout and failure to maintain altitude and/or clearance from the obstruction (power line) during low altitude flight. The lack of natural lighting at dusk was a related factor.Jun 26, 1996 · N3887R · Substantial damage NTSB ATL93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Ridgeland, SCThe pilot's improper use of carburetor heat, which resulted in a partial loss of engine power. Factors were the carburetor icing conditions, and the soft terrain at the forced landing site.Jun 6, 1993 · N50000 · Substantial damage NTSB ATL93LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Ravenel, SCThe continuation of the landing attempt into the short sod field without the use of flaps and the use of excessive airspeed by the pilot. Factors in the accident were the failure of the aircraft flaps to extendJun 5, 1993 · N8279U · Substantial damage NTSB ATL91LA173Accident · No injuriesLimited investigationFinal reportCessna 172G · Summerton, SCThe pilot's inadequate compensation for the wind conditions at the airstrip. Factors in the accident were the quartering tailwind and the wet field conditions at the airstrip.Sep 13, 1991 · N4184L · Substantial damage NTSB ATL85LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbia, SCThe plt reported that during a descent to 2100 ft, intermediate level offs were made at 5000, 4000, & 3000 ft. he stated that at 2200 ft, carb heat was removed & power was applied for the level off. However, when the throttle was advanced, the eng began…May 31, 1985 · N5221F · Substantial damage NTSB ATL83FA150Accident · Serious injuriesField investigationFinal reportCessna 172 · Spartanburg, SCAccording to the plt's son, who was a passenger, the plt had made a final approach lineup on the wrong set of lights. Realizing the mistake, the plt initiated a go-around at aprx 200 ft AGL. However, the eng lost power. During an emergency landing at night,…Apr 5, 1983 · N8253U · Substantial damage NTSB MIA77FLG05Accident · No injuriesClosedCessna 172 · Columbia, SCDec 29, 1976 · N5529T · Substantial damage NTSB MIA76DLG54Accident · No injuriesClosedCessna 172 · Landrum, SCSep 26, 1976 · N5895R · Substantial damage NTSB MIA76DLG39Accident · No injuriesClosedCessna 172 · Neeses, SCAug 29, 1976 · N6482E · Substantial damage NTSB MIA76DLG23Accident · No injuriesClosedCessna 172 · Blair, SCOct 25, 1975 · N6439E · Substantial damage NTSB MIA76DLG10Accident · Minor injuriesClosedCessna 172H · Nichols, SCAug 19, 1975 · N3292L · Substantial damage NTSB IAD73AI005Accident · 2 fatalClosedCessna 172F · Mcclellanville, SCMar 9, 1973 · N5310R · Destroyed NTSB MIA73DLG29Accident · No injuriesClosedCessna 172 · No.Myrtle Bch, SCDec 27, 1972 · N2610L · Substantial damage NTSB MIA73DLG24Accident · No injuriesClosedCessna 172H · Landrum, SCOct 8, 1972 · N2881L · Substantial damage NTSB MIA73DLG12Accident · No injuriesClosedCessna 172G · Saluda, SCAug 11, 1972 · N4311L · Substantial damage NTSB MIA72AM141Accident · 1 fatalClosedCessna 172B · Santee, SCJun 24, 1972 · N7516X · Destroyed NTSB MIA72DLG25Accident · Minor injuriesClosedCessna 172B · Greenville, SCFeb 19, 1972 · N6982X · Substantial damage NTSB MIA72DLG01Accident · No injuriesClosedCessna 172C · Spartanburg, SCJul 18, 1971 · N1887Y · Substantial damage NTSB MIA70DLG12Accident · No injuriesClosedCessna 172 · Columbia, SCMar 24, 1970 · N3784L · Substantial damage NTSB MIA70F0228Accident · No injuriesClosedCessna 172B · Crescent Beach, SCOct 30, 1969 · N7446X · Substantial damage NTSB MIA69A0068Accident · 1 fatalClosedCessna 172D · Summerton, SCApr 16, 1969 · N50001 · Substantial damage NTSB MIA68D0430Accident · Minor injuriesClosedCessna 172D · Chester, SCDec 7, 1967 · N2839U · Destroyed NTSB MIA68F0025Accident · No injuriesClosedCessna 172A · Winnsboro, SCJul 14, 1967 · N7550T · Substantial damage NTSB MIA67A0110Accident · 1 fatalClosedCessna 172F · Jackson, SCApr 23, 1967 · N5504R · Substantial damage NTSB MIA67D0001Accident · Minor injuriesClosedCessna 172D · Ridgeland, SCJan 22, 1967 · N2732U · Substantial damage NTSB MIA67D0551Accident · Minor injuriesClosedCessna 172B · Allendale, SCJan 21, 1967 · N7651X · Destroyed NTSB MIA67F0138Accident · No injuriesClosedCessna 172 · Spartanburg, SCSep 4, 1966 · N8070X · Substantial damage NTSB MIA66D0510Accident · No injuriesClosedCessna 172 · Moncks Corner, SCMar 27, 1966 · N5340T · Substantial damage NTSB MIA66F0174Accident · No injuriesClosedCessna 172 · Little Mtn., SCAug 18, 1965 · N7476A · Substantial damage NTSB MIA66D0038Accident · No injuriesClosedCessna 172E · Bamberg, SCJun 6, 1965 · N3650S · Substantial damage NTSB MIA65F0105Accident · Minor injuriesClosedCessna 172 · Mcbee, SCMay 16, 1965 · N8288B · Substantial damage NTSB MIA65D0049Accident · No injuriesClosedCessna 172 · Anderson, SCApr 8, 1965 · N3744S · Substantial damage