NTSB investigations: Continental O-470 series
97 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “In flight collision with object”. 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 ('17026')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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 ('17026')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.NTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).NTSB NYC96LA072Accident · No injuriesLimited investigationFinal reportCessna 182L · Weedsport, NYthe pilot's decision to takeoff on a closed snow-covered runway, and his inadequate compensation for a crosswind. A factor in the accident was the pilot's lack of recent flying experience.NTSB ATL96FA018Accident · 2 fatalField investigationFinal reportNavion D · Canton, GAThe pilot's impairment of judgement and performance due to drugs which led to his overconfidence of personal ability and continued flight into known adverse weather conditions. The weather conditions and dark night were factors.NTSB SEA96LA014Accident · No injuriesLimited investigationFinal reportCessna 180J · Stanley, IDthe pilot's failure to maintain clearance with obstacles at the end of the takeoff area. His failure to attain sufficient altitude to clear the obstacles was a factor.NTSB LAX96LA040Accident · 2 fatalLimited investigationFinal reportCessna 180 · Placerville, CAthe pilot's intentional buzzing, his failure to identify an obstruction (inadequate visual lookout), and his failure to maintain adequate altitude/clearance from the obstruction (utility pole). Factors relating to the accident were: dust generated by farm…NTSB ANC95LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Minto, AKThe pilot's failure to abort the takeoff in a timely manner. A factor relating to the accident was: the pilot's failure to use all of the available area (waterway) for the takeoff.NTSB CHI95LA090Accident · No injuriesLimited investigationFinal reportCessna 180J · Cotton, MNthe pilot's failure to gain sufficient clearance over the trees during the aborted landing.NTSB FTW94FA315Accident · 2 fatalField investigationFinal reportCessna 182K · Heeney, COThe pilot's failure to maintain terrain clearance. A factor was the rising terrain.NTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.NTSB ATL94LA087Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellijay, GAThe inadvertent deployment of the parachute because of the jumpmaster's inattention to the static line.NTSB FTW93LA232Accident · No injuriesLimited investigationFinal reportCessna 182A · Killeen, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswinds.NTSB ATL92LA104Accident · 1 fatalLimited investigationFinal reportCessna 188 · Elba, ALThe pilot's failure to maintain clearance from objects (trees), and his inadequate visual lookout. A factor was the trees located in the practice area.NTSB LAX92LA210Accident · 1 fatalLimited investigationFinal reportCessna 182A · S.Lake Tahoe, CAThat the pilot-in-command used poor judgment by flying at an unwarranted low altitude and misjudged the clearance between the tree tops and the airplane.NTSB ANC92LA071Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Chitina, AKThe pilot's failure to maintain proper alignment with the landing area. Contributing factors were the gusty wind and the trees.NTSB ATL92LA067Accident · 1 fatalLimited investigationFinal reportCessna 182 · Barnwell, SCThe pilot's failure to maintain a safe altitude above the ground while making a low pass at night.NTSB SEA92LA053Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Quilcene, WAThe pilot's failure to maintain directional control. Factors include a poor in flight decision and unfavorable/gusty winds.NTSB CHI92LA025Accident · No injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadvertent deployment of the sky diver's parachute.NTSB SEA91LA125Accident · No injuriesLimited investigationFinal reportCessna C-182A · Buhl, IDThe intentional high speed buzzing by the pilot, and his failure to maintain clearance from obstacles on the ground.NTSB ATL90FA144Accident · 1 fatalField investigationFinal reportCessna 305A · Fruitdale, ALThe pilot exercised poor judgment by attempting to operate the airplane while impaired by alcohol.NTSB ATL90FA132Accident · 1 fatalField investigationFinal reportCessna 182E · Newland, NCAttempted VFR flight into instrument meteorological conditions.NTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.NTSB FTW89DRD15Accident · Serious injuriesFinal reportCessna 188 · Winnsboro, LAThe pilot's inadequate visual lookout and subsequent collision with a tree.NTSB MIA89LA131Accident · No injuriesLimited investigationFinal reportCessna 182P · Tavernier, FLFailure of the pilot to maintain runway alignment and retract the flaps to the recommended setting during the go-around.NTSB ANC89LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Meshik Lake, AKThe pilot was attempting to takeoff from an unimproved landing area with two hunter-friends. He stated that the aircraft bounced three times, reached an altitude of about four feet, then hit the ten-foot high trees at the departure end of the area and nosed…NTSB ANC89LA001Accident · No injuriesLimited investigationFinal reportCessna 180 · Wasilla, AKDrg arrival to land on a lake at night, the plt began a 180 deg turn from a NE heading at aprx 500' AGL to a final apch on a sw heading. As the acft was in the turn, it began losing altitude rapidly. The plt applied power to stop the descent, but the acft…NTSB LAX87FA077Accident · 1 fatalField investigationFinal reportCessna 182Q · Essex, CAUpon reaching his destination the pilot descended to make a message drop. He selected a flight path that was perpendicular to a 55 foot tall, unmarked, electrical power line. During the low pass for the drop the aircraft collided with the electrical wires.…NTSB LAX87LA352Accident · 2 fatalLimited investigationFinal reportCessna 180K · Lakeport, CAThe plt & his daughter were believed to have depd his pvt airstrip on 11/22/86 or 11/23/86. They were rprtd missing on 11/24/86 & a search was begun, but the acft was not fnd until 8/19/88, when the wreckage was discovered by hunters. The crash site was…NTSB SEA86LA235Accident · 2 fatalLimited investigationFinal reportCessna 182D · Stibnite, IDAfter taking off in mountainous terrain, the pilot prematurely turned on course to a northerly heading, intending to cross over a ridge line. Shortly after the turn, and while flying up a drainage area towards rising terrain, he encountered a downdraft…NTSB ATL86FA129Accident · 1 fatalField investigationFinal reportCessna 182P · Bay Minette, ALThe acft collided with trees during a descent. The plt was attempting to fly below the overcast to determine his location. The plt radioed just prior to his descent to announce his intentions to his destination UNICOM. There were no further communications…NTSB LAX86FUA01Accident · No injuriesFinal reportBeech J35 · Long Beach, CAThe acft collided with an object in flt. The plt reported that his right wing had been struck by what he thought was a large bird. After a safe landing at nearby Long Beach arpt the acft was examined. The rt wing had a hole aft of the leading edge and…NTSB FTW86LPA19Accident · No injuriesFinal reportCessna 182A · Decatur, TXThe acft was damaged in a collision with a power line during a low pass over a field. The acft was landed off arpt in a field after the collision with the wires. Half the rudder and vert fin were separated, the wing was torn and the prop nicked during the…NTSB DEN86LA078Accident · No injuriesLimited investigationFinal reportCessna 182 · Wray, COAccording to the plt, the acft contacted a twr with the nose gear while he was making a visual surveillance of a private airstrip prior to landing. The plt said he diverted to a nearby arpt to land. During landing, fuel from broken fuel lines ignited & the…NTSB NYC86FA030Accident · 2 fatalField investigationFinal reportCessna C-182N · Winterport, METhe acft departed bangor under special VFR dur to low ceilings. A witness saw the acft fly under powerlines that crossed a river and disappear behind trees. There was no indication of an accident. 22 day later, the acft was located 150 ft south from the…NTSB DEN85FTE08Accident · Minor injuriesFinal reportCessna 182N · Alamosa, COThe acft contacted trees, a fence and a ditch during a precautionary landing on a dirt road. The plt stated that when approaching his destination, the eng began running rough and he was unable to correct the problem. He then decided to land on the road and…NTSB ATL85LA150Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Bayou La Batre, ALInadvertant opening of parachute in aircraft during climb to jump altitude pulled jumper from aircraft. Jumper struck right horizontal tail. Control of aircraft was lost and the pilot and the other three jumpers exited the aircraft, deployed their chutes and…NTSB MKC85FA039Accident · 1 fatalField investigationFinal reportCessna 180K · Ft.Smith, ARWitnesses along the Arkansas river observed the acft flying low over the river, in a northeasterly direction. As the acft approached a set of high voltage power lines that crossed the river aprx 85 ft above the water, it banked left and the rt wing struck the…NTSB MKC84FA245Accident · Serious injuriesField investigationFinal reportCessna 188 · Bloom, KSThe acft struck two guy wires during a spraying operation when the plt failed to clear the wires. Operators heard the impact which occurred about 160 AGL & toppled the 310 ft tower. The acft wings were separated from the fuselage which continued to the west…NTSB FTW84LA313Accident · No injuriesLimited investigationFinal reportCessna 182M · Georgetown, TXWhile on a x-country flight the acft experienced a bird strike. The plt elected to return to the departure airfield for a precautionary landing. She made two hard landings on the first approach and then recovered and made a go-around. On the next approach she…NTSB FTW84LA106Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Corsicana, TXThe acft collided with wires shortly after takeoff as the plt maneuvered at low altitude. After the collision the acft flew for about 1/4 mile and crashed in an unimproved field on a farm. There was no passenger seat in the acft and the passenger was…NTSB NYC84FA058Accident · 2 fatalField investigationFinal reportBeech T-34A · Stockton, NJPrior to the accident, the acft was observed in aerobatic type maneuvers. According to one witness, he saw the acft enter a descent after it had completed a roll maneuver. It was still in a steep descent when he lost sight of the acft due to trees. The acft…NTSB ATL83LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Tallassee, ALAs the student jumper was getting out of the aircraft and onto the step in preparation for a parachute jump the pack tray prematurely opened and the canopy blossomed under the tail pulling the jumper into the horizontal stabilizer causing a cut on his left…NTSB FTW83FRG04Accident · 2 fatalFinal reportCessna 182L · Near Mcallen, TXThe aircraft departed Mcallen, TX at 1903 CST to an unknown destination. During departure, it was observed heading northwest. About 1 1/2 hrs later, it was again observed in the vicinity, about 7 miles northwest of Mcallen, TX. Witnesses stated that the plane…NTSB ATL83FA012Accident · 1 fatalField investigationFinal reportCessna 182P · Conyers, GAAircraft was observed making low passes. During on of these low passes aircraft collided with wires, trees and a tennis court. Pilots blood ethanol level was 214 mg percent. The pilot had not been given permission by the owner to fly the aircraft.NTSB NYC82FA193Accident · 2 fatalField investigationFinal reportCessna 180H · Porter, METhe acft was taking off from a pond which is about 4,200 ft at its longest length. A power line extends across the pond about 2,000 ft from the south end. The acft was observed to takeoff to the north remaining on the water while passing under the wires. The…NTSB ANC82DAA09Accident · No injuriesFinal reportCessna 182 · Ft. Yukon, AKThe pilot stated that he overflew the Ft. Yukon airport and observed men working on runway 21. He flew a downwind pattern for runway 03. While on final approach to runway 03 the pilot observed an "x" on the end of the runway the pilot attempted a landing off…NTSB CHI82DA154Accident · Minor injuriesFinal reportCessna 182 · Ottawa, ILThe aircraft collided with a truck off the approach end of the runway during a low, no flap approach. According to the pilot a caution sign for vehicles using the road had been removed by vandals and he did not see the truck because of his low approach. The…