NTSB investigations: Continental 0-300 series
36 cases on aircraft whose registry engine model is Continental 0-300 series, where the defining event was Loss of control in flight. 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
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 3 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 2 |
| 2023 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
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.
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 ('17022')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN26LA201Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172H · Berryville, ARThe pilot in command’s decision to continue the takeoff when the airplane was not airborne at midfield, and the student pilot’s likely improper technique that resulted in a lack of sufficient climb performance and subsequent loss of control.NTSB GAA23WA071Accident · 3 fatalClass 5 · ForeignCessna 172H · San Francisco, GuatemalaNTSB CEN21LA415Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170B · Ozark, ARThe pilot’s inadequate takeoff performance planning that resulted in a climb gradient too low to clear trees on departure, and his failure to maintain aircraft control that resulted in an aerodynamic stall and impact with terrain.NTSB WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.NTSB ERA21FA029Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dunnellon, FLA total loss of engine power due to fuel exhaustion. Contributing was the pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin and loss of control.NTSB 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.NTSB 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.NTSB GAA19CA123Accident · Minor injuriesData collectionFinal reportCessna 172 · Center, TXThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB 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.NTSB 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.NTSB 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…NTSB ANC17FA003Accident · 1 fatalField investigationFinal reportCessna 172 · Palmer, AKThe student pilot's exceedance of the airplane's critical angle of attack during a steep climbing turn following a touch-and-go landing, which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB ERA17LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLA partial loss of engine power due to a stuck exhaust valve and the noncertificated pilot's inadequate preflight planning, which resulted in the airplane being overloaded, both of which led to the airplane's inability to attain a positive climb rate.…NTSB ERA16FA161Accident · 2 fatalField investigationFinal reportCessna 172 · Westmoreland, NYThe pilot's decision to takeoff on the grass runway given the conditions at the time; his excessive aft control input during the takeoff roll, which resulted in the aft fuselage contacting the runway surface; and his failure to attain sufficient airspeed and…NTSB GAA16CA150Accident · No injuriesData collectionFinal reportCessna 172 · La Junta, COThe pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.NTSB GAA15CA243Accident · No injuriesData collectionFinal reportCessna 172 · New Enterprise, PAThe pilot's exceedance of the critical angle of attack during takeoff, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN15FA378Accident · 1 fatalField investigationFinal reportCessna 172 · Martinville, ILThe non-certificated pilot's failure to maintain clearance from terrain.NTSB CEN15FA278Accident · 1 fatalField investigationFinal reportCessna 172 · Shreveport, LAThe pilot's loss of airplane control during initial climb after takeoff for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact anomalies.NTSB GAA15CA136Accident · No injuriesData collectionFinal reportCessna 172H · Cottonwood Falls, KSThe pilot's failure to attain adequate airspeed to climb the airplane out of ground effect, which resulted in an aerodynamic stall and a collision with terrain.NTSB ERA15FA203Accident · 1 fatalField investigationFinal reportCessna 172 · Penn Yan, NYThe student pilot's failure to maintain airplane control during the initial climb. Contributing to the accident was the student's inappropriate configuration of the airplane's wing flaps for the initial climb.NTSB CEN15LA111Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Lowell, MIThe student pilot’s loss of airplane control during a go-around after not applying sufficient engine power.NTSB CEN13LA581Accident · No injuriesLimited investigationFinal reportCessna 172 · Rio Vista, TXThe student pilot’s failure to maintain adequate airspeed during the initial climb after an excessive takeoff run from a grass airstrip, which resulted in the exceedance of the airplane's critical angle-of-attack and a subsequent aerodynamic stall and loss of…NTSB ERA13FA388Accident · 1 fatalField investigationFinal reportCessna 172 · Limington, MEAn impairing medical event of undetermined origin that led to a loss of control during takeoff.NTSB CEN13LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Akron, COThe pilot’s physical impairment due to alcohol intoxication, which resulted in an aerodynamic stall during landing.NTSB ANC13CA003Accident · No injuriesData collectionFinal reportCessna 172D · Buckland, AKThe pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.NTSB CEN12CA620Accident · No injuriesData collectionFinal reportCessna 172H · Phillipsburg, OHThe pilot’s improper flare, which resulted in a hard landing.NTSB ERA12CA320Accident · Minor injuriesData collectionFinal reportCessna 172F · Cambridge, NYThe pilot’s loss of airplane control during a takeoff in variable crosswind conditions.NTSB WPR12LA189Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Beckwourth, CAThe pilot’s failure to maintain sufficient airspeed during initial climb, which resulted in a loss of airplane control.NTSB ERA11CA331Accident · Serious injuriesData collectionFinal reportCessna 172 · Ghent, NYThe pilot's delayed decision to abort the landing and execute a go-around.NTSB CEN11LA138Accident · 1 fatalLimited investigationFinal reportCessna 172H · Walnut Grove, MOThe pilot's loss of control for undetermined reasons. Contributing to the accident was the pilot's fatigue.NTSB ERA09LA527Accident · 2 fatalLimited investigationFinal reportCessna 172 · Lowndesville, SCThe pilot's inadequate preflight planning and improper decision to continue flight into deteriorating weather conditions, which resulted in spatial disorientation after entering instrument flight conditions.NTSB ANC09CA026Accident · Minor injuriesData collectionFinal reportCessna 170B · Dillingham, AKThe pilot's selection of unsuitable terrain for takeoff and his failure to attain adequate airspeed to avoid an aerodynamic stall. Contributing to the accident was the pilot's decision to take off with the airplane over its maximum allowable gross weight.NTSB ERA09LA132Accident · 1 fatalLimited investigationFinal reportCessna 172 · Hardin, KYThe pilot's failure to maintain aircraft control and his impairment from illegal drug use.NTSB MIA08CA157Accident · No injuriesData collectionFinal reportCessna 172 · Wingate, NCThe student pilot's failure to maintain control of the airplane during a go-around.NTSB MIA08CA100Accident · No injuriesData collectionFinal reportCessna 172A · Jamestown, PAThe pilot's failure to maintain control after takeoff resulting in contact with the ground. Contributing to the accident was the pilot's inadequate preflight planning resulting in a takeoff from a short, wet, soft, runway.NTSB ANC08FA037Accident · 1 fatalField investigationFinal reportCessna 170B · Tyonek, AKThe pilot's failure to maintain adequate airspeed to prevent a stall while maneuvering, which resulted in an uncontrolled descent and collision with terrain.