NTSB investigations: Continental IO-360 series
692 cases on aircraft whose registry engine model is Continental IO-360 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 ('17025', '17045'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17025', '17045'))
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 CHI99LA002Accident · No injuriesLimited investigationFinal reportCessna C-336 · Sheboygan, WIThe pilot's improper flare and improper recovery from a bounced landing.NTSB NYC99LA013Accident · Serious injuriesLimited investigationFinal reportGoodyear Aerospace GZ-20-A · Bedford, MAThe separation of the pull-in-line. A factor in the accident was the gusting winds.NTSB NYC98LA153Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Jeanette, PAThe pilot's delay in applying the brakes during the landing rollout.NTSB CHI98LA196Accident · No injuriesLimited investigationFinal reportCessna 172K · Omaha, NEThe aircraft modification not being in compliance with the Supplemental Type Certificate. A factor to the accident was the fracture of the landing gear axle during landing.NTSB NYC98LA110Accident · 1 fatalLimited investigationFinal reportCessna 337B · Montgomery, NYthe pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).NTSB FTW98LA083Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Lakeview, ARthe pilot's failure to maintain runway alignment during the approach, and his delayed decision to execute a go-around. A related factor was the sunglare interfering with the pilot's view.NTSB LAX98LA014Accident · No injuriesLimited investigationFinal reportStinson AT-19 · North Las Vegas, NVThe pilot of the Stinson AT-19, N88793, inadequate visual lookout and his failure to perform clearing S-turns while taxiing. A related factor was the inherent forward visual restriction of the aircraft's conventional landing gear design.NTSB FTW97LA353Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · San Marcos, TXThe pilot's loss of control while performing aerobatics resulting in an inadvertent stall/spin. A factor was the lack of altitude available for recovery.NTSB ANC97LA149Accident · No injuriesLimited investigationFinal reportMaule M4-210 · Bethel, AKThe pilot's abrupt application of brakes during the landing roll.NTSB MIA97LA230Accident · No injuriesLimited investigationFinal reportCessna R172E · Mary Esther, FLThe loss of engine power for undetermined reasons.NTSB CHI97LA120Accident · No injuriesLimited investigationFinal reportMaule M-5 · West Fargo, NDthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point. Factors relating to the accident were: the unfavorable wind conditions, and the terrain condition where the airplane touched down.NTSB ANC97LA033Accident · No injuriesLimited investigationFinal reportCessna 337T · Fairbanks, AKa leaking landing gear actuator seal, which resulted in an inability of the landing gear to lock in the down position. Failure of the emergency gear extension handle was a related factor.NTSB FTW97LA108Accident · No injuriesLimited investigationFinal reportCessna R172K · Brownsville, TXthe pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion.NTSB LAX97FA093Accident · 1 fatalField investigationFinal reportCessna R172K · Bagdad, AZcontinued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from terrain. Factors relating to the accident were: the high/mountainous terrain and adverse weather conditions.NTSB ATL97LA006Accident · No injuriesLimited investigationFinal reportCessna 337G · Fayetteville, NCThe unapproved maintenance modification of the landing gear electrical system by maintenance personnel that prevented the extension of the landing gear.NTSB ANC96LA136Accident · No injuriesLimited investigationFinal reportMaule M-4 · Skwentna, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the rough and uneven terrain.NTSB FTW96LA340Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Hudson, COthe pilot's delay in initiating a go-around and failure to attain sufficient airspeed to clear obstructions at the departure end of the runway, which resulted in an inadvertent stall and collision with the ground. Factors relating to the accident were: the…NTSB SEA96LA053Accident · No injuriesLimited investigationFinal reportCessna R172K · Garden Valley, IDThe pilot's selection of an unsuitable landing area. The snow covered runway was a related factor.NTSB DCA96RA042Accident · 4 fatalForeign investigationCessna 337 · Havana, CubaNTSB CHI96LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Worthington, MNProgressive failure of the engine, beginning with failure of the left magneto, which resulted in preignition or detonation, a burned hole in the #3 piston, subsequent oil exhaustion, and failure of the #1 and #2 connecting rods.NTSB CHI96LA042Accident · No injuriesLimited investigationFinal reportCessna T337G · Pontiac, MIthe pilot's improper level-off and improper recovery from a bounced landing.NTSB FTW96FA046Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Cypress, TXThe pilot's failure to maintain aircraft control while flying in instrument meteorological conditions. Factors were the weather, and the failure of the airplane's vacuum pump which rendered the attitude indicator and the directional gyro inoperative.NTSB LAX95LA336Accident · No injuriesLimited investigationFinal reportSjostrand Wheeler Express · Mariposa, CAthe pilot's premature rotation and liftoff, which resulted in an inadvertent stall and subsequent hard touchdown.NTSB FTW95LA378Accident · No injuriesLimited investigationFinal reportMaule M5-210C · Westcliffe, COFailure by the pilot to maintain directional control of the aircraft during taxi. A factor was lack of experience in make and model aircraft.NTSB BFO95LA089Accident · No injuriesLimited investigationFinal reportCessna R172K · Lisbon, OHLoss of oil, where an oil filter adapter had separated from the crankcase cover, due to stripped threads that were caused or allowed by inadequate maintenance or inspection, which resulted in oil exhaustion and subsequent loss of engine power. A factor…NTSB ANC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Cordova, AKThe pilot's improper planning/decision and delayed decision to abort the takeoff.NTSB CHI95LA231Accident · Serious injuriesLimited investigationFinal reportCessna 337H · Holland, MIthe passenger's improper decision to exit the airplane with the engine(s) running.NTSB CHI95LA177Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Plato Center, ILthe pilot's excessive pull-up during a downwind banner pick-up resulting in a stall. A factor related to the accident was the tailwind.NTSB CHI95LA164Accident · No injuriesLimited investigationFinal reportCessna 337B · Lemmon, SDthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB LAX95LA194Accident · Serious injuriesLimited investigationFinal reportAero Commander 500S · Santa Barbara, CAthe inadequate visual lookout by both pilots and their failures to maintain adequate separation from each other while taxiing in a non-movement area.NTSB ATL95LA082Accident · No injuriesLimited investigationFinal reportCessna 337G · Savannah, GAThe pilot's improper flare and his improper use of the flight controls during landing which resulted in collapse of the nose gear.NTSB BFO95FA006Accident · 2 fatalField investigationFinal reportCessna T337G · Hyannis, MALoss of aircraft control for an undetermined reason. Darkness and the weather conditions were related factors.NTSB SEA95LA008Accident · Minor injuriesLimited investigationFinal reportCessna R172K · St. George, UTInadequate fuel consumption calculations. Factors to the accident were: fuel exhaustion and a parked aircraft in the landing path.NTSB FTW95FA008Accident · 3 fatalField investigationFinal reportCessna T337G · Milford, UTThe pilot's continued flight into adverse weather conditions, which resulted in airframe (structural) ice, a loss of control, and subsequent in-flight breakup of the airplane. A factor related to the accident was: the icing/weather condition.NTSB NYC94FA176Accident · No injuriesField investigationFinal reportWDL 1B · Farmingdale, NYInadequate design of the airship, which allowed the center ballonet to overfill and to collapse the trunking to the fore and aft ballonets, rendering the airship uncontrollable. Factors related to the accident were: inadequate maintenance by the…NTSB ANC94LA076Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Northway, AKThe failure of the left main landing gear attachment fittings as a result of the improper welds by the maintenance repair facility. Factors in the accident that precipitated the gear failure were the wind gusts, and the pilot not adequately compensating for…NTSB SEA94LA012Accident · No injuriesLimited investigationFinal reportCessna T-337E · Yamhill, ORThe pilot failed to attain the proper touchdown point. The tailwind was a factor.NTSB NYC94LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt. Gilead, OHthe pilot's improper inflight decision to conduct a night landing at an airport without runway lights, and the subsequent misalignment with the runway and collision with an object.NTSB LAX94LA001Accident · No injuriesLimited investigationFinal reportCessna O-2A · Tucson, AZwas the partial loss of engine power during initial climb due to partial clogging of the engine's fuel injectors. Blockage of the fuel injectors was due to inadequate maintenance of the fuel system by contract maintenance personnel.NTSB BFO93FA178Accident · 1 fatalField investigationFinal reportMaule M-4-210C · Staunton, VAInadequate preflight by the pilot which resulted in inadequate altitude to clear the embankment during the initial climb. Factors in this accident were a tailwind on takeoff and rising terrain at the departure end of the grass airstrip.NTSB SEA93LA160Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Jerome, IDThe pilot's improper fuel management procedures which resulted in fuel starvation. Factors include the pilot's lack of familiarity with this type aircraft, and rough/uneven terrain in the landing area.NTSB CHI93LA258Accident · No injuriesLimited investigationFinal reportMaule M4 · Tomahawk, WIthe pilot's improper recovery from a bounced landing.NTSB DEN93LA078Accident · No injuriesLimited investigationFinal reportCessna 172XP · Allen, TXFuel exhaustion induced power loss. A factor was the lack of suitable terrain for the forced landing.NTSB ANC93LA109Accident · No injuriesLimited investigationFinal reportMaule M4 · Iliamna, AKThe pilot in command's improper taxi speed. A factor in the accident was the rough water.NTSB CHI93LA229Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Point Lookout, MOThe pilot in command's failure to maintain proper glide path, and her failure to attain the proper touch down Point.NTSB SEA93LA114Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Moscow, IDThe inadequate visual lookout by the pilot and his failure to maintain clearance from electrical transmission wires. Factors relating to the accident were the sunglare and the presence of the wires.NTSB ANC93LA065Accident · No injuriesLimited investigationFinal reportCessna 172K · Rohn Roadhouse, AKThe pilot in command's inadequate compensation for the wind conditions and allowing the airspeed to go below stalling speed in the landing configuration.NTSB NYC93LA092Accident · No injuriesLimited investigationFinal reportCessna P337 · Holland, VAThe pilot's improper inflight planning during the approach for landing, resulting in a touchdown too FAR down the runway, and the subsequent collision with objects off the end of the runway.NTSB ATL93FA060Accident · Serious injuriesField investigationFinal reportCessna 337D · Nashville, TNThe pilot's failure to ensure an adequate fuel supply for the flight, which resulted in fuel exhaustion.NTSB DEN93LA018Accident · No injuriesLimited investigationFinal reportCessna 172E · Ramah, COA total loss of engine power due to mechanical failure of the number one connecting rod. A factor was: a forced landing onto unsuitable terrain.