NTSB investigations: Continental 0-200 series, AR

108 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\" = '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'))
  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 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 damageNTSB MKC86LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Carlisle, ARThe student plt was making the takeoff, after a stop and go landing. The acft began to drift to the lt during the roll and the CFI cautioned the student to correct for torque. The CFI took control but was unable to get the student to release the controls…Dec 31, 1985 · N4649X · Substantial damageNTSB MKC84LA171Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with a ditch while taxiing after landing. The plt was attempting to make a 180 degree turn on the rwy. She said she turned right to allow more room to swing left. She said that she was then unable to depress the left rudderpedal. The acft…Jun 14, 1984 · N51128 · Substantial damageNTSB MKC84LA125Accident · No injuriesLimited investigationFinal reportCessna 150K · Paragould, ARA student pilot carrying a passenger landed to refuel. Unaware of the procedure to acquire fuel at this location, he took off for another airport. The engine quit on climb-out and the aircraft was substantially damaged when it landed short of the runway. No…Apr 14, 1984 · N6057G · Substantial damageNTSB MKC84LA083Accident · No injuriesLimited investigationFinal reportCessna C-150K · Hot Springs, ARThe acft collided with trees during the forced landing 1/4 mile from the rwy. The plt had landed only 19 miles from the accident, and finding no fuel available at the unattended arpt decided to continue his flt. Just short of destination the acft, ran out of…Feb 25, 1984 · N6063G · Substantial damageNTSB FTW84LA008Accident · No injuriesLimited investigationFinal reportCessna 150G · Forrest City, ARDuring a landing, the acft touched down hard, then bounced & touched down hard, 2 more times. On the 3rd impact, the nose gear collapsed. Subsequently, the acft slid to a stop with damage to the propeller & firewall.Oct 2, 1983 · N2938S · Substantial damageNTSB FTW83LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with trees after running off the end of the rwy during an aborted takeoff. The student plt made 2 touch and go landings and taxied in to have his seat fixed. After the repair he taxied out and held for about 5 minutes for traffic. After…Mar 19, 1983 · N5512G · Substantial damageNTSB FTW83LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Pine Bluff, ARThe student pilot had made several touch-and-go landings on the same runway. He stated his last approach and touchdown were normal. Reportedly, the nose gear collapsed during the landing roll. The aircraft went off the left side of the runway and flipped…Oct 1, 1982 · N8119F · Substantial damageNTSB FTW82FPG19Accident · 1 fatalFinal reportCessna 150J · North Little Ro, ARAfter a right turn after takeoff from rwy 17 the plt declared an emergency. A witness heard the eng backfiring. The plt continued the right turn & attempted a landing on rwy 35. He was described as being too high & hot, & touched down, or almost touched down,…Jul 22, 1982 · N60246 · DestroyedNTSB FTW81DPG21Accident · No injuriesClosedCessna 150 · Marshall, ARApr 29, 1981 · N50494 · Substantial damageNTSB FTW80DPG67Accident · No injuriesClosedCessna 150 · Benton, ARSep 8, 1980 · N11485 · Substantial damageNTSB FTW80FA102Accident · 2 fatalClosedCessna 150H · Jonesboro, ARAug 10, 1980 · N6780S · DestroyedNTSB FTW79DPG26Accident · No injuriesClosedCessna 150 · Marked Tree, ARApr 14, 1979 · N6433G · Substantial damageNTSB FTW79DPG22Accident · No injuriesClosedCessna 150 · Arkadelphia, ARMar 7, 1979 · N2594J · Substantial damageNTSB FTW79DPG09Accident · No injuriesClosedCessna 150 · Benton, ARNov 19, 1978 · N11485 · Substantial damageNTSB FTW79DPG08Accident · No injuriesClosedCessna 150F · Mt.Ida, ARNov 5, 1978 · N2200W · Substantial damageNTSB FTW78DPG70Accident · No injuriesClosedCessna 150 · Lakeview, ARJul 29, 1978 · N7143S · DestroyedNTSB FTW78DPG10Accident · No injuriesClosedCessna 150 · Newark, ARDec 9, 1977 · N560MA · Substantial damageNTSB FTW77DPG44Accident · No injuriesClosedCessna 150G · Arkadelphia, ARJun 11, 1977 · N6256S · Substantial damageNTSB FTW77DPG25Accident · No injuriesClosedCessna 150 · N.Little Rock, ARApr 14, 1977 · N63290 · Substantial damageNTSB FTW77FPG22Accident · No injuriesClosedCessna 150L · Pine Bluff, ARMar 25, 1977 · N1716Q · Substantial damageNTSB FTW77DPG15Accident · No injuriesClosedCessna 150 · Conway, ARJan 1, 1977 · N4271U · Substantial damageNTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARDec 24, 1976 · N66094 · Substantial damageNTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARDec 23, 1976 · N8430J · Substantial damageNTSB FTW76FPH14Accident · Serious injuriesClosedCessna 150 · Searcy, ARSep 21, 1976 · N6936F · DestroyedNTSB FTW76FRJ26Accident · No injuriesClosedCessna 150M · Texarkana, ARMay 19, 1976 · N45547 · Substantial damageNTSB FTW76DPG54Accident · No injuriesClosedCessna 150 · Bay, ARMay 18, 1976 · N6049G · Substantial damageNTSB FTW76FPG45Accident · No injuriesClosedCessna 150D · Stuttgart, ARMar 14, 1976 · N4271U · Substantial damageNTSB FTW76DPG29Accident · No injuriesClosedCessna 150 · Rye, AROct 11, 1975 · N11485 · Substantial damageNTSB FTW76DPG17Accident · No injuriesClosedCessna 150 · Mountain View, ARAug 20, 1975 · N19068 · Substantial damageNTSB FTW75FPG52Accident · Serious injuriesClosedCessna 150L · Greenwood, ARMay 10, 1975 · N19395 · DestroyedNTSB FTW75DPG37Accident · No injuriesClosedCessna 188 · Widner, ARMar 21, 1975 · N6523G · Substantial damageNTSB FTW75DPG05Accident · Minor injuriesClosedCessna 150 · Springdale, ARJul 22, 1974 · N5416Q · Substantial damageNTSB FTW74DPG59Accident · No injuriesClosedCessna 150 · Fayetteville, ARMay 2, 1974 · N50041 · Substantial damageNTSB FTW74FPG28Accident · No injuriesClosedCessna 150L · Joiner, AROct 2, 1973 · N18155 · 2 aircraft · Substantial damageNTSB FTW74FRD12Accident · No injuriesClosedCessna 150 · Loreauville, ARSep 13, 1973 · N8983S · Substantial damageNTSB FTW72FPG81Accident · Serious injuriesClosedCessna 150 · Guion, ARJun 1, 1972 · N22570 · Substantial damageNTSB FTW72FPG68Accident · No injuriesClosedCessna 150C · El Dorado, ARMar 25, 1972 · N4496U · Substantial damageNTSB FTW72FPG54Accident · No injuriesClosedCessna 150 · Jacksonville, ARNov 7, 1971 · N6182T · Substantial damageNTSB FTW71DPG62Accident · No injuriesClosedCessna 150E · Roland, ARJun 4, 1971 · N2576J · Substantial damageNTSB FTW71FPG52Accident · No injuriesClosedCessna 150 · Heber Springs, ARMay 1, 1971 · N50171 · Substantial damageNTSB FTW71FPG46Accident · No injuriesClosedCessna 150J · Monticello, ARApr 14, 1971 · N61019 · Substantial damageNTSB FTW71AF048Accident · No injuriesClosedCessna 150H · W.Memphis, ARFeb 17, 1971 · N23323 · 2 aircraft · Substantial damageNTSB FTW71FPG18Accident · Minor injuriesClosedCessna 150 · Brinkley, ARSep 6, 1970 · N6797S · Substantial damageNTSB FTW71DPG11Accident · Minor injuriesClosedCessna 150H · Hatfield, ARAug 16, 1970 · N23496 · Substantial damageNTSB FTW70DPG33Accident · No injuriesClosedCessna 150 · Ravenden Spgs, ARMay 28, 1970 · N5734G · Substantial damageNTSB FTW70F0222Accident · No injuriesClosedCessna 150 · Camden, ARSep 14, 1969 · N23444 · Substantial damageNTSB FTW69F0007Accident · No injuriesClosedCessna 150 · Carlisle, ARMay 31, 1968 · N4347U · Substantial damageNTSB FTW68D0499Accident · No injuriesClosedCessna 150 · Conway, ARMar 18, 1968 · N8584G · Substantial damageNTSB FTW68F0231Accident · No injuriesClosedCessna 150F · Tinsman, ARSep 2, 1967 · N8545G · Substantial damage