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 MIA07CA101Accident · No injuriesData collectionFinal reportMooney M20R · Carthage, NCThe delay by the pilot-in-command to recover from a bounced landing resulting in a hard landing and subsequent collapse of the nose and left main landing gears.May 24, 2007 · N904MM · Substantial damageNTSB ATL07FA077Accident · 5 fatalField investigationFinal reportBeech 58 · Hamilton, GAThe pilot's exceeding the design stress limits of the airplane while performing aerobatics in a nonaerobatic airplane, which resulted in an in-flight overload failure of the airframe. A factor in the accident was the pilot's decision to perform aerobatics.Apr 22, 2007 · N5647C · DestroyedNTSB ATL07CA049Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Ocraacoke, NCThe pilot's improper use of the aileron and rudder controls and inadequate compensation for the wind conditions during a crosswind landing resulting in a loss of directional control.Mar 11, 2007 · N313L · Substantial damageNTSB NYC07CA074Accident · No injuriesData collectionFinal reportMooney M20R · Marshfield, MAA loss of directional control for undetermined reasons.Mar 9, 2007 · N323RW · DestroyedNTSB SEA07CA064Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Glen Canyon Nat, UTThe pilot's intentional flight over water at low altitude and his subsequent failure to maintain adequate clearance from the water. A contributing factor was the glassy surface condition of the lake.Feb 24, 2007 · N224MT · Substantial damageNTSB ATL07LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Brunswick, GAThe pilot's failure to activate the electric fuel pump following a loss of engine power for undetermined reasons.Feb 9, 2007 · N315P · Substantial damageNTSB DEN07LA049Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMThe pilot-rated dual student's failure to maintain sufficient airspeed during the landing approach to avoid a stall. Also causal was the flight instructor's failure to provide adequate supervision. Factors associated with the accident are an inadvertent…Jan 12, 2007 · N8183E · Substantial damageNTSB LAX07FA062Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Young, AZThe pilot's failure to maintain terrain clearance during cruise flight while flying at night at an altitude to remain clear of clouds and icing conditions. Contributing to the accident were an inadequate weather evaluation, the clouds, icing conditions, and…Dec 19, 2006 · N457S · DestroyedNTSB DFW07FA041Accident · 1 fatalField investigationFinal reportBeech A36 · Fayetteville, ARThe pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.Dec 19, 2006 · N1100J · DestroyedNTSB NYC07FA041Accident · 1 fatalField investigationFinal reportMooney M20R · Summersville, WVThe airplane's encounter with in-flight icing, which resulted in a loss of engine power. Contributing to the accident were the pilot's improper weather evaluation, the in-flight icing conditions, the reduced visibility from a snow squall during the forced…Dec 7, 2006 · N9165T · DestroyedNTSB ATL07FA013Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Statesville, NCThe pilot's failure to maintain airspeed while maneuvering with a low ceiling in instrument flight conditions, resulting in an inadvertent stall, and collision with trees and the ground. Factors in the accident were the pilot's failure to follow the published…Oct 27, 2006 · N969ES · Substantial damageNTSB LAX07FA021Accident · 4 fatalField investigationFinal reportCirrus SR22 · Meadview, AZThe pilot's inadequate weather evaluation and continued flight into forecasted icing conditions. Contributing to the severity of the accident was the pilot's failure to follow proper operating procedures and deploy the CAPS when the airplane entered a spin.…Oct 25, 2006 · N121LD · DestroyedNTSB NYC07CA010Accident · No injuriesData collectionFinal reportCirrus SR-22 · Lumberton, NJThe pilot's failure to maintain aircraft control during a go-around, which resulted in an in-flight collision with a tree.Oct 19, 2006 · N246MT · Substantial damageNTSB DFW06LA216Accident · 1 fatalLimited investigationFinal reportWeber Venture · El Paso, TXThe aircraft's inadequate landing gear design, which resulted in a loss of directional control and subsequent nose-over. A factor was the owner/builder's failure to incorporate modifications to the landing gear.Sep 28, 2006 · N5QE · Substantial damageNTSB CHI06FA269Accident · 1 fatalField investigationFinal reportCessna 182Q · Cumberland, WIThe pilot's inadvertent attempt to land on water with the wheels down and his failure to verify the gear position prior to landing. Contributing factors were the inoperative gear system due to the open gear selector circuit breaker, which tripped for…Sep 24, 2006 · N97435 · Substantial damageNTSB MIA06WA137Incident · No injuriesForeign investigationCirrus Design SR22 · Bull Bay, JamaicaSep 22, 2006 · N181LM · Minor damageNTSB CHI06CA267Accident · No injuriesData collectionFinal reportColumbia 350 · Bloomington, INThe pilot did not comply with the pilot operating handbook warning when he intentionally opened the cabin door during flight.Sep 15, 2006 · N6500V · Substantial damageNTSB CHI06LA243Accident · 1 fatalLimited investigationFinal reportFrick Questair Q20 · Big Rapids, MIThe pilot's failure to ensure an adequate fuel supply, which resulted in the exhaustion of the fuel supply and the subsequent loss of engine power. The trees that the airplane struck during the forced landing were a factor.Aug 23, 2006 · N2QV · Substantial damageNTSB ANC06LA119Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Whittier, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with terrain while maneuvering to reverse direction in a pass. A factor contributing to the accident was clouds in the pass.Aug 19, 2006 · N4975U · Substantial damageNTSB NYC06WA203Accident · No injuriesForeign investigationCirrus SR-22 · Ligure Sea, ItalyAug 12, 2006 · N357MV · Substantial damageNTSB CHI06FA218Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Boyceville, WIThe pilot's failure to maintain adequate airspeed and the certified flight instructor's delayed remedial action and inadequate supervision of the flight training, which resulted in an inadvertent stall during a base to final turn to the landing runway. An…Aug 5, 2006 · N658CD · Substantial damageNTSB CHI06FA186Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Edgewater, MDThe pilot' failure to maintain sufficient airspeed which resulted in a stall. A factor was the pilots failure to properly set the flaps for the go-around.Jul 11, 2006 · N8163Q · DestroyedNTSB LAX06FA222Accident · 2 fatalField investigationFinal reportRaytheon A36 · Somis, CAa ground collision during an emergency landing for undetermined reasons.Jul 1, 2006 · N615M · DestroyedNTSB CHI06CA133Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Verdigre, NEThe pilot's decision to land on a wet grass runway that had insufficient length available for landing roll. An additional cause was the pilot's failure to properly retract the flaps during the aborted landing, resulting in diminished climb performance and the…May 20, 2006 · N814SN · Substantial damageNTSB MIA06CA079Accident · No injuriesData collectionFinal reportMooney M20R · Destin, FLThe pilot's failure to maintain airspeed while attempting a go-around at a low altitude which resulted in an inadvertent stall/mush, an uncontrolled descent and an impact with terrain.Apr 5, 2006 · N4654M · Substantial damageNTSB LAX06CA128Accident · No injuriesData collectionFinal reportCirrus SR22 · Scottsdale, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.Mar 10, 2006 · N8141L · Substantial damageNTSB DFW06LA071Accident · Serious injuriesLimited investigationFinal reportHodge Express · Tyler, TXA loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Feb 16, 2006 · N410MP · DestroyedNTSB MIA06FA050Accident · 3 fatalField investigationFinal reportCirrus Design SR-22 · Stuart, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent and impact with the water. Contributing to the accident were a reported instrument failure, pilot disorientation, and instrument meteorological conditions. A factor in…Feb 4, 2006 · N667WP · DestroyedNTSB DEN06LA035Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe student pilot's improper flare, resulting in a hard landing. Contributing factors were the flight instructor's inadequate supervision of the pilot, and the dark night light conditions.Jan 26, 2006 · N1830V · Substantial damageNTSB NYC06CA058Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lincoln Park, NJThe pilot's failure to maintain directional control during an aborted landing.Jan 22, 2006 · N285MG · DestroyedNTSB ATL06LA035Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Childersburg, ALThe pilot's inadequate preflight planning, failure to obtain a current weather briefing, and his decision to operate the airplane into a known area of icing outside the airplanes certification standards resulting in the aircraft accumulating ice, a loss of…Jan 13, 2006 · N87HK · Substantial damageNTSB ATL06FA029Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Sylva, NCThe pilot's continued VFR flight into IMC conditions resulting in a collision with mountainous terrain.Dec 29, 2005 · N799TM · DestroyedNTSB SEA06LA026Accident · Serious injuriesLimited investigationFinal reportHitchens EDI 90FT · Chehalis, WAThe pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.Dec 11, 2005 · N900EH · Substantial damageNTSB CHI06FA043Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Arco, MNThe pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…Dec 11, 2005 · N621PH · DestroyedNTSB DFW06LA038Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXThe pilot's excessive taxi speed and his excessive use of brakes.Dec 9, 2005 · N302BY · Substantial damageNTSB DEN06FA013Accident · 1 fatalField investigationFinal reportBeech A36 · Datil, NMthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.Nov 8, 2005 · N1548Y · DestroyedNTSB DEN06FA010Accident · 2 fatalField investigationFinal reportLancair LC-40-550FG · Steamboat Spgns, COthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors include the pilot's lack of recent experience, the pilot's improper in-flight planning and decision making, the dark night and the mountainous terrain.Oct 23, 2005 · N101HK · DestroyedNTSB IAD05CA140Accident · No injuriesData collectionFinal reportBeech BE-36 · Farmingdale, NYThe pilot's improper recovery from a bounced landing.Sep 23, 2005 · N8014T · Substantial damageNTSB IAD05CA131Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Lincoln Park, NJThe pilot's failure to obtain the proper touchdown point during landing which resulted in a runway overrun. A factor was the pilot's misjudgment of speed/distance during the approach.Sep 5, 2005 · N209SL · Substantial damageNTSB SEA05CA143Accident · No injuriesData collectionFinal reportBeech A36 · Sequim, WAThe temporary loss of engine power for an undetermined reason during the takeoff initial climb.Jul 14, 2005 · N3119T · Substantial damageNTSB NYC05LA110Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-22 · Haverstraw, NYThe pilot's physiological condition, which resulted in his incapacitation during the flight, and subsequent loss of aircraft control.Jun 30, 2005 · N3452L · Substantial damageNTSB LAX05LA210Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Phoenix, AZthe pilot's delay in executing a timely go-around and failure to raise the flaps, which resulted in a collision with terrain.Jun 18, 2005 · N626Z · Substantial damageNTSB DFW05LA115Accident · No injuriesLimited investigationFinal reportLancair Legacy · Nacogdoches, TXThe loss of engine power for undetermined reasons.May 2, 2005 · N204RH · DestroyedNTSB SEA05CA078Accident · No injuriesData collectionFinal reportShannon Lancair Legacy 2000 · Bend, ORThe pilot's failure to put the landing gear down for landing.Apr 8, 2005 · N115YP · Substantial damageNTSB IAD05LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Rocky Hill, NJThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall, and subsequent impact with terrain. Factors included the night lighting conditions, and the airplane approaching the opposite runway.Apr 7, 2005 · N4398H · Substantial damageNTSB CHI05CA085Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Atkinson, NEThe pilot's failure to compensate for the wind condition which resulted in a loss of aircraft control while landing. A factor associated with the accident was the gusty crosswind condition that existed at the time of the accident.Apr 2, 2005 · N8150F · Substantial damageNTSB DEN05LA065Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's improper soft-field takeoff procedures and failure to maintain control of the aircraft. A contributing factor was the attempted aborted takeoff.Mar 30, 2005 · N1830V · Substantial damageNTSB DEN05CA062Accident · No injuriesData collectionFinal reportBeech A36 · Farmington, NMthe student pilot's failure to maintain airspeed which resulted in a stall and loss of control. Contributing factors were wind gusts, instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.Mar 15, 2005 · N435P · Substantial damageNTSB LAX05LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Half Moon Bay, CAThe pilot's excessive braking during taxi that resulted in the right brake overheating and a fire. A factor in the accident was the pilot's continued operation with known deficiencies.Mar 8, 2005 · N517SW · Substantial damageNTSB LAX05FA088Accident · 1 fatalField investigationFinal reportCirrus Design SR22 G2 · Norden, CAthe pilot's in-flight loss of control following an inadvertent encounter with unforecast severe icing conditions. A factor in the accident was the inaccurate icing forecast developed by the NWS Aviation Weather Center.Feb 7, 2005 · N286CD · Destroyed