NTSB investigations: Continental 0-200 series, 1997
70 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.
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 year(c.\"eventDate\") = 1997
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 year(c."eventDate") = 1997
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" 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 MIA97LA114Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Petersburg, FLthe student pilot's improper level off.NTSB IAD97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsburgh, PAthe student pilot inadvertently became lost/disoriented during a cross-country flight, and failed to use his radio for assistance, which led to fuel exhaustion, loss of engine power, and a forced landing.NTSB CHI97LA092Accident · No injuriesLimited investigationFinal reportChampion 7ECA · South St. Paul, MNThe pilot's inadequate compensation for wind and his failure to maintain adequate obstacle clearance which resulted in collision with a snowbank. The pilot's lack of recent experience, the crosswind, and snowbank are contributing factors.NTSB CHI97LA089Accident · No injuriesLimited investigationFinal reportCessna 150 · Petersburg, INThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Low altitude flight is a contributing factor.NTSB FTW97FA135Accident · 1 fatalField investigationFinal reportTeschendorf Cassutt Sport · Stilwell, OKfailure of the right wing spar and/or debonding of the right wing skin, which resulted in separation of the wing skin and a portion of the right wing, during high speed flight. Factors related to the accident were: previous wing damage and inadequate…NTSB CHI97LA088Accident · No injuriesLimited investigationFinal reportCessna 150J · La Valle, WIthe pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.NTSB FTW97FA109Accident · 1 fatalField investigationFinal reportKeating Quickie II · Houston, TXThe loss of engine power due to fuel starvation as result of the pilot's improper fuel management. Factors were the pilot's lack of familiarity with the airplane, the dark night, the lack of cockpit lights, and the lack of suitable terrain for the pilot to…NTSB SEA97LA068Accident · Minor injuriesLimited investigationFinal reportHemingway Varieze · Arlington, WAThe pilot's failure to maintain control of the aircraft. Factors contributing to the accident were the pilot's lack of total experience in the type of aircraft and the gusty wind conditions.NTSB ATL97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Raleigh, NCa loose fuel capd and siphoning of fuel, resulting in fuel exhaustion and a loss of engine power. A factor was the rough terrain in the forced landing field that resulted in the nose over during the landing roll.NTSB NYC97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarksville, MDThe pilot's failure to maintain directional control and failure to abort the takeoff.NTSB IAD97LA050Accident · No injuriesLimited investigationFinal reportCessna 150 · Turner, MELoss of engine power for undetermined reasons. A related factor was the snowbank.NTSB SEA97LA064Accident · No injuriesLimited investigationFinal reportCessna 150J · Price, UTThe flight instructor's failure to ensure that the dual student maintained adequate airspeed.NTSB ATL97LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLthe student pilot's inadvertent movement of the mixture control to idle cut-off during the approach to land, which resulted in engine shut-down, and the student's failure to follow emergency procedures for restarting the engine.NTSB SEA97LA055Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Bandon, ORthe dual student's failure to maintain directional control of the airplane, and the flight instructor's improper remedial action. A factor relating to the accident was: the ravine located near the right side of the runway.NTSB CHI97LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Dowagiac, MIthe pilot's failure to maintain directional control. A factor was the snowbank.NTSB ATL97FA034Accident · 2 fatalField investigationFinal reportCessna A150L · Trinity, ALfailure of the pilot to maintain flying airspeed, while maneuvering at low altitude, which resulted in a stall and subsequent collision with a tree, utility line, and the ground.NTSB NYC97FA043Accident · 2 fatalField investigationFinal reportCessna 150L · Collegeville, PAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed during the forced landing, which resulted in a stall and collision with the ground. A contributing factor was wind gusts.NTSB SEA97LA042Accident · No injuriesLimited investigationFinal reportCessna 150K · Helena, MTThe pilot's failure to maintain directional control.NTSB MIA97LA054Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Daytona Beach, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel for continued flight, which resulted in fuel exhaustion and subsequent collision with objects (concrete blocks) during a forced landing. Factors relating to the accident…NTSB IAD97FA038Accident · 1 fatalField investigationFinal reportCessna 150F · Bittinger, MDVFR flight by the noninstrumented-rated pilot into instrument meteorological conditions (IMC), which lead to spatial disorientation of the pilot, his loss of aircraft control, and an uncontrolled collision with the terrain. Factors relating to the accident…