Fatal NTSB investigations: Continental 0-200 series, 2004

9 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, 2004 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\") = 2004
    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 CHI05LA012Accident · 1 fatalLimited investigationFinal reportCessna 150M · Ashley, NDThe non-instrument rated pilot's continued flight into known adverse weather conditions and his not maintaining aircraft control during cruise flight. Factors present were the night condition and low ceilings.Oct 21, 2004 · N63439 · DestroyedNTSB FTW04LA226Accident · 1 fatalLimited investigationFinal reportCassutt Iiim · Pearland, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin while turning from the base leg of the traffic pattern to final. A contributing factor was the pilot's lack of experience for the make/model airplane.Sep 2, 2004 · N3TW · DestroyedNTSB CHI04WA235Accident · 2 fatalForeign investigationChampion 7ECA · Angle Inlet, MNAug 23, 2004 · N11083 · DestroyedNTSB SEA04LA168Accident · 1 fatalLimited investigationFinal reportCessna 150L · Angela, MTThe failure of the pilot to maintain clearance while maneuvering. A factor contributing to the accident was the physical impairment of the pilot due to an elevated blood alcohol level.Aug 19, 2004 · N17062 · DestroyedNTSB NYC04FA185Accident · 2 fatalField investigationFinal reportCessna A150L · Kinnelon, NJBoth pilots inadequate visual lookout, which resulted in a midair collision.Aug 7, 2004 · N6186F · 2 aircraft · Substantial damageNTSB ANC04FA042Accident · 2 fatalField investigationFinal reportCessna 150C · DeLand, FLThe pilot's failure to detect water in the fuel system during the preflight inspection, which precipitated a loss of engine power during initial climb, and his failure to maintain adequate airspeed resulting in a stall.Mar 17, 2004 · N2080Z · DestroyedNTSB ATL04FA071Accident · 1 fatalField investigationFinal reportCessna 150G · High Falls, GAThe pilot's impairment due to alcohol which resulted in his failure to maintain adequate airspeed, inadvertent stall, and subsequent in-flight collision with trees.Jan 27, 2004 · N2981J · Substantial damageNTSB MIA04FA044Accident · 2 fatalField investigationFinal reportCessna 150M · Venice, FLThe spatial disorientation of the flightcrew during the dark night and their failure to maintain control of the airplane resulting in the uncontrolled descent and in-flight collision with trees and terrain.Jan 18, 2004 · N63159 · DestroyedNTSB MIA04FA043Accident · 1 fatalField investigationFinal reportPiper PA-30 · Clearwater, FLThe failure of both pilots to maintain adequate visual lookout while entering the traffic pattern (downwind leg) at an uncontrolled airport resulting in a midair collision. inadvertent stall, and in-flight collision with terrain.Jan 17, 2004 · N8735Y · 2 aircraft · Substantial damage