NTSB investigations: Continental 0-300 series, 2017

20 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, 2017 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\") = 2017
    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 CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.Dec 9, 2017 · N8856B · Substantial damageNTSB WPR18LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna 172D · Auburn, WAThe pilot's loss of airplane control for reasons that could not be determined based on the available information.Dec 7, 2017 · N2351U · Substantial damageNTSB CEN18FA037Accident · 1 fatalField investigationFinal reportCessna 172G · Pittsford, VTThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.Nov 22, 2017 · N4676L · DestroyedNTSB GAA17CA526Accident · Serious injuriesData collectionFinal reportCessna 172 · Coolin, IDThe pilot's decision to take off in high-density altitude and gusting quartering tailwind conditions, which resulted in a loss of lift and an inability to gain altitude during the initial climb.Sep 10, 2017 · N5703A · Substantial damageNTSB GAA17CA513Accident · Minor injuriesData collectionFinal reportCessna 172 · Belle Fourche, SDThe flight instructor's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall.Aug 30, 2017 · N2982U · Substantial damageNTSB GAA17CA476Accident · No injuriesData collectionFinal reportCessna 172 · Drexel, MOThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Aug 5, 2017 · N8226U · Substantial damageNTSB WPR17LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Enumclaw, WAThe pilot's improper approach for landing, which resulted in the airplane landing long, and his delayed decision to go around with insufficient runway remaining, which resulted in collision with an airport perimeter fence.Jul 28, 2017 · N7243T · Substantial damageNTSB GAA17CA437Accident · No injuriesData collectionFinal reportCessna 172 · Powell, WYThe student pilot’s improper landing flare and subsequent failure to relinquish the flight controls, which resulted in a hard landing.Jul 24, 2017 · N6470E · Substantial damageNTSB ERA17LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cape Coral, FLA total loss of engine power due to fuel contamination with water and the pilot's inadequate preflight inspection that detected, but did not fully resolve, the water contamination of the fuel system.Jul 7, 2017 · N2492U · Substantial damageNTSB GAA17CA380Accident · No injuriesData collectionFinal reportCessna 172 · Tucson, AZThe pilot’s failure to maintain pitch and yaw control during the landing roll in crosswind conditions.Jul 2, 2017 · N4482L · Substantial damageNTSB CEN17LA241Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fulton, MOThe partial loss of engine power due to water contamination in the fuel system.Jun 24, 2017 · N6474B · Substantial damageNTSB WPR17LA112Accident · Minor injuriesLimited investigationFinal reportCessna 175 · El Monte, CAThe flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…May 27, 2017 · N6832D · Substantial damageNTSB GAA17CA302Accident · No injuriesData collectionFinal reportCessna 175 · Prospect, ORThe flight instructor’s failure to attain an adequate climb rate during takeoff, which resulted in impact with trees.May 20, 2017 · N175DH · Substantial damageNTSB ERA17LA158Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Euharlee, GAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.Apr 18, 2017 · N8368B · Substantial damageNTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.Apr 8, 2017 · N88470 · 2 aircraft · Substantial damageNTSB ERA17FA143Accident · 2 fatalField investigationFinal reportCessna 170B · Edgewater, FLThe Cessna pilot's failure to maintain clearance from the Grumman during the transition to a different formation. Contributing to the accident was the stepped down configuration of the formation flight which was composed of dissimilar aircraft.Apr 1, 2017 · N8082A · 2 aircraft · DestroyedNTSB GAA17CA206Accident · No injuriesData collectionFinal reportCessna 172 · Timberlake, NCThe student pilot’s failure to maintain pitch control during the landing flare with a tailwind, which resulted in a propeller strike.Mar 23, 2017 · N3947R · Substantial damageNTSB GAA17CA175Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, METhe pilot's failure to maintain directional control while taxiing in gusting crosswind conditions.Mar 2, 2017 · N7450X · Substantial damageNTSB WPR17FA065Accident · 3 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.Feb 26, 2017 · N3712F · Substantial damageNTSB CEN17FA085Accident · 1 fatalField investigationFinal reportCessna 172 · Jay, OKThe pilot's negligent maintenance of the airplane, which resulted in improper fuel management, fuel starvation, and a loss of engine power during takeoff due to a missing securing pin in the fuel selector handle, and a subsequent forced landing on unsuitable…Jan 25, 2017 · N5639A · Substantial damage