NTSB investigations: Continental IO-550 series

464 cases on aircraft whose registry engine model is Continental IO-550 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042'))
  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 SEA05FA038Accident · 3 fatalField investigationFinal reportCirrus SR22 · Hood River, ORThe pilot's failure to maintain terrain clearance. Contributing factors were the mountainous terrain, the low ceiling weather conditions, and dark night light conditions.Jan 21, 2005 · N6057M · DestroyedNTSB IAD05FA032Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Coconut Creek, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent to the ground. Factors included an avionics failure, pilot disorientation, and instrument meteorological conditions. A factor in the severity of the impact was the…Jan 15, 2005 · N889JB · DestroyedNTSB SEA05FA023Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Belgrade, MTThe pilot's failure to maintain altitude/clearance while maneuvering in mountainous terrain, which resulted in an inflight collision with trees and terrain. Contributing factors were the mountainous terrain and the downdraft.Dec 4, 2004 · N1159C · DestroyedNTSB DEN05LA028Accident · No injuriesLimited investigationFinal reportFarrell Lancair LC3 · Las Cruces, NMthe pilot's failure to maintain directional control during takeoff.Nov 20, 2004 · N41MF · Substantial damageNTSB ATL05IA025Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Peachtree City, GAThe failure of maintenance personnel to properly torque a fuel line fitting, which resulted in a fuel leak and in-flight engine fire.Nov 16, 2004 · N723CD · Minor damageNTSB CHI05FA020Accident · 3 fatalField investigationFinal reportBeech A36 · Downing, MOThe pilot not maintaing airplane control during cruise flight. Factors present were night and thunderstorm conditions.Oct 30, 2004 · N55448 · DestroyedNTSB DEN05LA022Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pueblo, COThe pilot’s inadequate compensation for wind and his failure to maintain aircraft control which resulted in a gear collapse due to an on-ground collision with terrain. Contributing factors were the wind shear, gusty wind conditions, and rough terrain. This…Oct 29, 2004 · N203RF · Substantial damageNTSB CHI05CA007Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Port Austin, MIThe pilot's excessive airspeed during landing resulting in the airplane exiting the end of the wet turf runway. Factors were the wind gusts, the wet grass, the reported airplane braking not being possible on the wet grass, and the impacted fence.Oct 16, 2004 · N555MN · Substantial damageNTSB NYC04LA213Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Somerville, NJThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's impairment due to the influence of non-prescribed pain medication.Sep 15, 2004 · N29BF · Substantial damageNTSB NYC04LA209Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Oxford, CTThe pilot's improper recovery from a bounced landing.Sep 12, 2004 · N579AL · Substantial damageNTSB CHI04FA255Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Park Falls, WIThe flightcrew's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with water during approach. The low altitude was a factor in the accident.Sep 10, 2004 · N1223S · DestroyedNTSB CHI04CA230Accident · No injuriesData collectionFinal reportBowles Questair Venture · Liberal, KSThe loss of directional control during landing for undetermined reasons.Aug 18, 2004 · N39SB · Substantial damageNTSB ANC04LA090Accident · No injuriesLimited investigationFinal reportCessna 185F · Wasilla, AKThe pilot's failure to compensate for a crosswind during landing and his failure to maintain directional control, which resulted in a loss of control and collision with a ditch. A factor contributing to the accident was a crosswind.Aug 8, 2004 · N61609 · Substantial damageNTSB CHI04FA203Accident · 1 fatalField investigationFinal reportKnoepflein Lancair Legacy 2000 · Madison, WIA loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…Aug 1, 2004 · N98SN · DestroyedNTSB SEA04LA124Accident · No injuriesLimited investigationFinal reportMooney M20R · Hailey, IDThe pilot's improper flare, failure to maintain directional control, and inadequate remedial action, which resulted in the airplane impacting a taxiway sign along the side of the runway. A factor contributing to the accident was the taxiway sign.Jul 6, 2004 · N1054K · Substantial damageNTSB CHI04LA187Accident · No injuriesLimited investigationFinal reportBeech A36 · Algona, IAThe failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…Jul 2, 2004 · N3248T · Substantial damageNTSB LAX04LA266Accident · No injuriesLimited investigationFinal reportLancair LC-40-550FG · Show Low, AZthe pilot's failure to maintain directional control of the airplane during landing after encountering a dust devil.Jun 25, 2004 · N6505L · Substantial damageNTSB FTW04CA177Accident · No injuriesData collectionFinal reportMooney M20R · Kerrville, TXThe pilot's failure to compensate for existing wind conditions. Contributing factors were the gusty high winds.Jun 24, 2004 · N9147H · Substantial damageNTSB CHI04LA129Accident · 3 fatalLimited investigationFinal reportHall Lancair IV-P · Vermontville, MIThe failure of Air Route Traffic Control Center controllers to provide adverse weather avoidance assistance as required by FAA directives, which led to the airplane's encounter with a thunderstorm and subsequent loss of control. Contributing to the accident…May 31, 2004 · N707SH · DestroyedNTSB LAX04LA227Accident · No injuriesLimited investigationFinal reportBeech A36 · Hollister, CAthe pilot's inadequate preflight inspection which failed to detect the mis-rigged elevator trim system, and the pilot's delay in aborting the takeoff.May 30, 2004 · N6797Y · Substantial damageNTSB NYC04CA135Accident · No injuriesData collectionFinal reportMooney M20R · Warren, VTThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the wind shear as reported by the pilot.May 29, 2004 · N53WM · Substantial damageNTSB LAX04LA213Accident · 4 fatalLimited investigationFinal reportBachman Lancair IV-P · Supai, AZthe loss of aircraft control while in cruise flight for undetermined reasons.May 16, 2004 · N299SD · DestroyedNTSB ATL04LA097Accident · 1 fatalLimited investigationFinal reportDurr Lancair Legacy · Oakland, TNThe pilot loss control of the airplane when he continued flight into known thunderstorm and convective activity. A factor is insufficient information provided by ATC personnel.Apr 23, 2004 · N511WD · DestroyedNTSB MIA04LA070Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · N. Lauderdale, FLThe erratic operation of the pitot-static system associated flight instruments due to water contamination, and the pilot's failure to take the appropriate corrective actions.Apr 10, 2004 · N916LJ · Substantial damageNTSB FTW04LA092Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Conroe, TXThe loss of engine power due to the improper fuel type. Contributing factors were the improper aircraft servicing, lack of training by the fixed base operator, and the low cloud ceiling.Mar 15, 2004 · N789SA · Substantial damageNTSB SEA04LA040Accident · No injuriesLimited investigationFinal reportLancair LC42-550FG · Redmond, ORThe pilot rated passenger's failure to maintain directional control during the landing roll. Inadequate supervision by the pilot-in-command (CFI) and a taxiway sign were factors.Feb 10, 2004 · N6503C · Substantial damageNTSB DEN04LA040Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's improper in-flight planning/decision making and his failure to maintain adequate airspeed which resulted in fuel starvation/exhaustion and a stall spin.Jan 23, 2004 · N8240U · Substantial damageNTSB NYC04LA061Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · College Park, MDThe loss of hydraulic fluid due to chaffing of a brake line by a strut fairing rivet, resulting in the failure of the braking system.Jan 22, 2004 · N344CD · Substantial damageNTSB FTW04LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20R · Sheridan, ARThe loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel tank selector. A factor was the lack of suitable terrain for the forced landing.Jan 1, 2004 · N5284C · Substantial damageNTSB ATL04LA060Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · King, NCA loss of engine power for undetermined reasons and the pilot's failure to maintain a visual lookout and obstacle clearance while performing a simulated engine out resulting in an in-flight-collision with a power line and the ground.Dec 27, 2003 · N742CD · Substantial damageNTSB LAX04LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Lancaster, CAA loss of engine power due to thermal fatigue failure of the first stage turbine wheel resulting in release of a section of its rim. The thermal fatigue was due to the engine exceeding its temperature limits during one or more start cycles.Oct 16, 2003 · N700TT · Substantial damageNTSB ATL04WA042Accident · 4 fatalForeign investigationCirrus Design SR-22 · Pamplona, SpainOct 12, 2003 · N100BR · Substantial damageNTSB CHI03LA325Accident · No injuriesLimited investigationFinal reportBrice Lancair Legacy · Kimberling City, MOThe pilot's delayed aborted takeoff. Contributing to the accident was the pilot's inadequate preflight planning/preparation in his failure to remove the pitot cover.Sep 19, 2003 · N27RM · Substantial damageNTSB NYC03CA188Accident · No injuriesData collectionFinal reportLancair IVP · Manassas, VAThe pilot's failure to follow the published takeoff procedures for the make and model airplane and his failure to maintain directional control during takeoff.Sep 2, 2003 · N789HS · Substantial damageNTSB LAX03LA275Accident · 2 fatalLimited investigationFinal reportBacon Questair #20 Venture · Carefree, AZThe pilot's misjudgment of speed/distance and his failure to do a go-around. Also causal was the pilot's failure to maintain directional control, and his delay aborting the landing.Sep 2, 2003 · N29G · DestroyedNTSB CHI03LA143Accident · No injuriesLimited investigationFinal reportMooney M20S · West Chicago, ILThe pilot's improper flare, and the pilot's failure to maintain directional control. Contributing factors were the pilot's improper flare and his inadequate recovery from a bounced landing.Jun 2, 2003 · N21737 · Substantial damageNTSB ATL03LA094Accident · 4 fatalLimited investigationFinal reportKerner Lancair IV · Allendale, SCThe pilot's inadvertent flight into adverse weather ,thunderstorms, that resulted in the design limits of the airplane being exceeded.May 16, 2003 · N29ME · DestroyedNTSB IAD03FA050Accident · 2 fatalField investigationFinal reportBeech A36 · Jackson, OHThe flight instructor's improper decision to turn back to the airport at an insufficient altitude after takeoff and his failure to maintain adequate airspeed, during a simulated engine failure.Apr 26, 2003 · N523BL · Substantial damageNTSB CHI03LA116Accident · No injuriesLimited investigationFinal reportWalker Lancair IV · Wamego, KSThe pilot not maintaining altitude/clearance from the runway while maneuvering on final approach. A factor to the accident was the pilot's misjudgment of his altitude while on final approach.Apr 26, 2003 · N7441W · Substantial damageNTSB LAX03FA135Accident · 3 fatalField investigationFinal reportBeech A36 · Sedona, AZa partial loss of engine power due to the certified flight instructor's failure to comply with the pilot operating handbook requirements for the mixture setting during takeoff. Also causal was the instructor's inadequate supervision of the flight, failure to…Apr 13, 2003 · N323D · DestroyedNTSB DEN03LA056Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's premature liftoff resulting in his failure to attain airspeed and achieve takeoff climb. Contributing factors were the runway light and taxiway sign.Mar 24, 2003 · N435P · Substantial damageNTSB IAD03FA039Accident · 1 fatalField investigationFinal reportMooney M20R · Leesburg, VAThe pilot's failure to maintain control of the airplane while on final approach for undetermined reasons.Mar 21, 2003 · N1005P · DestroyedNTSB CHI03LA063Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot's failure to maintain aircraft control which resulted in the overload of the aircraft. Spatial disorientation, an inoperative turn coordinator, and the pilot's misinterpretation of the flight instruments were contributing factors.Feb 1, 2003 · N5677X · Substantial damageNTSB CHI03FA057Accident · 2 fatalField investigationFinal reportCirrus Design SR-22 · Hill City, MNSpatial disorientation experienced by the pilot, due to a lack of visual references, and a failure to maintain altitude. Contributing factors were the pilot's improper decision to attempt flight into marginal VFR conditions, his inadvertent flight into…Jan 18, 2003 · N9523P · DestroyedNTSB MIA03LA028Accident · No injuriesLimited investigationFinal reportBeech A36 · Laurens, SCImproper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation…Dec 15, 2002 · N12MB · Substantial damageNTSB MIA03FA025Accident · 2 fatalField investigationFinal reportRaytheon 58 · Fort Myers, FLthe pilot's spatial disorientation during instrument meteorological conditions, which resulted in his failure to maintain aircraft control. Contributing factors included the pilot's distraction to the low fuel status and the low cloud conditions.Dec 6, 2002 · N241JG · DestroyedNTSB NYC03LA019Accident · 2 fatalLimited investigationFinal reportMooney M20R · Vineyard Haven, MAThe pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.Nov 13, 2002 · N2165Y · DestroyedNTSB FTW03LA005Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Lewisville, TXThe improper reinstallation of the left aileron by maintenance personnel. A contributing factor was the non-suitable terrain for the forced landing.Oct 3, 2002 · N1223S · Substantial damageNTSB ATL02FA171Accident · 2 fatalField investigationFinal reportMooney M20R · Burnsville, NCThe pilot's failure to maintain airspeed during final approach, which resulted in an inadvertent stall and uncontrolled descent into trees and terrain. Factors were wind gusts and terrain-induced turbulence.Sep 20, 2002 · N574DJ · DestroyedNTSB LAX02FA278Accident · 1 fatalField investigationFinal reportBeech A36 · Grand Canyon, AZthe pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed which resulted in an encounter with adverse weather conditions and the loss of control due to a stall. Contributing factors were thunderstorm related turbulence,…Sep 8, 2002 · N8261J · Destroyed