Skip to content

NTSB investigations: Continental 0-200 series, DE

19 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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" = 'DE' 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

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\" = 'DE' 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" = 'DE' 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

Run 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 NYC06LA163Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Smyrna, DEThe pilot's misjudged fuel calculations, which resulted in fuel exhaustion and subsequent loss of engine power. A factor was the nighttime lighting conditions.Jun 30, 2006 · N6970S · Substantial damage NTSB NYC00LA189Accident · No injuriesLimited investigationFinal reportCessna 150 · Freemont, DEThe pilot's failure to maintain altitude/clearance and delayed power application while attempting to release a banner from the airplane.Jul 7, 2000 · N8362M · Substantial damage NTSB IAD98LA067Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Selbyville, DEInadequate compensation for wind conditions by the pilot, and his failure to maintain control of the airplane. High, gusting winds were contributing factors.Jun 3, 1998 · N3731J · Substantial damage NTSB NYC97LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · New Castle, DEthe pilot's failure to maintain directional control of the airplane. A contributing factor was the gusty wind conditions.May 10, 1997 · N23471 · Substantial damage NTSB BFO87LA038Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEDuring takeoff the pilot stated that at about 150 to 200 feet he experienced a slow sinking of the aircraft. The engine was at full throttle, the flaps set at 10 degrees and the airspeed at 70 knots. The aircraft continued to sink and collided with trees.…May 16, 1987 · N5747G · Destroyed NTSB NYC83LA065Accident · No injuriesLimited investigationFinal reportCessna 150K · Wilmington, DEA C-130 aircrew was cleared to taxi to the run-up area at the north end of the arpt for a run-up. At that time, the wind was reported from 360 deg at 8 KTS. The C-130 crew stopped on the run-up pad facing the wind & began a run-up. In the meantime, a Cessna…Feb 19, 1983 · N5898G · Substantial damage NTSB IAD80DHD01Accident · No injuriesClosedCessna 150 · Middletown, DEOct 12, 1979 · N11820 · Substantial damage NTSB IAD79FHD05Accident · No injuriesClosedCessna 150 · Rehobeth, DENov 25, 1978 · N5440Q · Substantial damage NTSB IAD75FHD18Accident · No injuriesClosedCessna 150 · Laurel, DEJul 28, 1974 · N7172F · Substantial damage NTSB IAD74DHD26Accident · Minor injuriesClosedCessna 150 · Cheswold, DEJan 22, 1974 · N18140 · Substantial damage NTSB NYC72DHD44Accident · No injuriesClosedCessna 150 · Laurel, DEJun 24, 1972 · N50747 · Substantial damage NTSB IAD71DHD04Accident · No injuriesClosedCessna 150 · Middletown, DEJul 7, 1970 · N8400J · Substantial damage NTSB DIA69D0203Accident · No injuriesClosedCessna 150 · Dover, DEApr 18, 1969 · N8946S · Substantial damage NTSB DIA69D0049Accident · No injuriesClosedCessna 150 · Middletown, DEJul 24, 1968 · N3976J · Substantial damage NTSB DIA68D0132Accident · No injuriesClosedCessna 150 · Wyoming, DENov 20, 1967 · N8946S · Substantial damage NTSB DIA68F0108Accident · Serious injuriesClosedCulver LFA · Middletown, DESep 15, 1967 · N29288 · Substantial damage NTSB NYC68F0174Accident · No injuriesClosedCessna 150G · Milford, DESep 1, 1967 · N2992J · Substantial damage NTSB DIA67D0088Accident · No injuriesClosedCessna 150G · Middletown, DEApr 20, 1967 · N8480J · Substantial damage NTSB NYC66D0241Accident · No injuriesClosedCessna 150 · Laurel, DESep 15, 1965 · N7840Z · Substantial damage