NTSB investigations: Continental 0-200 series, GA
177 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, newest first
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.\"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."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 ATL88LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Watkinsville, GAStrong headwinds were encountered during the x-c flt. The plt landed at an arpt to refuel but found the arpt FBO to be closed. He continued on toward his destination. About 10 miles from his destination, he made a precautionary ldg in a field due to a…NTSB ATL88LA119Accident · No injuriesLimited investigationFinal reportCessna 150J · Villa Rica, GAAcft was landed to the west on a 2500' dirt strip. Trees, about 25-30' high bounded the approach threshold. Wind was variable nw to w gusting 15-18 KTS. PIC said acft dropped out from under him and landed hard. After bouncing it landed on nose gear which…NTSB ATL88FA078Accident · 1 fatalField investigationFinal reportCessna 150H · Cedartown, GANTSB ATL88LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Waynesboro, GAThe student plt lost control of the airplane while landing, during his second supervised-solo flt. The airplane veered off of the rwy into a ditch where the nosegear collapsed and the airplane nosed over. The wind was reportedly calm.NTSB ATL88LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumming, GAThe student pilot was attempting to land on the 1550 foot runway. The aircraft touched down hard and bounced. The pilot pushed forward on the control column and the aircraft came down on the nose gear which collapsed.NTSB ATL87LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Dahlonega, GAThe acft impacted trees and a hillside shortly after a night takeoff from rwy 33 while the CFI was flying the acft from the rt seat. The CFI reported that he intended to fly the pattern to demonstrate a ldg to his student. During initial climb, he lost sight…NTSB ATL86LA232Accident · No injuriesLimited investigationFinal reportCessna 150H · Rome, GAThe plt said he took off with about 6 gallons of automotive gas in the acft for the 14 NM trip to a local arpt. During descent for landing, the eng quit and a forced landing was made in a corn field. Post accident exam of the acft failed to reveal any fuel in…NTSB ATL86LA021Accident · No injuriesLimited investigationFinal reportCessna 150J · Cumming, GAShortly after takeoff the acft experienced a loss of pwr as related by the student plt. A forced landing was performed in a fld during which the nose wheel dug into the terrain and the acft nosed over. Examination of the wreckage failed to disclose any…NTSB ATL85LA142Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Alma, GAThe student pilot and passenger changed the engine oil just prior to attempting the takeoff. The oil was drained on the ground on the airport where the aircraft was parked. Examination of the oil, disclosed that metal shavings were present in the drained oil.…NTSB MIA85LA008Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Coolidge, GAThe acft collided with a bush during landing. The plt flew under a wire that he saw just in time to avoid hitting and over the 5 foot embankment on the opposite side of an intervening roadway. After the collision, the acft flipped over and slid through a…NTSB 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 ATL83LA317Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Broxton, GADuring arrival, the plt landed on an ag strip in light & variable wind conditions. The dirt & grass rwy was aprx 50 ft wide & was next to a fence. Reportedly, the acft drifted to the left, during the landing, until the left wheel got into a rut. Subsequently,…NTSB ATL83LA304Accident · No injuriesLimited investigationFinal reportCessna 150J · Monroe, GAAfter turning final approach the pilot realized he was high so he lowered full flaps. Shortly thereafter he saw that the indicated airspeed was low and made an aircraft attitude adjustment. After he corrected for the low air speed he failed to rotate to a…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 ATL82DA277Accident · No injuriesFinal reportCessna 120 · Hawkinsville, GAThe aircraft nosed over while landing in a peanut field. The pilot reported that the terrain was softer than he realized, and when he applied brake pressure, the plane nosed over. He believed the accident would not have occurred it brakes had not been applied.NTSB ATL82FKG16Accident · No injuriesFinal reportCessna 150M · Madison, GAAfter touchdown the tailwheel equipped C-150 veered off the rwy into a gully breaking off the tailwheel. The acft then struck an embankment.NTSB ATL82DA136Accident · Minor injuriesFinal reportCessna 150 · Buford, GAThe pilot used zero flaps and about 2/3RDS of the available runway in an attempt to practice a short field takeoff. During the takeoff roll the pilot was unable to obtain takeoff speed and elected to abort but was unable to stop the aircraft before it rolled…NTSB ATL82FKG03Accident · Minor injuriesClosedCessna 150F · Columbus, GANTSB ATL81FKG19Accident · No injuriesClosedCessna 150 · Williamson, GANTSB MIA80FA056Accident · 1 fatalClosedCessna 150L · Alamo, GANTSB MIA80FKG18Accident · No injuriesClosedCessna 150 · Columbus, GANTSB MIA79DLA52Accident · Serious injuriesClosedCessna 150 · Brunswick, GANTSB MIA79FKG59Accident · Minor injuriesClosedChampion 7ECA · Social Circle, GANTSB MIA79DLA41Accident · No injuriesClosedCessna 150 · Camilla, GANTSB MIA79DLA38Accident · No injuriesClosedCessna 150 · Waycross, GANTSB MIA79DLA30Accident · Minor injuriesClosedCessna 150 · Mayday, GANTSB MIA79FKG33Accident · 1 fatalClosedCessna 150 · Hawkinsville, GANTSB MIA79FA055Accident · 1 fatalClosedCessna 150 · Albany, GANTSB MIA79FKG06Accident · No injuriesClosedCessna 150 · Madison, GANTSB MIA78FKG70Accident · No injuriesClosedCessna 150 · Savannah, GANTSB MIA78FKG64Accident · Minor injuriesClosedCessna 150 · Athens, GANTSB MIA78FKG36Accident · No injuriesClosedCessna 150 · Covington, GANTSB MIA78DLA20Accident · No injuriesClosedCessna 150M · Bainbridge, GANTSB MIA78FKG23Accident · Minor injuriesClosedCessna 150 · Lawrenceville, GANTSB MIA78FKG20Accident · No injuriesClosedCessna 150 · Roswell, GANTSB MIA78FKG16Accident · No injuriesClosedCessna 150 · Norcross, GANTSB MIA78DLA09Accident · No injuriesClosedCessna 150 · Cairo, GANTSB MIA77DLA45Accident · No injuriesClosedCessna 150 · Nashville, GANTSB MIA77FKG56Accident · No injuriesClosedCessna 150F · Milledgeville, GANTSB MIA77DKG49Accident · No injuriesClosedCessna 150 · Shell Bluff, GANTSB MIA77FKG45Accident · No injuriesClosedCessna 150 · Atlanta, GANTSB MIA77DKG46Accident · No injuriesClosedCessna 150 · Peachtree City, GANTSB MIA77FKG28Accident · No injuriesClosedCessna 150 · Fitzgerald, GANTSB MIA77FKG23Accident · Serious injuriesClosedCessna 150 · Atlanta, GANTSB MIA77FKG24Accident · No injuriesClosedCessna 150 · Monroe, GANTSB MIA77DKG10Accident · No injuriesClosedCessna 150F · Elberton, GANTSB MIA76DKH08Accident · No injuriesClosedCessna 150 · Columbus, GANTSB DEN76DKG80Accident · Minor injuriesClosedCessna 150 · Statesboro, GANTSB MIA76FKG55Accident · No injuriesClosedCessna 150K · Fayetteville, GA