NTSB investigations: Continental O-470 series
150 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - in flight”. 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 per year
| 1982 | 5 |
|---|---|
| 1983 | 11 |
| 1984 | 3 |
| 1985 | 12 |
| 1986 | 7 |
| 1987 | 10 |
| 1988 | 7 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 8 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 12 |
| 2004 | 7 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 9 |
Where
Latest cases
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\" = 250))
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" = 250))
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 ANC07FA102Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe failure of the pilot's seat to engage, or remain engaged, and the pilot's inadvertent stall/mush during takeoff-initial climb. Contributing to the accident was the failure of maintenance personnel to comply with an FAA AD regarding the pilot's seat rails.NTSB ANC07CA084Accident · No injuriesData collectionFinal reportCessna 180 · Skwentna, AKThe pilot's inadequate compensation for wind conditions during takeoff initial climb, which resulted in the airplane descending uncontrolled into high vegetation. Factors contributing to the accident were wind gusts and a crosswind.NTSB NYC07FA173Accident · 1 fatalField investigationFinal reportCessna 150L · Hammondsport, NYThe pilot's inadequate in flight decision and failure to maintain aircraft control during cruise flight. Contributing to the accident were inadequate preflight planning, dark night and poor weather conditions.NTSB SEA07CA198Accident · No injuriesData collectionFinal reportCessna 182B · Leadore, IDThe pilot's inadequate compensation for the gusty wind conditions and his failure to maintain aircraft control, which resulted in a loss of control and collision with terrain during the takeoff initial climb. A contributing factor was the gusty wind condition.NTSB SEA07LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Moab, UTThe pilot's failure to maintain control of the airplane while maneuvering after takeoff.NTSB SEA07FA119Accident · 5 fatalField investigationFinal reportCessna 182C · Marion, MTThe pilot’s failure to maintain aircraft control while maneuvering to reverse direction. Factors included the airplane exceeding its maximum gross takeoff weight, the improper preflight by the pilot by not securing an oil cap, the low altitude, and an…NTSB LAX07LA140Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Carlsbad, CAthe pilot's loss of control due to spatial disorientation.NTSB SEA07GA112Accident · 1 fatalFinal reportCessna 182R · Rachal, TXThe pilot's failure to maintain aircraft control while maneuvering, which resulted in an inadvertent stall/spin and subsequent impact with the ground. A factor was the gusty tailwind condition.NTSB DFW07FA055Accident · 1 fatalField investigationFinal reportCessna 310 · Jackson, MSThe pilot's loss of control for undetermined reasons.NTSB NYC07FA047Accident · 1 fatalField investigationFinal reportCessna 310Q · Montgomery, NYImproper maintenance performed on the airplane by maintenance personnel, and the failure of the mechanic with an inspection authorization (IA) to verify the maintenance work performed, which resulted in a reverse elevator trim system, and subsequent loss of…NTSB SEA06CA174Accident · No injuriesData collectionFinal reportCessna 180 · Arock, ORThe pilot's failure to maintain directional control during a go-around, resulting in an in-flight collision with trees and substantial damage to the airplane. Factors included the pilot's failure to attain the proper touchdown point, the delayed go-around,…NTSB ANC06CA097Accident · No injuriesData collectionFinal reportCessna 180 · Anchor Point, AKThe pilot's inadequate compensation for wind conditions, which resulted in a collision with high brush during the landing flare. A factor contributing to the accident was wind gusts.NTSB SEA06LA140Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDThe pilot's failure to maintain directional control of the aircraft during takeoff and initial climb out.NTSB CHI06CA156Accident · No injuriesData collectionFinal reportCessna 182N · Cooperstown, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control while landing. Factors associated with the accident were the crosswind condition, the high vegetation which the airplane contacted, and the high…NTSB DEN06CA074Accident · No injuriesData collectionFinal reportCessna 182Q · Fort Bridger, WYthe pilot's failure to maintain aircraft control during the landing flare and touchdown. Contributing to the accident was the high, gusty crosswinds.NTSB NYC06CA183Accident · No injuriesData collectionFinal reportCessna 180H · Blue Bell, PAThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in the right wing contacting the runway. A factor was the crosswind.NTSB DEN06CA021Accident · Minor injuriesData collectionFinal reportCessna 182E · Lansing, KSthe pilot's inability to maintain aircraft control during the forced landing which resulted in a collision with terrain. A contributing factor was the pilot becoming ill during cruise flight.NTSB CHI06CA039Accident · Serious injuriesData collectionFinal reportLarson Aero Comp-6 · Brainerd, MNThe pilot/builder inadvertently reversed the aileron control systems during installation and failed to maintain control of the airplane during takeoff. A factor associated with the accident was the pilot/builder’s failure to perform an adequate aircraft…NTSB DFW06CA014Accident · No injuriesData collectionFinal reportCessna 182J · San Antonio, TXThe pilot's failure to compensate for prevailing wind conditions and his delay in executing a go-around. A contributing factor was the gusty winds.NTSB NYC05FA109Accident · 4 fatalField investigationFinal reportCessna 182Q · Groton, CTThe pilot's failure to maintain aircraft control while executing an ILS (Instrument Landing System) approach to minimums.NTSB NYC05FA100Accident · 1 fatalField investigationFinal reportCessna 182Q · Stockholm, NJThe pilot's failure to maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the ground. Factors in this accident were clouds, and the pilot's spatial disorientation.NTSB DFW05CA130Accident · Serious injuriesData collectionFinal reportCessna 182P · Lowell, ARThe instructor's inadequate supervision and the second pilot's inadequate planning/decision to assure adequate takeoff performance to clear obstacles. Contributing factors were the prevailing quartering tailwind, the pilots selection of the wrong runway, and…NTSB LAX05FA079Accident · 1 fatalField investigationFinal reportCessna 180 · Adelanto, CAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an attempted go-around, resulting in a loss of control and collision with terrain.NTSB LAX05FA076Accident · Minor injuriesField investigationFinal reportBeech P35 · Willits, CAThe pilot's failure to maintain control of the airplane during an instrument landing approach, resulting in an in-flight collision with trees and terrain. Factors contributing to the accident were turbulence, and the pilot's diverted attention.NTSB SEA05FA034Accident · 2 fatalField investigationFinal reportCessna 182R · Monroe, LAThe failure of the pilot manipulating the controls to maintain aircraft control during a night missed approach in instrument meteorological conditions. Factors include a dark night and low ceilings.NTSB NYC04CA202Accident · Minor injuriesData collectionFinal reportCessna 305A · Lawrence, MAThe pilot's inadvertent pickup of a banner towline with the airplanes main landing gear after encountering gusting wind conditions. A factor related to the accident was the gusting wind conditions.NTSB FTW04TA219Accident · Serious injuriesFinal reportCessna 182Q · Lamar, OKThe pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.NTSB ANC04LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Talkeetna, AKThe pilot's inadequate compensation for the wind conditions during cruise flight, which resulted in the airplane impacting the lake. A factor associated with the accident was a downdraft, and low altitude flight.NTSB NYC04FA137Accident · 1 fatalField investigationFinal reportCessna 182C · Kutztown, PAThe towplane pilot's failure to maintain a climb while towing a glider for undetermined reasons, which resulted in the early release of the glider and the tow plane's subsequent impact with trees.NTSB ATL04LA103Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Sale Creek, TNThe pilot's failure to maintain airspeed, and the pilot's alcohol impairment that resulted in an inadvertent stall and collision with the ground.NTSB SEA04FA060Accident · 3 fatalField investigationFinal reportCessna 182Q · Santiam Junc., ORThe pilot's failure to maintain adequate airspeed which resulted in a stall while attempting a low-level crossing of a ridge from the leeward to the windward side. Factors include low-level maneuvering, strong gusty winds, and downdrafts.NTSB SEA04FA032Accident · 4 fatalField investigationFinal reportCessna 182G · Glasgow, MTLoss of aircraft control resulting in an in-flight collision with terrain. Factors include marginal weather and dark night conditions.NTSB DEN04LA004Accident · No injuriesLimited investigationFinal reportCessna 182L · Randolph, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing factors were the wind gusts and crosswind conditions.NTSB ATL03LA145Accident · No injuriesLimited investigationFinal reportCessna 180 · Pavo, GAThe pilot's failure to maintain airspeed, resulting in an inadvertent stall.NTSB CHI03LA310Accident · No injuriesLimited investigationFinal reportCessna 182D · Rushville, INThe pilot failed to maintain control of the airplane during the initial takeoff climb which resulted in an inadvertent stall.NTSB NYC03LA196Accident · Minor injuriesLimited investigationFinal reportCessna 180D · Greenville, METhe inadequate installation and inspection of an aileron cable by maintenance personnel, which resulted in a loss of control in-flight and subsequent collision with water.NTSB LAX03CA272Accident · No injuriesData collectionFinal reportCessna 182J · Marble Canyon, AZthe failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.NTSB CHI03FA251Accident · 1 fatalField investigationFinal reportCessna 182G · Topeka, KSThe pilot's failure to maintain adequate airspeed resulting in a stall during takeoff. Contributing factors were the low altitude he was at during the takeoff, and the trees.NTSB FTW03FA174Accident · 1 fatalField investigationFinal reportCessna 182H · Cushing, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB DEN03TA102Accident · Minor injuriesFinal reportCessna 182R · Hobbs, NMThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB LAX03TA174Accident · Minor injuriesFinal reportCessna 182Q · So Lake Tahoe, CAa loss of pitch flight control authority due to the disconnection and separation of the elevator DOWN control cable turnbuckle. The separation of the turnbuckle was due to the severance of the safety wire by unknown persons at an unknown time.NTSB DEN03TA082Accident · No injuriesFinal reportCessna 182R · Boulder, COthe pilot's failure to maintain aircraft control during landing flare/touchdown which resulted in a hard landing. A contributing factor was the pilot's improper flair.NTSB IAD03FA053Accident · 3 fatalField investigationFinal reportBeech 24R · Wauseon, OHThe pilots failure to maintain control during the approach-to-landing. Factors were the high wind gusts and turbulence, and the pilot's decision to fly in those conditions.NTSB CHI03FA088Accident · 1 fatalField investigationFinal reportCessna 182R · North English, IAThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident was the CFI's improper decision to attempt to takeoff from a short, grass taxiway instead of departing from a runway aligned with the prevailing winds,…NTSB CHI03LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Wheatfield, INThe pilot not maintaining aircraft control and the pilot's inadequate compensation for the gusting wind condition. Factors to the accident were the gusting wind condition and the inadvertent stall at a low altitude.NTSB ATL02FA156Accident · 3 fatalField investigationFinal reportCessna 182R · Lake City, TNThe pilot's failure to follow procedures pertaining to mountain flying, and the pilot's failure to maintain airspeed that resulted in an inadvertent stall and subsequent in-flight collision with trees and terrain. A factor was the certified flight instructor…NTSB LAX02FA041Accident · 2 fatalField investigationFinal reportCessna 182E · Prescott, AZthe pilot's failure to adequately deice the airplane prior to takeoff, which resulted in the airplane's degraded aerodynamic and climb performance capability, failure to maintain an adequate airspeed, and a stall/spin. Contributing factors were the pilot's…NTSB FTW01LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Gladewater, TXthe pilot's inadvertent visual flight into instrument meteorological conditions while maneuvering, which resulted in her spatial disorientation and subsequent loss of control of the airplane.NTSB FTW01LA134Accident · No injuriesLimited investigationFinal reportCessna 182K · Victoria, TXthe pilot's inadequate preflight inspection which resulted in an unsecured seat which slipped aft on takeoff.NTSB IAD01LA045Accident · No injuriesLimited investigationFinal reportCessna 182N · Cedarville, NJThe pilot's failure to maintain directional control during the landing flare. A factor was the wind gusts.