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 LAX91LA187Accident · No injuriesLimited investigationFinal reportBeech F33A · Goodyear, AZThe pilot's failure to ensure that the airplane's landing gear was extended by the passenger who he was allowing fly the airplane. A contributing factor related to the pilot's inadequate supervision of the passenger.Apr 29, 1991 · N5585Y · Substantial damageNTSB FTW91LA062Accident · No injuriesLimited investigationFinal reportCessna A188B · Tipton, OKFailure of the pilot to maintain poroper clearance above obstacles. A factor was the sun glare.Apr 6, 1991 · N4165J · Substantial damageNTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.Mar 28, 1991 · N9462S · DestroyedNTSB ATL91LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Chamblee, GAThe hole in the airport taxiway, which was created by the erosion of soil beneath the taxiway, and the failure of the airport to inspect and maintain ditches which run beneath the runways and taxiways.Mar 26, 1991 · N7224L · Substantial damageNTSB ANC91T#A01Accident · Minor injuriesClass 3Final reportCessna A185F · Galena, AKMar 21, 1991 · N735HB · Substantial damageNTSB FTW91FA049Accident · 2 fatalField investigationFinal reportBeech 36 · New Braunfels, TXThe pilot's disregard for the minimum descent altitude and failure to perform a missed approach. Factors were the pilot's attempt to fly into known adverse weather conditions, low ceiling, rain, and fog.Mar 16, 1991 · N23535 · DestroyedNTSB DEN91LA050Accident · No injuriesLimited investigationFinal reportBeech V35B · Englewood, COThe pilot's premature liftoff and inadvertent stall mush. Factors were: downdrafts, high density altitude, and unsuitable terrain.Mar 10, 1991 · N9038Q · DestroyedNTSB CHI91DCQ04Accident · 1 fatalFinal reportCessna A-188 · Harper, KSThe pilot inadvertently stalling the airplane.Mar 8, 1991 · N8189V · Substantial damageNTSB ANC91IA039Incident · No injuriesIncident investigationFinal reportCessna U206G · Sparrevohn Afs, AKThe loss of engine power due to the ice in the fuel strainer/gascalator. Contributing was: the inadequate preflight preparation by the pilot, and unsuitable terrain on which to make the forced landing.Mar 8, 1991 · N756XE · Minor damageNTSB LAX91LA114Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coalinga, CAFuel starvation and the improper use of the fuel selector by the pilot. The rough terrain on which the aircraft landed was a factor in the accident.Feb 26, 1991 · N8290R · Substantial damageNTSB DEN91FA037Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Olton, TXThe pilot exceeded the design stress limits of the airframe and the performance of aerobatics at an altitude insufficient for recovery.Jan 26, 1991 · N4035B · DestroyedNTSB NYC91LA062Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Cleveland, OHFatigue failure of the number two propeller blade actuating pin, due to improper installation of the pins and non-compliance with an airworthiness directive (AD 77-13-77).Jan 23, 1991 · N4626F · Substantial damageNTSB SEA91LA041Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Tooele, UTEngine fuel system blockage due to ice formation in the fuel system during a period of weather temperature extremes. A factor was the lack of suitable terrain for a forced landing.Jan 13, 1991 · N235M · DestroyedNTSB MIA91WA062Accident · 2 fatalForeign investigationBeech 58 · St. Maarten I., NTJan 7, 1991 · N100GT · DestroyedNTSB MIA91IA061Incident · No injuriesIncident investigationFinal reportCessna 210M · Lutz, FLFuel line chafing, and in-flight fire caused by shorting of the electrical system which resulted in a forced landing with the landing gear not extended.Jan 5, 1991 · N823AR · Minor damageNTSB NYC91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 210L · New Haven, CTThe failure of the vehicle driver to adequately monitor the radio/traffic pattern. Factors related to the accident were: darkness, the aircraft's loss of electrical power after activating the runway lights and entering the pattern, and the lack of visual…Dec 6, 1990 · N5280V · DestroyedNTSB LAX91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Fallbrook, CAThe failure of the number 5 cylinder piston connecting rod due to bending and subsequent fatigue fracture. Contributing to the accident was the improper starting procedure accomplished by an unidentified person which resulted in excessive fuel in the cylinder…Nov 20, 1990 · N9139M · DestroyedNTSB NYC91LA021Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Columbus, OHFailure by pilots of the other aircraft to see and alter taxi path to avoid the standing aircraft.Oct 29, 1990 · N972VJ · 2 aircraft · Minor damageNTSB NYC91FA005Accident · 4 fatalField investigationFinal reportBeech V35B · Ottawa, OHFailure of the pilot to follow the proper instrument procedure and maintain the minimum descent altitude (mda) during an approach to the airport at night in instrument meteorological conditions.Oct 8, 1990 · N409E · DestroyedNTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.Oct 2, 1990 · N8281M · Substantial damageNTSB MIA90LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Vicksburg, MSFailure of the pilot to avoid a mud hole on the runway during the ground roll to takeoff.Sep 21, 1990 · N86405 · Substantial damageNTSB ANC90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe improper use of elevator controls by the pilot.Sep 21, 1990 · N33181 · Substantial damageNTSB ATL90LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Hertsboro, ALFatigue failure of the propeller blade which resulted from improper overhaul procedures, and the absence of oil in the propeller hub which would allow the detection of blade cracks.Sep 20, 1990 · N8677G · Substantial damageNTSB ANC90LA180Accident · No injuriesLimited investigationFinal reportCessna 185 · Upper Colleen, AKThe pilot-in-command's failure to select suitable terrain for landing. Contributing to the accident was the rough and uneven terrain.Sep 18, 1990 · N70087 · Substantial damageNTSB ANC90LA175Accident · No injuriesLimited investigationFinal reportCessna 206 · Puntilla Lake, AKAn inadequate preflight.Sep 16, 1990 · N756JC · Substantial damageNTSB ANC90LA172Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKFailure of the pilot to obtain or maintain adequate airspeed which resulted in a stall or mush.Sep 13, 1990 · N4861Q · Substantial damageNTSB SEA90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Lewistown, MTThe pilot did not maintain an adequate lookout while maneuvering which resulted in a collision with a transmission wire.Sep 6, 1990 · N2107F · Substantial damageNTSB MIA90WA178Accident · No injuriesForeign investigationBeech 58 · Union Island, St. Vincent & GrenadinesSep 6, 1990 · N1896W · Substantial damageNTSB ANC90FA158Accident · 2 fatalField investigationFinal reportCessna 414 · Sitka, AKImproper planning/decision by the pilot, and his failure to follow IFR procedures and maintain clearance from mountainous terrain.Aug 28, 1990 · N8180K · DestroyedNTSB DEN90DTE05Accident · No injuriesFinal reportCessna 188B · Eckley, COA failure on the part of the pilot in command to maintain adequate terrain clearance.Aug 20, 1990 · N4933Q · Substantial damageNTSB SEA90FA163Accident · 1 fatalField investigationFinal reportCessna A185F · Wrangell, AKThe pilot did not maintain an adequate airspeed. The pilot's lack of recent experience in the Cessna 185 was a contributing factor.Aug 12, 1990 · N5317R · DestroyedNTSB ANC90LA136Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKFailure of the right main landing gear spring upon landing.Aug 8, 1990 · N5246E · Substantial damageNTSB FTW90DRD15Accident · No injuriesFinal reportCessna 188 · Archibald, LAThe power loss for undetermined reasons. A factor was the rough uneven terrain in which the forced landing was performed.Aug 3, 1990 · N70114 · Substantial damageNTSB NYC90LA160Accident · 1 fatalLimited investigationFinal reportCessna U206F · Augusta, MEImproper planning/decision by the pilot, and his failure to compensate for wind conditions. The unfavorable wind conditions and rough water were related factors.Jul 14, 1990 · N8514Q · Substantial damageNTSB LAX90LA257Accident · No injuriesLimited investigationFinal reportCessna A185F · Discovery Bay, CAThe pilot's improper visual lookout to assure the area was clear of boats before departing.Jul 14, 1990 · N888BL · Substantial damageNTSB NYC90LA183Accident · No injuriesLimited investigationFinal reportCessna 310R · Mansfield, OHAn unavoidable collision with a deer while taking off which bent the drag brace and prevented it from locking. Factors related to the accident were the night conditions which reduced the pilots visibility to the illuminated area of the landing lights.Jul 11, 1990 · N3463G · Substantial damageNTSB DEN90LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Michigan, NDThe failure of the pilot to maintain proper alignment during landing.Jul 11, 1990 · N4940R · Substantial damageNTSB LAX90LA249Accident · No injuriesLimited investigationFinal reportBeech V35B · Big Bear, CAThe fuel starvation due to the pilot's inadvertent selection of an empty fuel tank.Jul 9, 1990 · N4796M · Substantial damageNTSB CHI90LA168Accident · No injuriesLimited investigationFinal reportBeech V35B · Lockport, ILThe pilot's failure to maintain aircraft directional control and keep the aircraft on the runway during the landing roll.Jul 5, 1990 · N35TP · Substantial damageNTSB LAX90LA243Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · Fullerton, CAThe pilot's failure to detect an incorrect rudder trim adjustment, his failure to follow the prescribed pre-takeoff instructions that call for the trim to be adjusted. The collision with the fence and the incorrect rudder trim adjustment were factors in the…Jul 3, 1990 · N5852J · Substantial damageNTSB ANC90LA108Accident · No injuriesLimited investigationFinal reportCessna 185 · King Salmon, AKTotal loss of engine power caused by the failure of the piston rod assemblies.Jul 2, 1990 · N53046 · Substantial damageNTSB ANC90FA105Accident · 2 fatalField investigationFinal reportCessna 185 · Iliamna, AKThe pilot's failure to follow proper procedures and directives (excessive flaps); failure to operate the airplane within the allowable gross weight limitations; improper compensation for wind conditions and failure to maintain minimum safe flying speed,…Jul 2, 1990 · N185KA · Substantial damageNTSB LAX90FA233Accident · Minor injuriesField investigationFinal reportBellanca 17-30A · Ojai, CAStructural damage sustained by the Bellanca, N39843, as a result of encountering wake turbulence during a near-collision with a navy F-14A.Jun 28, 1990 · N39843 · 2 aircraft · Substantial damageNTSB MKC90LA137Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Goddard, KSFuel starvation due to a loose fuel strainer screen. A factor related to this accident was lack of suitable terrain for a forced landing.Jun 26, 1990 · N1655C · Substantial damageNTSB FTW90FA125Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Dallas, TXThe initial partial loss of engine power, followed by the total loss of engine power and the striking of a hidden set of transmission wires.Jun 26, 1990 · N6608V · DestroyedNTSB CHI90LA163Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Savoy, ILThe loss of engine power for undetermined reasons and the inadvertent stall during the forced landing.Jun 26, 1990 · N35703 · DestroyedNTSB MIA90IA144Incident · No injuriesIncident investigationFinal reportCessna 210L · Fort Lauderdale, FLIncorrect placement of the retaining ring in the left main landing gear door actuator by the mechanic resulting in the loss of hydraulic fluid. This prevented the gear from extending resulting in the gear up landing.Jun 25, 1990 · N732BL · Minor damageNTSB FTW90LA123Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Mc Allen, TXLoss of engine power for undetermined reasons. The concrete canal that he impacted was a factor.Jun 24, 1990 · N1568U · Substantial damageNTSB LAX90LA225Accident · No injuriesLimited investigationFinal reportBellanca BL26 · Santa Ana, CAThe pilot's use of an improper starting technique.Jun 20, 1990 · N4034B · Substantial damageNTSB ANC90LA091Accident · No injuriesLimited investigationFinal reportCessna 185 · Chandler, AKThe pilot-in-command's failure to maintain control of the airplane.Jun 17, 1990 · N2797J · Substantial damage