Fatal NTSB investigations: Continental I0-470 series
39 cases on aircraft whose registry engine model is Continental I0-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
| 1983 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 5 |
| 1989 | 1 |
| 1991 | 2 |
| 1993 | 2 |
| 1994 | 2 |
| 1996 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 1 |
| 2006 | 3 |
| 2007 | 2 |
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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17027')
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17027')
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 NYC07FA096Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Saranac Lake, NYThe pilot's failure to maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall.NTSB LAX07LA130Accident · 3 fatalLimited investigationFinal reportBeech 35-B33 · Sedona, AZThe pilot's inadequate compensation for the high wind conditions and wind shear encounter on final approach, that led to a failure to maintain an adequate airspeed and a stall.NTSB CHI06FA264Accident · 1 fatalField investigationFinal reportBeech BE-95-B55 · N. Sioux City, SDThe pilot's failure to maintain control of the airplane during cruise flight, and subsequent inadvertent flat spin from which he could not recover. Contributing to the accident were clouds, turbulence, and rain showers.NTSB DFW06FA205Accident · 1 fatalField investigationFinal reportBeech BE95 A-55 · McGregor, TXThe pilot's failure to maintain airspeed resulting in a stall and loss of control of the airplane.NTSB NYC06FA162Accident · 2 fatalField investigationFinal reportCessna 310D · Sutton, WVThe pilot's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/mush. A factor associated with the accident was the inadvertent stall/mush.NTSB ANC04FA021Accident · 1 fatalField investigationFinal reportBeech J35 · Pensacola, FLThe pilot's improper decision to conduct flight that exceeded his demonstrated skills/ability. Also causal was his failure to properly execute the instrument approach. Contributing factors were low ceiling, fog, and the pilot's lack of the appropriate…NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.NTSB LAX03LA270Accident · 1 fatalLimited investigationFinal reportBeech K35 · Gerlach, NVthe pilot's failure to maintain an adequate airspeed resulting in a stall mush and collision with terrain.NTSB NYC03FA136Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Harned, KYThe airplane's in-flight collision with terrain for undetermined reasons.NTSB ATL03FA002Accident · 1 fatalField investigationFinal reportBeech K35 · Jellico, TNThe pilot's incapacitation in flight due to a heart attack resulting in an in-flight loss of control, and collision with terrain. A factor was the pilot acting as a pilot-in-command with a known medical grounding condition.NTSB ATL02FA160Accident · 1 fatalField investigationFinal reportBeech BE-55 · Jacksboro, TNPilot incapacitation due to a heart attack resulting in a loss of control and the subsequent in-flight collision with a lake.NTSB CHI02FA237Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Festus, MOThe pilot's lack of recent experience and his failure to maintain adequate airspeed which resulted in a stall and collision with the ground. The pilot's failure to execute a go-around was a factor.NTSB FTW02FA004Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Alvarado, TXThe inadvertent flat spin of the airplane by the flightcrew resulting from the flight instructor's inadequate supervision. A contributing factor was the impairment (drugs) of the private pilot.NTSB FTW01FA171Accident · 4 fatalField investigationFinal reportCessna 205 · De Queen, ARthe pilot's VFR flight into IMC, which resulted in spatial disorientation and a loss of aircraft control. A contributing factor to the accident was the pilot's lack of total instrument flight time.NTSB CHI01FA230Accident · 2 fatalField investigationFinal reportBeech K35 · Grafton, IAThe pilot's improper inflight decision to continue into known adverse weather. A factor was the thunderstorm.NTSB LAX01FA152Accident · 1 fatalField investigationFinal reportCessna 310F · Carmel Valley, CAThe in-flight loss of control of the airplane in instrument meteorological conditions for undetermined reasons.NTSB CHI01FA113Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Norris, SDThe pilot encountering instrument meteorological conditions and his subsequent loss of control of the airplane.NTSB CHI00FA080Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Moorhead, MNthe pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…NTSB NYC99FA085Accident · 2 fatalField investigationFinal reportCessna 310N · Cecilia, KYThe flight instructor's failure to maintain control of the airplane. A factor was the flight instructor's inexperience instructing in the accident airplane.NTSB LAX97FA046Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Goleta, CAfailure of the pilot to maintain control of the aircraft during an instrument approach, due to spatial disorientation, and/or his failure to maintain proper altitude. Factors relating to the accident were: the pilot's delay (or failure) to initiate a missed…NTSB CHI96FA318Accident · 2 fatalField investigationFinal reportBeech 35-33 · Brownsburg, INfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent impact on a roadway. Buzzing by the pilot was a contributing factor.NTSB FTW94FA233Accident · 2 fatalField investigationFinal reportCessna 310Q · Greenville, TXThe cfi's failure to maintain airspeed above VMC, resulting in a loss of control during the single engine G0-around. Factors were not attaining runway alignment and the cfi's failure to retract the landing gear for the go-around procedure.NTSB SEA94FA084Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · Wendover, UTInadequate in flight planning/decision. Factors to the accident were: clearance was not maintained and dark night conditions.NTSB NYC94FA011Accident · 2 fatalField investigationFinal reportCessna 310Q · Tiro, OHLoss of aircraft control for an undetermined reason, and subsequent flight that resulted in the stress limits of the airplane being exceeded and airframe failure.NTSB SEA93FA205Accident · 2 fatalField investigationFinal reportCessna 185A · De Borgia, MTThe pilot's poor in-flight planning/decision and his failure to maintain airspeed above a stall.NTSB FTW91FA147Accident · 3 fatalField investigationFinal reportBeech 35-C33 · Dalhart, TXThe pilot's flight into known adverse weather. Factors were the pilot's lack of instrument experience and existing weather conditions.NTSB ATL91FA116Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Irmo, SCThe loss of control of the aircraft for undetermined reason(s).NTSB FTW90FA032Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Arlington, TXThe pilot-in-command's loss of control in flight because of spatial disorientation. A factor was the dark night.NTSB FTW88FA033Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Commerce, TXThe purpose of the flight was to satisfy an insurance requirement that the owner receive 10 hours of dual instruction in this aircraft. The dual controls had been removed and the single control was on the left side. The aircraft was observed in a clockwise…NTSB ANC88FA021Accident · 3 fatalField investigationFinal reportCessna 185 · Fairbanks, AKThe pilot and his two passengers were returning from a hunting trip when the airplane crashed 7 miles from the Fairbanks international airport. The airplane struck the ground in a vertical attitude at a high rate of speed. Evidence at the scene suggests that…NTSB MIA88FA003Accident · 4 fatalField investigationFinal reportCessna 310K · Inverness, FLWitnesses stated that the plt initiated a go around at the runway 19 threshold, broke off to the right & went behind a tree line in a 60 degree right bank. On the other side of the tree line the acft was observed to strike the trees with the left wing and…NTSB CHI87DER09Accident · 1 fatalFinal reportGreat Lakes Adams 2T-1 · Bethel/Msp, MNThe amateur built aircraft impacted in an open farm field. Although witnesses did not agree on the altitude the aircraft was flying at, they all stated that the Great lakes 2T-1 was spinning before it collided with the ground. One witness indicated that the…NTSB NYC87FA170Accident · 2 fatalField investigationFinal reportCessna 310Q · Montgomery, NYN5527K crashed about 2 miles south of the orange cnty airport shortly after a night tkof fm runway 21. Departure instructions for the IFR flt included a right turn of 130 degrees, to 340 degrees magnetic to intercept V-58 and climb to 5000 ft. the plt…NTSB BFO86FA038Accident · 4 fatalField investigationFinal reportBeech 95-B 55 · Lynchburg, VAThe non-instrument rated pilot filed an IFR flight plan into known and forecast IFR weather. During his second ILS approach to the airport, after the control tower had closed, he failed to utilize the aircraft radio to illuminate the approach lighting system.…NTSB LAX86MA074Accident · 7 fatalMajor investigationFinal reportBeech 95-A55 · Concord, CADrg arr, the acft was vectored for an lda rwy 19R apch. After being clrd for the apch, the plt was advised that radar svc was terminated & told to contact the twr. At 2033 PST, he rprtd inbnd at the final apch fix & was clrd for the apch. Aprx 2 min later, he…NTSB MKC85FA036Accident · 1 fatalField investigationFinal reportCessna 310L · Kaiser, MOThe acft was observed departing the airport to the south climbing. IFR flt conditions prevailed in the area. The plt rptd VFR at 2000 ft. the acft was noted by passengers of an earlier flight to have malfunctioning autopilot altitude andguidance…NTSB ATL85FA050Accident · 2 fatalField investigationFinal reportBeech N35 · Hagwood Store, NCThe acft broke up in flight during an uncontrolled descent in instrument meteorological conditions under instrument flt rules (IFR). An IFR flt plan was filed. Shortly after takeoff the plt exhibited & reported problems with acft heading control &…NTSB MKC83FA128Accident · 4 fatalField investigationFinal reportBeech J35 · Knoxville, IAThe acft was observed to lift off the rwy aft abt a 900 ft ground roll. The lndg gear began to retract as it lifted off, and it began an immediate left turn overflying the airport hangars. It was further observed with the wings aligned with the ground in a 90…NTSB LAX83FA279Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Van Nuys, CAThe acft crashed in a residential area after a loss of control by the plt. The acft was climbing through an overcast in IFR conditions and last reported 'four' in response to a request for altitude. This was the last radio transmission received from the flt.…