NTSB investigations: Continental IO-550 series
33 cases on aircraft whose registry engine model is Continental IO-550 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
| 1986 | 1 |
|---|---|
| 1991 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 2 |
Where
Open the mapLatest 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 ('17042')
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 ('17042')
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 LAX07FA258Accident · 2 fatalField investigationFinal reportRaytheon A36 · Cameron Park, CAThe airplane's sudden encounter with a wind shift during the initial takeoff climb that resulted in degraded climb performance and a stall mush condition. Contributing to the accident was the airplane's over gross weight condition, high density altitude, the…NTSB DEN07LA049Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMThe pilot-rated dual student's failure to maintain sufficient airspeed during the landing approach to avoid a stall. Also causal was the flight instructor's failure to provide adequate supervision. Factors associated with the accident are an inadvertent…NTSB ATL07FA013Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Statesville, NCThe pilot's failure to maintain airspeed while maneuvering with a low ceiling in instrument flight conditions, resulting in an inadvertent stall, and collision with trees and the ground. Factors in the accident were the pilot's failure to follow the published…NTSB NYC07CA010Accident · No injuriesData collectionFinal reportCirrus SR-22 · Lumberton, NJThe pilot's failure to maintain aircraft control during a go-around, which resulted in an in-flight collision with a tree.NTSB CHI06FA186Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Edgewater, MDThe pilot' failure to maintain sufficient airspeed which resulted in a stall. A factor was the pilots failure to properly set the flaps for the go-around.NTSB MIA06CA079Accident · No injuriesData collectionFinal reportMooney M20R · Destin, FLThe pilot's failure to maintain airspeed while attempting a go-around at a low altitude which resulted in an inadvertent stall/mush, an uncontrolled descent and an impact with terrain.NTSB MIA06FA050Accident · 3 fatalField investigationFinal reportCirrus Design SR-22 · Stuart, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent and impact with the water. Contributing to the accident were a reported instrument failure, pilot disorientation, and instrument meteorological conditions. A factor in…NTSB NYC06CA058Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lincoln Park, NJThe pilot's failure to maintain directional control during an aborted landing.NTSB SEA06LA026Accident · Serious injuriesLimited investigationFinal reportHitchens EDI 90FT · Chehalis, WAThe pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.NTSB DEN06FA013Accident · 1 fatalField investigationFinal reportBeech A36 · Datil, NMthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.NTSB IAD05LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Rocky Hill, NJThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall, and subsequent impact with terrain. Factors included the night lighting conditions, and the airplane approaching the opposite runway.NTSB DEN05CA062Accident · No injuriesData collectionFinal reportBeech A36 · Farmington, NMthe student pilot's failure to maintain airspeed which resulted in a stall and loss of control. Contributing factors were wind gusts, instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB IAD05FA032Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Coconut Creek, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent to the ground. Factors included an avionics failure, pilot disorientation, and instrument meteorological conditions. A factor in the severity of the impact was the…NTSB CHI04FA255Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Park Falls, WIThe flightcrew's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with water during approach. The low altitude was a factor in the accident.NTSB SEA04LA124Accident · No injuriesLimited investigationFinal reportMooney M20R · Hailey, IDThe pilot's improper flare, failure to maintain directional control, and inadequate remedial action, which resulted in the airplane impacting a taxiway sign along the side of the runway. A factor contributing to the accident was the taxiway sign.NTSB LAX04LA213Accident · 4 fatalLimited investigationFinal reportBachman Lancair IV-P · Supai, AZthe loss of aircraft control while in cruise flight for undetermined reasons.NTSB IAD03FA050Accident · 2 fatalField investigationFinal reportBeech A36 · Jackson, OHThe flight instructor's improper decision to turn back to the airport at an insufficient altitude after takeoff and his failure to maintain adequate airspeed, during a simulated engine failure.NTSB DEN03LA056Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's premature liftoff resulting in his failure to attain airspeed and achieve takeoff climb. Contributing factors were the runway light and taxiway sign.NTSB IAD03FA039Accident · 1 fatalField investigationFinal reportMooney M20R · Leesburg, VAThe pilot's failure to maintain control of the airplane while on final approach for undetermined reasons.NTSB CHI03LA063Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot's failure to maintain aircraft control which resulted in the overload of the aircraft. Spatial disorientation, an inoperative turn coordinator, and the pilot's misinterpretation of the flight instruments were contributing factors.NTSB MIA03FA025Accident · 2 fatalField investigationFinal reportRaytheon 58 · Fort Myers, FLthe pilot's spatial disorientation during instrument meteorological conditions, which resulted in his failure to maintain aircraft control. Contributing factors included the pilot's distraction to the low fuel status and the low cloud conditions.NTSB NYC03LA019Accident · 2 fatalLimited investigationFinal reportMooney M20R · Vineyard Haven, MAThe pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.NTSB ATL02FA171Accident · 2 fatalField investigationFinal reportMooney M20R · Burnsville, NCThe pilot's failure to maintain airspeed during final approach, which resulted in an inadvertent stall and uncontrolled descent into trees and terrain. Factors were wind gusts and terrain-induced turbulence.NTSB MIA02LA125Accident · No injuriesLimited investigationFinal reportMooney M20R · Mt. Pleasant, SCThe pilot's failure to maintain airspeed resulting in a stall, an uncontrolled descent, and an impact with the ground during the attempted go-around.NTSB ATL02LA100Accident · 2 fatalLimited investigationFinal reportTaber Lancair Super ES · Hattiesburg, MSThe pilot's failure to maintain airspeed during takeoff which resulted in an inadvertent stall and subsequent collision with the ground.NTSB NYC02FA089Accident · 2 fatalField investigationFinal reportCirrus SR-22 · Parish, NYThe pilots' failure to maintain airspeed, which resulted in an inadvertent stall/spin. The continued spin to the ground was a result of the pilots' failure to deploy the onboard parachute recovery system, for undetermined reasons.NTSB FTW02LA031Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Crownpoint, NMThe safety pilot's failure to maintain directional control during the landing. Contributing factors were the safety pilot's lack of experience flying from the right seat and the improper retraction of the flaps during the attempted go-around.NTSB MIA01LA181Accident · 1 fatalLimited investigationFinal reportFloback Lancair 4 · Kissimmee, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB LAX01LA095Accident · No injuriesLimited investigationFinal reportBeech A36 · Palo Alto, CAThe pilot-in-command's delayed decision to go-around and his failure to maintain sufficient airspeed during the attempted go-around. His non-verification of the flap setting contributed to the accident.NTSB LAX98FA199Accident · 2 fatalField investigationFinal reportMooney M20R · Van Nuys, CAthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions. Factors were the low ceiling, drizzle, and fog.NTSB FTW96LA351Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Midland, TXfailure of the pilot to obtain or maintain adequate airspeed, by allowing the airplane to enter an excessive nose high attitude and an excessive rate of climb after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain. A…NTSB FTW91DRG06Accident · 1 fatalFinal reportQuestair Venture · San Marcos, TXThe pilot's failure to maintain flying airspeed resulting in a stall.NTSB LAX86LA259Accident · Serious injuriesLimited investigationFinal reportBeech A-36TC · San Rafael, CAThe acft stalled and collided with the ground initial during a takeoff initial climb. He indicated that he misjudged the stall buffet as turbulent airflow from a crosswind. The right wing dropped and the acft stalled. The plt also indicated the stall warning…