NTSB investigations: Continental IO-520 series
4,750 cases on aircraft whose registry engine model is Continental IO-520 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 ('17032'))
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 ('17032'))
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 MIA02LA107Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Manteo, NCa total loss of engine power due to the failure of a connecting rod bolt because of fatigue, resulting in damage to the airplane during the subsequent ditching.NTSB LAX02WA195Accident · Minor injuriesForeign investigationBellanca 17-30A · Puertecitos, MexicoNTSB CHI02TA149Accident · No injuriesFinal reportCessna A185F · Necedah, WIDirectional control of the airplane not maintained by the pilot. The gusting winds was a contributing factor.NTSB ATL02IA112Incident · Minor injuriesIncident investigationFinal reportCessna 210L · Sarasota, FLThe pilot's failure to follow the before landing checklist and confirm that the landing gear was extended.NTSB MIA02FA102Accident · 1 fatalField investigationFinal reportBeech F33A · Conway, SCThe failure of the pilot to request in-flight weather avoidance assistance and his poor in-flight planning/decision for flying into a Level 5 thunderstorm resulting in an in-flight loss of control, uncontrolled descent, and subsequent in-flight collision with…NTSB WAS02WA044Accident · Minor injuriesForeign investigationCessna TU 206F · Swan River, CanadaNTSB LAX02LA175Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Willits, CAthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors in the accident were the pilot's failure to raise the flaps and the wind shear conditions.NTSB ANC02LA039Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate evaluation of weather conditions, which precipitated an in-flight loss of control and subsequent collision with terrain. A factor contributing to the accident was the tailwind.NTSB ATL02WA109Accident · 1 fatalForeign investigationCessna 210F · Grand Cayman, Cayman IslandsNTSB LAX02LA171Accident · No injuriesLimited investigationFinal reportCessna 206 · Mohave Valley, AZthe pilot's failure to maintain directional control.NTSB CHI02LA129Accident · Minor injuriesLimited investigationFinal reportCessna 210M · Watertown, MNThe improper fuel management by the pilot which resulted in fuel starvation and subsequent loss of engine power. Contributing to the accident was the soft terrain in which the forced landing was completed.NTSB CHI04LA124Accident · No injuriesLimited investigationFinal reportBeech 58 · Lansing, ILThe flight crew's failure to follow the checklist resulting in a landing without the landing gear extended.NTSB MIA02LA090Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Myakka City, FLthe pilot's failure to maintain altitude while maneuvering during an aerial application, subsequently resulting in impact with the terrain.NTSB CHI02LA124Accident · No injuriesLimited investigationFinal reportCessna 185F · Cumberland, WIthe failure of the pilot to maintain directional control after encountering high winds and gusty winds during taxi from landing.NTSB DEN02LA041Accident · No injuriesLimited investigationFinal reportCessna A185E · Greeley, COthe inadvertent ground loop during landing roll. A contributing factor was the partial brake system failure.NTSB IAD02LA041Accident · No injuriesLimited investigationFinal reportCessna U206F · Matinicus, MEA partially blocked fuel metering unit inlet screen, which resulted in a partial loss of engine power. Also causal, was the operator's lack of inlet screen inspection procedures.NTSB ATL02LA070Accident · No injuriesLimited investigationFinal reportCessna 210 · Naples, FLTotal loss of engine power due to improper maintenance by company maintenance personnel which allowed the mixture control linkage to disconnect in flight which resulted in an emergency descent to landing into unsuitable terrain.NTSB DEN02LA038Accident · No injuriesLimited investigationFinal reportCessna T337D · St. George, UTthe pilot's misjudged landing flare, which resulted in an inadvertent stall/mush and a hard landing.NTSB ANC02LA019Accident · No injuriesLimited investigationFinal reportCessna 207A · Kotlik, AKThe failure of the pilot-in-command to maintain the proper glide path to the runway during the final approach for a VFR landing.NTSB ATL02LA056Accident · No injuriesLimited investigationFinal reportCessna 210L · Atlanta, GAThe pilot's failure to obtain the proper touchdown point and excessive airspeed on landing resulting in the airplane going off the end of the runway, on-ground collision with an embankment, and subsequent nose over.NTSB LAX02LA091Accident · No injuriesLimited investigationFinal reportBeech V35 · San Jose, CAa loss of engine power for undetermined reasons, which resulted in a forced landing into a residential area.NTSB ANC02FA014Accident · 1 fatalField investigationFinal reportCessna 206 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate ground clearance, which resulted in an in flight collision with terrain. Factors associated with the accident were flat light conditions, and…NTSB NYC02FA055Accident · 2 fatalField investigationFinal reportBeech V35B · Chester, CTThe pilot's failure to maintain adequate airspeed during the turn to final, which resulted in an inadvertent stall/spin. Factors included low ceilings and night lighting conditions.NTSB DEN02LA023Accident · 1 fatalLimited investigationFinal reportBeech V35B · American Fork, UTThe pilot's poor judgment in that he intentionally initiated VFR flight into instrument meteorological conditions. Contributing factors were low ceiling and obscuration, and the pilot's lack of recent instrument time.NTSB CHI02LA070Accident · 2 fatalLimited investigationFinal reportBellanca 17-30A · Alexandria, MNThe pilot's disregard of the weather evaluation and his attempt to fly into known adverse weather without an instrument rating. Factors in the accident were the low ceiling, the low visibility, and the icing conditions.NTSB CHI02LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Bloomington, INThe pilot's inadequate recovery from a bounced landing which resulted in a hard contact with the runway. Factors associated with the accident were the improper flare and the crosswind condition.NTSB CHI02LA051Accident · No injuriesLimited investigationFinal reportBeech S35 · Angola, INThe pilot 's failure to maintain adequate airspeed and encountered a stall on approach to land. The low altitude on final approach was a factor.NTSB ATL02FA025Accident · 1 fatalField investigationFinal reportCessna C-210N · Lilburn, GAThe pilot's failure to maintain aircraft control.NTSB ATL02LA019Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Vero Beach, FLThe pilot's inadequate preflight fuel requirements for the flight, resulting in fuel exhaustion and the subsequent loss of engine power.NTSB LAX02LA052Accident · No injuriesLimited investigationFinal reportCessna 185F · Reno, NVWear on the tail wheel thrust plate spacers resulted in the compression springs binding on the thrust plates and the tail wheel sticking, so that the pilot could not maintain directional control.NTSB SEA02LA019Accident · No injuriesLimited investigationFinal reportCessna 310 · Sidney, MTThe pilot's improper abort procedure and inadequate remedial action, leading to a loss of directional control after losing power in one engine during the takeoff roll. Factors include the loss of power from one engine, and a fence around the perimeter of the…NTSB MIA02LA030Accident · No injuriesLimited investigationFinal reportBeech A36 · Milton, FLthe pilot's failure to properly manage the available fuel in all fuel tanks, which resulted in the loss of engine power due to fuel starvation, a forced landing, and damage to the aircraft when the proper touch down point was not attained.NTSB FTW02LA032Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Houston, TXthe failure of the left outboard elevator attachment, which resulted in the partial separation of the left elevator and induced an airframe vibration.NTSB CHI02LA028Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Nevada, MOThe inadequate fuel consumtion calculations by the pilot resulting in fuel starvation during the aborted landing, and the overloaded steering link for undetermined reasons resulting in the lack of directional control during landing. Factors were the…NTSB LAX02LA027Accident · No injuriesLimited investigationFinal reportCessna 210K · North Las Vegas, NVThe failure of maintenance personnel to properly diagnose the cause of a reported maintenance discrepancy resulting in the airplane being released from an annual inspection with a worn hydraulic pump which lacked sufficient output to operate the landing gear.…NTSB CHI02LA027Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Mounds View, MNFuel starvation caused by the pilot's improper positioning of the fuel tank fuel selector while in the traffic pattern, and the unsuitable terrain encountered during the forced landing. Factors relating to the accident were the pilot not complying with the…NTSB FTW02LA022Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Clarendon, TXthe loss of engine power for undetermined reasons. Contributing factors to the accident were the dark night light conditions and the lack of suitable terrain for the forced landing.NTSB CHI02FA009Accident · 1 fatalField investigationFinal reportBeech 58 · Dubuque, IAThe pilot continued flight into known adverse weather and disregarded the minimum descent altitude. Additional factors were the conditions conducive to pilot fatigue, fog, and night.NTSB ANC02LA006Accident · No injuriesLimited investigationFinal reportCessna 207A · Kobuk, AKThe pilot's failure to maintain adequate clearance from objects during the initial climb after takeoff, and subsequent collision with a tree. A factor was the presence of trees along the runway.NTSB LAX02LA011Accident · No injuriesLimited investigationFinal reportCessna A185E · Winnemucca, NVThe pilot's inadequate compensation for the wind conditions, failure to maintain directional control and use of excessive braking, which resulted in the airplane nosing over.NTSB ATL02LA015Accident · No injuriesLimited investigationFinal reportCessna 188B · Whiteville, TNThe failure of the engine driven fuel pump that contaminated the fuel system and restricted fuel flow to the engine.. A factor is rough/uneven terrain.NTSB FTW02LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Midlothian, TXthe pilot's failure to maintain control of the aircraft while taxiing from a landing. A contributing factor was the gusty wind conditions.NTSB IAD02FA002Accident · 2 fatalField investigationFinal reportCessna 210M · Pittsfield, PAThe pilot's loss of control in flight due to spatial disorientation, and his subsequent overstress of the airplane during a recovery attempt. A factor in the accident was the pilot's use of inappropriate medications.NTSB FTW02TA007Accident · No injuriesFinal reportCessna A185F · Houma, LAthe pilot's high flare, which resulted in a hard landing.NTSB ANC01LA147Accident · No injuriesLimited investigationFinal reportCessna 206 · Galena, AKThe pilot's inadequate preflight planning and preparation for takeoff from an off-airport, short field site. Factors associated with the accident are a variable wind, and the pilot's inadequate weather evaluation.NTSB ANC01LA143Accident · No injuriesLimited investigationFinal reportCessna U206 · Paxson, AKThe pilot's failure to maintain clearance from a sign while taxiing after landing in mixed rain and snow. Factors associated with the accident are reduced visibility conditions due to the snow and rain.NTSB ATL01LA112Accident · No injuriesLimited investigationFinal reportCessna 210K · Bessemer, ALFailure of the landing gear-down lock mechanism, which resulted in the pilot's inability to control the airplane. A factor was the trees.NTSB LAX01LA303Accident · 2 fatalLimited investigationFinal reportCessna P206B · Willits, CAthe failure of the pilot to reset the elevator trim tab during the go-around, which resulted in his failure to maintain airspeed and an inadvertent stall.NTSB SEA01FA167Accident · 3 fatalField investigationFinal reportBeech 58 · Ashland, ORThe pilot's failure to maintain clearance from the terrain after inadvertently entering an area of instrument meteorological conditions (IMC) during a visual flight rules (VFR) flight. Factors include mountainous/hilly terrain and low ceilings in the area…NTSB IAD01LA103Accident · No injuriesLimited investigationFinal reportCessna U206G · Millersburg, OHThe pilot's misjudgment of speed and distance, which resulted in an overrun during landing. Factors were the short, wet, grass runway, and his failure to do a go-around.