NTSB investigations: Continental 0-300 series, MO
86 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.
Cases per year
| 1964 | 6 |
|---|---|
| 1965 | 8 |
| 1966 | 15 |
| 1967 | 6 |
| 1968 | 6 |
| 1969 | 2 |
| 1970 | 4 |
| 1971 | 1 |
| 1972 | 4 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 4 |
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 1 |
| 1986 | 2 |
| 1988 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2017 | 2 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'MO' 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" = 'MO' 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" DESCRun 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 GAA17CA476Accident · No injuriesData collectionFinal reportCessna 172 · Drexel, MOThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN17LA241Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fulton, MOThe partial loss of engine power due to water contamination in the fuel system.NTSB CEN12CA361Accident · No injuriesData collectionFinal reportCessna 172H · Moscow Mills, MOThe pilot's failure to maintain control of the airplane during takeoff in a gusty crosswind, which resulted in a runway excursion.NTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.NTSB CHI07CA012Accident · Minor injuriesData collectionFinal reportCessna 172 · Maryville, MOThe pilot's inadequate recovery from a bounced landing leading to the nose gear overload.NTSB CHI06LA095Accident · No injuriesLimited investigationFinal reportCessna 172G · Collins, MOThe pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion, and the loss of engine power during cruise flight. An additional cause was the pilot's improper in-flight decision to continue when he believed his fuel gauges were erratic…NTSB CHI04CA088Accident · Minor injuriesData collectionFinal reportCessna 172A · Springfield, MOThe pilot failed to initiate a go-around and the airplane porpoised during the hard landing. Factors associated with the accident were the excessive groundspeed and the overload failure of the nose gear.NTSB CHI03LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Holt, MOThe pilot's inadequate preflight planning/preparation, which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident were the trees.NTSB CHI03LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Callao, MOA loss of engine power due to the erosion of the number 2 piston, resulting in loss of compression on that cylinder. Contributing factors were the tailwind, the muddy runway condition, and the roadway and ditch.NTSB CHI02LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Butler, MOThe fuel exhaustion, the inadequate fuel consumption calculations by the pilot, and the inadequate in-flight planning/decision by the pilot. The unsuitable terrain encountered during the forced landing is a contributing factor.NTSB CHI01LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Carrollton, MOthe misjudged touchdown point by the pilot. Factors were the runway lights not on, the dark night, and the plowed field.NTSB CHI00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Buffalo, MOThe inadvertent stall during a go-around. Factors relating to this accident were the student pilot's improper in-flight decisions and his failure to raise the flaps during the go around.NTSB CHI92LA005Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Cassville, MOThe pilot-in-command's improper preflight planning and preparation. Factors contributing to this accident were fuel exhaustion, a hidden obstruction within the terrain the pilot landed on and a collapsed nosegear.NTSB MKC90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Dexter, MOThe pilot misjudged his distance and altitude on final approach, and failed to reach the proper touchdown point for landing. The gusty crosswind condition was a related factor.NTSB MKC89LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Linn, MOWhile attempting to land crosswind on a 900 foot long dirt runway, the pilot decided he was too high and had excessive airspeed. He attempted to make a go around. However, he was unable to clear a dirt embankment and struck the nose wheel. Unaware of the…NTSB MKC88LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrensburg, MOWhile practicing stop and go ldgs, the student lost directional control. The takeoff was attempted with a left crosswind. The acft veered to the left, off the runway, and hit an embankment. The nose and left main gears, the propeller, and fuselage were…NTSB MKC88LA068Accident · No injuriesLimited investigationFinal reportCessna 172G · Springfield, MOThe pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180…NTSB MKC86LA127Accident · No injuriesLimited investigationFinal reportCessna 172F · Jefferson City, MOThe runway was under construction with a new section being added to the old runway. This construction was covered in a published NOTAM. The pilot had been making touch and go landings and was making a full stop landing when he landed on the new portion of the…NTSB MKC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Grain Valley, MOThe PIC was making a roundtrip flt to numerous airports across Kansas and Missouri. The owner of the aircraft was aboard for the trip which was for pleasure. The PIC had obtained weather info and was apprised of the wind conditions for his route of flt. Upon…NTSB MKC82DA022Accident · No injuriesFinal reportCessna 172H · Wentzville, MODuring a cross-country flight, the pilot switched the fuel selector from both tanks to the right tank to balance the fuel. After the tanks were balanced, he failed to switch the selector back to both. During a night, final approach at his destination, the…NTSB MKC82DCA05Accident · No injuriesClosedCessna 172D · Jefferson City, MONTSB MKC82FCA02Accident · Minor injuriesClosedCessna 172 · Piedmont, MONTSB MKC81FA042Accident · 2 fatalClosedCessna 172G · Newburg, MONTSB MKC81FCA03Accident · No injuriesClosedCessna 172H · West Plains, MONTSB MKC80DCA10Accident · No injuriesClosedCessna 172 · Festus, MONTSB MKC78DCA46Accident · No injuriesClosedCessna 172 · Taylor, MONTSB MKC78FCG28Accident · Minor injuriesClosedCessna 172G · Springfield, MONTSB MKC78FCG22Accident · No injuriesClosedMaule M-4 · Sedalia, MONTSB MKC78DCG14Accident · No injuriesClosedCessna 172H · Marshfield, MONTSB MKC77FCG25Accident · No injuriesClosedCessna 172 · Gravois, MONTSB MKC76FCA22Accident · Minor injuriesClosedCessna 172 · Shelbyville, MONTSB MKC7GFCA16Accident · No injuriesClosedCessna 172E · Poplar Bluff, MONTSB MKC74DCG44Accident · No injuriesClosedCessna 172 · Columbia, MONTSB MKC73FCA18Accident · Serious injuriesClosedCessna 172 · Cuba, MONTSB MKC73DCG31Accident · No injuriesClosedCessna 172D · Queen City, MONTSB MKC73FCA10Accident · No injuriesClosedCessna 172 · Fulton, MONTSB MKC73AK033Accident · No injuriesClosedCessna 172 · Chesterfield, MONTSB MKC72DCG58Accident · No injuriesClosedCessna 172 · Stover, MONTSB MKC71DCG75Accident · No injuriesClosedCessna 172 · Springfield, MONTSB MKC71FCA21Accident · No injuriesClosedCessna 170B · Wentzville, MONTSB MKC71DCG22Accident · No injuriesClosedCessna 172 · Carthage, MONTSB MKC70DCA18Accident · No injuriesClosedCessna 172E · Richwoods, MONTSB MKC70DCG27Accident · No injuriesClosedCessna 172H · Maryville, MONTSB MKC69F0348Accident · No injuriesClosedCessna 172 · Salem, MONTSB MKC69D0347Accident · No injuriesClosedCessna 172 · Independence, MONTSB MKC69F0284Accident · No injuriesClosedCessna 172 · Carrollton, MONTSB MKC69D0201Accident · No injuriesClosedCessna 172 · Springfield, MONTSB MKC69D0179Accident · No injuriesClosedCessna 172H · Tarkio, MONTSB MKC68D0597Accident · No injuriesClosedCessna 172 · Kansas City, MONTSB MKC69F0006Accident · Minor injuriesClosedCessna 172 · Memphis, MO