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.
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 ('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" 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 CHI90LA207Accident · No injuriesLimited investigationFinal reportAircoupe F-1 · Washington, MOFailure of the other aircraft's pilot to maintain an adequate visual lookout prior to turning to final. A factor in the accident was the restricted visual lookout for this aircraft's pilot.NTSB MIA90LA156Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Jensen Beach, FLFuel exhaustion due to improper planning by the pilot.NTSB CHI90LA179Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOInadequate visual outlook by the PIC.NTSB ANC90LA121Accident · No injuriesLimited investigationFinal reportCessna 150M · Goose Bay, AKA loss of engine power for undetermined reasons. The wet tundra was a contributing factor.NTSB CHI90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Moorhead, MNThe pilot's poor in-flight planning and fuel system monitoring, and his failure to maintain directional control during the subsequent forced landing.NTSB LAX90LA256Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Santa Catalina, CAThe engine failure due to carburetor ice and the pilots improper use of carburetor heat.NTSB SEA90LA128Accident · No injuriesLimited investigationFinal reportCessna 150C · Sutherlin, ORLoss of engine power was due to fuel exhaustion. Because of inadequate fuel consumption calculations and poor preflight planning and preparation for the flight.NTSB FTW90FA138Accident · 1 fatalField investigationFinal reportMingess-Bennett M30 · New Braunfels, TXFailure of the pilot in the overtaking aircraft (N97RJ) to see-and-avoid the aircraft that had been leading (N911HG). Factors related to the accident were: the lack of ability for the pilot in the lead aircraft (911HG) to be able see other aircraft in the…NTSB NYC90LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Montour Falls, NYThe pilot in command's decision to attempt takeoff at night from an inimproved field which resulted in collision with a vehicle.NTSB CHI90LA167Accident · No injuriesLimited investigationFinal reportCessna 150G · Manchester, MILoss of engine power due to a stuck exhaust valve.NTSB MIA90LA147Accident · No injuriesLimited investigationFinal reportCessna 150F · Pensacola, FLInstructor pilots failure to assure that the flaps were in the proper position for takeoff resulting in reduced climb performance. This resulted in the forced landing, during which, the airplane collided with a power line, stalled, then crashed to the ground.NTSB DEN90LA142Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Durango, COA pilot induced stall. A factor was the pilot's lack of experience.NTSB DEN90LA143Accident · No injuriesLimited investigationFinal reportCessna 150 · Bountiful, UTPower loss due to fuel exhaustion. A factor was the pilot's failure to refuel.NTSB ATL90LA137Accident · No injuriesLimited investigationFinal reportCessna 150L · Blountville, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.NTSB MIA90LA143Accident · No injuriesLimited investigationFinal reportCessna 150M · Rockledge, FLThe pilots failure to raise the flaps as required during the go-around and failure to place the carburetor heat in the cold position.NTSB BFO90LA059Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesapeake, VAThe failure of both pilots (CFI and student pilot) to maintain adequate control of the aircraft during the landing flare and touchdown phase of flight. The student pilot's inexperience was a factor, as was the cfi's inadequate supervision during the dual…NTSB BFO90LA058Accident · No injuriesLimited investigationFinal reportCessna 150 · Alderson, WVThe pilot's failure to maintain adequate airspeed, causing the aircraft to stall. Low altitude and inattention were related factors.NTSB ATL90LA130Accident · No injuriesLimited investigationFinal reportCessna 150 · Kinston, NCFlight crew's failure to properly preflight and plan for the intended flight by not ensuring that adequate fuel was on board prior to takeoff. The engine quit due to fuel exhaustion.NTSB ATL90LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greenwood, SCThe pilot's failure to maintain flying speed during the flare phase of the approach/landing. Contributing to the accident was a sudden increase in winds.NTSB SEA90LA094Accident · No injuriesLimited investigationFinal reportCessna A150M · Seattle, WAThe fuel starvation caused by carburetor contaminants blocking the accelerator pump inlet check valve assembly and main nozzle assembly.NTSB CHI90LA135Accident · No injuriesLimited investigationFinal reportCessna 150F · White Cloud, MIFailure of the pilot to maintain control of the airplane during a landing flare and touchdown. The pilot's lack of total aviation experience is a factor in the accident.NTSB ANC90LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe flight instructor's failure to use carburetor heat during a simulated engine failure. The rough terrain and weather conditions conducive to carburetor icing were contributing factors.NTSB MIA90LA124Accident · No injuriesLimited investigationFinal reportCessna 150G · Marianna, FLThe pilot's delay in the application of carburetor heat. The carburetor icing condition was a related factor.NTSB LAX90LA192Accident · No injuriesLimited investigationFinal reportCessna 150F · Franklin, CAThe fixed base operator mechanic used improper bolt/nut during repair of the elevator system.NTSB LAX90LA182Accident · 2 fatalLimited investigationFinal reportCessna 150H · Goleta, CAThe pilot's failure to maintain control of the airplane. Factors which contributed to the accident were the dark night and the pilot's lack of night flying experience.NTSB ANC90LA089Accident · No injuriesLimited investigationFinal reportCessna C-150M · Chakachamna, AKPilot-in-command's failure to properly survey the landing area and ensure the appropriate width for his airplane.NTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.NTSB NYC90LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Tinton Falls, NJThe failure of the student pilot to ensure there was sufficient fuel on board for the planned flight. A factor related to the accident was the failure of the flight instructor to properly prepare his student for the flight.NTSB NYC90LA093Accident · No injuriesLimited investigationFinal reportCessna C-150 · Turbotville, PAThe pilot to maintain sufficent flying speed for takeoff when strong winds were encountered.NTSB MKC90LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Allport, ARImproper use of carburetor heat by the pilot. Contributing factors were carburetor icing conditions, power lines and visual outlook inadequate by the pilot.NTSB BFO90LA038Accident · No injuriesLimited investigationFinal reportCessna 150G · Clinton, MDPilot factor in that he improperly used the engine controls.NTSB MKC90LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Salina, KSFuel exhaustion, fuel calculations misjudged and refueling not performed by the pilot in command.NTSB MKC90LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Two Harbors, MNPilot factor in that he failed to maintain flying speed.NTSB CHI90LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Franklin, WIInadequate compensation for wind conditions by the pilot, and his failure to maintain runway alignment during the attempted go-around (aborted landing). The wind conditions and soft terrain were related factors.NTSB MIA90LA097Accident · No injuriesLimited investigationFinal reportCessna 150L · Vieques, PRFailure of packing around the carburetor accelerator pump, which had jammed throttle movement and would not allow an increase in engine RPM above idle.NTSB ANC90FA046Accident · No injuriesField investigationFinal reportCessna 150 · Birchwood, AKCarburetor ice due to the pilot's improper use of the carburetor heat. Factors related to the accident were: carburetor icing conditions, unfavorable wind, and the snow covered terrain.NTSB MKC90LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Ankeny, IAFuel contamination and inadequate aircraft preflight by the pilot in command.NTSB MKC90LA072Accident · No injuriesLimited investigationFinal reportCessna 150 · Concordia, MOInadequate pre-flight planning and preparation, misjudged fuel consumption calculations and re-fueling not performed by the pilot in command.NTSB CHI90LA100Accident · No injuriesLimited investigationFinal reportCessna 150B · Shelbyville, INThe private pilot's failure to maintain directional control of the aircraft during the landing. The crosswind was a related factor.NTSB ATL90LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, NCThe pilot's delayed pull up from an intentional descent during an aborted suicide attempt.NTSB SEA90LA051Accident · No injuriesLimited investigationFinal reportCessna 150J · Graham, WALoss of engine power due to fuel exhaustion and inadequate remedial action after bouncing/ballooning during the forced landing. The pilot's inadequate preflight planning/preparation was a factor related to the accident.NTSB LAX90FA112Accident · 1 fatalField investigationFinal reportCessna 150J · Pine Valley, CAThe decision of the pilot to continue VFR flight into instrument meteorological conditions, spatial disorientation and inadvertent stall/spin. Factors were: obscuration, low ceiling, and over-confidence in ability.NTSB SEA90LA049Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Valmy, NVThe pilots poor inflight planning and decision to land on an abandoned highway in strong gusty crosswind conditions, his improper remedial action of turning downwind at a low altitude after aborting the landing and his failure to maintain airspeed. Factors in…NTSB ATL90LA067Accident · No injuriesLimited investigationFinal reportCessna 150M · Leitchfield, KYThe pilot's inadequate preflight, in that he did not assure that both fuel tank filler caps were secure prior to flight.NTSB ATL90LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Roxboro, NCThe pilot's failure to use the before landing checklist which requires the application of carburetor heat. Factors were soft terrain at accident site, and condition favorable for the formation of carburetor ice.NTSB CHI90LA083Accident · No injuriesLimited investigationFinal reportCessna 150H · Plainwell, MIForeign object (ice), which jammed the right wheel. A factor related to the accident was: the snowbank.NTSB BFO90LA029Accident · No injuriesLimited investigationFinal reportCessna 150M · Leesburg, VAThe pilot's failure to assure an adequate supply of fuel was onboard to complete the flight.NTSB MKC90LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palestine, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB LAX90LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Bullhead City, AZThe pilot's miscalculation of the fuel remaining, which caused the engine to quit.NTSB MKC90LA052Accident · No injuriesLimited investigationFinal reportCessna 150 · Clear Lake, MNFailure of the pilot to maintain proper alignment with the runway, his delay in initiating a go-around, and his premature raising of the flaps. Factors related to the accident were the adverse wind conditions and the tree.