NTSB investigations: Continental IO-520 series
144 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “In flight collision with terrain/water”. 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 ('17032')
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\" = 230))
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 ('17032')
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" = 230))
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 NYC98FA035Accident · 2 fatalField investigationFinal reportCessna 310R · St Mary'S, PAwas the pilot's descent below the minimum descent altitude and his failure to comply with published procedures.NTSB CHI98LA051Accident · No injuriesLimited investigationFinal reportBeech E55 · Gardner, KSthe inadvertant landing gear retraction, which occurred due to undetermined reason(s).NTSB LAX98FA031Accident · 4 fatalField investigationFinal reportCessna U206B · Markleeville, CAthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the excessive gross weight of the airplane, the high density altitude, and the…NTSB CHI97LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Elwood, NEthe pilot not maintaining clearance from the bushes. Factors contributing to this accident were the pilot's inadequate preparation prior to the takeoff attempt, his changing flap positions during the takeoff run which degraded the airplane's performance…NTSB FTW97LA297Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Creede, COThe pilot's intentional low altitude flight over mountainous terrain, inadequate altitude to clear surrounding obstacles, and his misjudging vertical clearance. A factor was the pilot's use of an inappropriate chart for navigation.NTSB ANC97LA110Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilots failure to maintain terrain clearance during the downslope, downwind, high altitude, takeoff. Factors were the snow and lighting conditions, and the tailwind takeoff.NTSB ANC97LA078Accident · No injuriesLimited investigationFinal reportCessna 185F · Ketchikan, AKthe pilot allowed an excessive rate of descent to develope during an approach to land, and delayed in initiating a go-around.NTSB LAX97LA041Accident · No injuriesLimited investigationFinal reportBeech F33A · Marana, AZimproper planning/decision by the flight instructor (CFI), which resulted in his failure to recover from a descent during demonstration of a simulated (engine-out) emergency procedure.NTSB ANC96LA135Accident · No injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKthe pilot's improper in-flight planning/decision, which resulted in intering a box canyon with insufficient altitude to either execute a turn to safety or outclimb rising terrain. A factor associated with the accident was: the pilot allowed the passenger to…NTSB ANC95LA049Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Old Harbor, AKThe pilot's continued flight into known adverse weather. The whiteout condition was a factor.NTSB ANC95LA036Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's continued VFR flight into IMC conditions and a failure to maintain altitude. A factor in the accident was 'whiteout' weather conditions.NTSB SEA95FA038Accident · 3 fatalField investigationFinal reportBeech V35 · Moose, WYThe pilot's failure to fly the proper glidepath. A factor was the dark night light conditions.NTSB ANC95LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Angoon, AKThe pilot's continued flight into adverse weather. A factor related to the accident was the snow conditions.NTSB LAX94FA171Accident · 2 fatalField investigationFinal reportCessna 206 · Show Low, AZthe pilot's intentional VFR flight into known adverse IMC weather conditions. Inadequate preflight planning, dark night operations, and weather conditions that included low ceilings and mountain obscuration were factors in the accident.NTSB LAX93LA357Accident · No injuriesLimited investigationFinal reportCessna 210F · Chino, CAthe pilot's inadequate compensation for the downdraft and his failure to maintain the proper glidepath.NTSB ANC93LA174Accident · 1 fatalLimited investigationFinal reportCessna 206 · Swikshak Bay, AKThe pilot-in-command's failure to attain a proper climb rate.NTSB ANC93LA170Accident · 1 fatalLimited investigationFinal reportCessna 185 · Hulahula River, AKThe pilot in command's attempted VFR flight into IMC conditions. Factors contributing to the accident were the high terrain and the obscuration.NTSB ANC93LA121Accident · No injuriesLimited investigationFinal reportCessna 206G · Kelly River Bar, AKThe pilot's failure to assure that adequate takeoff distance was available. The rough/uneven terrain was a factor.NTSB ANC93FA081Accident · Minor injuriesField investigationFinal reportCessna A185E · Anchorage, AKThe pilot in command exceeding the maximum authorized gross takeoff weight of the airplane and his failure to compensate for the wind conditions. A factor in the accident was the gusty wind condition.NTSB ANC93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Scammon Bay, AKThe pilots failure to follow VFR procedures. A factor was the whiteout snow condition.NTSB CHI93LA052Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Cedar Rapids, IAThe pilot-in-command's failure to maintain a proper glidepath.NTSB ATL93FA028Accident · 1 fatalField investigationFinal reportBeech 58 · West Columbia, SCThe pilot's continued operation with known deficient equipment, his improper descent, and his failure to perform a missed approach. A factor was the operator's inadequate surveillance of the pilot's procedures and the maintenance of the airplane.NTSB ATL92LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's inadequate compensation for existing wind conditions, which resulted in his inability to maintain a proper altitude. Factors were the turbulence and wind shear present at the time of the accident.NTSB LAX92FA220Accident · 2 fatalField investigationFinal reportBeech S-35 · Avalon, CA1) Improper preflight planning, 2) the pilots selection of the wrong runway for departure which put the aircraft immediately in an area of restricted visibility and fog after liftoff, 3) the pilots intentional flight into instrument conditions, and 4) his…NTSB ANC91LA130Accident · Minor injuriesLimited investigationFinal reportCessna U206-G · Rainy Pass, AKThe pilot exceeded the climb performance of the aircraft.NTSB CHI91FA266Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boyne City, MIThe pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..NTSB SEA91LA206Accident · No injuriesLimited investigationFinal reportBeech V35B · Belgrade, MTThe pilot's failure to maintain a positive rate of climb during the takeoff. Factors contributing to the accident were the open cabin window and the pilot's diverting his attention.NTSB FTW91DRG02Accident · No injuriesFinal reportCessna 188 · La Feria, TXThe pilot exceeded the proper descent rate.NTSB LAX91LA149Accident · Minor injuriesLimited investigationFinal reportBeech V-35-A · Superior, AZVisual flight into instrument meteorological conditions.NTSB FTW91FA049Accident · 2 fatalField investigationFinal reportBeech 36 · New Braunfels, TXThe pilot's disregard for the minimum descent altitude and failure to perform a missed approach. Factors were the pilot's attempt to fly into known adverse weather conditions, low ceiling, rain, and fog.NTSB ANC90FA158Accident · 2 fatalField investigationFinal reportCessna 414 · Sitka, AKImproper planning/decision by the pilot, and his failure to follow IFR procedures and maintain clearance from mountainous terrain.NTSB DEN90DTE05Accident · No injuriesFinal reportCessna 188B · Eckley, COA failure on the part of the pilot in command to maintain adequate terrain clearance.NTSB DEN90LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Michigan, NDThe failure of the pilot to maintain proper alignment during landing.NTSB MKC89LA140Accident · No injuriesLimited investigationFinal reportCessna 188B · Grygla, MNInadequate preflight planning and preparation by the pilot. Tall grass (high vegetation) at the end of the strip was a contributing factor.NTSB NYC89FA059Accident · 1 fatalField investigationFinal reportBeech A36 · Bridgeport, CTTwice prior to being established on final the pilot was asked if he was getting proper indications for the approach to land. Contact was subsequently lost while the pilot was attempting to make an ILS approach to runway 06 at Bridgeport. The aircraft was…NTSB MKC88LA155Accident · No injuriesLimited investigationFinal reportCessna 188B · Sumner, IADuring takeoff for an aerial application operation, the pilot said he was not able to climb high enough to clear a 4 foot high road at the end of the runway. He collided with the road, shearing off the main ldg gear and substantially damaging the acft. He…NTSB ATL88DKG09Accident · 1 fatalFinal reportCessna 188 · Garfield, GAFollowing minor engine maintenance, the plt/mechanic made the test flight. The engine cowling was not installed prior to the flt. Witnesses reported that the acft wheels touched the water of a nearby pond followed by a sharp pull-up into the plt's customary…NTSB ANC88FA083Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKThe flight departed six mile lake on elmendorf air force base and was destined for coghill lake. The airplane was found at the 2500 foot level of a mountain on the north side of burns glacier. The airplane heading was 324 degrees. The heading to go through…NTSB FTW88LA053Accident · No injuriesLimited investigationFinal reportBeech V35B · Temple, TXThe pilot failed to execute a missed approach when he descended through decision height.NTSB MKC88FA037Accident · No injuriesField investigationFinal reportBeech 58 · Dewitt, ARThe pilot of N4613S was making a VFR approach into the de witt, Arkansas municipal airport. Snow had been removed from the runway and piled up on the approach end of runway 35. The nose gear of the aircraft contacted the piled up snow/ice at touchdown,…NTSB NYC88FA032Accident · 2 fatalField investigationFinal reportBeech F-33A · Forked River, NJThe pilot and passenger departed white plains, new york on a VFR flight to kill devil hills, north carolina. Search efforts were initiated when the aircraft failed to arrive at its destination. A witness in a hunting camp near the crashsite saw the aircraft…NTSB MKC87LA134Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Benton, ARDuring a positioning flt to pick up revenue passengers, PIC neglected to lower ldg gear for ldg. Acft was substantially damaged. PIC stated he forgot to lower gear and no warning horn had activated.NTSB ANC87LA018Accident · No injuriesLimited investigationFinal reportCessna U206G · Uganik Pass, AKThe pilot stated that he encountered a complete white-out condition; he started a turn to the left and struck the top of the ridge at the 1780 foot level.NTSB SEA86FA194Accident · 1 fatalField investigationFinal reportCessna 310C · Vancouver, WAPlt not IFR rated. Attempted departure from own airstrip in fog during early dawn. Positive rate of climb not established. Acft contacted terrain 3/4 mile from runway end. Psgrs reported no sensation of power probs, but complete loss of ground ref at liftoff.…NTSB SEA86LA192Accident · Minor injuriesLimited investigationFinal reportCessna 185FII · Reno, NVPlt attempted takeoff with acft 540 pounds over max cert wt and 8500 ft density altitude conditions. Acft became airborne but positive climb and airspeed increase not possible. Plt turned to avoid obstructions, putting acft into semi-controlled collision with…NTSB FTW86FA115Accident · 1 fatalField investigationFinal reportCessna P206C · Grand Chenier, LAThe aircraft impacted the marshy terrain while in a very shallow descent and wings level attitude and at a relatively high speed (I.e.,cruise). It then cartwheeled and slid to a stop. There was evidence of substantial engine power being developed at impact.…NTSB CHI86FER08Accident · No injuriesFinal reportCessna A188B · Montevideo, MNDuring takeoff roll from a roadway the wind shifted from a headwind to a tailwind. The pilot of this crop duster turned to avoid a stop sign on the roadway and allowed his landing gear to touch down on a crossing roadway. The aircraft then flipped over onto…NTSB BFO86FID04Accident · No injuriesFinal reportCessna 210N · Blacksburg, VAWhile landing at Blacksburg airport in Blacksburg, Virginia, the landing gear failed to extend. The aircraft collided with a runway light and served off the runway onto a grass area causing substantial damage to the left stabilizer and elevator. The pilot…NTSB LAX86LA035Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Fresno, CAThe acft approached the rwy for landing without the landing gear extended. The controller instructed the plt to go around but the plt continued the apch and landed with the gear retracted. Post accident inspection of the acft disclosedthe gear selector was in…NTSB ATL86LMG01Accident · No injuriesFinal reportCessna 310R · Rocky Mount, NCThe acft touched down 150 ft short of rwy 04 at the Rocky mountain-wilson arpt. The acft contacted two rows of apch lights and a ground drop off which sheared all three landing gears. The flt departed wilson municipal arpt and upon reaching 3700 ft the plt…