Skip to content

NTSB investigations: Continental 0-200 series, SD

21 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

19672026

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" = 'SD' 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\" = 'SD' 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" = 'SD' 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 CEN22FA109Accident · 1 fatalClass 3 · FieldFinal reportChristavia MK1 · Oral, SDThe noncertificated pilot’s failure to maintain control of the airplane, which led to the airplane exceeding its critical angle-of-attack and subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to attempt a flight with no…Jan 31, 2022 · N3177F · Substantial damage NTSB CEN18LA329Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, SDA stuck No. 3 cylinder exhaust valve, which resulted in failure of the associated rocker arm, a partial loss of engine power, and the subsequent forced landing into tall vegetation.Aug 14, 2018 · N6341K · Substantial damage NTSB CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.Aug 4, 2008 · N16235 · Substantial damage NTSB CHI01LA253Accident · No injuriesLimited investigationFinal reportCessna 150M · Rapid City, SDThe student solo pilot failed to compensate for the wind conditions. Factors included the high wind, gusts, and tailwind.Jul 26, 2001 · N714GF · Substantial damage NTSB CHI01LA053Accident · No injuriesLimited investigationFinal reportCessna 150M · New Underwood, SDThe pilot's inadequate planning and preparation, which resulted in fuel exhaustion. A factor relating to this accident was the plowed field.Dec 26, 2000 · N63067 · Substantial damage NTSB CHI00LA100Accident · No injuriesLimited investigationFinal reportPiper J-3C · Eureka, SDthe foreign object (shot gun shell) which jammed the control stick. Factors associated with the accident were the low altitude at which the control stick jammed and the rough terrain which the airplane contacted.Mar 30, 2000 · N71060 · Substantial damage NTSB CHI95LA077Accident · No injuriesLimited investigationFinal reportCessna 150F · Castlewood, SDthe pilot's inadequate preflight planning and preparation. Factors associated with the accident are the snow covered/drifted runway, and a fence.Jan 21, 1995 · N8981S · Substantial damage NTSB CHI94LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Waubay, SDthe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the false indications on the fuel gauges.Jan 23, 1994 · N10449 · Substantial damage NTSB DEN82DA187Accident · No injuriesFinal reportCessna 150 · Faith, SDThe pilot reported that the aircraft lifted off the runway nicely, but after climbing to about 75 ft AGL, it started to lose lift and airspeed. He elected to land on a gravel road, but reported that a car was on the roadway. The aircraft was damaged during a…Sep 7, 1982 · N8127S · Substantial damage NTSB DEN82DTK01Accident · No injuriesClosedCessna 150 · Elkton, SDDec 6, 1981 · N5845G · Substantial damage NTSB MKC80DTK10Accident · No injuriesClosedCessna 150 · Watertown, SDApr 19, 1980 · N4685X · Substantial damage NTSB MKC80FA020Accident · 2 fatalClosedCessna 150 · Sioux Falls, SDFeb 11, 1980 · N17013 · Destroyed NTSB MKC79FTK03Accident · Serious injuriesClosedCessna 150M · Rapid City, SDDec 3, 1978 · N63067 · Substantial damage NTSB MKC79DTK01Accident · Minor injuriesClosedCessna 150 · Piedmont, SDNov 24, 1978 · N66231 · Substantial damage NTSB MKC78FTK12Accident · No injuriesClosedCessna 150 · Rapid City, SDMar 17, 1978 · N22530 · Substantial damage NTSB MKC77FTK05Accident · No injuriesClosedCessna 150 · Holabird, SDJan 2, 1977 · N8433G · Substantial damage NTSB MKC70DDQ01Accident · No injuriesClosedCessna 150 · Miller, SDJan 13, 1970 · N2870S · Substantial damage NTSB MKC69D0363Accident · No injuriesClosedCessna 150 · Sioux Falls, SDFeb 19, 1969 · N6402F · Substantial damage NTSB MKC69F0044Accident · No injuriesClosedCessna 150 · Hot Springs, SDJun 13, 1968 · N22053 · Substantial damage NTSB MKC68F0491Accident · No injuriesClosedCessna 150G · Rapid City, SDMar 30, 1968 · N3613J · Substantial damage NTSB MKC68D0152Accident · No injuriesClosedCessna 150 · Rapid City, SDAug 15, 1967 · N6725F · Substantial damage