NTSB investigations: Continental O-470 series

6,204 cases on aircraft whose registry engine model is Continental O-470 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 ('17026'))
  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.

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.Aug 25, 2007 · N1560C · DestroyedNTSB DEN07FA140Accident · 3 fatalField investigationFinal reportCessna 182R · Dayton, WYthe pilot's inability to maintain aircraft control while maneuvering in mountainous terrain due to gusty wind conditions, and lee side turbulence. Contributing to the accident was the pilot's improper in-flight planning and decision making, and his failure to…Aug 20, 2007 · N6109N · DestroyedNTSB SEA07LA234Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDThe total loss of engine power due to the carburetor throat becoming obstructed with paint that had pealed off of the induction air inlet channel in an area where paint should not have been applied. Factors include an earthen berm running across the field…Aug 14, 2007 · N52581 · Substantial damageNTSB CHI07CA263Accident · Minor injuriesData collectionFinal reportCessna 180 · Princeton, MNThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the fuel siphoning from the right fuel tank.Aug 11, 2007 · N2311C · Substantial damageNTSB SEA07CA225Accident · No injuriesData collectionFinal reportCessna 182P · Bremerton, WAThe pilot's failure to maintain airspeed during the landing flare. A factor was the encounter of the stall and subsequent hard landing.Aug 10, 2007 · N1298M · Substantial damageNTSB CHI07CA264Accident · No injuriesData collectionFinal reportCessna 182 · Jasper, MNThe loss of engine power due to fuel starvation as a result of the pilot's inadequate preflight. The false indication of the fuel remaining in the fuel tanks and the corn crop were factors.Aug 10, 2007 · N52998 · Substantial damageNTSB ANC07CA075Accident · No injuriesData collectionFinal reportCessna 180 · Skwentna, AKThe failure of the left brake, and the pilot's continued operation with a known defect (the left brake), which resulted in a loss of control during the landing roll, and an on ground encounter with terrain. A contributing factor to the accident was the…Aug 8, 2007 · N7741A · Substantial damageNTSB CHI07CA253Accident · No injuriesData collectionFinal reportCessna 180A · Duluth, MNThe pilot's failure to maintain directional control, which resulted in impact with terrain during an attempted aborted landing. A factor in the accident was the geese impacted during the landing roll.Aug 1, 2007 · N5016E · Substantial damageNTSB SEA07CA215Accident · No injuriesData collectionFinal reportCessna 305-C · Chino, CAThe pilot's failure to maintain directional control during the landing roll.Jul 26, 2007 · N919BD · Substantial damageNTSB ANC07LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Arecibo, PRThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power during climb, and an off-airport forced landing.Jul 25, 2007 · N6428A · Substantial damageNTSB SEA07CA216Accident · No injuriesData collectionFinal reportCessna 182P · Baker City, ORThe pilot's failure to maintain airspeed and misjudged flare during landing.Jul 24, 2007 · N7380S · Substantial damageNTSB 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.Jul 24, 2007 · N10958 · Substantial damageNTSB 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.Jul 15, 2007 · N2625G · Substantial damageNTSB CHI07CA216Accident · No injuriesData collectionFinal reportCessna 180 · Madison, SDThe tailwheel vibrations during the landing roll that resulted in the tailwheel spring disconnect. Directional control was not possible and the grassy terrain were factors.Jul 15, 2007 · N3306D · Substantial damageNTSB DEN07CA121Accident · No injuriesData collectionFinal reportCessna 180 · Marble, COThe pilot misjudging his altitude and his failure to maintain control of the airplane, resulting in a hard landing. Factors contributing to the accident were the excessive descent rate, and the pilot's improper recovery from a bounced landing.Jul 14, 2007 · N3196D · Substantial damageNTSB LAX07LA216Accident · No injuriesLimited investigationFinal reportCessna 180A · Redding, CAFuel exhaustion due to the pilot's inadequate in-flight planning/decision concerning fuel system management and his failure to refuel while en route.Jul 13, 2007 · N5248D · Substantial damageNTSB DEN07CA117Accident · No injuriesData collectionFinal reportCessna 182R · Montpelier, VTThe pilot's improper flare and subsequent hard landing.Jul 10, 2007 · N9890H · Substantial damageNTSB LAX07LA212Accident · No injuriesLimited investigationFinal reportCessna 182G · Orland, CAFuel exhaustion due to the pilot's improper preflight inspection and preparation, and his failure to ensure adequate fuel was onboard for the anticipated flight.Jul 9, 2007 · N4521M · Substantial damageNTSB NYC07CA163Accident · Minor injuriesData collectionFinal reportCessna 182K · Matincus Island, MEAn evasive maneuver to avoid a bird, while on final approach, which resulted in an in-flight collision with trees.Jul 8, 2007 · N2762Q · Substantial damageNTSB NYC07CA161Accident · No injuriesData collectionFinal reportCessna 182Q · New Haven, CTThe pilot's improper flare which resulted in a hard landing. A factor to the accident was the wind gusts.Jul 8, 2007 · N759BY · Substantial damageNTSB DFW07LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Lexington, TXThe pilot's improper decision to takeoff from the unsuitable runway. Contributing to this accident was the soft terrain in the overrun area.Jul 8, 2007 · N5518B · Substantial damageNTSB NYC07LA160Accident · Minor injuriesLimited investigationFinal reportCessna Ector 305A · Berkeley Townsh, NJA loss of engine power during cruise flight for undetermined reasons.Jul 7, 2007 · N12633 · Substantial damageNTSB DEN07CA111Accident · No injuriesData collectionFinal reportCessna 180A · Loveland, COThe pilot's failure to maintain directional control of the airplane during landing.Jul 1, 2007 · N180EV · Substantial damageNTSB SEA07FA189Accident · 1 fatalField investigationFinal reportCessna 182Q · Cashmere, WAThe pilot's failure to maintain adequate clearance from trees while on final approach. A contributing factor was the sun glare.Jun 29, 2007 · N735KP · Substantial damageNTSB NYC07FA145Accident · 2 fatalField investigationFinal reportCessna 182C · Hiddenite, NCCarburetor icing, which resulted in a loss of engine power. Also causal, was the pilots' failure to maintain airspeed during the forced landing, which resulted in an inadvertent stall.Jun 21, 2007 · N8691T · DestroyedNTSB SEA07LA160Accident · No injuriesLimited investigationFinal reportCessna 182D · Phoenix, AZThe loss of engine power due to the intake manifold disconnection to the engine's cylinders on the left side.Jun 18, 2007 · N807X · Substantial damageNTSB NYC07LA144Accident · No injuriesLimited investigationFinal reportBeech T-34A · Maxton, NCA total loss of engine power for undetermined reasons.Jun 18, 2007 · N55192 · Substantial damageNTSB SEA07CA164Accident · Minor injuriesData collectionFinal reportCessna 180H · Nampa, IDThe pilot's failure to stop for additional fuel, which resulted in a loss of engine power due to fuel exhaustion.Jun 17, 2007 · N2467F · Substantial damageNTSB DFW07WA137Accident · 2 fatalForeign investigationCessna 182 · San Luis Gonzag, MexicoJun 15, 2007 · N5603B · DestroyedNTSB SEA07CA150Accident · No injuriesData collectionFinal reportCessna 182P · Aurora, ORThe pilot's misjudged flare during landing, and his improper recovery from a bounced landing, resulting in collision with the runway.Jun 4, 2007 · N58518 · Substantial damageNTSB DFW07CA127Accident · Minor injuriesData collectionFinal reportCessna 182L · Cheneyville, LAThe loss of engine power while climbing due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the soft terrain at the forced landing site.Jun 2, 2007 · N3356R · Substantial damageNTSB SEA07LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Moab, UTThe pilot's failure to maintain control of the airplane while maneuvering after takeoff.May 28, 2007 · N2164R · Substantial damageNTSB DEN07CA094Accident · Minor injuriesData collectionFinal reportCessna 180H · Grand Junction, COThe pilot's failure to maintain directional control during the take-off roll. A factor contributing to the accident was the crosswind.May 28, 2007 · N3408Y · Substantial damageNTSB 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…May 12, 2007 · N8771T · Substantial damageNTSB DFW07CA112Accident · No injuriesData collectionFinal reportCessna 180 · Austin, TXThe loss of engine power as result of carburetor icing. Contributing factors were the lack of suitable terrain for the forced landing and the weather conditions conducive to carburetor icing.May 10, 2007 · N2209C · Substantial damageNTSB CHI07CA136Accident · No injuriesData collectionFinal reportCessna 182P · Traer, IAThe pilot's failure to maintain control of the airplane during landing on the grass airstrip. A contributing factor was the pilot's limited experience operating on grass runways. Additional factors were the runway cone struck during landing and the irrigation…May 10, 2007 · N52621 · Substantial damageNTSB MIA07LA092Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Marstons Mill, MAThe pilot's improper preflight planning and preparation resulting in an in-flight loss of engine power due to fuel exhaustion.May 5, 2007 · N403RA · Substantial damageNTSB ATL07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Asheville, NCThe failure of the directional gyro and attitude indicator due to a vacuum system leak caused by a loose fitting. Contributing to the accident was the pilot's failure to execute a partial panel, no-gyro approach.May 4, 2007 · N735DP · Substantial damageNTSB LAX07LA140Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Carlsbad, CAthe pilot's loss of control due to spatial disorientation.Apr 29, 2007 · N97287 · DestroyedNTSB 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.Apr 25, 2007 · N6277E · DestroyedNTSB NYC07LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Russellville, KYA loss of engine power for undetermined reasons, during the initial climb after an aborted landing.Apr 21, 2007 · N299AA · Substantial damageNTSB MIA07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Cudjoe Key, FLThe pilot's failure to maintain clearance from an active restricted area, which resulted in the airplane colliding with the tether of an aerostat.Apr 21, 2007 · N422G · Substantial damageNTSB DFW07CA092Accident · Minor injuriesData collectionFinal reportCessna 182E · Marietta, OKThe airplane noseover due to the pilot's failure to obtain current NOTAM information on the closed airport. A contributing factor was the unsuitable terrain.Apr 15, 2007 · N3280Y · Substantial damageNTSB ATL07CA075Accident · Minor injuriesData collectionFinal reportCessna 182B · ST. Mary's, GAThe pilot's decision to operate an airplane with known deficiencies in equipment (inoperative carburetor heat control cable) resulting in a total loss of engine power due to carburetor icing.Apr 14, 2007 · N2455G · Substantial damageNTSB DEN07CA084Accident · No injuriesData collectionFinal reportCessna 180C · Santa Fe, NMExceeding the airplane's maximum demonstrated crosswind component during the takeoff roll. A contributing factor was the crosswind.Apr 11, 2007 · N9253T · Substantial damageNTSB LAX07CA116Accident · No injuriesData collectionFinal reportCessna 180D · Winslow, AZthe pilot's failure to maintain directional control during landing.Mar 29, 2007 · N6450X · Substantial damageNTSB LAX07CA111Accident · Serious injuriesData collectionFinal reportCessna 182 · Diamond Lake, ORFuel exhaustion due to the pilot's inadequate preflight inspection and failure to verify the fuel supply. A factor was the night lighting condition.Mar 17, 2007 · N6462A · Substantial damageNTSB SEA07CA076Accident · No injuriesData collectionFinal reportCessna 182H · Phoenix, AZThe pilot's inadequate preflight inspection, resulting in fuel exhaustion and the loss of power. A factor was the sign.Mar 14, 2007 · N1903X · Substantial damageNTSB CHI07LA086Accident · 1 fatalLimited investigationFinal reportCamair 480 · East Liberty, OHThe uncontrolled descent for undetermined reasons.Mar 8, 2007 · N209 · DestroyedNTSB LAX07LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Banning, CALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was the unfavorable wind condition.Mar 3, 2007 · N735SD · Substantial damage