NTSB investigations: Continental 0-200 series, FL

10 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

19832026
NTSB investigations: Continental 0-200 series, FL per year, 1983–2026: 10 cases
19831
19881
19891
19941
19951
19962
19981
20011
20021

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

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.Dec 16, 2002 · N9852J · Substantial damageNTSB 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.Jan 18, 2001 · N704ZF · Substantial damageNTSB MIA98LA199Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLThe student pilot's failure to maintain directional control.Jul 17, 1998 · N704FE · Substantial damageNTSB MIA96LA160Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, FLfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a ground swerve and subsequent nose over.Jun 19, 1996 · N11532 · Substantial damageNTSB MIA96LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Port Richey, FLFailure of the pilot to maintain directional control of the airplane, while landing with a crosswind, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the pilot's lack of recent flying experience.Jan 6, 1996 · N60647 · Substantial damageNTSB MIA95LA136Accident · No injuriesLimited investigationFinal reportCessna A150L · Miami, FLThe dual student's improper use of the rudder following a left swerve during landing rollout which prevented the flight instructor from regaining directional control.May 25, 1995 · N6188F · Substantial damageNTSB MIA95LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, resulting in an on-ground loss of control, and collision with terrain.Oct 21, 1994 · N18539 · Substantial damageNTSB MIA89LA257Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockledge, FLFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. The gusty crosswind and proximity of the parked aircraft were related factors.Sep 28, 1989 · N17295 · Substantial damageNTSB MIA88LA096Accident · No injuriesLimited investigationFinal reportCessna 150 · Titusville, FLStudent pilot lost directional control while landing with right quartering wind. The acft departed the left side of the runway and the nose gear bogged down in sand. The nose gear then failed aft and the acft came to rest on the nose and left wing tip.Jan 31, 1988 · N9260U · Substantial damageNTSB MIA83LA116Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe acft swerved off the runway, collided with a hole and nosed over during landing roll. This was a student training flight. The student pilot was not injured. The wind was reported as a tail wind.Apr 12, 1983 · N8724U · Substantial damage