NTSB investigations: Continental 0-300 series, 2004

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

19642026
NTSB investigations: Continental 0-300 series, 2004 per year, 1964–2026: 3,125 cases
1964183
1965197
1966237
1967250
1968163
1969112
1970114
1971113
197296
197387
197453
197551
197661
197768
197865
197949
198037
198148
198231
198331
198434
198531
198638
198739
198835
198927
199028
199123
199229
199330
199422
199532
199629
199718
199831
199928
200027
200128
200230
200337
200428
200532
200627
200728
200823
200918
201022
201117
201220
201321
201412
201522
201617
201720
201822
201923
202013
202130
202217
202319
202417
202525
202610

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\") = 2004
    AND 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.

NTSB CHI05LA037Accident · No injuriesLimited investigationFinal reportCessna 172H · Belle Plaine, MNA loss of engine power for undetermined reasons during descent, and the unsuitable terrain encountered during the forced landing.Nov 28, 2004 · N2663L · Substantial damageNTSB MIA05CA032Accident · Serious injuriesData collectionFinal reportCessna 172B · Zephyrhills, FLThe pilot's failure to set the parking brake and his improper starting procedure which resulted in an unattended aircraft running away after hand starting the engine and the airplane colliding with parked airplanes, incurring substantial damage.Nov 21, 2004 · N7493X · Substantial damageNTSB IAD05LA013Accident · No injuriesLimited investigationFinal reportCessna 172E · Rupert, WVThe pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.Nov 21, 2004 · N3750S · Substantial damageNTSB MIA05LA027Accident · No injuriesLimited investigationFinal reportCessna 170A · Opa Locka, FLThe pilot's improper landing flare/touchdown, which resulted in a hard landing.Nov 12, 2004 · N9059A · Substantial damageNTSB IAD05LA010Accident · No injuriesLimited investigationFinal reportCessna 172 · Wolfeboro, NHA jammed control wheel during landing. A contributing factor to the accident was the inadequate maintenance inspection of the airplane's flight control system.Nov 4, 2004 · N8803B · Substantial damageNTSB FTW04CA245Accident · No injuriesData collectionFinal reportCessna 172H · Houston, TXThe student pilot's failure to maintain clearance from a parked aircraft while taxiing. A contributing factor was the student pilot's anxiety attack.Sep 28, 2004 · N189W · Substantial damageNTSB SEA04FA191Accident · 1 fatalField investigationFinal reportCessna 172D · Mountain Home, IDThe pilot's failure to maintain clearance from high terrain while maneuvering. High terrain was a factor.Sep 19, 2004 · N2650U · Substantial damageNTSB ANC04LA112Accident · No injuriesLimited investigationFinal reportCessna 170 · Teller, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate evaluation of the wind conditions, which resulted in a collision with an embankment during takeoff-initial climb. Factors contributing to the accident was the presence of a sand…Sep 8, 2004 · N3492C · Substantial damageNTSB SEA04LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Port Angeles, WAThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors contributing to the accident included the fence and the ditch.Sep 5, 2004 · N5788T · Substantial damageNTSB CHI04FA234Accident · 2 fatalField investigationFinal reportCessna 172E · Decorah, IAThe pilot's intentional operation of the airplane with a defective magneto, his failure to abort the takeoff due to degraded aircraft performance, and his failure to obtain or maintain airspeed which resulted in a stall/spin and subsequent impact with the…Aug 22, 2004 · N5410T · DestroyedNTSB NYC04LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Cooperstown, NYThe pilot's failure to maintain adequate airspeed and her premature rotation which resulted in an inadvertent stall/mush and subsequent impact with the ground.Aug 3, 2004 · N7957U · Substantial damageNTSB SEA04LA152Accident · 1 fatalLimited investigationFinal reportPaulick Wittman W-10 · Langley, WAThe pilot's inadequate preflight preparation to assure adequate takeoff performance to clear obstacles, and his failure to maintain obstacle clearance.Aug 1, 2004 · N70P · DestroyedNTSB ATL04CA163Accident · Minor injuriesData collectionFinal reportCessna 172 · Inman, SCThe pilot's failure to maintain clearance from the ground while maneuvering for a visual approach to land.Jul 29, 2004 · N3967F · Substantial damageNTSB SEA04CA141Accident · No injuriesData collectionFinal reportCessna 172D · Morton, WAThe pilot's misjudgment of altitude on final approach which resulted in an improper touchdown point and subsequent runway overrun. A factor was sunglare.Jul 24, 2004 · N2527Y · Substantial damageNTSB IAD04FA031Accident · 1 fatalField investigationFinal reportCessna 172C · Edinburgh, NYThe pilot's occluded left main coronary artery, which resulted in a massive heart attack and sudden death in flight.Jul 11, 2004 · N8358X · Substantial damageNTSB DEN04CA097Accident · No injuriesData collectionFinal reportCessna 172E · La Junta, COthe student pilot's failure to maintain aircraft control and adequate airspeed during the go-around resulting in an inadvertent stall. Contributing to the accident was the low airspeed and altitude.Jul 4, 2004 · N3581S · DestroyedNTSB ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.Jun 12, 2004 · N8777U · DestroyedNTSB ANC04LA061Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing flare/touchdown. A factor contributing to the accident was soft tundra terrain.Jun 6, 2004 · N2631D · Substantial damageNTSB LAX04LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, CAthe pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop.Jun 1, 2004 · N2915D · Substantial damageNTSB SEA04FA083Accident · 1 fatalField investigationFinal reportCessna 170B · Tenino, WAThe pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.May 17, 2004 · N3510D · 2 aircraft · DestroyedNTSB CHI04CA121Accident · No injuriesData collectionFinal reportCessna 172C · Fort Leavenwort, KSThe inadequate flare by the pilot.May 15, 2004 · N1806Y · Substantial damageNTSB SEA04LA053Accident · No injuriesLimited investigationFinal reportCessna 172E · Raymond, WAThe pilot's failure to maintain directional control during the landing roll resulting in the aircraft nosing over. Incorrect remedial action and soft terrain were factors.Mar 21, 2004 · N3950S · Substantial damageNTSB CHI04CA088Accident · Minor injuriesData collectionFinal reportCessna 172A · Springfield, MOThe pilot failed to initiate a go-around and the airplane porpoised during the hard landing. Factors associated with the accident were the excessive groundspeed and the overload failure of the nose gear.Mar 21, 2004 · N7265T · Substantial damageNTSB SEA04LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Marion, MTThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the gust of wind and the snowbank.Mar 20, 2004 · N90076 · Substantial damageNTSB LAX04CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Thermal, CAthe pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.Mar 14, 2004 · N8287X · Substantial damageNTSB ANC04LA034Accident · No injuriesLimited investigationFinal reportCessna 170A · North Pole, AKThe pilot's delayed response in initiating an aborted takeoff, which resulted in an overrun and collision with a snowbank.Mar 5, 2004 · N515N · Substantial damageNTSB NYC04CA068Accident · No injuriesData collectionFinal reportCessna 172E · Batavia, NYThe pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.Feb 15, 2004 · N369WP · Substantial damageNTSB LAX04CA086Accident · No injuriesData collectionFinal reportCessna 172F · Redlands, CAthe pilot's inadequate compensation for the existing gusty crosswind condition, and his failure to maintain directional control. Contributing factors were a crosswind and wind gusts.Jan 3, 2004 · N5184F · Substantial damage