Fatal NTSB investigations: Continental 0-300 series

13 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

20082026
Fatal NTSB investigations: Continental 0-300 series per year, 2008–2026: 13 cases
20081
20092
20111
20131
20153
20162
20191
20201
20231

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 c.\"highestInjuryLevel\" = 'Fatal'
    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')
      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.

NTSB GAA23WA071Accident · 3 fatalClass 5 · ForeignCessna 172H · San Francisco, GuatemalaFeb 13, 2023 · N8203L · DestroyedNTSB 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.Oct 25, 2020 · N724BC · 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 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.Oct 29, 2016 · N6353E · Substantial damageNTSB 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…Apr 18, 2016 · N1863Y · DestroyedNTSB CEN15FA378Accident · 1 fatalField investigationFinal reportCessna 172 · Martinville, ILThe non-certificated pilot's failure to maintain clearance from terrain.Aug 21, 2015 · N8265B · Substantial damageNTSB 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.Jun 19, 2015 · N5743A · Substantial damageNTSB 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.May 3, 2015 · N3969L · Substantial damageNTSB ERA13FA388Accident · 1 fatalField investigationFinal reportCessna 172 · Limington, MEAn impairing medical event of undetermined origin that led to a loss of control during takeoff.Aug 30, 2013 · N8063B · Substantial damageNTSB 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.Jan 4, 2011 · N1416F · Substantial damageNTSB 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.Sep 19, 2009 · N5845A · Substantial damageNTSB ERA09LA132Accident · 1 fatalLimited investigationFinal reportCessna 172 · Hardin, KYThe pilot's failure to maintain aircraft control and his impairment from illegal drug use.Jan 9, 2009 · N28RP · Substantial damageNTSB 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.Feb 27, 2008 · N8458D · Substantial damage