Fatal NTSB investigations: Continental I0-470 series

291 cases on aircraft whose registry engine model is Continental I0-470 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, newest first

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 ('17027'))
  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 CEN15FA374Accident · 1 fatalField investigationFinal reportBeech 35 B33 · El Dorado, ARThe loss of engine power for reasons that could not be determined during postaccident examination of the accident site or based on the available information and the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical…Aug 23, 2015 · N9704Y · DestroyedNTSB ERA15FA308Accident · 2 fatalField investigationFinal reportBeech N35 · Weirsdale, FLA partial loss of engine power during takeoff. The reason for the partial loss of power could not be determined due to the extensive fire and impact damage to the engine.Aug 12, 2015 · N390Z · DestroyedNTSB CEN15FA320Accident · 4 fatalField investigationFinal reportBeech M35 · Amery, WIThe pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.Jul 27, 2015 · N9CB · DestroyedNTSB ERA15FA215Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Saltville, VAThe pilot’s flight into developing rain showers and updrafts, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident were the pilot’s continued flight into forecast adverse weather conditions, and his reliance on…May 18, 2015 · N5816S · DestroyedNTSB CEN15FA056Accident · 1 fatalField investigationFinal reportAero Commander 500A · McDade, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack for reasons that could not be determined based on the available evidence, which resulted in an aerodynamic stall/spin. Contributing to the accident…Nov 23, 2014 · N14AV · Substantial damageNTSB ERA14FA128Accident · 3 fatalField investigationFinal reportBeech 95-B55 · LaGrange, GAThe pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…Feb 22, 2014 · N36638 · DestroyedNTSB CEN14FA141Accident · 3 fatalField investigationFinal reportBeech 35/33 · Telluride, COThe airplane’s failure to obtain a positive climb rate, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s inadequate preflight planning.Feb 16, 2014 · N400DJ · Substantial damageNTSB CEN14FA024Accident · 1 fatalField investigationFinal reportBellanca 14-19-3A · Boerne, TXA defective exhaust system that allowed carbon monoxide to enter the cabin and impair the pilot, rendering him unable to control the airplane.Oct 27, 2013 · N11RC · DestroyedNTSB ANC13FA058Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Cantwell, AKThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.Jun 28, 2013 · N5JG · DestroyedNTSB WPR13FA288Accident · 1 fatalField investigationFinal reportBeech J35 · Helena, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.Jun 24, 2013 · N8255D · Substantial damageNTSB ERA13FA133Accident · 3 fatalField investigationFinal reportCessna 310H · Yeehaw Junction, FLThe noninstrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions and his subsequent spatial disorientation. Contributing to the accident was the copilot's improper evaluation of the weather…Feb 14, 2013 · N104DR · Substantial damageNTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.Jan 19, 2013 · N143E · Substantial damageNTSB CEN13FA082Accident · 2 fatalField investigationFinal reportBeech P35 · Correctionville, IAThe pilot’s failure to perform a go-around after encountering thick fog at night.Dec 2, 2012 · N1566Z · Substantial damageNTSB ANC13FA001Accident · 1 fatalField investigationFinal reportGrumman G-44 · Aleknagik, AKThe pilot's decision to make multiple low passes over the glassy surface water, which resulted in an impact with the surface of the lake.Oct 8, 2012 · N139F · Substantial damageNTSB WPR12FA098Accident · 2 fatalField investigationFinal reportCessna 210 · Morgan, UTThe non-instrument-rated pilot’s poor planning and continued visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from mountainous terrain.Feb 9, 2012 · N9619T · Substantial damageNTSB WPR12FA012Accident · 3 fatalField investigationFinal reportBeech E33 · Daggett, CAA loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…Oct 16, 2011 · N7011N · Substantial damageNTSB ERA11FA458Accident · 1 fatalField investigationFinal reportCessna 310Q · Tupelo, MSThe pilot’s delayed reaction in performing the engine failure procedures and his failure to maintain adequate airspeed, which resulted in a loss of airplane control. Contributing to the accident was maintenance personnel’s improper torquing of the B-nut…Aug 17, 2011 · N444YM · Substantial damageNTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.Jan 1, 2011 · N6725X · Substantial damageNTSB CEN11FA130Accident · 1 fatalField investigationFinal reportCessna 210B · Loveland, COThe pilot's intentional flight into terrain.Dec 27, 2010 · N200EP · Substantial damageNTSB ERA11FA038Accident · 1 fatalField investigationFinal reportCessna 210A · Aiken, SCThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot’s…Oct 28, 2010 · N6655X · Substantial damageNTSB CEN11FA040Accident · 1 fatalField investigationFinal reportBeech 95-B55 (T42A) · Clarion, IAThe pilot's failure to maintain control of the airplane. Contributing to the accident was the loss of left engine power for undetermined reasons.Oct 21, 2010 · N784CB · DestroyedNTSB CEN10FA493Accident · 2 fatalField investigationFinal reportCessna 310C · Calhan, COThe pilots'failure to maintain control of the airplane which resulted in an inadvertent stall and spin.Aug 23, 2010 · N896H · Substantial damageNTSB WPR10FA397Accident · 2 fatalField investigationFinal reportAero Commander 500-B · Burns, ORThe non-instrument rated pilot's improper decision to continue flight into an area of known instrument meteorological conditions and his failure to maintain control of the airplane after entering those conditions.Aug 11, 2010 · N500FV · Substantial damageNTSB CEN10FA392Accident · 3 fatalField investigationFinal reportBeech 35C33 · Tolar, TXThe pilot's failure to maintain control of the airplane while maneuvering at night over a rural area, due to spatial disorientation.Jul 14, 2010 · N5827S · Substantial damageNTSB WPR10FA158Accident · 1 fatalField investigationFinal reportBeech K35 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management; also causal was his subsequent failure to maintain clearance from power lines.Mar 13, 2010 · N5392E · Substantial damageNTSB ERA10FA154Accident · 1 fatalField investigationFinal reportBeech P35 · Edgewater, MDThe pilot's failure to maintain adequate airspeed while on approach, which resulted in an inadvertent stall. Contributing to the accident was the pilot's likely impairment due to back pain, symptoms of opiate withdrawal, or both.Feb 27, 2010 · N1521S · Substantial damageNTSB ERA10FA040Accident · 2 fatalField investigationFinal reportCessna 310J · Lawrenceville, GAThe pilot’s loss of aircraft control while maneuvering in instrument meteorological conditions, as a result of spatial disorientation.Oct 30, 2009 · N308J · Substantial damageNTSB WPR09FA248Accident · 3 fatalField investigationFinal reportCessna 172N · Long Beach, CAThe failure of both pilots to see and avoid each other's aircraft.May 19, 2009 · N738NN · 2 aircraft · Substantial damageNTSB WPR09FA235Accident · 5 fatalField investigationFinal reportBeech 95 · Minden, NVThe pilot's failure to maintain an adequate airspeed while maneuvering during a low altitude maneuver that resulted in a stall.May 9, 2009 · N1533Z · Substantial damageNTSB CEN09FA164Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Porter, TXThe pilot’s failure to maintain control of the airplane during an aborted landing for undetermined reasons.Feb 12, 2009 · N9648Y · Substantial damageNTSB WPR09FA096Accident · 2 fatalField investigationFinal reportCessna 205 · Flagstaff, AZThe pilot's loss of situational awareness and failure to maintain clearance from hilly terrain while flying in an area of a low cloud ceiling. Contributing to the accident was the pilot's decision to continue flight due to a self-induced pressure.Jan 23, 2009 · N8298Z · Substantial damageNTSB ERA09FA074Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Homosassa Spgs., FLThe pilot’s continued flight into known adverse weather conditions.Nov 30, 2008 · N945T · DestroyedNTSB NYC08FA231Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Jasper, ALThe pilot's intentional visual flight into known instrument meteorological conditions, resulting in spatial disorientation and a subsequent loss of control in flight. Contributing to the accident was the overweight and aft-center-of-gravity condition of the…Jun 29, 2008 · N727BC · DestroyedNTSB DFW08FA153Accident · 2 fatalField investigationFinal reportCessna 310Q · Steamboat, COThe pilot's failure to maintain clearance from mountainous terrain in day visual conditions. Contributing to the accident was the pilot's impairment due to marijuana and inadequate medical oversight of the pilot by the Federal Aviation Administration.May 25, 2008 · N8187Q · DestroyedNTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.Feb 11, 2008 · N5030Q · Substantial damageNTSB SEA08FA006Accident · 2 fatalField investigationFinal reportCessna 310N · Ekalaka, MTThe pilot's improper in-flight planning/decision, his continued flight into adverse weather (icing conditions), and failure to maintain an adequate airspeed during the emergency descent for landing. Contributing to the accident were the forecast icing…Oct 7, 2007 · N85WT · Substantial damageNTSB SEA07FA148Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Quilcene, WAThe pilot's continued flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain. Factors contributing to the accident included the low clouds which obscured the rising, mountainous terrain.Jun 7, 2007 · N8308Z · Substantial damageNTSB SEA07LA129Accident · 1 fatalLimited investigationFinal reportSIAI-Marchetti FN-333 · Minden, NVThe loss of engine power as a result of fuel starvation due to the pilot's improper positioning of the fuel selector and failure to select a tank containing fuel.May 20, 2007 · N95DR · Substantial damageNTSB NYC07FA096Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Saranac Lake, NYThe pilot's failure to maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall.Apr 18, 2007 · N868ST · DestroyedNTSB LAX07LA130Accident · 3 fatalLimited investigationFinal reportBeech 35-B33 · Sedona, AZThe pilot's inadequate compensation for the high wind conditions and wind shear encounter on final approach, that led to a failure to maintain an adequate airspeed and a stall.Apr 15, 2007 · N9556Y · DestroyedNTSB LAX07LA037Accident · 1 fatalLimited investigationFinal reportBeechcraft J35 · Flagstaff, AZThe pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.Nov 18, 2006 · N8246D · Substantial damageNTSB CHI06FA264Accident · 1 fatalField investigationFinal reportBeech BE-95-B55 · N. Sioux City, SDThe pilot's failure to maintain control of the airplane during cruise flight, and subsequent inadvertent flat spin from which he could not recover. Contributing to the accident were clouds, turbulence, and rain showers.Sep 22, 2006 · N4JV · Substantial damageNTSB DEN06FA132Accident · 4 fatalField investigationFinal reportBeech 35-C33 · Telluride, COThe pilot's inadvertent flight into mountain wave turbulence resulting in the airplane's loss of control and subsequent impact into mountainous terrain. Factors contributing to the accident were the mountain wave turbulence and high winds.Sep 15, 2006 · N5893J · DestroyedNTSB DFW06FA205Accident · 1 fatalField investigationFinal reportBeech BE95 A-55 · McGregor, TXThe pilot's failure to maintain airspeed resulting in a stall and loss of control of the airplane.Sep 2, 2006 · N181Y · DestroyedNTSB NYC06FA162Accident · 2 fatalField investigationFinal reportCessna 310D · Sutton, WVThe pilot's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/mush. A factor associated with the accident was the inadvertent stall/mush.Jun 30, 2006 · N6867T · DestroyedNTSB CHI06MA115Accident · 1 fatalMajor investigationFinal reportCessna 210A · Ludville, GAThe pilot's failure to obtain updated en route weather information, which resulted in his continued instrument flight into a widespread area of severe convective activity, and the air traffic controller's failure to provide adverse weather avoidance…Apr 19, 2006 · N6579X · DestroyedNTSB SEA06FA036Accident · 1 fatalField investigationFinal reportBeech 35-A33 · Heber City, UTThe pilot's continued VFR flight into IMC and his subsequent failure to maintain terrain clearance while maneuvering resulting in an in-flight collision with terrain. Contributing factors were low ceilings, snow, and mountainous terrain.Jan 2, 2006 · N1254Z · Substantial damageNTSB LAX06FA049Accident · 1 fatalField investigationFinal reportNavion G · Imperial, CAThe pilot's failure to maintain clearance from a tree and transmission wires while performing a low altitude maneuver. Also causal was the pilot's impaired judgment and performance due to alcohol ingestion.Nov 29, 2005 · N2455T · DestroyedNTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.Nov 18, 2005 · N9928H · DestroyedNTSB DEN05LA117Accident · 1 fatalLimited investigationFinal reportBellanca 14-19-3 · Grand Junction, COA loss of engine power due to fuel starvation as a result of the improper fuel selector position. Factors contributing to the accident were the inadvertent stall, the ravine, and the steep drop off embankment.Jul 30, 2005 · N8870R · Substantial damage