NTSB investigations: Continental 0-200 series
136 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “In flight collision with object”. 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 | 7 |
|---|---|
| 1983 | 10 |
| 1984 | 8 |
| 1985 | 8 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 7 |
| 1989 | 6 |
| 1990 | 8 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 8 |
| 2000 | 5 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 5 |
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\" = 220))
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" = 220))
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 ANC08LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe flight instructor's inadequate supervision of the student, and his delayed go-around. Contributing to the accident was dark night conditions.NTSB LAX07CA224Accident · Minor injuriesData collectionFinal reportCessna 150M · Woodland, CAAn in-flight collision with a bird. A factor in the accident was the deteriorated aircraft performance capability due to the increased drag that made continued flight impossible.NTSB LAX07CA183Accident · No injuriesData collectionFinal reportCessna 210F · Denton, MTThe pilot's decision to abort the landing with insufficient runway available to gurantee obstruction clearance.NTSB CHI07CA139Accident · No injuriesData collectionFinal reportCessna 150 · English, INThe pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.NTSB CHI07LA095Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Austin, INThe pilot's improper preflight planning/preparation, and his failure to abort the takeoff. Contributing factors were a tailwind and a short runway.NTSB CHI07LA010Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Monroe City, INThe student pilot not maintaining clearance from the tree during climb. Factors were the tree and the student pilot's lack of total experience.NTSB ATL06FA078Accident · 2 fatalField investigationFinal reportCessna 150L · Cumming, GAThe pilot's failure to consider the appropriate aircraft performance data prior to takeoff, and his improper use of the wing flaps during takeoff, which resulted in reduced climb performance and an in-flight collision with a residence. A factor associated…NTSB DFW06CA109Accident · No injuriesData collectionFinal reportCessna 150M · Roanake, TXThe pilot's failure to maintain clearance from an unmarked transmission wire. A contributing factor was the low altitude flight.NTSB ANC06LA014Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F-19 · Chenga Bay, AKThe pilot's failure to maintain adequate altitude/clearance during takeoff initial climb, which resulted in an in-flight collision with trees, and subsequent collision with the ground.NTSB LAX05LA272Accident · 1 fatalLimited investigationFinal reportPatch Dan F Varieze · San Diego, CAa divergence from the final approach course and an in-flight collision with storage containers for undetermined reasons.NTSB DEN05CA073Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Fort Collins, COthe pilot's inadequate preflight planning/preparation which failed to assure adequate takeoff performance to clear obstacles. Contributing factors included the miscalculated weight and balance and the high density altitude.NTSB LAX05FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Marana, AZthe failure of the pilot to maintain an adequate altitude and clearance from obstructions that resulted in an in-flight collision with power lines.NTSB SEA05LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Augusta, MTThe pilot's failure to maintain adequate obstacle clearance which resulted in the in-flight collision with rising terrain. Trees and rising terrain are factors in the accident.NTSB CHI04LA254Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Ancona, ILThe pilot became incapacitated (unconscious) for undetermined reasons which resulted in his inability to maintain altitude.NTSB SEA04CA136Accident · Minor injuriesData collectionFinal reportCessna 150L · La Center, WAThe private pilot receiving the flight review's failure to follow the Owner’s Manual's procedures for a go-around. Contributing factors were the flight instructor's delay in telling the private pilot to go-around, and the trees.NTSB ATL04CA127Accident · Minor injuriesData collectionFinal reportCessna 150 · Decatur, ALThe pilot's failure to maintain obstacle clearance, which resulted in collision with utility wires.NTSB NYC04LA011Accident · 2 fatalLimited investigationFinal reportCessna 150M · Wax, KYThe pilot's failure to maintain obstacle clearance. Low altitude flight is a contributing factor.NTSB ANC03CA078Accident · No injuriesData collectionFinal reportTaylorcraft F-19 · Aniak, AKThe pilot's inadvertent touchdown, and failure to maintain clearance from trees during an aborted landing, which resulted in the nose over of the airplane. A factor associated with the accident was the soft terrain.NTSB CHI03LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cedar Springs, MIThe pilot's inadequate glidepath and his failure to maintain obstacle clearance. A factor to the accident was the semi-trailer.NTSB ATL03LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Montgomery, ALThe in-flight collision with birds that resulted in a partial loss of engine power, and subsequent in-flight collision with trees while maneuvering for an emergency landing.NTSB LAX03FA025Accident · 1 fatalField investigationFinal reportCessna 150E · Anaheim Hills, CAthe pilot's continued VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance from power lines. A contributing factor was the pilot's impairment by medication.NTSB IAD02LA068Accident · No injuriesLimited investigationFinal reportCessna 150 · Griswold, CTthe pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.NTSB MIA02LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe flight instructor's inadequate supervision of the dual student and failure to take prompt remedial action, resulting in a collision with a tree, a subsequent loss of control, and collision with the ground.NTSB ANC02LA013Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Talkeetna, AKThe pilot's failure to remove sufficient ice/frost from the airplane prior to flight, and his failure to maintain adequate clearance from trees and terrain. A factor associated with the accident is the reduced climb capability of the airplane due to the…NTSB IAD01FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's failure to recover from a spin for undetermined reasons.NTSB ATL01LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lake City, FLThe pilots failure to maintain clearance during an approach to land, that resulted in an in-flight collision with trees.NTSB FTW01LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Denham Springs, LAthe pilot's inadequate preflight planning and decision making, which resulted in the airplane's performance being exceeded during the takeoff initial climb. A contributing factor was the rising terrain.NTSB ATL01LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Pell City, ALThe pilot's selection of the wrong runway that resulted in an attempted takeoff with a tailwind.NTSB NYC01FA123Accident · 2 fatalField investigationFinal reportCessna 150A · Jackson Twp., PAThe pilot's inadequate visual lookout while manuevering at low level. A factor was the pilot's improper decision to conduct low-level flight.NTSB ATL01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Maryville, TNThe pilot's inadequate preflight planning that resulted in the in-flight collision with a fence during an attempted takeoff from a grass strip.NTSB IAD00LA084Accident · No injuriesLimited investigationFinal reportCessna 150G · Conesus, NYthe pilot's inadequate preflight performance planning.NTSB NYC00LA224Accident · Minor injuriesLimited investigationFinal reportCessna 150 · East Moriches, NYThe pilot's failure to maintain a climb during climbout. A factor in the accident was the pilot's failure to reconfigure the flaps for the aborted landing.NTSB SEA00FA133Accident · 3 fatalField investigationFinal reportCessna 150E · Ashton, IDThe pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…NTSB SEA00LA070Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Auburn, WAThe pilot's failure to follow aircraft operating procedures by not raising the flaps during the go-around maneuver. Contributing factors were the pilot's failure to adhere to the balked landing checklist (FLAPS to 20) resulting in degraded climb performance,…NTSB ATL00LA040Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Leesburg, FLThe pilot's failure to maintain clearance from objects during the final approach. A factor was downdraft on final approach.NTSB ANC00LA016Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F-19 · Skwentna, AKThe pilot's selection of an unsuitable landing/takeoff area. Factors associated with the accident were snow-covered terrain, and a tree.NTSB ATL00LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Arecibo, PRThe pilot's failure to maintain altitude clearance during final approach to landing. A factor was the hay bundles.NTSB SEA99LA173Accident · No injuriesLimited investigationFinal reportCessna 150M · Camas, WAA misjudged approach and inadequate airspeed. Sunglare, a delayed decision to go-around, and not maintaining clearance from a fence were factors.NTSB CHI99LA307Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Garrett, INthe pilot's improper inflight planning/decision to land and takeoff on the airstrip which was unsuitable and closed, and the pilot's failure to attain clearance with the trees during the takeoff initial climb. Factors associated with the accident were the…NTSB FTW99LA202Accident · No injuriesLimited investigationFinal reportCessna A150M · Alvin, TXThe flight instructor's excessive rotation while performing a soft field takeoff, which resulted in a delayed lift-off and the ensuing failure to attain obstacle clearance.NTSB IAD99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Granville, NYThe pilot's not maintaining a proper glidepath during the visual approach to the runway.NTSB ATL99LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Seneca, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with trees.NTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.NTSB FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.NTSB CHI98LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Clarkston, MIthe pilot selected unsuitable terrain on which to make the precautionary landing due to weather. Factors associated with the accident were the fog, low ceiling, poor in-flight planning, the precautionary landing, the loose wet gravel on which the…NTSB SEA98IA060Incident · Minor injuriesIncident investigationFinal reportCessna 150L · Seattle, WAThe pilot's failure to reposition the flaps to the 20 degree position during a go-around, as called for in the Pilot's Operating Handbook. Factors include the pilot's decision to land long behind a departing aircraft, an encounter with wake turbulence during…NTSB FTW98LA105Accident · No injuriesLimited investigationFinal reportCessna 140A · Justin, TXthe pilot's improper planning/decision and failure to ensure that the airplane would be able to remain clear of the fence during takeoff. Factors relating to the accident were: the wet/soft/short runway (and terrain) conditions.NTSB FTW98LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Brigham City, UTfailure of the pilot to maintain lateral (or vertical) clearance from a tree, during takeoff. Related factors were: the tree, and the pilot's improper use of flaps.NTSB ATL97LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Kenly, NCThe pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.NTSB CHI97LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MOthe pilot's failure to maintain an adequate visual lookout.