NTSB investigations: Continental 0-200 series, 1997, FL

7 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 per year

19642026
NTSB investigations: Continental 0-200 series, 1997, FL per year, 1964–2026: 368 cases
19642
196511
196617
196724
196820
196914
197012
197111
197212
197313
197417
197521
19766
197715
19789
19797
19809
19818
19822
19833
19841
19853
19866
19875
19885
19895
19906
19915
19923
19935
19947
19954
19966
19977
19986
19992
20004
20013
20026
20031
20043
20065
20074
20081
20092
20105
20114
20122
20154
20191
20215
20221
20231
20243
20251
20263

Latest cases

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.\"eventStateOrRegion\" = 'FL' 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.

NTSB ATL98FA025Accident · 2 fatalField investigationFinal reportCessna A150K · Jacksonville, FLthe pilot's failure to maintain adequate flying speed following a banner pick up, which resulted in a stall and an uncontrolled collision with the ground. A related factor was: the pilot allowed the maximum certificated gross weight of the airplane to be…Dec 17, 1997 · N1218M · Substantial damageNTSB MIA98LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLa loss of engine power for undetermined reasons.Nov 13, 1997 · N6062K · Substantial damageNTSB MIA97LA170Accident · No injuriesLimited investigationFinal reportCessna 150F · Venice, FLfailure of the pilot to maintain sufficient airspeed on final approach and during the landing to properly flare the airplane.May 19, 1997 · N102HA · Substantial damageNTSB MIA97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Miami, FLThe student pilot's inadequate preflight planning and improper fuel consumption calculations which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Apr 6, 1997 · N50918 · Substantial damageNTSB MIA97LA114Accident · No injuriesLimited investigationFinal reportCessna 150G · St. Petersburg, FLthe student pilot's improper level off.Apr 3, 1997 · N2402J · Substantial damageNTSB 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.Feb 9, 1997 · N6679F · Substantial damageNTSB 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…Jan 1, 1997 · N5813G · Substantial damage