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.
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" 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 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB 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,…NTSB FTW81DPG21Accident · No injuriesClosedCessna 150 · Marshall, ARNTSB FTW80DPG67Accident · No injuriesClosedCessna 150 · Benton, ARNTSB FTW80FA102Accident · 2 fatalClosedCessna 150H · Jonesboro, ARNTSB FTW79DPG26Accident · No injuriesClosedCessna 150 · Marked Tree, ARNTSB FTW79DPG22Accident · No injuriesClosedCessna 150 · Arkadelphia, ARNTSB FTW79DPG09Accident · No injuriesClosedCessna 150 · Benton, ARNTSB FTW79DPG08Accident · No injuriesClosedCessna 150F · Mt.Ida, ARNTSB FTW78DPG70Accident · No injuriesClosedCessna 150 · Lakeview, ARNTSB FTW78DPG10Accident · No injuriesClosedCessna 150 · Newark, ARNTSB FTW77DPG44Accident · No injuriesClosedCessna 150G · Arkadelphia, ARNTSB FTW77DPG25Accident · No injuriesClosedCessna 150 · N.Little Rock, ARNTSB FTW77FPG22Accident · No injuriesClosedCessna 150L · Pine Bluff, ARNTSB FTW77DPG15Accident · No injuriesClosedCessna 150 · Conway, ARNTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARNTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARNTSB FTW76FPH14Accident · Serious injuriesClosedCessna 150 · Searcy, ARNTSB FTW76FRJ26Accident · No injuriesClosedCessna 150M · Texarkana, ARNTSB FTW76DPG54Accident · No injuriesClosedCessna 150 · Bay, ARNTSB FTW76FPG45Accident · No injuriesClosedCessna 150D · Stuttgart, ARNTSB FTW76DPG29Accident · No injuriesClosedCessna 150 · Rye, ARNTSB FTW76DPG17Accident · No injuriesClosedCessna 150 · Mountain View, ARNTSB FTW75FPG52Accident · Serious injuriesClosedCessna 150L · Greenwood, ARNTSB FTW75DPG37Accident · No injuriesClosedCessna 188 · Widner, ARNTSB FTW75DPG05Accident · Minor injuriesClosedCessna 150 · Springdale, ARNTSB FTW74DPG59Accident · No injuriesClosedCessna 150 · Fayetteville, ARNTSB FTW74FPG28Accident · No injuriesClosedCessna 150L · Joiner, ARNTSB FTW74FRD12Accident · No injuriesClosedCessna 150 · Loreauville, ARNTSB FTW72FPG81Accident · Serious injuriesClosedCessna 150 · Guion, ARNTSB FTW72FPG68Accident · No injuriesClosedCessna 150C · El Dorado, ARNTSB FTW72FPG54Accident · No injuriesClosedCessna 150 · Jacksonville, ARNTSB FTW71DPG62Accident · No injuriesClosedCessna 150E · Roland, ARNTSB FTW71FPG52Accident · No injuriesClosedCessna 150 · Heber Springs, ARNTSB FTW71FPG46Accident · No injuriesClosedCessna 150J · Monticello, ARNTSB FTW71AF048Accident · No injuriesClosedCessna 150H · W.Memphis, ARNTSB FTW71FPG18Accident · Minor injuriesClosedCessna 150 · Brinkley, ARNTSB FTW71DPG11Accident · Minor injuriesClosedCessna 150H · Hatfield, ARNTSB FTW70DPG33Accident · No injuriesClosedCessna 150 · Ravenden Spgs, ARNTSB FTW70F0222Accident · No injuriesClosedCessna 150 · Camden, ARNTSB FTW69F0007Accident · No injuriesClosedCessna 150 · Carlisle, ARNTSB FTW68D0499Accident · No injuriesClosedCessna 150 · Conway, ARNTSB FTW68F0231Accident · No injuriesClosedCessna 150F · Tinsman, AR