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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MKC89LA166Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Hannibal, MOFuel starvation for undetermined reasons which resulted in a forced landing and subsequent collision with trees.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB MKC81FCG46Accident · No injuriesClosedCessna A188B · Orrick, MONTSB MKC81FCG42Accident · No injuriesClosedCessna 210 · Sedalia, MONTSB MKC81FCG33Accident · No injuriesClosedCessna 210 · Lebanon, MONTSB MKC80FCA26Accident · No injuriesClosedCessna 188B · Advance, MONTSB MKC80FA041Accident · Serious injuriesClosedBeech 95-C55 · Chesterfield, MONTSB MKC80DCG30Accident · No injuriesClosedCessna 188B · Bigelow, MONTSB MKC80FCG09Accident · No injuriesClosedBeech S35 · Springfield, MONTSB MKC80FCG02Accident · No injuriesClosedBeech 58 · Kansas City, MONTSB MKC79IA025Incident · No injuriesClosedCessna 210 · Bunker, MONTSB MKC79FCA11Accident · Serious injuriesClosedBeech 58 · Chesterfield, MONTSB MKC79FCG10Accident · No injuriesClosedBeech B95-55 · Kansas City, MONTSB MKC78FCG47Accident · No injuriesClosedCessna 210 · Oak Grove, MONTSB MKC78FCA21Accident · No injuriesClosedCessna A188B · Marston, MONTSB MKC78FCA19Accident · Minor injuriesClosedBeech V35B · Creve Coeur, MONTSB MKC78IA015Incident · No injuriesClosedCessna 402 · Rolla, MONTSB MKC77IA041Incident · No injuriesClosedCessna 402 · Vichy, MONTSB MKC77FCA29Accident · No injuriesClosedCessna A188B · Senath, MONTSB MKC77FA018Accident · No injuriesClosedBeech V-35 · Lutesville, MONTSB MKC77FCA11Accident · No injuriesClosedBellanca 17-30A · St Charles, MONTSB MKC76DCG62Accident · No injuriesClosedBeech 36 · Camdenton, MONTSB MKC76AK051Accident · No injuriesClosedCessna U206F · Columbia, MONTSB MKC76FCA09Accident · Minor injuriesClosedBeech V35A · St Louis, MONTSB MKC76FCA01Accident · No injuriesClosedCessna 210 · Sikeston, MONTSB MKC75FCG32Accident · No injuriesClosedCessna P206A · Macon, MONTSB MKC73DCA06Accident · No injuriesClosedCessna A188A · Fisk, MONTSB MKC72FCG49Accident · No injuriesClosedBeech V35A · Springfield, MONTSB MKC72FCG18Accident · No injuriesClosedCessna 206A · Richmond, MONTSB MKC72FCA25Accident · No injuriesClosedBeech V35 · St.Louis, MONTSB MKC71DCG14Accident · No injuriesClosedCessna 210 · Protem, MONTSB MKC70DCG31Accident · No injuriesClosedCessna 206 · Grain Valley, MONTSB MKC70FCA11Accident · No injuriesClosedBeech 95-C55 · Berkeley, MONTSB MKC69D0214Accident · No injuriesClosedBeech S35 · Bethany, MONTSB MKC68F0284Accident · Serious injuriesClosedBeech V35 · Cedar City, MONTSB MKC68F0139Accident · No injuriesClosedCessna 210E · Lambert Field, MONTSB MKC68D0137Accident · No injuriesClosedCessna P206A · Caruth, MONTSB MKC68D0145Accident · No injuriesClosedBeech V35 · St.Louis, MONTSB MKC67F0554Accident · No injuriesClosedBeech S35 · Shell Knob, MO