Skip to content

NTSB investigations: Continental IO-520 series, ID

74 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" = 'ID' 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\" = 'ID' 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" = 'ID' 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 SEA93LA184Accident · No injuriesLimited investigationFinal reportCessna 206B · Challis, IDInadequate compensation for wind conditions. The downdraft was a factor.Aug 25, 1993 · N3431L · Substantial damage NTSB SEA92LA132Accident · No injuriesLimited investigationFinal reportCessna 210D · Burley, IDThe pilot's inadequate visual lookout. Factors include FAA NOTAMS not being obtained, flight service station services not being used, and an object (temporary barrier) on the runway.Jun 23, 1992 · N3739Y · Substantial damage NTSB SEA92LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Stanley, IDThe pilot-in-command's selection of unsuitable terrain (snow covered runway) for landing resulting in a nose over on landing rollout.Dec 27, 1991 · N113LC · Substantial damage NTSB SEA91LA167Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Burley, IDPowerplant failure for undetermined reasons. Factors include in-flight collision with a tree.Jul 13, 1991 · N6302G · Destroyed NTSB SEA89LA028Accident · No injuriesLimited investigationFinal reportCessna 210D · Twin Falls, IDPrior to landing, the pilot was unable to lower the nose gear by using either the normal or emergency systems. Subsequently, he landed the acft with the main gear extended & the nose gear in the retracted position. After landing, the nose gear uplock actuator…Dec 17, 1988 · N3815Y · Substantial damage NTSB SEA86LA091Accident · No injuriesLimited investigationFinal reportCessna T210C · Boise, IDWhile attempting to land on a parallel runway, the aircraft encountered wake turbulence from a landing transport aircraft. The aircraft rolled and struck the ground hard. A successful go around was then made with an uneventful landing. The pilot was aware of…Mar 31, 1986 · N3423F · Substantial damage NTSB SEA85LA169Accident · No injuriesLimited investigationFinal reportCessna 185F · Boise, IDThe acft ground looped and the left main gear collapsed during a landing roll. The plt reported that the left wing came up during the landing roll which resulted in the acft veering to the right. When the wing settled, the left main gear collapsed allowing…Jul 17, 1985 · N4309R · Substantial damage NTSB SEA85LA140Accident · Serious injuriesLimited investigationFinal reportCessna 188A · Pocatello, IDDuring aerial application the aircrafts engine ceased operating. During engine tear down it was discovered that the engine's #2 connecting rod was broken and had come through the top of the crankcase. Recommended overhaul time is 1200 hours. This engine had a…Jun 17, 1985 · N5695J · Substantial damage NTSB SEA85LA007Accident · No injuriesLimited investigationFinal reportCessna 180 · Burley, IDAs plt initiated takeoff in a left x-wind, acft began to weathervane to the left. Increased right rudder and repeated applications of right brake failed to arrest an increasing swerve to left, with right brake pedal eventually bottoming out. As acft departed…Oct 10, 1984 · N4752Q · Substantial damage NTSB SEA84FA217Accident · 4 fatalField investigationFinal reportCessna 210K · Mccall, IDTwo acft departed in trail intending to follow a river through the mountainous terrain in their climb above the ridge line. The first acft proceeded as planned along the river and turned toward the dest at a safe alt. About 1/4 of a mile behind, the second…Sep 3, 1984 · N8136G · Destroyed NTSB SEA83LA177Accident · No injuriesLimited investigationFinal reportCessna 185E · Boise, IDThe acft landed in a near maximum velocity crosswind and while braking to control/correct a swerve, the right main landing gear separated from the acft. The landing was on rwy 28R and the wind was from 200 degrees at 10 to 14 KTS on final and 12 KTS when the…Aug 14, 1983 · N4772Q · Substantial damage NTSB SEA81DYA09Accident · No injuriesClosedCessna 188 · Idaho Falls, IDMay 5, 1981 · N4729Q · Substantial damage NTSB SEA80DYA13Accident · Minor injuriesClosedCessna T188C · American Falls, IDMay 22, 1980 · N91964 · Substantial damage NTSB SEA80FYA06Accident · Serious injuriesClosedCessna 210E · Burley, IDJan 23, 1980 · N2352F · Substantial damage NTSB SEA80FA011Accident · 2 fatalClosedBeech V35A · Sublett, IDDec 7, 1979 · N7950R · Destroyed NTSB SEA79DYP10Accident · No injuriesClosedCessna 185 · Cottonwood, IDFeb 5, 1979 · N80337 · Substantial damage NTSB SEA76FYG62Accident · No injuriesClosedCessna 188B · Lewiston, IDJun 29, 1976 · N9919G · Substantial damage NTSB SEA74DYA35Accident · No injuriesClosedCessna 188 · Idaho Falls, IDMay 31, 1974 · N9385G · Substantial damage NTSB SEA74DYG28Accident · No injuriesClosedCessna A188B · Nez Perce, IDApr 18, 1974 · N8080V · Substantial damage NTSB SEA72DYG34Accident · Minor injuriesClosedCessna 188 · Cameron, IDApr 24, 1972 · N3557Q · Substantial damage NTSB SEA71DXM11Accident · No injuriesClosedCessna 210D · Montpelier, IDSep 30, 1970 · N3957Y · Substantial damage NTSB SEA68D0187Accident · No injuriesClosedCessna P206 · Grace, IDNov 4, 1967 · N2677X · Substantial damage NTSB SEA66F0069Accident · No injuriesClosedBeechcraft S-35 · Hailey, IDAug 5, 1965 · N8922U · Substantial damage NTSB SEA66D0043Accident · No injuriesClosedCessna 206 · Sellway, IDJul 11, 1965 · N5229U · Substantial damage