NTSB investigations: Continental 0-200 series, 2010

38 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 per year

19642026
NTSB investigations: Continental 0-200 series, 2010 per year, 1964–2026: 6,416 cases
196496
1965172
1966317
1967365
1968305
1969299
1970273
1971265
1972216
1973191
1974222
1975212
1976214
1977232
1978209
1979171
1980123
1981118
1982104
1983100
1984101
198584
198676
198794
198879
198971
199098
199167
199275
199382
199471
199556
199662
199770
199852
199976
200063
200168
200247
200355
200450
200553
200644
200756
200835
200938
201038
201138
201238
201323
201419
201536
201631
201723
201829
201925
202021
202134
202229
202330
202429
202527
202619

Latest 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 year(c.\"eventDate\") = 2010
    AND 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.

NTSB WPR11FA046Accident · 1 fatalField investigationFinal reportCessna 150J · Tucson, AZThe pilot's inability to maintain airplane control while on final approach due to undiagnosed cardiac disease, which caused a medical emergency and subsequent pilot incapacitation.Nov 14, 2010 · N60858 · Substantial damageNTSB CEN11CA056Accident · Minor injuriesData collectionFinal reportCessna 150H · Kenmare, NDThe pilot's inadequate landing flare and recovery from a bounced landing.Nov 4, 2010 · N23099 · Substantial damageNTSB ANC10LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · North Pole, AKThe overstress separation of the left nose wheel steering linkage rod end during the takeoff roll, which resulted in a loss of control.Oct 1, 2010 · N3569L · Substantial damageNTSB ERA10FA503Accident · 1 fatalField investigationFinal reportCessna 150F · Sweetwater, TNThe pilot's inadequate preflight weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Sep 26, 2010 · N7915F · Substantial damageNTSB ANC10CA089Accident · No injuriesData collectionFinal reportCessna 150M · Bethel, AKThe pilot's failure to maintain altitude/clearance during a night approach, resulting in a collision with terrain short of the runway.Sep 14, 2010 · N45624 · Substantial damageNTSB ANC10CA090Accident · No injuriesData collectionFinal reportCessna 150L · Kenai, AKThe pilot's decision to takeoff from a remote lake after overloading the airplane. Contributing to the accident was the pilot's lack of a seaplane rating.Sep 12, 2010 · N1612Q · Substantial damageNTSB ERA10LA475Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Fayetteville, WVA loss of engine power due to the failure of the left magneto system’s distributor gear as a result of the improper maintenance of the magnetos by maintenance personnel.Sep 10, 2010 · N7922E · Substantial damageNTSB ERA10FA464Accident · 2 fatalField investigationFinal reportCessna 150H · DeLand, FLThe pilot's failure to maintain adequate airspeed and airplane control during the initial climb, which resulted in an aerodynamic stall, wire strike, and subsequent impact with the ground.Sep 4, 2010 · N23471 · Substantial damageNTSB WPR10CA453Accident · No injuriesData collectionFinal reportCessna 150C · Fields, ORThe pilot's misjudged landing flare, resulting in a bounced landing and loss of directional control. Contributing to the accident was the pilot's inaccurate perception of the airplane’s proximity to the ground as a result of the featureless white landing area.Sep 3, 2010 · N2068Z · Substantial damageNTSB CEN10LA514Accident · 1 fatalLimited investigationFinal reportCessna 150L · Boone, IAThe pilot’s failure to maintain airplane control while performing low-level banner towing operations with a gusting wind.Sep 2, 2010 · N10128 · Substantial damageNTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.Aug 24, 2010 · N5101L · 2 aircraft · Substantial damageNTSB CEN10CA500Accident · Minor injuriesData collectionFinal reportCessna 150K · Gaylord, MIA loss of engine power for undetermined reasons.Aug 24, 2010 · N6032G · Substantial damageNTSB ERA10CA420Accident · Minor injuriesData collectionFinal reportCessna 150A · West Liberty, KYThe pilot's premature turn toward trees during the initial climb. Contributing to the accident was the airplane's high gross weight and density altitude that precluded a normal takeoff and climb.Aug 14, 2010 · N7023X · Substantial damageNTSB ERA10LA400Accident · No injuriesLimited investigationFinal reportDayton JD-2 · Hollywood, MDThe pilot's improper installation of the propeller hub to the engine crankshaft, which resulted in a loss of engine thrust.Aug 5, 2010 · N43015 · Substantial damageNTSB ERA10CA372Accident · No injuriesData collectionFinal reportCessna 150M · Knoxville, TNThe student pilot's improper recovery from a bounced landing.Jul 22, 2010 · N45220 · Substantial damageNTSB WPR10LA341Accident · Serious injuriesLimited investigationFinal reportRonald V White CH701 · Pima, AZA total loss of engine power while maneuvering due to a spark plug failure.Jul 10, 2010 · N3784A · Substantial damageNTSB WPR10FA326Accident · 1 fatalField investigationFinal reportCessna 150 · Keller, WAThe student pilot’s failure to maintain clearance from obstacles during the initial climb.Jul 6, 2010 · N1053M · Substantial damageNTSB WPR10CA337Accident · Minor injuriesData collectionFinal reportCessna 150M · Neola, UTA partial loss of engine power for undetermined reasons and the pilot's failure to maintain clearance from a power line.Jul 3, 2010 · N3143V · Substantial damageNTSB ERA10CA324Accident · No injuriesData collectionFinal reportCessna 150G · Jasper, TNThe pilot under instruction's failure to maintain directional control during landing, and his failure to relinquish the flight controls when directed.Jun 21, 2010 · N8321J · Substantial damageNTSB CEN10CA327Accident · Minor injuriesData collectionFinal reportRose-Rhinehart A4-C · Longmont, COA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel valve, resulting a loss of engine power after takeoff. Contributing to the accident was the pilot's overall lack of experience in the airplane make/model.Jun 19, 2010 · N14884 · Substantial damageNTSB ERA10LA351Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Thomasville, GAThe improper reinstallation of the airplane’s oleo piston assembly during an annual inspection, resulting in the collapse of the right main landing gear during touchdown.Jun 17, 2010 · N73PC · Substantial damageNTSB ERA10LA298Accident · No injuriesLimited investigationFinal reportCessna 150M · Pahokee, FLA partial loss of power during takeoff for undetermined reasons.Jun 5, 2010 · N2990V · Substantial damageNTSB CEN10CA286Accident · Minor injuriesData collectionFinal reportCessna 150M · Glasco, KSThe pilot’s delay in applying full power to arrest a sink rate at low altitude.May 31, 2010 · N9388U · Substantial damageNTSB WPR10CA206Accident · No injuriesData collectionFinal reportCessna 150L · Princeville, ORThe pilot’s failure to ensure that the parking brake was set prior to hand-starting the engine.Apr 15, 2010 · N6928G · Substantial damageNTSB WPR10CA201Accident · Minor injuriesData collectionFinal reportCessna 150D · Galena, IDThe pilot's encounter with soft, snow-covered terrain while executing a precautionary landing.Apr 10, 2010 · N4296U · Substantial damageNTSB ERA10CA220Accident · Minor injuriesData collectionFinal reportCessna 150G · Cooperstown, NYA partial loss of engine power during a simulated engine-out demonstration due to carburetor icing.Apr 7, 2010 · N4760X · Substantial damageNTSB CEN10CA196Accident · No injuriesData collectionFinal reportCessna 150 · Waterproof, LAThe pilot's failure to maintain directional control during landing and his failure to initiate a go-around when encountering the strong gusting winds.Apr 7, 2010 · N66262 · Substantial damageNTSB ERA10CA218Accident · No injuriesData collectionFinal reportCessna 150G · Winter Haven, FLThe student pilot's inadequate recovery from a bounced landing in gusting winds.Apr 4, 2010 · N4655X · Substantial damageNTSB ERA10LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Lake Alfred, FLA loss of engine power during the landing approach for undetermined reasons.Mar 22, 2010 · N6589G · Substantial damageNTSB WPR10LA168Accident · No injuriesLimited investigationFinal reportCessna 150F · Tillamook, ORThe partial loss of engine power during climb to cruise due to carburetor icing and the pilot's delay in using carburetor heat.Mar 17, 2010 · N7854F · Substantial damageNTSB WPR10LA166Accident · Serious injuriesLimited investigationFinal reportKjonaas Varieze · Casa Grande, AZA loss of engine power during cruise flight due to fuel exhaustion.Mar 17, 2010 · N50894 · Substantial damageNTSB CEN10LA149Accident · Serious injuriesLimited investigationFinal reportStump Davis · Seguin, TXThe pilot's improper flare, which resulted in a bounced landing and noseover during a downwind landing.Mar 10, 2010 · N4384N · Substantial damageNTSB ERA10CA169Accident · No injuriesData collectionFinal reportCessna 150H · New Bedford, MAThe pilot’s failure to maintain directional control during a crosswind landing/rollout.Mar 7, 2010 · N6603S · Substantial damageNTSB WPR10CA146Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Delta, UTThe student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…Feb 23, 2010 · N894CT · Substantial damageNTSB ERA10LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Augustine, FLA loss of engine power due to fuel exhaustion caused by the failure of the right wing fuel tank sending unit gasket, which resulted in a forced landing.Feb 1, 2010 · N3995J · Substantial damageNTSB ERA10CA124Accident · No injuriesData collectionFinal reportCessna 150 · Taunton, MAThe pilot's failure to obtain the proper touchdown point during landing.Jan 26, 2010 · N5478Q · Substantial damageNTSB CEN10CA092Accident · Minor injuriesData collectionFinal reportCessna 150L · Brownstown, ILA total loss of engine power due to fuel exhaustion as a result of the student pilot becoming lost/disoriented in flight.Jan 5, 2010 · N10401 · Substantial damageNTSB ERA10LA104Accident · No injuriesLimited investigationFinal reportCessna 150G · Doylestown, PAA partial loss of engine power due to carburetor icing.Jan 1, 2010 · N4026J · Substantial damage