NTSB investigations: Continental 0-200 series, AR

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

19862026
NTSB investigations: Continental 0-200 series, AR per year, 1986–2026: 9 cases
19861
19871
19921
19941
19981
20021
20041
20052

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\" = 'AR' 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 DFW05CA160Accident · Minor injuriesData collectionFinal reportCessna 150H · Morrilton, ARThe pilot's failure to maintain proper alignment with the runway during landing. A contributing factor was the dark night lighting condition.Jun 9, 2005 · N6973S · Substantial damageNTSB DFW05LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Tontitown, ARThe pilot's falure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.Mar 20, 2005 · N6828F · Substantial damageNTSB FTW04LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Benton, ARThe student pilot's failure to maintain airspeed resulting in an inadvertent stall during a go-around.Jun 5, 2004 · N5677E · Substantial damageNTSB FTW02LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Omaha, ARthe pilot's failure to maintain adequate airspeed during the go-around resulting in an inadvertent stall. A contributing factor was haze.Jul 15, 2002 · N22715 · Substantial damageNTSB FTW98FA365Accident · 1 fatalField investigationFinal reportCessna 150F · Wilton, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall. Factors were the pilot's improper use of flaps during the takeoff climb and the high density altitude.Aug 20, 1998 · N7738F · Substantial damageNTSB FTW94LA084Accident · Minor injuriesLimited investigationFinal reportNoble Quickie Q-200 · N. Little Rock, ARThe pilot/owner's inaccurate calculation of the airplane's center of gravity. A factor was the pilot's failure to follow the correct calculation procedure.Feb 19, 1994 · N827Q · Substantial damageNTSB FTW92FA073Accident · Serious injuriesField investigationFinal reportCessna 150 · Clarksville, ARThe pilots inadvertent stall. A factor was the operator's inadequate supervision.Feb 22, 1992 · N7896E · Substantial damageNTSB MKC87LA108Accident · No injuriesLimited investigationFinal reportCessna 150L · Harrison, ARThe pilot said he was landing into the wind and when he was 20 feet above the runway, the wind seemed to shift to a tail wind. The airplane stalled, hit the runway hard and bounced. The pilot said he pushed the control wheel forward and the nose wheel hit the…May 25, 1987 · N1418Q · Substantial damageNTSB MKC86FPG02Accident · Serious injuriesFinal reportCessna 150H · Lonoke, ARAfter the plt changed a tire & performed maintenance on the carb heat control, he elected to reposition the acft to adams field at little rock, AR. Shortly after lifting off from his private strip, the acft crashed. There was virtually no movement after it…Apr 1, 1986 · N22109 · Substantial damage