Skip to content

NTSB investigations: Continental 0-200 series, OR

112 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, newest first

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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 SEA87LA055Accident · No injuriesLimited investigationFinal reportCessna 150E · Joseph, ORPlt was on first flight of season. After two hours flying, landing was attempted on dry hard-surface runway in slight tailwind. During roll-out, left drift developed. Use of right brake caused tail of acft to lift. Plt applied both brakes and acft nosed over…Feb 8, 1987 · N3079J · Substantial damage NTSB SEA87LA042Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, ORA power loss occurred during takeoff at about 100 feet AGL due to fuel exhaustion. A turn to the left was made so that a landing could be made on a field. During landing roll the aircraft's wing struck two trees.Dec 27, 1986 · N11537 · Substantial damage NTSB SEA86LA127Accident · No injuriesLimited investigationFinal reportCessna 150 · Morgan, ORDuring takeoff from a soft rough barley field during a crosswind the pilot rotated prematurely. The aircraft settled back onto the field striking the nose gear first and then flipped inverted.Mar 12, 1986 · N45174 · Substantial damage NTSB SEA85LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Lapine, ORPlt recieved inflt wx brief. Present location and next reporting station were VFR, no known adverse wx between. En route, plt encountered IMC. Fuel comsumed in maneuvering to aviod wx precluded return to known VFR airfield. Plt elected to make a precautionary…Oct 14, 1984 · N11849 · Substantial damage NTSB SEA84FA113Accident · 1 fatalField investigationFinal reportCessna 150F · Gleneden Beach, ORTwo witnesses observed the student plt in the acft at about 1500 PDT. They reported that they were waiting for the wx to clear & that they tried to get the student to spend the night instead of leaving, but they were unsuccessful. Subsequently, the acft…May 19, 1984 · N6511F · Destroyed NTSB SEA84LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Oregon City, ORThe plt, who was an a & p mechanic, had just installed an eng that had been overhauled by someone else. He reported that the pretakeoff & run-up checks were normal. At aprx 250 to 300 ft AGL, during takeoff, the eng began to shake violently & lost power. The…Nov 18, 1983 · N6054G · Substantial damage NTSB SEA83LA169Accident · No injuriesLimited investigationFinal reportCessna 150J · Grants Pass, ORThe acft ran off the departure end of the rwy during a forced landing following engine failure during a touch and go landing. The nosewheel struck a mound of dirt and the acft nosed over. The acft had reached 40 ft AGL and 70 mph when the engine lost power…Aug 7, 1983 · N60754 · Substantial damage NTSB SEA83LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Scappoose, ORAt about 300 ft AGL after a touch & go the eng quit. The non-pilot owner who was at the controls turned the acft over to the passenger who was a private pilot & he made the forced landing. There was no usuable fuel on board the acft the passenger/pilot…Dec 26, 1982 · N2239J · Substantial damage NTSB SEA82DA124Accident · No injuriesFinal reportCessna 150M · Corvallis, ORAt 0830 PDT on 7/22/82, the aircraft was found near the approach end of runway 35 resting on its nose with the nose gear broken. Operator personnel reported that it had been stolen sometime after 2200 PDT on the night before. Also during that time, someone…Jul 22, 1982 · N8168U · Substantial damage NTSB SEA82DA066Accident · No injuriesFinal reportCessna 150F · Grande Ronde, ORThe student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch.May 6, 1982 · N6701F · Substantial damage NTSB SEA82FA064Accident · 2 fatalField investigationFinal reportCessna 150H · Oregon City, ORThe aircraft crashed during takeoff from a private airport that was not open to the public. Operations on the airport were at the owner's discretion (prior permission required). An electric fence crossed the airport about 1500 ft from the south end. The owner…May 4, 1982 · N6752S · Destroyed NTSB SEA81FA048Accident · 2 fatalClosedCessna 150H · Blue River, ORJul 24, 1981 · N6551S · Destroyed NTSB SEA81DYK13Accident · No injuriesClosedCessna 150G · Medford, ORJul 21, 1981 · N2800S · Substantial damage NTSB SEA80DYM48Accident · No injuriesClosedCessna 150J · Long Creek, ORJun 22, 1980 · N61365 · Substantial damage NTSB SEA79FYK29Accident · Minor injuriesClosedCessna 150F · Cottage Grove, ORSep 9, 1979 · N8937S · Substantial damage NTSB SEA78DYM20Accident · No injuriesClosedCessna 150G · Aurora, ORMar 13, 1978 · N6699G · Substantial damage NTSB SEA77DYK22Accident · No injuriesClosedCessna 150L · Tenmile, ORAug 31, 1977 · N17067 · Substantial damage NTSB SEA77DYM51Accident · No injuriesClosedCessna 150 · Dallas, ORJul 11, 1977 · N22499 · Substantial damage NTSB SEA77DYK11Accident · No injuriesClosedTaylorcraft F19 · Chiloquin, ORMay 30, 1977 · N3586T · Substantial damage NTSB SEA77FYC07Accident · No injuriesClosedCessna 150 · Sheridan, ORNov 18, 1976 · N3998U · Substantial damage NTSB SEA77DYC09Accident · Minor injuriesClosedCessna 150 · Cornelius, ORNov 7, 1976 · N60855 · Substantial damage NTSB SEA77DYC01Accident · No injuriesClosedCessna 150 · Lebanon, OROct 10, 1976 · N150FW · Substantial damage NTSB SEA76DYIIOAccident · No injuriesClosedCessna 150 · Roseburg, ORSep 2, 1976 · N11758 · Substantial damage NTSB SEA76FYC60Accident · No injuriesClosedCessna 150L · Oregon City, ORJun 25, 1976 · N10297 · Substantial damage NTSB SEA76DYC47Accident · No injuriesClosedCessna 150 · Clackamas, ORMay 15, 1976 · N61263 · Substantial damage NTSB SEA75DYI27Accident · No injuriesClosedCessna 150 · Redmond, ORMay 28, 1975 · N10297 · Substantial damage NTSB SEA75DYI21Accident · No injuriesClosedCessna 150 · Bend, ORApr 9, 1975 · N9934G · Substantial damage NTSB SEA75AS034Accident · 1 fatalClosedCessna 150L · Albany, ORMar 14, 1975 · N5331Q · Substantial damage NTSB SEA75DYC20Accident · No injuriesClosedCessna 150 · St Paul, OROct 19, 1974 · N23015 · Substantial damage NTSB SEA74FYC45Accident · No injuriesClosedCessna 150 · Grand Ronde, ORApr 12, 1974 · N5809E · Substantial damage NTSB LAX74DYI11Accident · No injuriesClosedCessna 150 · Medford, ORApr 7, 1974 · N2800S · 2 aircraft · Substantial damage NTSB SEA74DYC42Accident · No injuriesClosedCessna 150J · Molalla, ORApr 6, 1974 · N61365 · Destroyed NTSB SEA73DYC31Accident · No injuriesClosedCessna 150 · Salem, ORMay 28, 1973 · N21986 · Substantial damage NTSB SEA73FYI12Accident · No injuriesClosedCessna 150 · Roseburg, ORMar 6, 1973 · N6561G · Substantial damage NTSB SEA72FYC25Accident · No injuriesClosedCessna 150 · Forest Grove, ORDec 18, 1971 · N7011S · Substantial damage NTSB SEA70DXM08Accident · No injuriesClosedCessna 150H · Lagrande, ORMar 15, 1970 · N22209 · Substantial damage NTSB SEA70DWA05Accident · No injuriesClosedCessna 150 · Cottage Grve, ORFeb 22, 1970 · N3139J · Substantial damage NTSB SEA70FWA02Accident · No injuriesClosedCessna 150F · Donald, ORFeb 1, 1970 · N8135S · Substantial damage NTSB SEA70D0001Accident · No injuriesClosedCessna 150 · Albany, ORApr 20, 1969 · N4046J · Substantial damage NTSB SEA69F0214Accident · Minor injuriesClosedCessna 150H · Medford, ORFeb 27, 1969 · N22088 · Destroyed NTSB SEA69F0199Accident · Minor injuriesClosedCessna 150F · Goshen, ORFeb 13, 1969 · N8920S · Destroyed NTSB SEA69D0176Accident · No injuriesClosedCessna 150 · Chemult, ORDec 2, 1968 · N6915S · Substantial damage NTSB SEA69D0042Accident · Minor injuriesClosedCessna 150 · Halfway, ORJun 28, 1968 · N22499 · Substantial damage NTSB SEA69D0050Accident · No injuriesClosedCessna 150 · Springfield, ORMay 31, 1968 · N6716F · Substantial damage NTSB SEA68D0285Accident · No injuriesClosedCessna 150 · Florence, ORMar 14, 1968 · N7112F · Substantial damage NTSB SEA68F0278Accident · Minor injuriesClosedCessna 150 · Dillard, ORMar 11, 1968 · N3099S · Substantial damage NTSB SEA68D0204Accident · No injuriesClosedCessna 150 · Independence, ORSep 17, 1967 · N3097J · Substantial damage NTSB SEA68D0179Accident · No injuriesClosedCessna 150G · Wasco, ORAug 27, 1967 · N3292J · Substantial damage NTSB SEA68D0118Accident · No injuriesClosedCessna 150F · Sutherlin, ORJul 16, 1967 · N6533F · Substantial damage NTSB SEA68F0011Accident · No injuriesClosedCessna 150E · Medford, ORMay 20, 1967 · N2502J · Substantial damage