NTSB investigations: Continental 0-300 series
95 cases on aircraft whose registry engine model is Continental 0-300 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 | 1 |
|---|---|
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 3 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 7 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 3 |
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 ('17022')
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 ('17022')
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 CHI07FA290Accident · 2 fatalField investigationFinal reportCessna 172C · Kelleys Island, OHThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing to the accident were the water and dark night conditions which resulted in the lack of ground references during the takeoff.NTSB SEA07CA107Accident · Minor injuriesData collectionFinal reportCessna 172B · Los Angeles, CAThe pilot's failure to maintain adequate airspeed during performance of a go around, resulting in an inadvertent stall and in-flight collision with the ground.NTSB DEN07CA076Accident · No injuriesData collectionFinal reportCessna 172E · Pleasanton, KSThe pilot's failure to maintain control of the airplane during a go-around. Contributing factors were the gusts and crosswinds.NTSB NYC07LA011Accident · 1 fatalLimited investigationFinal reportBishop Bakeng Duce · South Boston, VAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall. Contributing was the deteriorating weather and diminishing light conditions, the pilot's decision to take off despite the weather advisory, and the pilot's…NTSB ATL06CA106Accident · Serious injuriesData collectionFinal reportCessna 172F · Rome, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with the ground.NTSB DFW06CA166Accident · No injuriesData collectionFinal reportCessna 172A · Durant, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB CHI06LA070Accident · 1 fatalLimited investigationFinal reportCessna 172 · Harrison, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor associated with the accident was the pilot's impairment due to drugs.NTSB ANC06CA006Accident · No injuriesData collectionFinal reportCessna 172 · Naknek, AKThe pilot's inadequate removal of frost from the wings, and his failure to attain adequate airspeed during takeoff initial climb, which resulted in a stall and collision with terrain. Factors contributing to the accident were the pilot's delayed aborted…NTSB LAX05LA286Accident · 1 fatalLimited investigationFinal reportCessna 172 · Yuma, AZthe pilot's failure to maintain an adequate airspeed on short final, which resulted in an inadvertent stall.NTSB SEA05FA180Accident · 1 fatalField investigationFinal reportMaule Bee Dee M-4 · Ritter, ORThe loss of control for an undetermined reason which resulted in a ground collision.NTSB LAX05CA233Accident · Minor injuriesData collectionFinal reportCessna 170B · Prescott, AZthe pilot's misjudged flare, and excessive use of the elevator control, which resulted in a failure to maintain adequate airspeed and a stall/mush.NTSB CHI05CA155Accident · No injuriesData collectionFinal reportCessna 172 · Willis, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. A factor associated with the accident were the trees that the airplane contacted during the aborted takeoff.NTSB NYC04LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Cooperstown, NYThe pilot's failure to maintain adequate airspeed and her premature rotation which resulted in an inadvertent stall/mush and subsequent impact with the ground.NTSB DEN04CA097Accident · No injuriesData collectionFinal reportCessna 172E · La Junta, COthe student pilot's failure to maintain aircraft control and adequate airspeed during the go-around resulting in an inadvertent stall. Contributing to the accident was the low airspeed and altitude.NTSB ATL04FA130Accident · 2 fatalField investigationFinal reportCessna 172F · Madisonville, TNThe pilot's failure to maintain airspeed while maneuvering on a touch and go landing resulting in a stall and collision with the ground.NTSB LAX04CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Thermal, CAthe pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.NTSB ATL04LA036Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Suches, GAThe pilot's failure to maintain airspeed during a go-round that resulted in an inadvertent stall and the subsequent collision with trees.NTSB CHI03LA266Accident · No injuriesLimited investigationFinal reportCessna 172G · Bowdon, NDThe pilot's failure to maintain adequate airspeed which led to a stall. Contributing to the accident was the pilot's lack of experience, the crosswind condition, wind gusts and power lines.NTSB CHI03LA216Accident · 1 fatalLimited investigationFinal reportCessna 172H · Isle, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. The trees, high density altitude, and the soft field were additional factors.NTSB SEA03LA105Accident · No injuriesLimited investigationFinal reportCessna T337G · Lewistown, MTInadequate preflight planning/preparation prior to takeoff, and the pilot's failure to maintain aircraft control during the takeoff. An inadvertent stall and rough terrain were factors.NTSB FTW03LA116Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB NYC02LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Sangerville, METhe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.NTSB ATL02FA121Accident · 1 fatalField investigationFinal reportCessna 172H · Palmetto, FLThe pilot's failure to maintain airspeed which resulted in a stall while maneuvering after a banner release.NTSB ATL02LA096Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Livingston, TNThe pilot failure to maintain flying speed, followed by a subsequent stall.NTSB CHI02LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Hackensack, MNThe pilot's inadequate compensation for the winds conditions which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the gusty crosswind conditions and the trees alongside the runway which the…NTSB NYC02FA012Accident · 3 fatalField investigationFinal reportCessna 172 · South Hero, VTThe pilot's failure to maintain aircraft control during the takeoff. Factors in this accident were wind gusts and the airplane's high gross weight condition.NTSB NYC01LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Wildwood, NJthe pilot's inadequate compensation for wind conditions. Factors were the crosswind and the gusts.NTSB NYC01FA147Accident · 1 fatalField investigationFinal reportCessna 172 · Newfane, VTThe pilot's failure to maintain aircraft control during takeoff. A factor was the pilot's impairment due to a narcotic painkiller and antihistamine.NTSB FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.NTSB LAX01FA070Accident · 2 fatalField investigationFinal reportCessna 172F · San Luis Obispo, CAThe pilot's failure to maintain a proper climb rate to VFR conditions on-top.NTSB CHI00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Buffalo, MOThe inadvertent stall during a go-around. Factors relating to this accident were the student pilot's improper in-flight decisions and his failure to raise the flaps during the go around.NTSB NYC00FA226Accident · 1 fatalField investigationFinal reportCessna 172 · Davis, WVThe pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind.NTSB IAD00LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Kutztown, PAThe pilot's improper recovery from a bounced landing, and his delay in remedial action.NTSB NYC00LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Sissonville, WVThe pilot's failure to maintain runway alignment during takeoff. A factor in the accident was wind gusts.NTSB ANC99FA128Accident · 2 fatalField investigationFinal reportCessna 170B · Cooper Landing, AKThe pilot's inadvertent stall.NTSB CHI99LA288Accident · No injuriesLimited investigationFinal reportCessna 172G · Glenarm, ILthe pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.NTSB SEA98LA189Accident · No injuriesLimited investigationFinal reportCessna 172D · Ronan, MTThe pilot's failure to attain adequate airspeed during liftoff from a soft field takeoff. Factors include high density alttiude.NTSB ANC98LA163Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's failure to maintain directional control of the aircraft. Contributing factors were the crosswind condition, the pilot's lack of total experience in make/model of the aircraft, and the pilot not achieving a climb on takeoff.NTSB FTW98LA318Accident · No injuriesLimited investigationFinal reportCessna 172H · Commerce, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.NTSB IAD98LA064Accident · No injuriesLimited investigationFinal reportCessna 172D · Beverly, MAfailure of the pilot to maintain control of the airplane during the landing and attempted go-around. A related factor was the crosswind.NTSB CHI98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Barrington Hill, ILThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent in-flight collision with trees.NTSB ANC98LA031Accident · No injuriesLimited investigationFinal reportCessna 172A · Paxson, AKThe pilots failure to maintain terrain clearance while flying into a box canyon, and an inadvertent stall during his attempt to reverse direction.NTSB FTW98LA155Accident · Minor injuriesLimited investigationFinal reportZito ZMI-A · Ogden, UTthe improper placement of lead ballast by the pilot, resulting in an improper balance of the airplane; and the pilot's excessive control input to correct a nose high attitude, resulting in ground impact.NTSB FTW98LA036Accident · No injuriesLimited investigationFinal reportCessna 172F · Hurley, NMthe student pilot's failure to adequately compensate for the wind conditions. Factors included the gusty crosswind conditions and inadequate supervision of the student pilot's solo flight by his flight instructor.NTSB ANC97LA114Accident · No injuriesLimited investigationFinal reportCessna 170B · Juneau, AKThe pilot's selection of an unsuitable off-airport site for takeoff, and his premature lift-off.NTSB IAD97LA009Accident · 1 fatalLimited investigationFinal reportCessna 172A · Lebanon, OHimproper aircraft handling by the tow pilot and/or the glider pilots, which allowed the tow plane and glider to get out of position with one another; and failure of the aircrews (in both aircraft) to ensure a timely release of the glider tow rope.NTSB LAX96LA345Accident · No injuriesLimited investigationFinal reportCessna 172F · Ehrenberg, AZThe pilot's attempt to perform a low altitude evasive maneuver with inadequate airspeed resulting in a stall/mush.NTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…NTSB NYC96LA009Accident · No injuriesLimited investigationFinal reportCessna 172G · Wilkes-Barre, PAthe instructor's inadequate supervision of the flight. Contributing factors were the instructor's inexperience and the student pilot's failure to maintain aircraft control.NTSB SEA95LA169Accident · No injuriesLimited investigationFinal reportCessna 172C · Red Lodge, MTThe pilot's failure to maintain airspeed. The pilot's inadequate preflight planning/preparation and selection of unsuitable terrain for landing were factors.