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.

NTSB CEN18LA321Accident · Minor injuriesLimited investigationFinal reportCessna A188 · Sedalia, MOA total loss of engine power during low-altitude maneuvering for reasons that could not be determined due to postimpact fire damage.Aug 6, 2018 · N4996R · DestroyedNTSB CEN18LA302Accident · No injuriesLimited investigationFinal reportBeech A36 · Brainerd, MNTotal loss of engine power due to a fuel supply interruption from the left tank for reasons that could not be determined, which resulted in the subsequent forced landing into trees.Jul 30, 2018 · N1856W · Substantial damageNTSB CEN18LA276Accident · No injuriesLimited investigationFinal reportBeech V35 · Katy, TXMaintenance personnel’s failure to remove a paper towel from the engine during recent maintenance, which resulted in oil starvation, the failure of a connecting rod, and a catastrophic engine failure and subsequent total loss of engine power.Jul 17, 2018 · N228Q · Substantial damageNTSB CEN18IA273Incident · No injuriesIncident investigationFinal reportCessna A188B · Rockford, OHThe total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.Jul 12, 2018 · N2483J · Minor damageNTSB GAA18CA388Accident · Minor injuriesData collectionFinal reportCessna A185 · Miami, FLThe pilot’s failure to retract the wheels of the amphibious airplane on takeoff, which resulted in a nose-over when the airplane landed on water with the wheels extended. Contributing to the accident was the pilot’s failure to use appropriate checklists.Jul 1, 2018 · N14ED · Substantial damageNTSB GAA18CA374Accident · No injuriesData collectionFinal reportBeech V35B · Chester, CTThe pilot’s failure to maintain clearance from a hangar during taxi.Jun 21, 2018 · N6KG · Substantial damageNTSB CEN18LA229Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Desdemona, TXThe total loss of engine power due to the fuel pump’s fuel flow setting being set too high, which resulted in an excessive fuel flow to the engine.Jun 17, 2018 · N6107R · Substantial damageNTSB WPR18LA209Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Fort Lauderdale, FLThe failure of the left starter relay, which resulted in a loss of electrical power during the flight and the failure of the T-handle from the cable led to a forced landing with the landing gear retracted.Jun 14, 2018 · N322HA · Substantial damageNTSB ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.Jun 13, 2018 · N9423B · 2 aircraft · Substantial damageNTSB GAA18CA344Accident · No injuriesData collectionFinal reportBeech A36 · Arcadia, FLThe pilot’s loss of directional control during landing due to a flat tire.Jun 11, 2018 · N4198S · Substantial damageNTSB CEN18LA213Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Uvalde, TXThe loose oil filter, which resulted in oil starvation and a total loss of engine power in flight.Jun 7, 2018 · N3291X · DestroyedNTSB GAA18CA335Accident · No injuriesData collectionFinal reportBeech A36 · Gilliam, LAThe pilot’s exceedance of the airplane’s critical angle of attack during a soft-field takeoff, which resulted in an aerodynamic stall.Jun 6, 2018 · N710JT · Substantial damageNTSB GAA18CA349Accident · No injuriesData collectionFinal reportBeech F33A · Martinsville, VAThe airplane’s collision with a deer during takeoff.Jun 1, 2018 · N5554X · Substantial damageNTSB ANC18LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Ramona, CAThe failure of the engine-driven hydraulic pump due to the installation of improper cap screws, which resulted in a gap in the pump housing, a subsequent hydraulic leak, and the landing gear collapsing.Jun 1, 2018 · N9410M · Substantial damageNTSB WPR18LA156Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tonopah, NVThe pilot's failure to properly lean the fuel/air mixture and to monitor critical engine parameters during the en route climb to cruise level, which resulted in excessive engine heat and oil starvation and the subsequent catastrophic engine failure.May 30, 2018 · N191HL · Substantial damageNTSB GAA18CA304Accident · No injuriesData collectionFinal reportBeech 58 · Gainesville, GAThe pilot’s failure to maintain a proper landing flare in gusting crosswind conditions.May 6, 2018 · N406PA · Substantial damageNTSB GAA18CA256Accident · No injuriesData collectionFinal reportCessna A185 · Chandler, AZThe pilot’s failure to maintain directional control during landing in gusting tailwind conditions.May 5, 2018 · N76SC · Substantial damageNTSB CEN18LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · Shullsburg, WIA catastrophic engine failure due to improper torque on the engine through-bolt nuts, which resulted in relative movement between the crankcase halves, damage to a main journal bearing, and a loss of oil lubrication.May 5, 2018 · N36LP · Substantial damageNTSB ERA18WA143Accident · 3 fatalForeign investigationCessna U206F · Trelawny, JamaicaThe government of Jamaica has notified the NTSB of an accident involving a CESSNA U206F airplane that occurred on May 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jamaica's investigation under the provisions of…May 4, 2018 · N8281Q · Substantial damageNTSB GAA18CA211Accident · No injuriesData collectionFinal reportCessna A185 · Sterling, AKThe pilot’s failure to maintain clearance from trees during the approach to land due to the sun glare.Apr 12, 2018 · N8702Z · Substantial damageNTSB ERA18FA114Accident · 2 fatalField investigationFinal reportBeech V35 · Hydro, OKThe pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure…Mar 26, 2018 · N7019N · DestroyedNTSB CEN18LA128Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe landing gear collapse due to the separation of the end fitting bolt for reasons that could not be determined based on the available evidence.Mar 22, 2018 · N372WP · Substantial damageNTSB ERA18LA111Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelburne, VTThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Mar 16, 2018 · N761DV · Substantial damageNTSB GAA18CA154Accident · No injuriesData collectionFinal reportCessna 207 · Newtok, AKThe pilot’s failure to maintain directional control during takeoff. Contributing to the accident was the pilot’s failure to properly check that the flight controls were correctly configured before takeoff.Feb 25, 2018 · N1658U · Substantial damageNTSB CEN18FA108Accident · 2 fatalField investigationFinal reportBeech 58 · Ulysses, KSAn inflight loss of control and collision with terrain for reasons that could not be determined.Feb 23, 2018 · N678DD · DestroyedNTSB ERA18WA217Accident · 1 fatalForeign investigationCessna A188 · La Vega, Dominican RepublicThe government of the Dominican Republic has notified the NTSB of an accident involving a Cessna A188B airplane that occurred on February 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…Feb 14, 2018 · N2451J · Substantial damageNTSB CEN18LA084Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Abilene, TXMaintenance personnel’s improper maintenance of the engine, which resulted in a catastrophic engine failure due the shifting/slipping of the No. 2 bearing and the subsequent oil starvation and total loss of engine power during cruise flight.Jan 22, 2018 · N3600A · Substantial damageNTSB GAA18CA115Accident · No injuriesData collectionFinal reportCessna 210 · Sussex, NJThe pilot’s inadvertent landing gear retraction during approach.Jan 21, 2018 · N884KM · DestroyedNTSB GAA18CA106Accident · No injuriesData collectionFinal reportCessna A185 · Lowman, IDThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of directional control.Jan 12, 2018 · N2W · Substantial damageNTSB WPR18LA058Accident · No injuriesLimited investigationFinal reportCessna 210 · San Bernardino, CAThe fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…Dec 30, 2017 · N222AT · Substantial damageNTSB ANC18FA012Accident · 2 fatalField investigationFinal reportCessna U206 · Maunaloa, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions while conducting an instrument approach, which resulted in a loss of visual reference and subsequent controlled flight into terrain.Dec 10, 2017 · N732DF · DestroyedNTSB ERA18FA046Accident · 5 fatalField investigationFinal reportBeech 58 · St. CroixThe non-multiengine rated pilot's failure to maintain airplane control during a single-engine approach. Contributing to the accident was a total loss of engine power on the left engine due to detonation for reasons that could not be determined based on the…Dec 8, 2017 · N4494A · DestroyedNTSB WPR18LA043Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Rio Oso, CAAn in-flight fire due to electrical arc corrosion of the fuel line.Dec 4, 2017 · N251E · Substantial damageNTSB CEN18FA023Accident · 2 fatalField investigationFinal reportBeech V35B · Alva, OKThe flight instructor's and pilot's failure to recognize that a high descent rate had developed on short final, likely due to their distraction by an open engine cowling, and the unexpected strong pitch-down force during flap extension due to the installation…Nov 4, 2017 · N777PH · DestroyedNTSB GAA18CA023Accident · No injuriesData collectionFinal reportCessna A185 · Tacoma, WAThe pilot’s loss of directional control during the landing roll.Oct 24, 2017 · N19EC · Substantial damageNTSB CEN18LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sweetwater, TXThe loss of engine power during a precautionary approach for landing for reasons that could not be determined based on the available information.Oct 6, 2017 · N8234R · Substantial damageNTSB CEN17LA357Accident · Minor injuriesLimited investigationFinal reportBeech A36 · McAlester, OKA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.Sep 15, 2017 · N18403 · Substantial damageNTSB CEN17LA352Accident · No injuriesLimited investigationFinal reportCessna 210G · Hallsville, MOThe total loss of engine power due to a fatigue failure of the engine mixture control cable.Sep 13, 2017 · N5906F · Substantial damageNTSB GAA17CA549Accident · No injuriesData collectionFinal reportCessna U206 · Chicken, AKThe pilot’s failure to maintain clearance from a sign while taking off from a road.Sep 5, 2017 · N734GW · Substantial damageNTSB ANC17LA053Accident · No injuriesLimited investigationFinal reportCessna U206G · Kodiak, AK***This probable cause was modified on November 27, 2018. Please see the docket for this accident to view the original probable cause.*** The pilot's improper decision to takeoff in an area of rough water and ocean swells, which resulted in a failure of the…Sep 4, 2017 · N16GP · Substantial damageNTSB ERA17LA307Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206 · Harpswell, MEA total loss of engine power due to maintenance personnel's failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1, 2, and 3 main bearings, loss of lubrication, and failure of the crankshaft.Sep 1, 2017 · N4615X · Substantial damageNTSB GAA17CA497Accident · No injuriesData collectionFinal reportBeech A36 · Loman, IDThe pilot’s inadequate compensation for a tailwind, which resulted in a runway overrun.Aug 19, 2017 · N136BJ · Substantial damageNTSB ANC17LA052Accident · No injuriesLimited investigationFinal reportCessna A185 · Aniak, AKThe pilot's inadequate preflight inspection, which failed to detect a crack in the propeller blade, which led to the separation of a section of a propeller blade due to fatigue.Aug 18, 2017 · N92DC · Substantial damageNTSB CEN17LA328Accident · No injuriesLimited investigationFinal reportBeech A36 · Gonzales, LAA partial loss of engine power due to inadequate maintenance, including worn spark plugs and a leaking fuel hose fitting.Aug 17, 2017 · N48TZ · Substantial damageNTSB CEN17LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Marshall, MOThe pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…Aug 4, 2017 · N3047J · Substantial damageNTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.Jul 26, 2017 · N208SS · Substantial damageNTSB GAA17CA432Accident · No injuriesData collectionFinal reportCessna TU206B · Sandy, ORThe pilot’s improper bank control during landing in gusting wind conditions.Jul 23, 2017 · N10AR · Substantial damageNTSB GAA17CA439Accident · No injuriesData collectionFinal reportCessna A185 · Arctic Village, AKThe pilot’s failure to maintain directional control after an aborted takeoff.Jul 22, 2017 · N5227R · Substantial damageNTSB ANC17LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Wasilla, AKThe pilot’s failure to manage fuel quantity in flight, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow manufacturer guidance for restoring engine power after emptying a fuel…Jul 16, 2017 · N401WC · Substantial damageNTSB WPR17LA154Accident · No injuriesClass 3 · LimitedFinal reportBeech D55 · Hailey, IDThe pilot’s loss of directional control during landing.Jul 14, 2017 · N1796A · Substantial damage