NTSB investigations: Continental 0-200 series, 1995

12 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

19822026
NTSB investigations: Continental 0-200 series, 1995 per year, 1982–2026: 370 cases
198217
198316
198423
198515
198620
198719
198813
198923
199027
199114
199210
199324
199417
199512
199615
199717
19983
199910
200014
200112
20025
20038
200410
20056
200613
20077

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 year(c.\"eventDate\") = 1995
    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 ATL96LA031Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaufort, SCAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of engine power. The tree stump was a factor.Dec 1, 1995 · N8779U · Substantial damageNTSB LAX96LA054Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Sonora, CAcarburetor icing, due to the pilot's improper use of power plant controls and/or carburetor heat. A factor relating to the accident was: the weather condition, which was conducive to carburetor ice.Nov 25, 1995 · N3000J · Substantial damageNTSB ATL96LA009Accident · No injuriesLimited investigationFinal reportCessna 150F · Charlotte, NCThe pilot's inadequate preflight/planning which resulted in fuel exhaustion due to an inadequate fuel supply.Oct 21, 1995 · N7157F · Substantial damageNTSB CHI96LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · Peosta, IAthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion.Oct 19, 1995 · N17382 · Substantial damageNTSB LAX96LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Brea, CAfuel exhaustion due to the pilot's improper leaning procedures and his failure to use the performance charts in the pilot operating handbook to determine fuel consumption rates for the selected cruise power setting.Oct 16, 1995 · N704QJ · Substantial damageNTSB LAX96LA002Accident · No injuriesLimited investigationFinal reportCessna 150M · Fillmore, CAthe CFI's failure to adequately supervise the flight; and the student pilot's poor preflight planning/preparation and fuel consumption calculations.Oct 2, 1995 · N63522 · Substantial damageNTSB FTW95LA400Accident · No injuriesLimited investigationFinal reportCessna 150K · Victoria, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.Sep 16, 1995 · N5DT · Substantial damageNTSB LAX95LA325Accident · 1 fatalLimited investigationFinal reportChambers C1C · Turlock, CAa loss of engine power due to fuel system contamination and the pilot's failure to maintain an adequate airspeed while maneuvering for an emergency landing. Factors in the accident were: the inadequate procedures used to purge the fuel system of known…Sep 4, 1995 · N177GE · DestroyedNTSB CHI95LA264Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Murphysboro, ILthe pilot's improper use of carburetor heat which led to a loss of power due to carburetor ice, and his failure to maintain airspeed during the forced landing. The carburetor icing conditions were a factor.Aug 8, 1995 · N11346 · Substantial damageNTSB SEA95LA166Accident · No injuriesLimited investigationFinal reportCessna 150J · West Jordan, UTThe pilot's failure to refuel the aircraft prior to initiating his cross-country flight resulting in a total power loss due to fuel exhaustion.Jul 30, 1995 · N61284 · Substantial damageNTSB LAX95LA231Accident · No injuriesLimited investigationFinal reportCessna 150G · Riverdale, CAFuel exhaustion due to the student pilot's inadequate preflight inspection and his failure to refuel the aircraft en route. A factor in the accident was inadequate supervision of the student by the flying club and the student's flight instructor.Jun 30, 1995 · N3421J · Substantial damageNTSB CHI95LA136Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Springfield, MOThe student pilot's failure to refuel the airplane. The student pilot's inadequate fuel consumption calculations were a related factor.Apr 26, 1995 · N3112J · Substantial damage