Fatal NTSB investigations: Continental 0-200 series, 1997

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
Fatal NTSB investigations: Continental 0-200 series, 1997 per year, 1964–2026: 439 cases
19644
19653
19665
19673
196811
19698
19707
19714
19723
19736
19743
19756
19764
197713
197824
197910
198014
198112
198210
198315
198410
19859
19864
198714
198814
19897
199011
19916
199210
19933
19944
19955
19966
19977
19985
19994
20004
200113
20026
20037
20049
200511
20067
200710
20084
20096
20105
20116
20126
20132
20145
20155
20163
20175
20188
20194
20204
20216
20223
20238
20244
20253
20261

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.\"highestInjuryLevel\" = 'Fatal'
    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 FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.Oct 20, 1997 · N6206K · DestroyedNTSB 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…Mar 20, 1997 · N86T · DestroyedNTSB 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…Feb 28, 1997 · N89WL · DestroyedNTSB 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.Feb 1, 1997 · N50TB · DestroyedNTSB 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.Jan 12, 1997 · N10809 · DestroyedNTSB 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…Jan 1, 1997 · N8925S · Destroyed