NTSB investigations: Continental 0-200 series
220 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 12 |
|---|---|
| 1983 | 13 |
| 1984 | 16 |
| 1985 | 6 |
| 1986 | 10 |
| 1987 | 12 |
| 1988 | 6 |
| 1989 | 4 |
| 1990 | 12 |
| 1991 | 9 |
| 1992 | 14 |
| 1993 | 11 |
| 1994 | 7 |
| 1995 | 6 |
| 1996 | 7 |
| 1997 | 14 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 10 |
| 2006 | 5 |
| 2007 | 7 |
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 ('17020')
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\" = 260))
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 ('17020')
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" = 260))
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 DFW08CA032Accident · No injuriesData collectionFinal reportCessna 150 · Muskogee, OKThe pilot's failure to maintain directional control while landing.NTSB NYC08CA010Accident · No injuriesData collectionFinal reportCessna 150M · Palmyra, PAThe student pilot's improper recovery from a bounced landing, and the CFI's failure to take remedial action.NTSB LAX07CA284Accident · Minor injuriesData collectionFinal reportCessna 150M · Sonoma, CAThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control while landing.NTSB DFW07CA097Accident · No injuriesData collectionFinal reportCessna 150E · Levelland, TXThe pilot's failure to compensate for existing wind conditions while landing. A contributing factor was the prevailing crosswind.NTSB ANC07LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Willow, AKThe student pilot's failure to maintain directional control while taxiing, which resulted in the airplane contacting a snow berm and nosing down. Factors associated with the accident were the snow and ice covered runway, and excessive taxispeed.NTSB SEA07CA078Accident · No injuriesData collectionFinal reportCessna 150A · Davenport, WAThe pilot's failure to maintain directional control while landing, which resulted in a nose over. Wind gusts and the pilot's inadequate compensation for the wind condition were factors.NTSB SEA07LA049Accident · No injuriesLimited investigationFinal reportCessna 150A · Cottonwood, AZThe pilot's failure to compensate for a gusty crosswind during the landing roll, which resulted in a loss of control and an on-ground encounter with a ditch. Factors associated with the accident are a crosswind and wind gusts.NTSB NYC07LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Livermore Falls, METhe pilot's failure to maintain directional control during landing, which resulted in a groundloop.NTSB CHI07CA029Accident · No injuriesData collectionFinal reportCessna 150J · South Haven, MIThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the ditch.NTSB ATL07CA003Accident · No injuriesData collectionFinal reportHadwise Varieze · Enterprise, ALThe pilot's improper starting procedure, which resulted in an uncommanded aircraft movement and collision with a hanger.NTSB CHI06CA170Accident · No injuriesData collectionFinal reportCessna 150G · Indianapolis, INThe pilot intentionally leaving the airplane unoccupied during the engine start and the failure of the tail tie-down, which ultimately resulted in the unoccupied airplane becoming airborne.NTSB LAX06CA177Accident · No injuriesData collectionFinal reportCessna 150M · Tucson, AZthe failure of the student pilot to maintain directional control and the certified flight instructor's delayed remedial actions and inadequate supervision of the flight.NTSB CHI06CA059Accident · No injuriesData collectionFinal reportCessna 150F · Poplar Grove, ILThe student pilot's inadequate recovery from the bounced landing, and not maintaining airplane control during the landing.NTSB ATL06CA012Accident · No injuriesData collectionFinal reportCessna 150 · Monroesville, ALThe pilot's failure to maintain directional control, which resulted in a loss of control and collision with trees.NTSB ATL06CA009Accident · Minor injuriesData collectionFinal reportSwing Brian S Quickie Q2 · Beaufort, SCThe pilot's failure to maintain directional control during the landing roll which resulted in a collision with an object.NTSB ATL06CA005Accident · No injuriesData collectionFinal reportCessna 150M · Morgantown, NCThe student pilot's improper recovery from a bounced landing,resulting in a loss of directional control and nose over.NTSB NYC05CA090Accident · No injuriesData collectionFinal reportCessna 150G · Willimantic, CTThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control while landing.NTSB LAX05LA154Accident · No injuriesLimited investigationFinal reportKittleson Quickie Q-200 · Santa Barbara, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.NTSB LAX05LA138Accident · No injuriesLimited investigationFinal reportCessna 150F · Prescott, AZthe pilot's failure to maintain directional control on landing.NTSB IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…NTSB LAX05CA096Accident · No injuriesData collectionFinal reportAeronca 7EC · Grass Valley, CAthe pilot's failure to maintain directional control.NTSB ATL04CA197Accident · No injuriesData collectionFinal reportCessna 150M · Sevierville, TNThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with high vegetation and a subsequent nose over. Factors were a foggy windshield and windshield defrost not activated.NTSB LAX04CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Williams, AZThe pilot's inadequate compensation for the wind condition and his failure to maintain directional/airplane control during landing rollout. Contributing factors were the gusty crosswind and the pilot's inadequate remedial action.NTSB SEA04LA176Accident · No injuriesLimited investigationFinal reportCessna 150K · Richland, WAThe pilot's failure to maintain aircraft control during landing. Wind gusts, inadequate compensation for wind conditions, and an airport marker sign were factors.NTSB SEA03LA193Accident · No injuriesLimited investigationFinal reportCessna A150K · Medford, ORThe student pilot's failure to maintain directional control of the aircraft during the landing roll.NTSB LAX03LA234Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Dyer, NVthe pilot's inadequate compensation for the gusting crosswind conditions and failure to maintain directional control.NTSB NYC03LA122Accident · No injuriesLimited investigationFinal reportCessna 150 · Culpeper, VAThe pilot's failure to maintain directional control on the runway during takeoff.NTSB CHI03LA111Accident · No injuriesLimited investigationFinal reportCessna 150F · Three Rivers, MIThe directional control not maintained by the student pilot. The student pilot's lack of experience was a contributing factor.NTSB NYC03LA073Accident · No injuriesLimited investigationFinal reportCessna 150G · Medina, OHThe pilot's failure to follow published procedures while starting the engine, and his failure to maintain control of the airplane.NTSB IAD03LA034Accident · No injuriesLimited investigationFinal reportCessna 150J · Williamson, NYThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor was the snow-covered runway.NTSB MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.NTSB ANC02LA120Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Gakona, AKThe pilot's failure to maintain directional control of the airplane, and his excessive use of the airplane's brakes during the landing roll, which resulted in the airplane nosing down. A contributing factor in the accident was wet, high grass along the runway…NTSB CHI02LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Belleville, ILDirectional control not obtained/maintained by the pilot during landing.NTSB NYC02LA087Accident · No injuriesLimited investigationFinal reportCessna 150H · Smithville, OHThe pilot's failure to maintain directional control. A factor was the gusty windsNTSB MIA02LA077Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Lawrenceville, GAThe pilot's failure to maintain directional control while landing and during his subsequent attempt at a go around, resulting in collision with a tree and impact with the terrain.NTSB SEA02LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Boardman, ORThe pilot-in-command's inability to maintain control of the aircraft while taxiing from landing resulting in a nose over. Contributing factors were high winds, crosswind conditions during taxi, and gusty wind conditions.NTSB ANC01LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe pilot's failure to maintain directional control during the landing roll. A factor associated with the accident is rough and uneven terrain at the off-airport landing site.NTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.NTSB ATL01LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe pilots failure to maintain directional control during the landing roll, which resulted in the collision with the airport sign.NTSB ANC01LA025Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe delayed remedial action by the pilot/instructor of another airplane during landing. Factors in the accident were the failure of the pilot of another airplane to maintain directional control, and the lack of available brakes to the pilot/instructor of…NTSB SEA01LA026Accident · No injuriesLimited investigationFinal reportCessna 150C · Pacific City, ORThe pilot's failure to maintain aircraft control during the landing roll. Factors include a higher than normal approach speed.NTSB CHI01LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Jefferson City, MOthe student pilots failure to maintain directional control. Factors were the service road and the nose gear collapse.NTSB CHI00LA236Accident · No injuriesLimited investigationFinal reportCessna 150M · Bloomington, ILthe pilot not maintaining directional control of the airplane. Factors were the crosswind weather condition, the airport sign, and the collapsed nose gear.NTSB LAX00LA120Accident · No injuriesLimited investigationFinal reportCessna 150E · Reedley, CAA loose seat latch which permitted the seat to move aft to a position where the pilot could no longer reach the controls.NTSB CHI00LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Marshall, MOthe go-around not performed, the improper flare, and recovery from a bounced landing not performed by the pilot. The crosswind was a contributing factor.NTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.NTSB CHI00LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Wisconsin Rapid, WIThe student pilot's failure to maintain directional control. Factors were the pilot's lack of total experience and the snowbank.NTSB NYC00LA080Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F19 · West Lafayette, OHwas a delayed decision of the pilot to abort the landing. Factors were the wet runway, and the tail winds that prevailed in the area.NTSB MIA00LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Morristown, TNThe pilot's failure to maintain directional control during the takeoff phase of a touch and go landing, and the subsequent skid off the runway and collapsed nose landing gear during the attempt to abort the takeoff.