NTSB investigations: Continental GO-300 series

395 cases on aircraft whose registry engine model is Continental GO-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 ('17024'))
  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 DFW05FA240Accident · 3 fatalField investigationFinal reportCessna 175B · Cleveland, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin. A contributing factor was the low altitude.Sep 15, 2005 · N8285T · DestroyedNTSB DFW05CA194Accident · No injuriesData collectionFinal reportCessna 175A · Graham, OKThe impending loss of engine power as result of the failure of the generator mounting gasket resulting in engine oil starvation. A contributing factor was the lack of suitable terrain for the precautionary landing.Jul 28, 2005 · N6776E · Substantial damageNTSB NYC05LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Lawrenceburg, KYThe pilot's inadequate pre-flight planning and in-flight planning decision, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing.Dec 31, 2004 · N8141T · Substantial damageNTSB FTW04LA229Accident · No injuriesLimited investigationFinal reportCessna 175 · De Ridder, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Sep 2, 2004 · N6517E · Substantial damageNTSB FTW04LA110Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Locust Grove, OKThe improper installation of the generator, which resulted in oil starvation. A factor was the unsuitable terrain.Apr 16, 2004 · N8172T · Substantial damageNTSB MIA04WA046Accident · No injuriesForeign investigationCessna 172 · Lamentin, MartiniqueDec 30, 2003 · N8547X · Substantial damageNTSB CHI04LA028Accident · No injuriesLimited investigationFinal reportCessna 175 · Mears, MILoss of engine power due to carburetor icing and the pilot's delayed application of carburetor heat during descent. A factor was the carburetor icing conditions.Nov 8, 2003 · N9275B · Substantial damageNTSB LAX03LA255Accident · Minor injuriesLimited investigationFinal reportLefever-Paul Skybolt · Mt. Hamilton, CAThe pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power.Aug 9, 2003 · N94PL · Substantial damageNTSB CHI03LA197Accident · No injuriesLimited investigationFinal reportCessna 175 · Wessington Spri, SDThe pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.Jul 4, 2003 · N7256M · DestroyedNTSB LAX03LA185Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Ash Fork, AZThe pilot's failure to attain and maintain an adequate airspeed, which resulted in a stall mush condition. Factors were the loose and uneven dirt runway surface, the known tailwind with gusts, and high density altitude.Jun 7, 2003 · N6902E · Substantial damageNTSB SEA03LA093Accident · No injuriesLimited investigationFinal reportCessna 175 · Middleton, IDThe pilot's failure to follow the checklist which led to fuel starvation and subsequent loss of engine power. A contributing factor was the uneven terrain at the landing site.Jun 5, 2003 · N7238M · Substantial damageNTSB DEN03LA088Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Cedar City, UTthe pilot's inadvertently switching the fuel selector to the right tank, resulting in fuel starvation, and his failure to maintain direction control during the forced landing. Contributing factors were the crosswind and the tree.May 23, 2003 · N8199T · DestroyedNTSB NYC03LA109Accident · No injuriesLimited investigationFinal reportCessna 175A · Ocean City, NJA partial loss of engine power for undetermined reasons.May 19, 2003 · N6989E · Substantial damageNTSB DEN03LA073Accident · No injuriesLimited investigationFinal reportCessna 175A · Colo. Springs, COthe stuck open exhaust valve on the engine's number 2 cylinder, the pilot's improper preflight planning, and his failure to maintain aircraft control. Factors contributing to the accident were the low altitude flight maneuver performed, the low airspeed, the…Apr 26, 2003 · N6884E · Substantial damageNTSB SEA03LA069Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Bonanza, ORSeparation of the connecting rod cap. Annual maintenance inspections which were disregarded by the owner/pilot was a factor.Apr 23, 2003 · N8159T · Substantial damageNTSB CHI03LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Grand Island, NEThe loss of engine power due to fuel contamination and the pilot's inadequate preflight inspection.Jan 19, 2003 · N6663E · Substantial damageNTSB CHI03FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 175 · MIUndetermined. Missing aircraft.Nov 11, 2002 · N7091M · Substantial damageNTSB CHI03LA008Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Lake Elmo, MNThe pilot's failure to maintain aircraft control. Factors to the accident included the gusting wind conditions and the encountered windshear, which resulted in the inadvertent stall at a low altitude and subsequent in-flight collision with the transmission…Oct 14, 2002 · N8161T · DestroyedNTSB CHI02LA186Accident · No injuriesLimited investigationFinal reportCessna 175 · Kaiser/Lake Oza, MOThe pilot's decision to conduct the flight with a known deficiency in the aircraft, a failure by the pilot to execute a precautionary landing due to "sluggish" performance during takeoff, the loss of engine power due to the malfunction of the left magneto,…Jul 9, 2002 · N175HL · Substantial damageNTSB DEN02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Salt Lake City, UTtotal mechanical loss of engine power for reasons undetermined. Contributing factors were the lack of an annual inspection and the (forced landing in) salt water.Jun 16, 2002 · N7338M · DestroyedNTSB LAX02LA174Accident · No injuriesLimited investigationFinal reportCessna 175 · Anaheim, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.May 24, 2002 · N6713E · Substantial damageNTSB MIA02LA035Accident · No injuriesLimited investigationFinal reportCessna 175A · Fairhope, ALThe pilot's failure to check wind conditions prior to landing resulting in a landing with a tailwind, on a wet runway, and damage to the airplane during a ground loop in an attempt to stop the airplane before over running the runway.Nov 20, 2001 · N7095E · Substantial damageNTSB SEA02FA009Accident · 1 fatalField investigationFinal reportCessna 175C · Miles City, MTThe separation of the number four cylinder exhaust valve guide from the cylinder head, leading to the failure of the exhaust valve stem and the catastrophic failure of the engine while in cruise flight. Factors include the necessity of attempting a forced…Nov 5, 2001 · N8347T · Substantial damageNTSB ANC01LA120Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Kenai, AKThe total loss of engine power during takeoff for an undetermined reason.Aug 21, 2001 · N6550E · Substantial damageNTSB MIA01LA185Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mooresville, NCthe pilot's improper fuel consumption calculations, inadequate preflight planning, and failure to refuel the airplane before takeoff, which resulted in a loss of engine power due to fuel exhaustion, and a forced landing in trees.Jul 15, 2001 · N8861E · DestroyedNTSB CHI01LA200Accident · No injuriesLimited investigationFinal reportCessna 175 · Tomahawk, WIThe inadequate preflight preparation that did not include calculating the density altitude and the pilot not maintaining clearance from the second row of trees on initial climb. Factors include those trees and the high density altitude present at the time of…Jul 8, 2001 · N103DL · Substantial damageNTSB LAX01LA235Accident · No injuriesLimited investigationFinal reportCessna 175 · Monterey, CAThe pilot's improper recovery from a bounced landing.Jul 4, 2001 · N9287B · Substantial damageNTSB DEN01FA013Accident · 1 fatalField investigationFinal reportCessna 175 · Hanksville, UTthe pilot's failure to maintain control of the airplane while maneuvering at low altitude, and his physical impairment due to alcohol and drugs. A contributing factor was the downdraft.Nov 12, 2000 · N7360M · DestroyedNTSB CHI00FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 175 · MIundetermined.Nov 12, 1999 · N6533E · DestroyedNTSB ATL99LA119Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mountain City, TNA blocked fuel system vent that resulted in fuel starvation and the complete loss of engine power.Aug 27, 1999 · N7566M · Substantial damageNTSB FTW99LA139Accident · No injuriesLimited investigationFinal reportCessna 175B · Spur, TXThe total loss of engine power during cruise flight for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.May 13, 1999 · N8133T · Substantial damageNTSB SEA99LA030Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Moses Lake, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jan 16, 1999 · N9326B · Substantial damageNTSB FTW98FA372Accident · 3 fatalField investigationFinal reportCessna 175A · Erie, COThe pilot's failure to maintain flying speed (above stall speed) and the subsequent stall/spin. Contributing factors were the tailwind, high density altitude, and aircraft overweight conditions.Aug 22, 1998 · N6874E · DestroyedNTSB SEA98LA166Accident · No injuriesLimited investigationFinal reportCessna 175 · Missoula, MTA complete loss of crankcase oil due to a missing oil filler tube followed by the failure of a connecting rod. Factors include encountering a small pine tree during the landing roll.Aug 15, 1998 · N8512X · Substantial damageNTSB NYC98LA158Accident · Minor injuriesLimited investigationFinal reportCessna 175 · East Canton, OHThe pilot's failure to maintain direction control of the airplane.Aug 1, 1998 · N6716E · Substantial damageNTSB FTW98FA287Accident · 1 fatalField investigationFinal reportCessna 175 · Clovis, NMThe pilot's failure to maintain adequate obstacle clearance and the proper landing glide path. Also causal was his loss of aircraft control during an attempted go-around. Factors were the dark night light conditions, the pilot's recent lack of sleep, and the…Jun 28, 1998 · N7366M · DestroyedNTSB SEA98LA041Accident · No injuriesLimited investigationFinal reportCessna 175 · Port Townsend, WAThe pilot's misjudged distance and speed during landing. A factor was the wet grass runway.Feb 26, 1998 · N7620M · Substantial damageNTSB FTW98LA062Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Houston, TXThe total loss of engine power resulting from detonation and the ensuing failure of the engine piston and connecting rod components. Factors were: the instructor's decision to take off with a known deficiency (magneto drop over limit), the flight instructor's…Dec 13, 1997 · N6846E · Substantial damageNTSB FTW97LA318Accident · No injuriesLimited investigationFinal reportCessna 175 · Rock Springs, WYThe delayed landing flare by both student pilot and flight instructor, and the flight instructor's inadequate supervision of the student. Factors were the no flap steep approach at low airspeed.Aug 18, 1997 · N7518M · Substantial damageNTSB SEA97LA192Accident · No injuriesLimited investigationFinal reportCessna 175 · Lynnwood, WAThe pilot's inadequate preflight planning and preparation, which led to fuel exhaustion and subsequent loss of engine power.Aug 17, 1997 · N7533M · Substantial damageNTSB ANC97LA044Accident · No injuriesLimited investigationFinal reportCessna 175 · Naknek, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. Factors associated with the accident were the pilot's inadequate preflight preparation and planning by failing to obtain information about the out of service runway lighting, and the rough…Apr 1, 1997 · N9261B · Substantial damageNTSB IAD97LA053Accident · No injuriesLimited investigationFinal reportCessna 175 · Weirs Cave, VAthe pilot's inadequate preflight planning/preparation, and inaccurate fuel calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Darkness and high vegetation in the forced landing area were related factors.Mar 10, 1997 · N9485B · Substantial damageNTSB FTW97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 175B · Mount Pleasant, TXThe total loss of engine power due to the #3 connecting rod separation resulting in engine seizure. Factors were the dark night and the lack of suitable terrain for the forced landing.Oct 7, 1996 · N8171T · Substantial damageNTSB CHI96LA338Accident · No injuriesLimited investigationFinal reportCessna 175 · Dexter, IAthe pilot's inadequate short field landing procedure/technique. The tailwind and grass runway were related factors.Aug 24, 1996 · N8217T · Substantial damageNTSB NYC96LA092Accident · No injuriesLimited investigationFinal reportCessna 175 · Pittsfield, MAthe pilot's inadequate crosswind compensations during the landing roll.Apr 20, 1996 · N7002M · Substantial damageNTSB FTW96LA032Accident · No injuriesLimited investigationFinal reportCessna 175 · Deer, ARThe pilot's selection of a downwind runway for landing. Factors were the tailwind and the pilot's misinterpretation of the wind conditions.Oct 22, 1995 · N7421M · Substantial damageNTSB FTW96LA018Accident · No injuriesLimited investigationFinal reportCessna 175 · Batesville, ARthe pilot's failure to maintain control of the airplane during landing.Oct 19, 1995 · N7021M · Substantial damageNTSB CHI95LA311Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Staples, MNthe pilot's delay in the application of carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent forced landing in a swampy area. The carburetor icing (weather) condition was a related factor.Sep 3, 1995 · N9425B · Substantial damageNTSB NYC95LA066Accident · No injuriesLimited investigationFinal reportCessna 175 · Quantico, VAthe failure of a connecting rod, which resulted in the total loss of engine power. Subsequently, the airplane was ditched.Mar 3, 1995 · N7175M · Substantial damageNTSB LAX95LA071Accident · No injuriesLimited investigationFinal reportCessna 175 · Davis, CAthe failure of the pilot to maintain directional control of the aircraft while on the rollout phase of landing on a dirt road. A factor in the accident was the pilot's intentional selection of the road as a landing site.Jan 2, 1995 · N7098M · Substantial damage