NTSB investigations: Continental 0-300 series, 2019

23 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, 2019 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\") = 2019
    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 CEN20LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Harrison, OHA total loss of engine power during approach to land due to carburetor icing during a simulated engine failure, which resulted in impact with trees.Dec 19, 2019 · N5406R · Substantial damageNTSB ERA20LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Toms River, NJThe failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…Nov 13, 2019 · N3958S · 2 aircraft · Substantial damageNTSB GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.Nov 12, 2019 · N3803S · Substantial damageNTSB ANC20LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palmer, AKThe pilot's delayed application of carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power, a precautionary landing, and impact with terrain.Oct 13, 2019 · N7267A · Substantial damageNTSB CEN20FA010Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Aberdeen, SDThe noncertificated pilot’s decision to fly in dark night instrument conditions, resulting in impact with terrain.Oct 10, 2019 · N6483B · DestroyedNTSB GAA20CA006Accident · Minor injuriesData collectionFinal reportCessna 172 · Kaplan, LAThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and impact with a pole during an off-airport landing.Oct 5, 2019 · N7871U · Substantial damageNTSB GAA19CA544Accident · No injuriesData collectionFinal reportCessna 172F · Hemet, CAThe flight instructor's improper decision to perform a precautionary landing on unsuitable terrain, which resulted in a noseover.Sep 12, 2019 · N5229F · Substantial damageNTSB CEN19LA311Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Grassy Butte, NDA total loss of engine power due to water contamination of the fuel, and the pilot's failure to conduct a preflight inspection.Sep 10, 2019 · N5347T · Substantial damageNTSB WPR19FA244Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · McKenzie Bridge, ORThe pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…Aug 28, 2019 · N4108F · DestroyedNTSB CEN19LA263Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New Carlisle, OHThe pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.Aug 11, 2019 · N8928B · Substantial damageNTSB GAA19CA486Accident · No injuriesData collectionFinal reportCessna 172 · Bayse, VAThe pilot's exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall.Aug 4, 2019 · N424BC · Substantial damageNTSB WPR19LA198Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Madras, ORA partial loss of power during final approach for undetermined reasons as postaccident examinations did not reveal any preimpact anomalies with the airplane or engine.Jul 22, 2019 · N3761L · Substantial damageNTSB CEN19LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Kingston, OKThe partial loss of engine power due to a stuck exhaust valve.Jul 22, 2019 · N8251L · Substantial damageNTSB WPR19LA202Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Port Townsend, WAThe loss of engine power for reasons that could not be determined based on available information.Jul 21, 2019 · N3863L · Substantial damageNTSB CEN19FA235Accident · FatalClass 3 · FieldFinal reportCessna 175 · Kilgore, TXThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack when the airplane became airborne during a high-speed taxi test, resulting in an aerodynamic stall and impact with terrain.Jul 20, 2019 · N7013M · Substantial damageNTSB GAA19CA477Accident · No injuriesData collectionFinal reportCessna 172 · Greer, SCThe pilot's improper decision to continue a steep and fast approach to landing, which resulted in a runway overrun and collision with a drainage culvert.Jun 29, 2019 · N724BC · Substantial damageNTSB GAA19CA323Accident · No injuriesData collectionFinal reportCessna 172 · Yellow Pine, IDThe pilot's improper approach, which resulted in the airplane touching down with insufficient runway remaining to stop on the runway, a runway overrun, and subsequent collision with bushes and terrain.Jun 9, 2019 · N5344R · Substantial damageNTSB GAA19CA267Accident · Minor injuriesData collectionFinal reportCessna 172 · Manvel, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in impact with a ditch.May 15, 2019 · N5788R · Substantial damageNTSB GAA19CA269Accident · No injuriesData collectionFinal reportCessna 172 · Tomball, TXThe student pilot's failure to maintain directional control during landing with a left crosswind, which resulted in a runway excursion and subsequent nose-over.May 14, 2019 · N8159U · Substantial damageNTSB WPR19LA140Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Red Rock, AZA partial loss of engine power for reasons that could not be determined based on the available information.May 6, 2019 · N8887U · Substantial damageNTSB CEN19FA099Accident · 1 fatalClass 2 · FieldFinal reportCessna 172 · Lakeway, TXA partial loss of engine power for reasons that could not be determined, and the flight instructor's exceedance of the airplane's critical angle of attack while maneuvering for a forced landing, which resulted in an aerodynamic stall and subsequent loss of…Mar 14, 2019 · N8620B · Substantial damageNTSB GAA19CA172Accident · No injuriesData collectionFinal reportCessna 172 · Oskaloosa, IAThe student pilot's failure to maintain directional control during landing with a left quartering tailwind, which resulted in a runway excursion, impact with a snowbank, and a nose-over.Mar 11, 2019 · N334SL · Substantial damageNTSB ERA19TA098Accident · Minor injuriesClass 3Final reportCessna 172 · Lignum, VAA total loss of engine power for undetermined reasons.Feb 10, 2019 · N7414N · Substantial damage