NTSB investigations: Continental 0-200 series
72 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “In flight collision with terrain/water”. 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, newest first
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.\"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\" = 230))
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."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" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW86FA054Accident · 1 fatalField investigationFinal reportCessna 150G · Salina, OKA night shift worker was returning home in the early morning hours. Crossing the grand river dam near salinas ok. He saw a flash or glint of metal and a large splash near the middle of the widest part of the lake. Examination of the wreckage indicated that…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.NTSB CHI86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · Charlotte, MIThe student was performing a practice approach to an emergency landing on a frozen, snow covered lake. After he had flown to an altitude low over the lake the instructor took over the controls. At this point the aircraft struck a ridge of snow and came to a…NTSB FTW85LA338Accident · No injuriesLimited investigationFinal reportCessna 150J · Crystal Beach, TXThe plt reportedly was delivering the acft to Crystal Beach, TX, from its home base at orange county airport, TX. The pilot reportedly call the owner and told him he had bent the acft upon landing at Crystal Beach. He was told by the owner to wait at the acft…NTSB MKC85FA030Accident · 1 fatalField investigationFinal reportCessna 150 · Colby, KSOn a heading of 065 deg the acft impacted in a slightly rising open field in a wings level 15 deg nose down attitude. Investigators found the acft in a landing configuration with the wing flaps fully extended and the throttle secured by the throttle friction…NTSB MKC84LA284Accident · No injuriesLimited investigationFinal reportCessna 150 · Campbell, MOPlt stated that the acft was low on final apch and full pwr was added to go-around. The acft continued to settle until it contacted the rwy. The acft traveled off the left side of the rwy. After continuing through grass the acft contacted a steel angle iron…NTSB ATL84IA262Incident · No injuriesIncident investigationFinal reportCessna 150H · Gastonia, NCPlt reached charlotte, NC, and discovered he could not transmit on the acft radio. Plt diverted to gasotnia, NC, but could not locate the arpt because of lowering visibility. Plt flew around for a few minutes looking for identifiable landmarks. Precautionary…NTSB ATL84FA250Accident · 1 fatalField investigationFinal reportCessna 150F · Banner Elk, NCAcft observed to depart short strip in hi dens alt conditions, 'wobbled into the air.' Acft did not circle for altitude, but headed straight ahead toward rising terrain 'wings rocking' at slow speed before right wing dropped and acft collided with terrain. No…NTSB DEN84LA176Accident · No injuriesLimited investigationFinal reportCessna 150M · Afton, WYThe plt departed rwy 16 with the intention of repositioning the acft on the arpt after landing. He estimated the surfacewinds were from the southeast at 15 KTS. A witness stated that the winds had changed directions about eight times during the day. The plt…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…NTSB LAX83FUJ15Accident · 1 fatalFinal reportGrau VARI-EZE · Tucson, AZWitnesses observed the acft make 4 low passes, 200-300 ft AGL. On the last pass the acft pulled up ino about a 30 deg nose high attitude & start a right roll. The nose began to drop, & as the roll was completed the acft was in about a 80 deg nose low, wings…NTSB ATL83LA304Accident · No injuriesLimited investigationFinal reportCessna 150J · Monroe, GAAfter turning final approach the pilot realized he was high so he lowered full flaps. Shortly thereafter he saw that the indicated airspeed was low and made an aircraft attitude adjustment. After he corrected for the low air speed he failed to rotate to a…NTSB CHI83LA274Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe CFI said the student pilot tried to correct for a gust of wind. After the acft turned 30 0R 40 degrees the CFI took control. During the go-around the right wing contacted the ground and the acft cartwheeled.NTSB CHI83LA109Accident · No injuriesLimited investigationFinal reportCessna 150 · Calumetville, WITais Cessna 150 collided with snow covered terrain while practicing the results of 'ground effect'. The weather was VMC and no flight plan was filed. The pilot was not injured in the accident. The flight originated at fond du lac WI at 1200 CST on feb. 12,…NTSB ATL83FKQ01Accident · 2 fatalFinal reportCessna 150F · Sidon, MSThe student pilot and passenger departed jackson on a flight to madison, MS. The highway patrol received a report of a low flying aircraft and a loud noise in the vicinity of Sidon, MS, the aircraft wreckage was found the next morning in a soy bean field. The…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…NTSB FTW82DA332Accident · No injuriesFinal reportCessna 150M · Balmorhea, TXThe pilot stated that while he was making a full flap landing, a crosswind drifted the aircraft off the narrow gravel landing strip. As he started to go around, the main gear hit a rock pile. The aircraft then bounced and hit the ground, nose first.NTSB ATL82FLQ09Accident · Serious injuriesFinal reportCessna 150 · Prestonburg, KYImmediately after takeoff from rwy 13 the CFI saw another acft on final to rwy 31 & entered a steep left climbing turn up a small valley east of the arpt. The CFI was unable to out-climb the rising terrain. The CFI stated he took this evasive action to avoid…NTSB DEN82DA143Accident · No injuriesFinal reportCessna 150M · Nr. Colorado Sp, COThe acft crashed in north cheyenne wood near pikes peak at approximately 8400 ft MSL. The plt reported that after arriving at the first ridge of mountains he was caught in downdrafts. Unable to clear the top of a mountain, he turned into a box canyon.NTSB CHI82DA182Accident · No injuriesFinal reportCessna 150G · White Cloud, MIThe student pilot stated he was too high on final approach so he attempted a go-around. As he applied power, the nose increased in pitch attitude and the empennage struck the runway. The aircraft started to turn to the left, the left wing struck the runway…NTSB NYC82FA041Accident · Serious injuriesField investigationFinal reportCessna 150G · Erwinna, PAThis was the student's first solo in powered aircraft. He held a private pilot certificate with a glider rating. His takeoff and traffic pattern appeared normal until the last part of his final approach for landing. About 600 ft short of the runway, the…NTSB NYC82DA017Accident · No injuriesFinal reportCessna 150L · Caldwell, NJThe student pilot was at the controls during a landing on runway 04. The wind was from 330 degrees at 15 knots. The instructor reported that the plane was slipped to the left on short final, and shortly thereafter, the right wheel struck a snowbank. The…