Skip to content

NTSB investigations: Continental IO-520 series, MI

113 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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" = 'MI' 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

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\" = 'MI' 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" = 'MI' 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

Run 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 CHI86FA102Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Frankfort, MIThe plt was taking off from his local arpt and local residents described conditions of 100 ft vis in heavy ground fog. After lift-off he began a left turn toward a 300 ft high ridge topped by 100 ft trees. The acft struck the tree tops, the plt lost control…Mar 14, 1986 · N123RM · Destroyed NTSB CHI86LA091Accident · No injuriesLimited investigationFinal reportCessna 210M · While Lake Twp., MIThe acft was four miles from the arpt on an ILS apch when an eng failure was experienced. The acft was damaged during the forced landing on a frozen lake. Post accident eng teardown revealed the eng failure originated from movement of the #2 main bearing.…Feb 28, 1986 · N761VX · Substantial damage NTSB CHI85LA276Accident · No injuriesLimited investigationFinal reportCessna 210MII · Detroit, MIThe acft contacted a tree during a forced landing in a residential area following a loss of pwr. Post accident inspection revealed the right fuel tank contained fuel and the left tank was dry, the left wing fuel vent was installed backwards and the fuel…Jul 6, 1985 · N29008 · Substantial damage NTSB CHI84LA221Accident · No injuriesLimited investigationFinal reportBeech 58 · Iron Mountain, MIThe plt reported that after he made a normal landing, he retracted the gear instead of the flaps. However, there were indicates that the gear was not fully extended during touchdown. The landing gear circuit breaker was found popped. The landing gear safety…Jun 6, 1984 · N1557W · Substantial damage NTSB CHI84LA056Accident · No injuriesLimited investigationFinal reportCessna A185F · Bad Axe, MIDuring arrival, the plt was advised by the UNICOM operator that rwy 21 was the active rwy. Soon after landing, a passenger boarded the acft & the plt took off again. He proceeded to make a pattern around the arpt & initiated another landing on rwy 21. The…Dec 12, 1983 · N7560H · Substantial damage NTSB CHI84LA029Accident · No injuriesLimited investigationFinal reportCessna U206G · South Fox Isl., MIThe acft collided with a mound alongside the rwy during landing. The rwy is 3500 ft long turf strip with a 20 degree dogleg 1500 ft from the north end. There is a small hill running along both sides of the rwy. The grass rwy was wet and theacft slid sideways.…Oct 16, 1983 · N756DM · Substantial damage NTSB CHI83LA212Accident · No injuriesLimited investigationFinal reportCessna A185F · Eaton Rapids, MIThe acft nosed over during landing at the plt's private strip the plt stated that he took off for a 15 minute local flt and during landing he touched down in a soft area. The wheels bogged in and the acft nosed over. He had taken off to thenorth and landed to…May 6, 1983 · N6305E · Substantial damage NTSB CHI83LA195Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Gaylord, MIThe acft nosed over immediately upon landing on a turf rwy. An inspection of the rwy revealed two skid marks in the turf about 75 ft long and 900 ft from the approach end of rwy 36.May 4, 1983 · N5222R · Substantial damage NTSB CHI83LA117Accident · No injuriesLimited investigationFinal reportBeech 58 · Detroit, MIDuring arrival, the plt received vectors for an ILS approach. He elected to make a localizer only approach. At the outer marker, the acft was aprx 200 ft above the minimum altitude & above the approach speed. The plt reported that he reduced the airspeed…Feb 23, 1983 · N58WA · Substantial damage NTSB CHI82DA334Accident · No injuriesFinal reportCessna 210 · Holland, MIDuring landing, the aircraft swerved to the left and went off the runway. The left gear struck a runway light fixture and failed. Also, the horizontal stabilizer hit a runway light and was damaged. An inspection of the wheel assembly revealed no mechanical…Aug 19, 1982 · N93019 · Substantial damage NTSB CHI82DA257Accident · No injuriesFinal reportBeech 36 · Ypsilanti, MIAfter the engine was started, the pilot found that he needed a new microphone. He stated that he leaned over to the right to help the passenger open the door and apparently bumped the throttle. The aircraft moved and struck a parked Grumman American AA-5A,…Jul 18, 1982 · N52GS · Substantial damage NTSB CHI81FEM42Accident · Serious injuriesClosedCessna C210 · Kalamazoo, MIAug 28, 1981 · N1198Q · Destroyed NTSB CHI81FA070Accident · 5 fatalClosedCessna 401 · Muskegon, MIJun 30, 1981 · N7957F · Destroyed NTSB CHI81FEC28Accident · Serious injuriesClosedCessna U206F · Plymouth, MIJun 19, 1981 · N8532Q · Destroyed NTSB CHI81DET05Accident · No injuriesClosedBeech V35B · Sturgis, MIMar 22, 1981 · N1030W · Substantial damage NTSB CHI80FEM35Accident · No injuriesClosedCessna U206B · Charlotte, MIJul 20, 1980 · N3830G · Substantial damage NTSB CHI80FEM13Accident · No injuriesClosedCessna 185 · Allegan, MIJan 23, 1980 · N80520 · Substantial damage NTSB CHI80FEC09Accident · No injuriesClosedBeech V35 · Detroit, MIJan 14, 1980 · N2060W · Substantial damage NTSB CHI79DEC38Accident · No injuriesClosedBeech D-55 · Troy, MIJul 18, 1979 · N6288V · Substantial damage NTSB CHI79FEC10Accident · No injuriesClosedCessna 210 · Ypsilanti, MIJan 18, 1979 · N5883F · Substantial damage NTSB CHI78FET23Accident · No injuriesClosedCessna 185 · Berrien Spgs, MIJun 14, 1978 · N1285F · Substantial damage NTSB CHI78FEM20Accident · No injuriesClosedBellanca 17-30 · Plainwell, MIJun 10, 1978 · N4850V · Substantial damage NTSB CHI78FA044Accident · 1 fatalClosedCessna 206G · East Tawas, MIJun 6, 1978 · N8194G · Destroyed NTSB CHI78FEM19Accident · Minor injuriesClosedBeech V35 · East Jordan, MIJun 4, 1978 · N5474U · Substantial damage NTSB CHI77FEM27Accident · No injuriesClosedCessna 188B · Grand Rapids, MIJun 24, 1977 · N9073R · Destroyed NTSB CHI77FEC02Accident · No injuriesClosedBellanca 17-30 · Flint, MIOct 24, 1976 · N7341V · Substantial damage NTSB CHI76FEC51Accident · No injuriesClosedCessna U206F · Owosso, MIJul 24, 1976 · N114KC · Substantial damage NTSB CHI76FEM51Accident · No injuriesClosedCessna A188B · Hamlin, MIJul 15, 1976 · N9032R · Substantial damage NTSB CHI76FEC48Accident · No injuriesClosedCessna 210 · Ypsilanti, MIJun 26, 1976 · N5874F · Substantial damage NTSB CHI76FEC37Accident · Minor injuriesClosedCessna 188 · Ypsilanti, MIApr 8, 1976 · N21829 · Substantial damage NTSB CHI76FEC29Accident · No injuriesClosedBellanca 17-30 · Port Huron, MIFeb 27, 1976 · N7341V · Substantial damage NTSB CHI76FEM30Accident · Minor injuriesClosedCessna 210 · Grand Rapids, MIFeb 10, 1976 · N93303 · Substantial damage NTSB CHI76DEC03Accident · No injuriesClosedCessna 172 · Almont, MIJul 28, 1975 · N6452G · Substantial damage NTSB CHI75FEM36Accident · No injuriesClosedBellanca 17-30A · Mackinac Is, MIApr 11, 1975 · N8259R · Substantial damage NTSB CHI75AC064Accident · No injuriesClosedBeech 95-C55 · Gaylord, MIMar 12, 1975 · N5740V · Substantial damage NTSB CHI75FEC36Accident · No injuriesClosedCessna 210F · Howell, MIFeb 13, 1975 · N1864F · Substantial damage NTSB CHI74FEC51Accident · 1 fatalClosedCessna U206 · Otisville, MIJun 22, 1974 · N3855G · Substantial damage NTSB CHI74AC071Accident · No injuriesClosedCessna 402 · St.Ignace, MIFeb 18, 1974 · N3295Q · Substantial damage NTSB CHI74FEC31Accident · No injuriesClosedBeech V35 · Romeo, MIFeb 13, 1974 · N855DS · Substantial damage NTSB CHI73FEM25Accident · No injuriesClosedBeech V35A · Barryton, MISep 16, 1972 · N7444S · Substantial damage NTSB CHI72FEM09Accident · No injuriesClosedBellanca 17-30 · Slt.St.Marie, MIAug 9, 1971 · N7309V · Substantial damage NTSB CHI72FEM08Accident · No injuriesClosedBeech S35 · Sharon, MIJul 29, 1971 · N8807M · Substantial damage NTSB CHI71FEC52Accident · No injuriesClosedBellanca 17-30 · Pontiac, MIMay 16, 1971 · N4848V · Substantial damage NTSB CHI71FEM79Accident · No injuriesClosedCessna A185E · Pellston, MIMay 15, 1971 · N4721Q · Substantial damage NTSB CHI70FDW25Accident · No injuriesClosedBellanca 17-30 · Romeo, MIJun 20, 1970 · N6658V · Substantial damage NTSB CHI70AC071Accident · Minor injuriesClosedCessna P206B · Allendale, MIApr 9, 1970 · N8616Z · Substantial damage NTSB CHI70DBJ18Accident · No injuriesClosedAero Comdr 200-D · East Jordan, MIMar 29, 1970 · N243M · Substantial damage NTSB CHI69F0425Accident · No injuriesClosedCessna 206 · Charlotte, MIJan 14, 1969 · N2527X · Substantial damage NTSB CHI69F0387Accident · No injuriesClosedCessna U206 · Lint, MIDec 11, 1968 · N3935G · Substantial damage NTSB CHI69F0345Accident · Minor injuriesClosedBellanca 17-30 · Watervliet, MIOct 15, 1968 · N4893V · Substantial damage