NTSB investigations: Continental 0-300 series
3,125 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, newest first
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.\"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."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 BFO92LA121Accident · No injuriesLimited investigationFinal reportCessna 172H · New Braintree, MAWater contaminated fuel which resulted in the loss of engine power and the pilot's inadequate preflight inspection.NTSB NYC92LA182Accident · No injuriesLimited investigationFinal reportCessna 172H · New Cumberland, WVThe pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…NTSB DEN92LA087Accident · No injuriesLimited investigationFinal reportCessna 172F · Folsom, NMCarburetor heat not used and improper use of throttle and mixture control. A factor was: the lack of suitable terrain for a forced landing.NTSB FTW92LA216Accident · No injuriesLimited investigationFinal reportCessna 172C · Weatherford, TXFuel starvation as result of a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.NTSB FTW92LA192Accident · No injuriesLimited investigationFinal reportCessna 172 · Vernon, TXAircraft control not maintained by pilot. A factor was unfavorable wind.NTSB CHI92LA212Accident · No injuriesLimited investigationFinal reportCessna 172H · Chenoa, ILInadequate preflight planning and preparation on the part of the pilot. Factors associated with this accident were a lack of recent experience in the type of operation the pilot was undertaking, a proper climb rate not obtained by the pilot and remedial…NTSB ATL92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fairhope, ALThe pilot's failure to maintain flying speed during final approach which resulted in a stall and an uncontrolled collision with the ground short of the runway.NTSB LAX92LA311Accident · No injuriesLimited investigationFinal reportCessna 172 · Elko, NVThe pilot's failure to maintain adequate altitude over the terrain, and his failure to maintain sufficient airspeed. The mountainous terrain was a factor.NTSB SEA92LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAThe improper recovery from a bounced landing and the improper use of brakes by the CFI. A factor relating to the accident was the failure of the dual student to touchdown properly.NTSB LAX92LA286Accident · No injuriesLimited investigationFinal reportCessna 172G · Tonopah, NVThe failure of the pilot to adequately identify and compensate for the existing tailwind conditions, and, his failure to initiate a go around when he became aware of being high with a fast ground speed.NTSB ATL92LA134Accident · No injuriesLimited investigationFinal reportCessna 172H · Huntsville, ALThe pilot's inadequate compensation for the wind conditions at the airstrip, and the excessive airspeed on final approach. A factor was the prevailing tailwind at the airstrip.NTSB LAX92LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Blythe, CAThe improper engine overhaul performed by the mechanic. Factors relating to this accident were the intake and exhaust valve leaks and the soft terrain.NTSB LAX92LA248Accident · No injuriesLimited investigationFinal reportCessna 172L · Safford, AZThe airplane colliding with animals which ran on to the runway during the pilot's takeoff roll. A factor in this accident was the pilot not being able to take remedial action and avoid the animals.NTSB ATL92FA108Accident · 3 fatalField investigationFinal reportCessna 172B · Cherokee, NCThe failure of the pilot to maintain control of the aircraft as a result of spatial disorientation. The lack of total flight time, and rain in the accident area were factors in the accident.NTSB ANC92LA066Accident · No injuriesLimited investigationFinal reportCessna C-170B · Talkeetna, AKLoss of control on landing roll due to the pilot's failure to maintain proper alignment, resulting in collision with terrain during an uncontrolled ground loop/swerve. A factor relating to the accident was the crosswind weather conditions.NTSB ATL92LA092Accident · No injuriesLimited investigationFinal reportCessna 172E · Concord, NCThe loss of engine power because of the formation of carburetor ice.NTSB CHI92FA119Accident · 1 fatalField investigationFinal reportCessna 172H · Browntown, WISpatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…NTSB SEA92LA059Accident · No injuriesLimited investigationFinal reportCessna 172G · Billings, MTThe pilot's failure to maintain directional control. A factor was the crosswind.NTSB FTW92LA082Accident · No injuriesLimited investigationFinal reportCessna 172B · Golden, TXFuel exhaustion due to the pilot's failure to refuel. Factors were false fuel sensor indications and a fence.NTSB LAX92AMS03Accident · 2 fatalFinal reportCessna 172D · Pacific Ocean (Pacific Ocean)The failure of the pilot to adequately evaluate the weather conditions, and continued VFR flight into IMC conditions which resulted in the pilot becoming lost and disoriented. Contributing to the accident was the lack of total aeronautical experience and fuel…NTSB DEN92LA032Accident · No injuriesLimited investigationFinal reportCessna 172 · Delta, COA complete power loss for undetermined reasons. A factor in the accident was: unsuitable terrain on which to conduct an emergency landing.NTSB ATL92LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Millen, GAThe pilot's failure to properly use carburetor heat during icing conditions which resulted in the formation of carburetor ice and subsequent loss of engine power.NTSB LAX92LA084Accident · No injuriesLimited investigationFinal reportCessna 172H · Arcata, CACarburetor icing and the failure of the pilot to use carburetor heat.NTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.NTSB FTW92LA038Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKClearance was not maintained and the airplane struck a wire. A factor was the aircraft had been stolen by two unknown individuals.NTSB ANC92LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Moose Pass, AKThe pilot's premature lift-off, causing the airplane to settle back to the ground. Contributing to the accident was the pilot's loss of directional control after settling back on the runway, due to his visibility being restricted by frost on the windshield.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 SEA92FA002Accident · 4 fatalField investigationFinal reportCessna 172G · Miltonfreewater, ORInadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.NTSB MIA91LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Palm Beach, FLTotal loss of engine power due to fuel exhaustion, and failure of the pilot to refuel before departure. Contributing to the accident was the pilot's lack of total experience in becoming lost/disoriented, and operation with known deficiencies in equipment.NTSB SEA91FA246Accident · Serious injuriesField investigationFinal reportCessna C-172G · Red Lodge, MTThe loss of control by the instructor due to the improper recovery altitude selected to terminate a simulated forced landing, the excessive pull-up by the student due to his lack of experience, and the delayed remedial action of the instructor. Factors…NTSB ATL91LA175Accident · No injuriesLimited investigationFinal reportCessna 172K · Greeneville, TNThe inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.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.NTSB SEA91LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Heber City, UTThe pilot's failure to maintain directional control during landing ground roll. A factor relating to the accident was the crosswind weather conditions.NTSB ANC91LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague Island, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor was the unsuitable terrain selected for landing by the pilot, which was loose gravel, rough and uneven.NTSB LAX91LA361Accident · No injuriesLimited investigationFinal reportCessna 172G · Hilo, HIFuel exhaustion due to the installation of a non standard propeller for which no performance charts were available.NTSB CHI91LA230Accident · No injuriesLimited investigationFinal reportCessna 172 · Metropolis, ILMiscellaneous equipment not removed (foam rubber) and inadequate preflight by the pilot.NTSB LAX91LA345Accident · No injuriesLimited investigationFinal reportCessna 172N · Lake Elsinore, CAThe pilot's poor judgement for unwarranted low flying and poor visual lookout.NTSB BFO91LA071Accident · No injuriesLimited investigationFinal reportCessna 172G · Fredericksburg, VAThe pilot's selection of the improper fuel tank. Contributing to the accident was the pilot did not use the check list.NTSB CHI91LA243Accident · No injuriesLimited investigationFinal reportCessna 172 · Oberlin, KSThe student pilot's failure to maintain directional control during landing. Factors in the accident were the pilot's discontinuing his crosswind compensation and his lack of experience in the type of operation.NTSB CHI91LA178Accident · No injuriesLimited investigationFinal reportCessna 172E · Grundy Center, IAFailure by other maintenance personnel to install a safety wire and fuel exhaustion.NTSB CHI91LA143Accident · No injuriesLimited investigationFinal reportCessna 170A · Newell, SDThe pilot's improper aircraft handling.NTSB BFO91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Morehead, KYThe pilot's operation of his aircraft in exceedingly high wind conditions.NTSB SEA91LA080Accident · No injuriesLimited investigationFinal reportCessna 172A · Hood River, ORAn inadequately planned approach which resulted in a hard landing. Factors to the accident were rough water landing conditions, poor supervision by the CFI, and the overload condition to the float assembly.NTSB LAX91LA119Accident · No injuriesLimited investigationFinal reportCessna 172G · Reno, NVThe pilot's improper planning/preparation decision. Factors related to the accident were the high wind condition and the pilot in commands inability to compensate for the wind condition.NTSB LAX91FA103Accident · Serious injuriesField investigationFinal reportCessna 172 · Bullhead City, CAThe pilot's poor in-flight planning and decision and physical impairment from fatigue; he also failed to maintain flying speed. The lineman's failure to secure the access door and the pilot's impairment due to consumption of alcohol were factors in the…NTSB ANC91FA019Accident · No injuriesField investigationFinal reportCessna 172G · Wasilla, AKPilot's not removing the frost from the airplane before attempting to takeoff. Contributing to the accident was the pilot's delayed abort, and the berm.NTSB SEA91LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Brigham City, UTThe pilot did not maintain a proper climb rate.NTSB DEN91LA011Accident · No injuriesLimited investigationFinal reportCessna 172H · Buena Vista, COThe failure of the pilot to flare properly during landing. The pilot's total lack of experience is a factor.NTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.