Skip to content

NTSB investigations: Continental 0-200 series

6,416 cases on aircraft whose registry engine model is Continental 0-200 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, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020'))
  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 ('17020'))
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 MIA97LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Homerville, GAcarburetor ice, due to the pilot's improper use of carburetor heat, which resulted in a forced landing and impact with trees.Dec 3, 1996 · N6532S · Substantial damage NTSB ANC97LA007Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKfailure of the pilot to maintain adequate distance from an airport sign, while taxiing on an unfamiliar airport.Nov 25, 1996 · N63414 · Substantial damage NTSB CHI97LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MOthe pilot's failure to maintain an adequate visual lookout.Nov 22, 1996 · N704DR · Substantial damage NTSB FTW97LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Tulsa, OKFuel exhaustion due the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Nov 10, 1996 · N8960U · Substantial damage NTSB CHI97LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, KSthe pilot's selection of unsuitable terrain on which to land the airplane. A factor relating with the accident was: the large rock, which the airplane contacted.Nov 2, 1996 · N3008J · Substantial damage NTSB NYC97LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Hilton, NYthe pilot's improper soft field landing technique, which allowed a nose over during the landing rollout. Soft terrain was a related factor.Oct 26, 1996 · N5535R · Substantial damage NTSB IAD97LA002Accident · No injuriesLimited investigationFinal reportCessna 150H · Sunbury, PAfailure of the cluster gear attaching bolts (of which one failed from fatigue), resulting in a disconnect of the gear and loss of engine power. An obstruction (rock) in the emergency landing area was a related factor.Oct 5, 1996 · N6741S · Substantial damage NTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.Sep 23, 1996 · N1947Z · Destroyed NTSB ANC96LA151Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe loss of engine power for an undetermined reason. Factors associated with the accident are the soft terrain and brush in the airstrip overrun area.Sep 9, 1996 · N7909Z · Substantial damage NTSB FTW96LA376Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, COan improper flare by the student pilot, and his improper recovery from a bounced landing. A factor relating to the accident was: the student pilot's lack of experience in the type (model) of aircraft.Sep 5, 1996 · N704QR · Substantial damage NTSB FTW96LA363Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKthe student pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the student's lack of experience in this make and model of aircraft, darkness, and lack…Aug 29, 1996 · N9253U · Substantial damage NTSB CHI96LA304Accident · No injuriesLimited investigationFinal reportCessna 150M · Traverse City, MIthe failure of the pilot of the Cessna 180, N2406C, to maintaining proper spacing from the Cessna 150M, N9352U. A factor relating to this accident was the Cessna 180 pilot's diverted attention.Aug 17, 1996 · N9352U · 2 aircraft · Substantial damage NTSB FTW96LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Fort Collins, COimproper flare by the pilot, which resulted in a hard landing, and subsequent overload failure of the nosewheel axle and nose gear.Aug 16, 1996 · N6935S · Substantial damage NTSB SEA96LA208Accident · No injuriesLimited investigationFinal reportCessna 150M · Paterson, WAfailure of the student pilot to maintain directional control of the airplane during a landing, which resulted in an uncontrolled ground loop/swerve. Factors relating to the accident were: the gusty crosswind condition, and soft terrain beside the runway.Aug 15, 1996 · N3882V · Substantial damage NTSB CHI96LA297Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOthe improper recovery from a bounced landing by the pilot in command. Factors were the gusty wind conditions, and the failure of the pilot to maintain aircraft control.Aug 14, 1996 · N10645 · Substantial damage NTSB CHI96LA296Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.Aug 14, 1996 · N61094 · Substantial damage NTSB CHI96LA291Accident · No injuriesLimited investigationFinal reportCessna 150 · Plattsmouth, NEfailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.Aug 8, 1996 · N3510L · Substantial damage NTSB CHI96LA271Accident · No injuriesLimited investigationFinal reportCessna 150 · Wisconsin Rapid, WIfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel management.Aug 2, 1996 · N3238X · Substantial damage NTSB MIA96LA196Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCthe student pilot's improper recovery from a bounced landing by applying power and slight nose up elevator input.Jul 28, 1996 · N704WM · Substantial damage NTSB CHI96LA254Accident · No injuriesLimited investigationFinal reportCessna 150 · Dubuque, IAinadequate airspeed and the student pilot's failure to perform a recovery from the bounced landing. Factors associated with the accident were the crosswind and the student's over compensation for the crosswind.Jul 25, 1996 · N6106K · Substantial damage NTSB FTW96LA311Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Los Lunas, NMthe pilot's improper weather evaluation. Factors were the dust devil and the turbulence.Jul 19, 1996 · N150PC · Substantial damage NTSB CHI96LA244Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Versailles, MOthe student pilot's failure to maintain airplane control during a go-around.Jul 16, 1996 · N11303 · Substantial damage NTSB ATL96FA103Accident · 2 fatalField investigationFinal reportGeorge Evenson Cuby · Hawkinsville, GAThe failure of the pilot-in-command to maintain airspeed.Jul 9, 1996 · N1035W · Destroyed NTSB SEA96LA150Accident · No injuriesLimited investigationFinal reportCessna 150 · Puyallup, WAimproper flare by the pilot during a touch-and-go landing.Jul 8, 1996 · N8310J · Substantial damage NTSB LAX96LA266Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Chino, CAFuel starvation due to the pilot's failure to monitor and correctly configure the fuel system for landing prior to entering the traffic pattern, and the pilot's premature lowering of full flaps which led to the runway undershoot. A factor in the accident was…Jul 7, 1996 · N50814 · Substantial damage NTSB IAD96LA104Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Mitchellville, MDthe pilot's failure to maintain directional control of the aircraft during the landing roll. Related factors were the gusty crosswind conditions.Jul 4, 1996 · N2004A · Substantial damage NTSB MIA96LA160Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, FLfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a ground swerve and subsequent nose over.Jun 19, 1996 · N11532 · Substantial damage NTSB FTW96LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Levelland, TXThe student pilot's improper use of mixture control resulting in a loss of engine power. A factor was the unsuitable terrain for the forced landing.Jun 13, 1996 · N17299 · Substantial damage NTSB LAX96LA225Accident · No injuriesLimited investigationFinal reportCessna 150H · Angels Camp, CAThe attempt by the pilot to operate the aircraft with a float known to be leaking. A factor was the pilot's lack of experience in the operation of float equipped aircraft.Jun 12, 1996 · N22474 · Substantial damage NTSB LAX96LA220Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Placerville, CAthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear surrounding terrain. A factor was the pilot's intentional buzzing.Jun 12, 1996 · N7880F · Destroyed NTSB CHI96LA195Accident · No injuriesLimited investigationFinal reportCessna 150M · Red Wing, MNthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply. A factor relating to the accident was: soft terrain in the emergency landing area.Jun 9, 1996 · N9132U · Substantial damage NTSB NYC96LA120Accident · No injuriesLimited investigationFinal reportCessna 150L · Matawan, NJthe student pilot's improper flare and improper recovery from a bounced landing. The gusty wind condtion was a related factor.May 25, 1996 · N10439 · Substantial damage NTSB CHI96LA166Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgregor, MNthe nose gear collapsed when it hit a soft spot in the runway.May 18, 1996 · N3750V · Substantial damage NTSB FTW96LA209Accident · No injuriesLimited investigationFinal reportCessna 150M · Springdale, ARthe flight instructor's improper (unapproved) procedure of using the mixture control to simulate an engine failure. A factor relating to the accident was: the lack of suitable terrain for a forced landing.May 11, 1996 · N704RS · Substantial damage NTSB IAD96LA076Accident · 2 fatalLimited investigationFinal reportCessna 150 · Welch, WVthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear obstacles. A factor was his intentional buzzing.May 10, 1996 · N6303S · Destroyed NTSB SEA96LA082Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salt Lake City, UTthe student pilot's inadequate preflight planning/preparation, by failuring to properly calculate the fuel consumption of the airplane, which led to fuel exhaustion and loss of power during cruise flight, due to an inadequate supply of fuel. A factor relating…Apr 21, 1996 · N8873S · Substantial damage NTSB IAD96LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Clinton, MDa loss of engine power for undetermined reasons.Apr 19, 1996 · N6508S · Substantial damage NTSB LAX96LA173Accident · No injuriesLimited investigationFinal reportCessna 150K · Mojave, CAthe pilot's failure to clear the engine during an idle power descent, as required by the engine manual.Apr 17, 1996 · N6466G · Substantial damage NTSB ANC96LA047Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Wasilla, AKA loss of engine power for an undetermined reason.Apr 14, 1996 · N50529 · Destroyed NTSB SEA96LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTthe pilot's excessive use of brakes during the landing rollout.Apr 13, 1996 · N8093F · Substantial damage NTSB SEA96LA080Accident · No injuriesLimited investigationFinal reportCessna 150 · Spiden Island, WAthe pilot's selection of an unsuitable airstrip for the landing and subsequent takeoff, and his delay in aborting the takeoff, which resulted in an overrun and collision with an embankment and trees. Factors relating to the accident were: the short, wet,…Apr 13, 1996 · N171RJ · Substantial damage NTSB IAD96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Akron, OHa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Apr 12, 1996 · N16188 · Substantial damage NTSB CHI96LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sikeston, MOThe pilot's delay in applying carburetor heat, which resulted in carburetor icing and subsequent loss of engine power. Factors relating to the accident were: carburetor icing (weather) conditions, and the pilot's lack of recent experience in the make and…Apr 9, 1996 · N6689G · Substantial damage NTSB LAX96LA151Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sacramento, CAA loss of engine power due to carburetor ice and the student's failure to use carburetor heat. The carburetor icing (weather) condition was a related factor.Mar 31, 1996 · N5266Q · Substantial damage NTSB MIA96LA104Accident · No injuriesLimited investigationFinal reportCessna 150F · Ocala, FLthe student pilot's inadequate compensation for the wind during the landing flare.Mar 24, 1996 · N6679F · Substantial damage NTSB SEA96LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Eugene, ORthe student pilot's inadvertent activation of the brakes and his failure to maintain directional control, which resulted in an inadvertent ground swerve.Mar 9, 1996 · N8920S · Substantial damage NTSB MIA96LA097Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe failure of the pilot-in-command to apply caburetor heat before reducing the throttle to simulate an engine failure. Contributing to the accident was the carburetor icing conditions and the unsuitable terrain encountered during the emergency descent.Mar 9, 1996 · N704XQ · Substantial damage NTSB ANC96LA031Accident · No injuriesLimited investigationFinal reportCessna 150H · Anchorage, AKloss of engine power for an undetermined reason.Mar 3, 1996 · N22053 · Substantial damage NTSB FTW96LA142Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Jasper, TXFailure of the pilot to ensure that the other person (outside the airplane) remained clear of the operating propeller, and failure of the other person to maintain awareness of the hazardous condition. A factor relating to the accident was: the other person…Mar 2, 1996 · N8642S · Minor damage NTSB NYC96LA066Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Linden, NJthe pilot's inadequate preflight and failure to follow the checklist to ensure that the fuel selector valve was in the ON position, which resulted in fuel starvation and subsequent loss of engine power. In addition, the pilot failed to maintain airspeed…Feb 26, 1996 · N6964S · Substantial damage