NTSB investigations: Continental IO-520 series, MO

101 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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND 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 MKC89LA166Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Hannibal, MOFuel starvation for undetermined reasons which resulted in a forced landing and subsequent collision with trees.Jul 23, 1989 · N69DM · Substantial damageNTSB MKC89LA123Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Poplar Bluff, MOThe pilot in command misjudged the clearance of the aircraft's vertical stabilizer from the power lines.Jun 2, 1989 · N3159W · Substantial damageNTSB MKC87LA052Accident · No injuriesLimited investigationFinal reportBeech B-35 · Butler, MOThe PIC flew a traffic pattern that placed him landing long to the rwy at Butler, MO. The PIC perceived an eng failure prior to attempting a go-around and activated the fuel boost pump and advanced the throttle. The PIC rptd the eng faultered and quit. The…Feb 18, 1987 · N8827M · Substantial damageNTSB MKC84LA133Accident · No injuriesLimited investigationFinal reportBeech V35B · Lee'S Summit, MOThe plt reported that the acft landed hard, bounced and landed hard again breaking the nose gear off the acft. The pilot stated he encountered a strong downdraft on approach.May 4, 1984 · N3138W · Substantial damageNTSB MKC84FA036Accident · No injuriesField investigationFinal reportBeech A36 · Kansas City, MOThe BE-A36 was holding short of rwy 18. The C-310 was taxiing to also hold short & collided with the BE-A36. The position & strobe lights on the BE-A36 were illuminated. The plt of the C-310 indicated that he did not see the BE-A36 because of what he…Dec 12, 1983 · N6416N · 2 aircraft · Substantial damageNTSB MKC84FA034Accident · Serious injuriesField investigationFinal reportCessna 21ON · Wentzville, MOThe acft was landed with the landing gear partially extended during a forced landing after an engine failure. The plt delayed the extension of the gear because of the condition of the landing area. Examination of the engine showed a failure of the #2…Dec 6, 1983 · N5209C · Substantial damageNTSB MKC83LA218Accident · No injuriesLimited investigationFinal reportCessna 188B · Catron, MOThe acft went out of control during the takeoff roll from a farm field. The plt states that as the roll began the left wing started to drop and the acft began turning left. The plt tried to correct with right brake but was unable to make a correction. The…Sep 8, 1983 · N4889Q · Substantial damageNTSB MKC83LA058Accident · No injuriesLimited investigationFinal reportBeech D55 · Cape Girardeau, MOThe aircraft was landed gear up on the runway after a business flight. The pilot said he lowered the landing gear handleand observed the green landing gear down light illuminate after receiving clearance to land. The pilot said he did not cross check the nose…Jan 25, 1983 · N7815R · DestroyedNTSB MKC82DA142Accident · 2 fatalFinal reportCessna 210J · Lees Summit, MOThe aircraft had been repainted at topeka, KS. On a return flight to Kansas city, MO, the pilot diverted to olathe, KS after finding clouds at the intended destination. He then departed on a night flight to Lees Summit, MO. After entering the traffic pattern…Aug 13, 1982 · N3331S · DestroyedNTSB MKC82FA110Accident · Serious injuriesField investigationFinal reportBellanca 17-30 · Columbia, MOThe plt stated he did not refuel or visually verify fuel quantity prior to departing Kansas city. The flt to st. louis was on the left tank. As the acft approached the Columbia, MO VOR at an altitude of 3000 ft MSL the eng failed. The pilot stated he…Jun 23, 1982 · N6656V · Substantial damageNTSB MKC82DA107Accident · No injuriesFinal reportCessna A188 · Appleton City, MOThe pilot elected to land on a crowned, asphalt, farm road while repositioning the aircraft for an agricultural operation. He reported that shortly after touchdown, the aircraft pulled to the left and the left wing entered high weeds. He said he was unable to…Jun 18, 1982 · N3503Q · Substantial damageNTSB MKC82FA075Accident · Serious injuriesField investigationFinal reportBeech A36 · Smithville, MOThe plt reported a loss of power & unable to reach the arpt. The acft collided with trees during the forced landing & then landed hard, gear up, in a farmyard. Examination revealed that the left fuel tank was empty. The right fuel tank was full & the fuel…May 9, 1982 · N1877L · Substantial damageNTSB MKC82IA071Incident · No injuriesIncident investigationFinal reportBeech F33A · Chesterfield, MOWhen the aircraft was returning for landing, the pilot selected gear down and stated that he felt it extend but could not recall seeing the green gear down lights because he was scanning for traffic. Shortly afterwards he experienced a rapid electrical power…May 4, 1982 · N2048Z · Minor damageNTSB MKC81FCG46Accident · No injuriesClosedCessna A188B · Orrick, MOJul 11, 1981 · N731BD · Substantial damageNTSB MKC81FCG42Accident · No injuriesClosedCessna 210 · Sedalia, MOJun 24, 1981 · N3331S · Substantial damageNTSB MKC81FCG33Accident · No injuriesClosedCessna 210 · Lebanon, MOMay 3, 1981 · N7241N · Substantial damageNTSB MKC80FCA26Accident · No injuriesClosedCessna 188B · Advance, MOJul 11, 1980 · N84354 · Substantial damageNTSB MKC80FA041Accident · Serious injuriesClosedBeech 95-C55 · Chesterfield, MOJun 24, 1980 · N7863L · Substantial damageNTSB MKC80DCG30Accident · No injuriesClosedCessna 188B · Bigelow, MOJun 24, 1980 · N731GR · Substantial damageNTSB MKC80FCG09Accident · No injuriesClosedBeech S35 · Springfield, MOJan 5, 1980 · N7944K · Substantial damageNTSB MKC80FCG02Accident · No injuriesClosedBeech 58 · Kansas City, MONov 14, 1979 · N7347R · Substantial damageNTSB MKC79IA025Incident · No injuriesClosedCessna 210 · Bunker, MOMay 1, 1979 · N6153N · Minor damageNTSB MKC79FCA11Accident · Serious injuriesClosedBeech 58 · Chesterfield, MOFeb 28, 1979 · N4494A · Substantial damageNTSB MKC79FCG10Accident · No injuriesClosedBeech B95-55 · Kansas City, MOOct 27, 1978 · N4825J · Substantial damageNTSB MKC78FCG47Accident · No injuriesClosedCessna 210 · Oak Grove, MOJul 8, 1978 · N761AT · Substantial damageNTSB MKC78FCA21Accident · No injuriesClosedCessna A188B · Marston, MOMar 17, 1978 · N84354 · Substantial damageNTSB MKC78FCA19Accident · Minor injuriesClosedBeech V35B · Creve Coeur, MOMar 6, 1978 · N4183S · Substantial damageNTSB MKC78IA015Incident · No injuriesClosedCessna 402 · Rolla, MODec 17, 1977 · N3295Q · Minor damageNTSB MKC77IA041Incident · No injuriesClosedCessna 402 · Vichy, MOSep 28, 1977 · N3295Q · Minor damageNTSB MKC77FCA29Accident · No injuriesClosedCessna A188B · Senath, MOJul 15, 1977 · N53213 · Substantial damageNTSB MKC77FA018Accident · No injuriesClosedBeech V-35 · Lutesville, MOMar 23, 1977 · N5928S · Substantial damageNTSB MKC77FCA11Accident · No injuriesClosedBellanca 17-30A · St Charles, MOFeb 6, 1977 · N8858V · Substantial damageNTSB MKC76DCG62Accident · No injuriesClosedBeech 36 · Camdenton, MOMar 19, 1976 · N7470N · Substantial damageNTSB MKC76AK051Accident · No injuriesClosedCessna U206F · Columbia, MOMar 11, 1976 · N8268Q · Substantial damageNTSB MKC76FCA09Accident · Minor injuriesClosedBeech V35A · St Louis, MOSep 25, 1975 · N250G · Substantial damageNTSB MKC76FCA01Accident · No injuriesClosedCessna 210 · Sikeston, MOJul 16, 1975 · N2358F · Substantial damageNTSB MKC75FCG32Accident · No injuriesClosedCessna P206A · Macon, MOMar 11, 1975 · N4658F · Substantial damageNTSB MKC73DCA06Accident · No injuriesClosedCessna A188A · Fisk, MOOct 16, 1972 · N5636J · Substantial damageNTSB MKC72FCG49Accident · No injuriesClosedBeech V35A · Springfield, MOApr 12, 1972 · N7165N · Substantial damageNTSB MKC72FCG18Accident · No injuriesClosedCessna 206A · Richmond, MOSep 5, 1971 · N4644F · Substantial damageNTSB MKC72FCA25Accident · No injuriesClosedBeech V35 · St.Louis, MOFeb 12, 1971 · N339LT · Substantial damageNTSB MKC71DCG14Accident · No injuriesClosedCessna 210 · Protem, MOAug 6, 1970 · N3340S · Substantial damageNTSB MKC70DCG31Accident · No injuriesClosedCessna 206 · Grain Valley, MOMay 31, 1970 · N5188U · Substantial damageNTSB MKC70FCA11Accident · No injuriesClosedBeech 95-C55 · Berkeley, MOMay 19, 1970 · N2764T · Substantial damageNTSB MKC69D0214Accident · No injuriesClosedBeech S35 · Bethany, MOAug 18, 1968 · N8636Q · Substantial damageNTSB MKC68F0284Accident · Serious injuriesClosedBeech V35 · Cedar City, MOOct 23, 1967 · N6238V · Substantial damageNTSB MKC68F0139Accident · No injuriesClosedCessna 210E · Lambert Field, MOJul 23, 1967 · N1814F · Substantial damageNTSB MKC68D0137Accident · No injuriesClosedCessna P206A · Caruth, MOJun 10, 1967 · N4706F · Substantial damageNTSB MKC68D0145Accident · No injuriesClosedBeech V35 · St.Louis, MOApr 25, 1967 · N4831J · Substantial damageNTSB MKC67F0554Accident · No injuriesClosedBeech S35 · Shell Knob, MOApr 20, 1967 · N5615K · Substantial damage