NTSB investigations: Continental 0-200 series, AZ

7 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19842026
NTSB investigations: Continental 0-200 series, AZ per year, 1984–2026: 7 cases
19841
19891
19901
19921
19971
19991
20041

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\" = 'AZ' 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\" = 353))
  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 LAX05CA044Accident · Minor injuriesData collectionFinal reportCessna 150J · Amado, AZthe pilot's inaccurate fuel consumption calculations and failure to refuel the airplane at the intermediate stop, which resulted in fuel exhaustion.Dec 8, 2004 · N60469 · Substantial damageNTSB LAX00LA037Accident · No injuriesLimited investigationFinal reportCessna 150K · Phoenix, AZFuel exhaustion due to the pilot's improper preflight planning, and failure to ensure that an adequate fuel supply was onboard the airplane.Nov 19, 1999 · N6199G · Substantial damageNTSB LAX98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Temple Bar, AZthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the terrain condition (ditch) in the emergency landing area.Oct 13, 1997 · N71VL · Substantial damageNTSB LAX92LA243Accident · No injuriesLimited investigationFinal reportCessna 150 · Tucson, AZThe pilot's failure to follow v.f.r. procedures; inadequate preflight planning/preperation; and improper fuel consumption calculations which resulted in fuel exhaustion.Jun 12, 1992 · N6972G · Substantial damageNTSB LAX90LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Bullhead City, AZThe pilot's miscalculation of the fuel remaining, which caused the engine to quit.Feb 10, 1990 · N1272Q · Substantial damageNTSB LAX90LA011Accident · No injuriesLimited investigationFinal reportCessna 150L · Marana, AZFailure of the pilot to properly judge his fuel supply, which resulted in fuel exhaustion.Oct 25, 1989 · N642EZ · Substantial damageNTSB LAX85LA072Accident · No injuriesLimited investigationFinal reportCessna 150F · Glendale, AZThe acft lost power & nosed over while making an emergency landing in a muddy field. Investigation revealed that fuel was being siphoned from the fuel tank vent.Dec 15, 1984 · N7967F · Substantial damage