What is the best way to estimate a demand curve? I did a linear regression on quantity sold and price for a good and simply the coefficients don't make any sense. number of observations = 16
Demand=1868 -14*P
Suply=0 +45*P
So p*= 1421.778  and Q*= 31.59507
Is there an error in the calculations? the P* =\$1421,778  does not make any sense since the product price is \$79. would it be due to the low number of observations? Or is a linear model not the most suitable for estimating a demand curve? if so which one would be best?
The approach you use has various problems.

Yes you need more than 16 observations. In most parametric models (including OLS) as a rule of thumb you need at least 25-30 observations per independent regressor (see Newbold et al statistics for business and economics for example).
You can use a linear model but you should not assume demand is a linear function of price. OLS is a model that is linear in its parameters but that does not mean necessarily that the relationship between two variables should be modeled in a linear way.

For example, a more realistic assumption about demand would be given by the following function:
$$q = a p^{\beta_1} x^{\beta_2}$$
where, $q$ is quantity, and $x$ some control variable, which is not linear but after taking logs of both sides this demand can be modeled by OLS because OLS needs to be just linear in parameters (here $\beta_1$ and $\beta_2$):
$$q = \ln (a) + \beta_1 \ln (p) + \beta_2 \ln (x) + e$$

Another problem is that you don't include any control variables. You should include several of them - anything you think can affect quantity demanded aside from price should be ideally controlled for (and remember you should expand your sample to always have at least 25-30 observations per independent regressor in a parametric model).

Even though demand is estimated with models that employ regressions, using just simple OLS is inappropriate. Supply-Demand is an endogenous system. Price affects quantity demanded and quantity demanded affects price at the same time and the same holds for supply.


Hence you cannot simply run two independent OLS and then equate them to determine equilibrium price. You should  model this as an endogenous system where both supply and demand are modeled at the same time. There are also further issues that I did not explore here but these are already quite severe and will lead to biased coefficients and/or wrong inference.
Writing a tutorial for estimating supply and demand relationship is completely beyond the scope of Stack Exchange, and what is the best way might vary from case to case, but if you want to see an example of how to properly estimate supply-demand relationship it can be found in this paper from MacKay &amp; Miller (2018).