NTSB investigations: Continental 0-200 series, GA

9 cases on aircraft whose registry engine model is Continental 0-200 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

19832026
NTSB investigations: Continental 0-200 series, GA per year, 1983–2026: 9 cases
19831
19841
19882
19961
20021
20041
20072

Latest 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.\"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\" = 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.

NTSB MIA07CA106Accident · Minor injuriesData collectionFinal reportCessna 150L · Greensboro, GAThe pilot's failure to retract the wing flaps during a go-around, which resulted in a stall, and uncontrolled descent, and an impact with terrain.Jun 10, 2007 · N1786Q · Substantial damageNTSB ATL07CA039Accident · No injuriesData collectionFinal reportCessna C150 · Palmetto, GAThe pilot's inadequate compensation for a crosswind during the landing flare, which resulted in a loss of control and an in-flight collision with objects. A factor associated with the accident was a crosswind.Feb 6, 2007 · N5843E · Substantial damageNTSB 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.Jan 27, 2004 · N2981J · Substantial damageNTSB 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.Aug 15, 2002 · N5603G · DestroyedNTSB ATL96FA103Accident · 2 fatalField investigationFinal reportGeorge Evenson Cuby · Hawkinsville, GAThe failure of the pilot-in-command to maintain airspeed.Jul 9, 1996 · N1035W · DestroyedNTSB 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.…Jun 22, 1988 · N4282U · DestroyedNTSB ATL88FA078Accident · 1 fatalField investigationFinal reportCessna 150H · Cedartown, GAJan 14, 1988 · N12NF · Substantial damageNTSB 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…Oct 15, 1984 · N60960 · Substantial damageNTSB 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…Sep 30, 1983 · N6063J · Substantial damage