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 NYC05FA048Accident · 1 fatalField investigationFinal reportBeech V35B · Norwich, NYA loss of engine power for undetermined reasons.Feb 5, 2005 · N35JL · DestroyedNTSB CHI05FA063Accident · 4 fatalField investigationFinal reportBeech BE-58 · Niles, MIThe steep nose down descent from cruise for undetermined reasons and the subsequent collision with terrain in a steep nose down attitude.Feb 4, 2005 · N12AZ · DestroyedNTSB CHI05LA064Accident · No injuriesLimited investigationFinal reportCessna A185F · Minneapolis, MNA failure of the tail wheel locking mechanism which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.Feb 3, 2005 · N1767R · Substantial damageNTSB DFW05FA059Accident · 2 fatalField investigationFinal reportBeech BE-36 · Brownwood, TXThe pilots failure to maintain proper altitude and clearance while on final approach to land. Contributing factors were the pilot's lack of familiarity with the geographic area, the dark night light conditions, the non-availability of a visual approach glide…Jan 22, 2005 · N1750A · DestroyedNTSB ANC05TA022Accident · No injuriesFinal reportCessna 185 · Eek, AKThe pilot's inadequate evaluation of weather conditions, which resulted in an on ground encounter with terrain during the landing roll. Factors associated with the accident were a tailwind, and snow-covered, icy terrain conditions.Jan 19, 2005 · N9452N · Substantial damageNTSB SEA05FA037Accident · 2 fatalField investigationFinal reportAero Commander AC200D (Meyers) · Hatch, UTThe pilot's failure to maintain aircraft control while maneuvering. Inadequate airspeed, the pilot's diverted attention, and low altitude flight were factors.Jan 18, 2005 · N49J · Substantial damageNTSB SEA05LA036Accident · No injuriesLimited investigationFinal reportCessna U206F · Prevost, WAThe pilot not identifying unsafe landing conditions, and his subsequent intentional swerve during the landing roll resulting in impacting a ditch. Contributing factors were the ice/frost on the grass/dirt one-way runway (1,560 feet in length), the unexpected…Jan 14, 2005 · N8313Q · Substantial damageNTSB CHI05FA048Accident · 2 fatalField investigationFinal reportBeech S35 · Herman, WIThe installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…Dec 25, 2004 · N5631K · Substantial damageNTSB ANC05CA019Accident · No injuriesData collectionFinal reportCessna U206G · Illiamna, AKThe pilot's inadequate compensation for the gusty wind conditions, which resulted in a loss of control, and the airplane nosing over. A factor contributing to the accident was the gusty wind condition.Dec 24, 2004 · N9909Z · Substantial damageNTSB ANC05CA017Accident · No injuriesData collectionFinal reportCessna U206G · Nunapitchuk, AKThe pilot's inadequate compensation for gusty wind conditions, which resulted in a loss of directional control, and collision with a ditch. Factors contributing to the accident were an icy taxiway and wind gusts.Dec 16, 2004 · N496K · Substantial damageNTSB SEA05FA022Accident · 1 fatalField investigationFinal reportCessna 185F · Renton, WAThe pilot's failure to maintain aircraft control when the flaps became jammed/stuck in their full-down position during a takeoff from a touch-and-go landing. Factors include a worn/disconnected flap latch mechanism, and the flaps being unable to be retracted.Dec 5, 2004 · N532PC · DestroyedNTSB ATL05FA032Accident · 5 fatalField investigationFinal reportCessna 421B · Apison, TNThe pilot's improper identification of a partial loss of engine power on initial takeoff climb resulting in a collision with trees and the ground. A factor was a partial failure of the left engine starter adapter due to overload.Dec 2, 2004 · N421SD · DestroyedNTSB NYC05FA021Accident · 2 fatalField investigationFinal reportCessna 310R · Paeonian Spring, VAThe pilot's failure to follow the published instrument approach procedure, which resulted in an in-flight collision with terrain. A factor related to the accident was the low cloud ceiling.Nov 24, 2004 · N310DM · Substantial damageNTSB ANC05LA015Accident · No injuriesLimited investigationFinal reportCessna U206F · Bethel, AKThe pilot's inadequate evaluation of the weather conditions, and his inadequate compensation for the wind conditions, which resulted in a loss of control and subsequent nose over during taxi from landing. A factor contributing to the accident was a tailwind.Nov 19, 2004 · N9644G · Substantial damageNTSB LAX05FA034Accident · 2 fatalField investigationFinal reportBeech A36 · Lake Havasu, CAthe pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.Nov 14, 2004 · N6111C · DestroyedNTSB MIA05CA034Accident · No injuriesData collectionFinal reportBeech 58 · Fort Pierce, FLThe failure of the pilot to follow the checklist and extend the landing gear during landing resulting in a gear-up landing.Nov 7, 2004 · N4545M · Substantial damageNTSB LAX05CA016Accident · Minor injuriesData collectionFinal reportBellanca BL17-30 · Las Vegas, NVthe pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power.Oct 25, 2004 · N4894V · Substantial damageNTSB CHI05LA014Accident · 1 fatalLimited investigationFinal reportCessna P206B · Taylorville, ILAircraft control not possible by the pilot following a premature deployment of a parachute as a parachutist exited the jump airplane during cruise flight. The inverted spin encountered by the pilot was an additional cause.Oct 24, 2004 · N8619Z · DestroyedNTSB ATL05FA008Accident · 1 fatalField investigationFinal reportBeech F33A · Flat Rock, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. Factors were low ceilings and fog.Oct 23, 2004 · N18303 · Substantial damageNTSB SEA05LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185F · White Bird, IDThe pilot's failure to attain the proper airspeed for takeoff and his improper soft-field takeoff procedure. Factors contributing to the accident included the pilot's improper preflight planning, the fence, and the closed exhaust stack.Oct 17, 2004 · N101AM · Substantial damageNTSB DEN05LA008Accident · No injuriesLimited investigationFinal reportCessna 210M · Salida, COThe pilot's inadequate preflight planning which failed to determine the fuel supply was inadequate resulting in fuel exhaustion and the loss of engine power.Oct 10, 2004 · N732TE · Substantial damageNTSB ANC05CA004Accident · Serious injuriesData collectionFinal reportCessna 185F · King Salmon, AKThe pilot's failure to use a checklist, and to remove the flight control locks prior to flight, which resulted in an uncontrolled descent and in-flight collision with terrain/water.Oct 10, 2004 · N5001R · Substantial damageNTSB DEN05CA001Accident · No injuriesData collectionFinal reportCessna 185F · Santa Fe, NMthe pilot's failure to maintain aircraft control during the landing roll resulting in a ground loop. Contributing to the accident was the crosswind.Oct 1, 2004 · N714MX · Substantial damageNTSB DFW05CA021Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Roanoke, TXThe disconnection of the engine mixture control cable due to improper maintenance which resulted in a loss of engine power.Sep 27, 2004 · N28086 · Substantial damageNTSB SEA04GA192Accident · 3 fatalFinal reportCessna U206G · Essex, MTThe pilot's misidentification of the airplane's location, which resulted in his improper decision to fly into the wrong drainage, and his failure to maintain terrain clearance while executing a turn to reverse course after he realized his navigational error.…Sep 20, 2004 · N206SM · DestroyedNTSB SEA04FA190Accident · 1 fatalField investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate in-flight planning/decision which resulted in VFR flight into IMC, and his failure to maintain aircraft control.Sep 14, 2004 · N20GV · Substantial damageNTSB SEA04LA189Accident · No injuriesLimited investigationFinal reportCessna P206A · Clearwater, IDA loss of engine power due to fatigue crack propagation of the number three piston pin while in cruise flight, leading to a power off forced landing in an open field. Factors include soft uphill terrain.Sep 13, 2004 · N4661F · Substantial damageNTSB LAX04LA312Accident · No injuriesLimited investigationFinal reportBeech F33A · Fresno, CAthe pilot's loss of pitch control authority during landing flare due to an autopilot system failure that inhibited control yoke movement. A factor was inadequate autopilot system maintenance.Sep 3, 2004 · N1854N · Substantial damageNTSB SEA04FA169Accident · 1 fatalField investigationFinal reportCessna A185F · Toutle, WAThe pilot's continued flight into known adverse weather conditions. Inadequate preflight planning/preparation, trees, a low ceiling and no suitable terrain available for the landing were factors.Aug 21, 2004 · N7562Q · DestroyedNTSB FTW04CA218Accident · No injuriesData collectionFinal reportBeech BE-58 · Groveton, TXThe pilot's intentional ground loop to avoid colliding with deer that entered the runway during the landing roll. A contributing factor was the tall grass adjacent to the runway that prevented detection of the deer.Aug 20, 2004 · N8140R · DestroyedNTSB SEA04FA165Accident · 3 fatalField investigationFinal reportCessna T210L · Tulsa, OKThe pilot's inadequate preflight inspection by his failure to secure the oil cap, which resulted in oil leakage on the windscreen, obstructing his vision, and his failure to maintain adequate airspeed.Aug 17, 2004 · N2452S · DestroyedNTSB CHI04LA227Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Anderson, INThe in-flight loss of engine power during downwind for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.Aug 15, 2004 · N6411S · Substantial damageNTSB MIA04FA119Accident · 1 fatalField investigationFinal reportCessna U206B · Key West, FLA loss of engine power for an undetermined reason during cruise flight, which resulted in the pilot ditching the airplane in ocean waters.Aug 14, 2004 · N3800G · Substantial damageNTSB SEA04CA164Accident · No injuriesData collectionFinal reportCessna U206G · Rose Lake, IDThe pilot's failure to maintain clearance with the powerlines on final approach which resulted in a hard landing. A factor contributing the to accident were the powerlines.Aug 13, 2004 · N9752Z · Substantial damageNTSB CHI04LA225Accident · 1 fatalLimited investigationFinal reportCessna A188B · Mylo, NDThe pilot's failure to maintain clearance from the windmill. The windmill was a contributing factor.Aug 12, 2004 · N92806 · DestroyedNTSB FTW04LA210Accident · No injuriesLimited investigationFinal reportBellanca BL17-30 · Austin, TXThe loss of engine power due to fuel starvation as result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.Aug 10, 2004 · N4700V · Substantial damageNTSB DEN04LA118Accident · No injuriesLimited investigationFinal reportBeech V35A · Grand Junction, COthe pilot's improper planning and decision making resulting in the loss of engine power due to fuel starvation. Contributing factors include the insufficient time to completely extend the landing gear, and the lack of suitable terrain for a forced landing.Aug 1, 2004 · N222S · Substantial damageNTSB FTW04LA201Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · Clayton, LAThe pilot's failure to maintain clearance from the high tension power lines.Jul 31, 2004 · N3159W · DestroyedNTSB ANC04LA099Accident · No injuriesLimited investigationFinal reportCessna U206G · Yakutat, AKThe pilot's inadequate preflight inspection, and his failure to secure the cargo door, which resulted in the cargo door coming open during the takeoff roll.Jul 29, 2004 · N9178G · Substantial damageNTSB LAX04CA278Accident · No injuriesData collectionFinal reportCessna A185F · Gridley, CAThe pilot's improper use of the rudder to correct for torque and P-factor effects and failure to maintain obstacle clearance.Jul 24, 2004 · N93DM · DestroyedNTSB LAX04FA271Accident · 3 fatalField investigationFinal reportBeech 58 · Bishop, CAthe pilot's continued VFR flight into marginal weather conditions with lowering ceilings in a box canyon in mountainous terrain, and his subsequent inability to maintain an adequate airspeed while maneuvering to reverse direction, which led to an accelerated…Jul 17, 2004 · N807Q · DestroyedNTSB SEA04CA138Accident · No injuriesData collectionFinal reportCessna A185F · Cut Bank, MTThe pilot's failure to maintain directional control during the takeoff roll.Jul 16, 2004 · N185S · Substantial damageNTSB ATL04LA157Accident · Minor injuriesLimited investigationFinal reportBeech A45 · LaGrange, GAThe maintenance personnel under-torquing of the crankcase throughbolts during top overhaul, which resulted in crankcase fretting, and the subsequent fatigue failure of the crankshaft at the No. 4 main journal. A factor was the lack of suitable terrain for…Jul 16, 2004 · N134BH · Substantial damageNTSB MIA04LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · Bay Saint Louis, MSThe failure of the pilot to verify the landing gear was extended prior to touchdown resulting in a gear-up landing.Jun 27, 2004 · N2167L · Substantial damageNTSB ANC04FA070Accident · 1 fatalField investigationFinal reportBeech 36 · Talkeetna, AKThe pilot's failure to maintain clearance from terrain during cruise flight, which resulted in an in-flight collision with terrain.Jun 26, 2004 · N7673N · DestroyedNTSB SEA04LA117Accident · No injuriesLimited investigationFinal reportCessna 185F · Bozeman, MTThe failure of the right main gear brake disk attach flange during the landing roll, due to fatigue cracks emanating from numerous corrosion pits present on the surface of the disk, leading to the right brake becoming totally inoperative, and resulting in a…Jun 24, 2004 · N4585F · Substantial damageNTSB CHI04LA146Accident · 1 fatalLimited investigationFinal reportCessna A188B · Prosser, NEThe pilot's abrupt maneuver to avoid obstructions, and his failure to maintain adequate airspeed resulting in a stall. The low altitude flight operation, and the transmission tower (antenna) were contributing factors.Jun 21, 2004 · N731MP · Substantial damageNTSB FTW04LA162Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Rush Springs, OKThe pilot's failure to maintain clearance with a utility pole and power lines while maneuvering during an aerial application.Jun 15, 2004 · N21650 · Substantial damageNTSB LAX04CA222Accident · No injuriesData collectionFinal reportCessna A188A · Minden, NVthe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an inadvertent ground loop. A contributing factor was the pilot's lack of experience in the accident airplane.Jun 2, 2004 · N9961G · Substantial damageNTSB ANC04LA057Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot/owner's failure to ensure that the airplane was in an airworthy condition prior to flight, which resulted in a partial loss of engine power and subsequent in-flight collision with a residence during an emergency landing after takeoff. Factors…May 26, 2004 · N70233 · Substantial damage