Skip to content

NTSB investigations: Continental 0-300 series, MS

37 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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 NYC08CA303Accident · No injuriesData collectionFinal reportCessna 172 · Newton, MSThe pilot's failure to maintain aircraft control while landing.Aug 30, 2008 · N6478E · Substantial damage NTSB MIA03LA099Accident · No injuriesLimited investigationFinal reportCessna 172D · South Ponotoc, MSthe pilot's failure to maintain altitude and aircraft control during a low pass over a grass runway, which resulted in the airplane impacting the ground.Apr 27, 2003 · N2371U · Substantial damage NTSB ATL02LA036Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Bellewood, MSThe pilot misjudged the proper touched down point and collided with the ground short of the runway during an attempted landing.Jan 8, 2002 · N48031 · Substantial damage NTSB MIA00LA015Accident · No injuriesLimited investigationFinal reportCessna 172G · Itta Bena, MSa loss of engine power for undetermined reasons resulting in a forced landing that was short of the intended touchdown point, and the subsequent impact with the ground.Oct 28, 1999 · N1171F · Substantial damage NTSB ATL99LA123Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, MSThe pilot's failure to switch the magneto switch to the both position before attempting a takeoff that resulted in the loss of engine power and resulted in the subsequent collision with trees.Sep 6, 1999 · N9785T · Substantial damage NTSB MIA95LA109Accident · No injuriesLimited investigationFinal reportCessna 172H · Hattiesburg, MSThe pilot-in-command's improper use of carburetor heat during descent, resulting in a total loss of engine power due to carburetor icing, and subsequent forced landing to unsuitable terrain.Apr 16, 1995 · N3835R · Substantial damage NTSB MIA93FA194Accident · 1 fatalField investigationFinal reportCessna 172H · Liberty, MSThe pilot's delayed go-around and failure to retract the flaps in a timely manner. Factors which contributed to the accident were: the pilot's misjudgment of distance and speed which resulted in overshooting the approach, and the existence of power lines…Sep 12, 1993 · N3767R · Destroyed NTSB MIA89LA199Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Forest, MSFailure of the pilot to maintain runway alignment and partial loss of power from water in the fuel. Contributing factors were: uneven runway, pilot's improper recovery from a bounced landing, a gusty crosswind condition, and trees.Jul 13, 1989 · N3905L · Substantial damage NTSB MIA89FA090Accident · 2 fatalField investigationFinal reportCessna 172 · Blue Mountain, MSThe continuation of a VFR flight into night, instrument meteorological conditions and the spatial disorientation of the non-instrument rated pilot. Contributing to the accident were the adverse weather conditions and the overconfidence of the pilot.Feb 20, 1989 · N3937F · Destroyed NTSB MIA88LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Tupelo, MSThe private pilot landed on runway 18 after completing a cross-country flight. During landing roll the aircraft encountered a downwind gust of wind and the pilot lost control of the aircraft while on the ground. The propeller and right wing were substantially…Aug 11, 1988 · N2344U · Substantial damage NTSB ATL84LA212Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Grenada, MSDuring arrival to an uncontrolled arpt, the plt made an apch while following about 1/4 mi behind a UH-1 helicopter. At that time, there was a quartering head wind at about 4 KTS. While on final apch at an alt of about 200 ft AGL, the Cessna 172 encountered…Jun 30, 1984 · N4650L · Substantial damage NTSB ATL84FLT08Accident · No injuriesFinal reportCessna 172 · Walls, MSThe plt stated that he stalled the acft about 15 ft AGL. When the acft hit the rwy it flipped over.Apr 13, 1984 · N8008X · Substantial damage NTSB ATL84LLT05Accident · Minor injuriesFinal reportCessna C-172F · Pascagoula, MSThe plt ditched the acft after a complete loss of power. The acft fuel system was damaged during the recovery process and a complete evaluation could not be made.Mar 3, 1984 · N8662U · Substantial damage NTSB ATL82DA097Accident · No injuriesFinal reportCessna 172 · Brook Haven, MSThe pilot visually checked the fuel level before takeoff and estimated that he had 15 to 16 gallons remaining. Since the flight was planned for 30 to 45 minutes, no fuel was added. However, after flying for 30 to 35 minutes, the engine lost power. The pilot…Apr 8, 1982 · N6444B · Substantial damage NTSB MIA75DKQ35Accident · No injuriesClosedCessna 172 · Forest, MSJun 14, 1975 · N4125F · Substantial damage NTSB MIA73FKQ21Accident · No injuriesClosedCessna 172 · Gulfport, MSOct 21, 1972 · N2429U · Substantial damage NTSB MIA71FLT13Accident · No injuriesClosedCessna 172 · Holly Spgs, MSApr 25, 1971 · N8181B · Substantial damage NTSB MIA70FKQ05Accident · No injuriesClosedCessna 172G · Purvis, MSApr 21, 1970 · N3728L · Substantial damage NTSB MIA70A0041Accident · 1 fatalClosedCessna 172G · Hazelhurst, MSNov 27, 1969 · N3814L · Destroyed NTSB MIA70F0076Accident · Minor injuriesClosedCessna 172 · Kosciusko, MSJul 17, 1969 · N5843A · Substantial damage NTSB MIA69D0023Accident · No injuriesClosedCessna 170 · Monticello, MSJul 7, 1968 · N2848C · Substantial damage NTSB MIA69D0007Accident · No injuriesClosedCessna 170B · Natchez, MSJun 5, 1968 · N2764D · Substantial damage NTSB MIA68D0515Accident · No injuriesClosedCessna 172 · Tutwiler, MSMay 12, 1968 · N8229B · Substantial damage NTSB MIA68F0294Accident · Minor injuriesClosedCessna 172 · Cleveland, MSNov 24, 1967 · N6321E · Substantial damage NTSB MIA68F0141Accident · Minor injuriesClosedCessna 172 · Lucedale, MSAug 26, 1967 · N3994S · Substantial damage NTSB MIA67F0057Accident · Minor injuriesClosedCessna 172 · Lamar, MSJul 14, 1966 · N6744A · Substantial damage NTSB MIA66D0533Accident · No injuriesClosedCessna 170B · Raymond, MSMay 8, 1966 · N3482C · Substantial damage NTSB MIA66F0487Accident · No injuriesClosedCessna 172 · Tchula, MSApr 5, 1966 · N5483R · Substantial damage NTSB MIA66D0231Accident · No injuriesClosedCessna 172 · Rural Hill, MSSep 11, 1965 · N2464U · Substantial damage NTSB MIA66F0233Accident · No injuriesClosedCessna 172E · Crowder, MSSep 7, 1965 · N7749U · Substantial damage NTSB MIA66D0239Accident · No injuriesClosedCessna 172 · Tchula, MSAug 29, 1965 · N7987U · Substantial damage NTSB MIA66D0040Accident · No injuriesClosedCessna 172 · Wayside, MSJun 18, 1965 · N6417B · Substantial damage NTSB MIA65F0039Accident · No injuriesClosedCessna 172 · Charleston, MSApr 4, 1965 · N2535Y · Substantial damage NTSB UNK65X0393Accident · No injuriesClosedCessna 172 · Marks, MSOct 24, 1964 · N3864S · Substantial damage NTSB UNK64X3872Accident · No injuriesClosedCessna 172 · Louisville, MSSep 8, 1964 · N7991B · Substantial damage NTSB UNK64X2102Accident · No injuriesClosedCessna 172E · Canton, MSJun 4, 1964 · N3805S · Substantial damage NTSB UNK64X1507Accident · No injuriesClosedCessna 172 · Picayune, MSApr 29, 1964 · N3980S · Substantial damage