NTSB investigations: Continental IO-520 series

4,751 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 FTW96FA373Accident · 1 fatalField investigationFinal reportBeech D55 · Corsicana, TXThe pilot's failure to maintain minimum control airspeed which resulted in the loss of control. Factors were the bent collar of the left main fuel tank refueling neck which resulted in fuel siphoning from the tank in flight, the pilot's failure to follow…Sep 5, 1996 · N873LB · DestroyedNTSB MIA96LA225Accident · No injuriesLimited investigationFinal reportCessna A188B · Winona, MSimproper maintenance of the airplane by the unqualified pilot/owner, by providing inadequate clearance between a flexible oil hose and a heat shield, which resulted in chafing of the hose, an oil leak, and subsequent oil starvation. A factor relating to the…Sep 3, 1996 · N53109 · Substantial damageNTSB ANC96LA144Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKan in-flight encouter with bird(s)/geese, which resulted in a bird strike.Sep 3, 1996 · N7396U · Substantial damageNTSB ANC96LA142Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the unfavorable wind.Sep 3, 1996 · N1801Q · Substantial damageNTSB ANC96LA135Accident · No injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKthe pilot's improper in-flight planning/decision, which resulted in intering a box canyon with insufficient altitude to either execute a turn to safety or outclimb rising terrain. A factor associated with the accident was: the pilot allowed the passenger to…Sep 2, 1996 · N733KD · Substantial damageNTSB ANC96FA139Accident · 1 fatalField investigationFinal reportCessna 206 · Yakutat, AKThe pilot's landing on the water with the landing gear inadvertently extended.Aug 31, 1996 · N7345N · Substantial damageNTSB IAD96WA141Accident · No injuriesForeign investigationCessna T-310P · Skiathos, GreeceAug 29, 1996 · N5758M · Substantial damageNTSB CHI96LA313Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNthe pilot's failure to maintain clearance from known transmission lines. Factors relating to this accident were the transmission lines and the sunglare which hindered the pilot's ability to see the transmission lines.Aug 23, 1996 · N4797Q · Substantial damageNTSB MIA96LA215Accident · No injuriesLimited investigationFinal reportCessna 210M · Opa Locka, FLthe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation, a forced landing, and subsequent in flight collision with terrain. The lack of suitable terrain for a forced landing was a related factor.Aug 21, 1996 · N732ST · Substantial damageNTSB LAX96FA308Accident · 1 fatalField investigationFinal reportCessna 210E · Big Bear City, CAan inadequate annual inspection conducted by other maintenance personnel.Aug 17, 1996 · N4931U · DestroyedNTSB SEA96LA193Accident · No injuriesLimited investigationFinal reportCessna A185E · Cody, WYfailure of the pilot to maintain directional control of the airplane and runway alignment during the takeoff roll. Factors relating to the accident were: the crosswind, and possible dragging of the right brake.Aug 15, 1996 · N185K · Substantial damageNTSB CHI96LA292Accident · No injuriesLimited investigationFinal reportCessna 210E · Clarksville, MOfuel starvation for undetermined reason(s). Factors relating to the accident were: the crop, and the uphill terrain condition in the emergency landing area.Aug 11, 1996 · N4963U · Substantial damageNTSB MIA96LA208Accident · 1 fatalLimited investigationFinal reportBeech A36 · Atlantic Ocean (Atlantic Ocean)an inflight collision with the terrain (water) for undetermined reason(s). Factors relating to the accident were: failure of the pilot to obtain a preflight weather briefing, his failure to obtain in-flight weather avoidance assistance, and his resultant…Aug 9, 1996 · N976WL · DestroyedNTSB FTW96LA338Accident · No injuriesLimited investigationFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain airspeed and altitude/clearance during the takeoff. A factor was the density altitude.Aug 7, 1996 · N92917 · Substantial damageNTSB SEA96LA177Accident · No injuriesLimited investigationFinal reportCessna U206F · Crane Island, WAthe pilot's failure to correctly judge the surface winds in the vicinity of the runway. Factors relating to the accident were: a tailwind during landing, a short runway with a wet surface, and an embankment/drop-off at the end of the airstrip.Aug 5, 1996 · N8313Q · Substantial damageNTSB LAX96LA307Accident · No injuriesLimited investigationFinal reportCessna A185F · Casa Grande, AZthe student pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop. Factors relating to the accident were: the student pilot's inadequate training and lack of certification (endorsement).Aug 4, 1996 · N2431Y · Substantial damageNTSB FTW96LA336Accident · No injuriesLimited investigationFinal reportBeech E-55 · Brownwood, TXThe pilot's failure to extend the landing gear. Factors were the pilot's failure to use a checklist, his diverted attention, and the landing gear warning horn not sounding.Aug 4, 1996 · N142P · Substantial damageNTSB ANC96LA111Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas MD369D · Healy, AKThe inadequate visual outlook by the pilots of both aircraft, and their failure to see and avoid the other aircraft. A factor associated with the accident was sunglare affecting the helicopter pilot's vision.Aug 4, 1996 · N58269 · 2 aircraft · No damageNTSB CHI96LA275Accident · No injuriesLimited investigationFinal reportBeech V35B · Walker, MNfailure of the pilot to properly flare the airplane for landing, and her improper recovery from a bounced landing.Aug 2, 1996 · N823T · Substantial damageNTSB MIA96LA198Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Sarasota, FLthe pilot's inadequate preflight inspection of the fuel tanks resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Jul 31, 1996 · N397MS · Substantial damageNTSB CHI96LA257Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Napoleon, NDthe pilot's improper use of the rudder to correct the airplane's drift to the right. A factor was the pilot's inadequate compensation for the crosswind.Jul 29, 1996 · N5708G · Substantial damageNTSB FTW96LA321Accident · No injuriesLimited investigationFinal reportCessna 188A · Decatur, TXthe pilot's failure to maintain directional control. A factor was the prevailing crosswind.Jul 28, 1996 · N1556M · Substantial damageNTSB ANC96LA107Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate preflight planning for departure and his selection of unsuitable terrain. Factors in the accident were soft, snow covered terrain and the pilot's delay in aborting the takeoff.Jul 28, 1996 · N70018 · DestroyedNTSB LAX96LA276Accident · No injuriesLimited investigationFinal reportCessna A188B · Merced, CAFuel exhaustion due to the pilot's inadequate preflight inspection and his failure to ensure that adequate fuel was onboard to complete the flight.Jul 18, 1996 · N731YT · Substantial damageNTSB CHI96LA239Accident · No injuriesLimited investigationFinal reportCessna A188B · Saint Charles, MOa partial loss of engine power due to undetermined reasons and the pilot's failure to maintain aircraft control. The factors involved were the pilot did not perform load jettison and low airspeed.Jul 15, 1996 · N9703J · Substantial damageNTSB ANC96TA095Accident · Minor injuriesFinal reportCessna 185 · Fairbanks, AKfatigue failure of the engine crankshaft. A factor related to the accident was: the lack of suitable terrain for a forced landing.Jul 4, 1996 · N185CA · DestroyedNTSB ATL96LA099Accident · No injuriesLimited investigationFinal reportCessna 188 · Pelham, GAfailure of the pilot to maintain directional control on the takeoff roll, which resulted in the airplane veering off the runway and colliding with a cotton picker (vehicle).Jul 1, 1996 · N9088R · Substantial damageNTSB ANC96TA087Accident · No injuriesFinal reportCessna 185F · Gustavus, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.Jun 11, 1996 · N56581 · Substantial damageNTSB IAD96LA092Accident · No injuriesLimited investigationFinal reportBeech V35B · Westminster, MDThe fracture of the engine crankshaft which had a subsurface origin and progressed in fatigue until overload and separation occurred.Jun 7, 1996 · N369JR · Substantial damageNTSB ANC96IA077Incident · No injuriesIncident investigationFinal reportCessna 206 · Kodiak, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were: soft terrain, the use of an oversize nose wheel tire, and the FAA's inadequate field approval process for tundra tires.Jun 1, 1996 · N9608G · Minor damageNTSB IAD96LA087Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · New Market, VAa loss of engine power as a result of the failure of the left exhaust tailpipe and led to a shorted ignition system. A related factor was the unsuitable terrain in which the aircraft landed.May 31, 1996 · N14765 · Substantial damageNTSB CHI96LA187Accident · No injuriesLimited investigationFinal reportCessna P206 · Goshen, INthe parachute equipment was not properly maintained by the parachutist. A factor related to the accident was the inadvertent deployment of the parachute.May 26, 1996 · N2625X · Substantial damageNTSB LAX96LA211Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Fallbrook, CAfailure of the pilot to attain the proper touchdown point on the runway, and his failure to maintain directional control of the airplane. Factors relating to the accident were: the excessive airspeed on final approach, and the short and wet condition of the…May 24, 1996 · N23MB · Substantial damageNTSB FTW96LA226Accident · Serious injuriesLimited investigationFinal reportNavion NA1 · Los Lunas, NMThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 24, 1996 · N2530T · Substantial damageNTSB ANC96TA075Accident · No injuriesFinal reportCessna A-185-F · Juneau, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the crosswind.May 20, 1996 · N56581 · Substantial damageNTSB NYC96LA102Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olean, NYthe pilot's improper IFR procedure by not maintaining the minimum descent altitude (MDA) during the ILS localizer approach. Factors relating to the accident were: low ceiling, fog, and weather below minimums for landing.May 9, 1996 · N65792 · Substantial damageNTSB SEA96LA089Accident · No injuriesLimited investigationFinal reportCessna A185E · Cascade, IDthe pilot's improper planning/decision, his failure to ensure that the airplane would maintain proper clearance from obstructions (trees), and his delay in aborting the takeoff. The soft/wet runway and tailwind were related factors.May 5, 1996 · N185MP · Substantial damageNTSB MIA96LA137Accident · No injuriesLimited investigationFinal reportCessna U206G · Gulf Of MexicoLoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.May 5, 1996 · N9702Z · Substantial damageNTSB ANC96LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKthe pilot's inadequate compensation for the crosswind conditions. Factors associated with the accident were the soft terrain at the landing site, and a crosswind.May 3, 1996 · N70039 · Substantial damageNTSB CHI96FA146Accident · 3 fatalField investigationFinal reportCessna 421 · Bernard, IAthe pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…Apr 29, 1996 · N341DA · DestroyedNTSB SEA96LA085Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Covington, WAfuel starvation, due to the pilot's improper fuel management. The uneven terrain in the forced landing area was a related factor.Apr 28, 1996 · N2975T · Substantial damageNTSB LAX96LA175Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Santa Barbara, CAThe pilot's failure to select a fuel tank containing an adequate quantity of fuel prior to landing, which resulted in fuel starvation.Apr 21, 1996 · N8711V · DestroyedNTSB FTW96LA171Accident · 1 fatalLimited investigationFinal reportCessna U206G · Venice, LAthe pilot's inadvertent flight into instrument meteorological conditions. A factor was the fog.Apr 14, 1996 · N734QW · DestroyedNTSB ANC96LA044Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.Apr 6, 1996 · N1692M · Substantial damageNTSB CHI96LA122Accident · No injuriesLimited investigationFinal reportCessna 210K · West Chicago, ILMaintenance personnel's failure to comply with an airworthiness directive on the landing gear which led to a retraction/extension assembly malfunction.Apr 1, 1996 · N9470M · Substantial damageNTSB CHI96LA118Accident · No injuriesLimited investigationFinal reportCessna 310R · Marshfield, WIthe failure of the pilot of the PA-32R, N1030Q, to obtain identification of the Cessna 310R, N1835E, visually, and his inadequate visual outlook. A factor was the failure of both pilots to hear communications from each other.Mar 20, 1996 · N1835E · 2 aircraft · Substantial damageNTSB MIA96FA100Accident · 5 fatalField investigationFinal reportCessna U206G · Key West, FLThe pilot's improper decision to continue the flight rather than making an immediate water landing due to the low altitude of the airplane and obstructions ahead, which led to his intentional maneuver to avoid the obstructions and subsequent inadvertent stall…Mar 17, 1996 · N9983Z · DestroyedNTSB ANC96LA030Accident · No injuriesLimited investigationFinal reportCessna 185F · Skwentna, AKthe pilot's selection of an unsuitable area for landing. A factor associated with the accident was the rough and uneven terrain.Mar 4, 1996 · N5246E · Substantial damageNTSB LAX96LA123Accident · No injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAthe pilot's improper use of the elevator control, while landing.Feb 29, 1996 · N2132F · Substantial damageNTSB FTW96LA123Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Dallas, TXfailure of the pilot to use a more favorable runway, and his failure to go-around, when he realized the airplane would not touch down at the proper touchdown point. Factors relating to the accident were: the inoperative flap motor, failure of the pilot to…Feb 21, 1996 · N4825J · Substantial damage