Fatal NTSB investigations: Continental 0-200 series, GA
20 cases on aircraft whose registry engine model is Continental 0-200 series. 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
| 1968 | 2 |
|---|---|
| 1979 | 2 |
| 1980 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1988 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2024 | 1 |
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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND 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 ('17020'))
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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
AND 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 ('17020'))
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 ERA25LA019Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Gainesville, GAThe pilot’s sudden incapacitation due to an in-flight cardiac arrest, which necessitated a landing by a non-pilot passenger and resulted in a hard landing and collapse of the nose landing gear.NTSB ERA19LA037Accident · 1 fatalLimited investigationFinal reportCessna 150 · Woodstock, GAThe pilot's failure to maintain airspeed during the initial climb in gusting wind conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's lack of recent flight experience.NTSB ERA17FA330Accident · 1 fatalField investigationFinal reportCessna 150G · Rhine, GAThe student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.NTSB ERA14FA377Accident · 2 fatalField investigationFinal reportCessna 150 · Senoia, GAThe noninstrument-rated pilot’s inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in subsequent collision with terrain.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 ATL04FA071Accident · 1 fatalField investigationFinal reportCessna 150G · High Falls, GAThe pilot's impairment due to alcohol which resulted in his failure to maintain adequate airspeed, inadvertent stall, and subsequent in-flight collision with trees.NTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.NTSB ATL96FA103Accident · 2 fatalField investigationFinal reportGeorge Evenson Cuby · Hawkinsville, GAThe failure of the pilot-in-command to maintain airspeed.NTSB ATL91FA110Accident · 1 fatalField investigationFinal reportCessna 150J · Monroe, GAThe pilots attempted flight in adverse weather and the physical impairment of the student pilot from the consumption of alcoholic beverages prior to flight. A factor in the accident was the foggy weather condition at the airport.NTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.NTSB ATL88FA198Accident · 1 fatalField investigationFinal reportCessna 150 · Eastman, GAThe accident occurred after takeoff from a private sod airstrip. A witness saw the aircraft climb to about 500 feet. It then started losing altitude, dropped out of sight, and crashed. The aircraft impacted the ground in a nose low attitude and burned.…NTSB ATL88FA078Accident · 1 fatalField investigationFinal reportCessna 150H · Cedartown, GANTSB MIA84FA241Accident · 4 fatalField investigationFinal reportCessna 152 · Valdosta, GAThe two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.…NTSB ATL83FA386Accident · 1 fatalField investigationFinal reportCessna A150L · Ringgold, GAThe acft was observed buzzing a truck stop, partially owned by the plt, at low altitude. The acft then stalled & spun into the ground. Some of the witnesses observed the plt waving & one witness said it appeared that the plt was leaning out the window…NTSB ATL83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Kennesaw, GAThe acft crashed in a wooded area after a touch and go landing. The wing flaps lever had been placed to the up position but the flaps did not retract. When the CFI finally noticed that the flaps were not up he took over at about 200 ft AGL and started a…NTSB MIA80FA056Accident · 1 fatalClosedCessna 150L · Alamo, GANTSB MIA79FKG33Accident · 1 fatalClosedCessna 150 · Hawkinsville, GANTSB MIA79FA055Accident · 1 fatalClosedCessna 150 · Albany, GANTSB MIA68A0084Accident · 2 fatalClosedCessna 150G · Lilburn, GANTSB MIA68A0076Accident · 2 fatalClosedCessna 150G · Columbus, GA