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 ANC96LA090Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing and the failure to maintain directional control of the airplane. A factor in the accident was an airstrip that was rough and uneven.NTSB FTW96LA207Accident · Minor injuriesLimited investigationFinal reportBowers Midget Mustang M-1 · Mesquite, TXThe pilot's failure to maintain aircraft control following the separation of the propeller spinner installed by the pilot. A factor was the pilot's failure to obtain the required FAA inspection for the installation.NTSB LAX96LA209Accident · No injuriesLimited investigationFinal reportCessna 172 · Marana, AZthe pilot's improper flare and improper recovery from a bounced landing.NTSB ANC96LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Fairbanks, AKThe student pilot's premature flare and the flight instructor's failure to perform remedial action prior to the hard landing.NTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…NTSB LAX96LA143Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Upland, CAfuel system contamination and the pilot's intentional operation of a known unairworthy aircraft.NTSB CHI96LA106Accident · No injuriesLimited investigationFinal reportCessna 172E · Tofte, MNthe pilot's failure to perform adequate preflight planning which resulted in landing at a closed airport. The snow covered runway was a factor.NTSB CHI96LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Camp Lake, WIFailure of the pilot to maintain clearance from trees that were located beside the runway.NTSB ATL96LA060Accident · No injuriesLimited investigationFinal reportCessna 172D · Macon, GAThe pilot's improper planning/decision, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB MIA96FA089Accident · 2 fatalField investigationFinal reportCessna 172D · Hawthorne, FLthe pilot's failure to maintain the proper glidepath during an instrument approach.NTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA056Accident · Minor injuriesLimited investigationFinal reportMaule M-4 · Hot Springs, SDan unauthorized modification of the air induction system by the pilot.NTSB LAX96LA069Accident · No injuriesLimited investigationFinal reportCessna 172 · Ocotillo Wells, CAthe failure of the pilot to maintain a proper glide path on final approach.NTSB ANC96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kasilof, AKThe pilot's inadvertent liftoff, and an inoperative elevator that became jammed due to frozen slush/snow.NTSB LAX96LA026Accident · No injuriesLimited investigationFinal reportCessna 172H · Borrego Springs, CAthe pilot's inadequate preflight inspection which failed to detect a bird's nest in the air induction system. Factors in the accident were carburetor icing conditions and the pilot's improper use of carburetor heat.NTSB NYC96LA009Accident · No injuriesLimited investigationFinal reportCessna 172G · Wilkes-Barre, PAthe instructor's inadequate supervision of the flight. Contributing factors were the instructor's inexperience and the student pilot's failure to maintain aircraft control.NTSB ATL95LA166Accident · No injuriesLimited investigationFinal reportCessna 170 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll and failure to take appropriate remedial action. A factor was trees.NTSB FTW95LA391Accident · No injuriesLimited investigationFinal reportCessna 172D · Prim, ARThe loss of engine power for undetermined reasons. Factors were the pilot's inability to initiate a flare due to the fracture of the yoke assembly, and the lack of suitable terrain for the forced landing.NTSB FTW95LA352Accident · No injuriesLimited investigationFinal reportCessna 172E · Alpine, TXThe failure of the pilots of both airplanes to see and avoid each other. A factor was the Cessna's inoperative radio.NTSB CHI95LA281Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILinadequate preflight planning and preparation by the pilot and an inadverent stall encountered by the pilot.NTSB ATL95LA157Accident · No injuriesLimited investigationFinal reportCessna 172H · Manteo, NCThe pilot's improper in-flight decision to touchdown at the mid-field point of the runway.NTSB SEA95LA169Accident · No injuriesLimited investigationFinal reportCessna 172C · Red Lodge, MTThe pilot's failure to maintain airspeed. The pilot's inadequate preflight planning/preparation and selection of unsuitable terrain for landing were factors.NTSB ANC95LA124Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Chickaloon, AKThe pilot's inadvertent encounter with adverse weather conditions and failure to maintain sufficient altitude/clearance from the terrain to compensate for such conditions. Factors related to the accident were: downdrafts, the proximity of mountainous terrain,…NTSB ANC95LA118Accident · Minor injuriesLimited investigationFinal reportCessna 172B · North Pole, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, when there was an inadequate supply of fuel to reach the destination.NTSB CHI95LA248Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Niles, MIThe pilot's failure to ensure an adequate supply of fuel was aboard the aircraft during preflight planning and his failure to lean the engine mixture during cruise flight.NTSB ATL95LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Stanton, TNThe pilot's failure to properly plan enough fuel for the intended flight which resulted in fuel exhaustion. Factors related to the accident were: the pilot became lost/disorientated, and high vegetation in the emergency landing area.NTSB ANC95FA104Accident · 2 fatalField investigationFinal reportCessna 172A · Naknek, AKInadequate visual lookout by the pilot of the Piper PA-18. The PA-18 pilot's diverted attention was a related factor.NTSB CHI95LA220Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Cedar Rapids, IAthe pilot's lack of experience in flying from the right seat. A factor was the steep final approach.NTSB LAX95LA221Accident · No injuriesLimited investigationFinal reportCessna 172 · Yerington, NVThe pilot's improper in-flight decision to enter mountainous terrain at an insufficient altitude to safely escape adverse weather conditions. Factors relating to the accident were: the terrain and weather conditions.NTSB SEA95LA107Accident · No injuriesLimited investigationFinal reportCessna 172B · Sinclair Island, WAThe pilot's failure to attain the proper touchdown point. Contributing to the accident were a tailwind, wet grass, and the pilot's inadequate remedial action.NTSB MIA95LA130Accident · No injuriesLimited investigationFinal reportCessna 172G · Sanford, FLThe pilot's failure to maintain airspeed during a forced landing resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was a total loss of engine power while descending due to fuel exhaustion, and the…NTSB BFO95FA050Accident · 1 fatalField investigationFinal reportCessna 172F · Tappahanock, VAThe student pilot's misjudgment of distance/speed during the approach to land, and her failure to go around while there was still sufficient runway remaining. Factors related to the accident were: inadequate supervision by the flight instructor, the student's…NTSB ANC95LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Chickaloon, AKThe fracture of the crankshaft resulting in separation of the propeller and propeller flange in-flight. A factor associated with the accident was the lack of suitable terrain for an emergency landing.NTSB LAX95LA181Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Colusa, CAthe pilot's selection of an inadequate en route cruise altitude for the aerial observation flight, and his failure to identify and stop an inadvertent descent while flying over flooded terrain at a very low altitude. Lack of pilot experience in low level…NTSB SEA95LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Twisp, WAThe improper installation of a nose landing gear assembly bolt (no cotter key installed) by unknown maintenance personnel. This led to a failure of the nose landing gear steering and subsequent noseover during landing rollout.NTSB FTW95FA349Accident · 4 fatalField investigationFinal reportCessna 172D · Tsaile, AZThe pilot's failure to maintain terrain clearance. Factors were the pilot's lack of mountain flying experience and the rising terrain.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.NTSB MIA95LA106Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Lauderdale, FLThe inadequate preflight planning by the pilot-in-command to assure that adequate fuel was on-board the airplane to complete the flight, which resulted in a loss of engine power, forced landing and the collision with a tree on touchdown.NTSB BFO95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Allentown, PAthe pilot's inadequate compensation for wind conditions. Related factors were the gusty wind conditions and the pilot's poor weather evaluation.NTSB SEA95LA071Accident · No injuriesLimited investigationFinal reportCessna 172D · Lake Oswego, ORThe pilot's improper touchdown on the surface of the water.NTSB CHI95LA103Accident · No injuriesLimited investigationFinal reportCessna 172H · Atkinson, NEThe pilot's failure to adequately compensate for the gusty crosswind. The wind was a factor.NTSB LAX95LA101Accident · 1 fatalLimited investigationFinal reportCessna 172G · Pope Valley, CAthe pilot's poor judgment to buzz the lake and his inadequate visual lookout.NTSB FTW95LA104Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mountain View, ARThe pilot's selection of a downwind runway for takeoff, his failure to use all available runway, and delay in aborting the takeoff. A factor was the tailwind.NTSB ANC95LA024Accident · No injuriesLimited investigationFinal reportCessna 172 · Unalakleet, AKThe pilot's inadequate compensation for a crosswind condition. A crosswind was a factor in the accident.NTSB CHI95LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Allegan, MIthe student pilot's failure to maintain directional control which resulted in the inability to obtain proper runway alignment. Related factors are the student pilot's lack of total flight experience and the snowbank.NTSB ATL95LA029Accident · No injuriesLimited investigationFinal reportCessna 172F · Carrollton, GAThe pilot's inadvertent collision with trees, adjacent to the taxiway, while attempting to avoid a deer that crossed the taxiway.NTSB FTW95LA062Accident · No injuriesLimited investigationFinal reportCessna 172B · Seguin, TXThe pilot's failure to attain proper touchdown point.NTSB MIA95LA032Accident · 1 fatalLimited investigationFinal reportCessna 172D · Miami, FLThe passenger committed suicide.NTSB SEA95LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · Lewiston, IDFuel exhaustion due to the pilot's failure to refuel en route. Factors include the embankment on the side of the road on which he made his forced landing.NTSB CHI95LA023Accident · No injuriesLimited investigationFinal reportCessna 172F · Cross Plains, WIthe pilot's failure to use carburetor heat. Factors were carburetor icing conditions and rough/uneven terrain.