Fatal NTSB investigations: Continental 0-200 series, 2015

5 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, 2015 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\") = 2015
    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 ANC16FA001Accident · 1 fatalField investigationFinal reportCessna 150F · Big Lake, AKThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering, which resulted in a stall at too low an altitude to allow recovery.Oct 8, 2015 · N7064 · Substantial damageNTSB ERA15FA362Accident · 2 fatalField investigationFinal reportCessna 150H · Morrisville, NYThe pilot's failure to maintain airspeed and her exceedance of the airplane's critical angle-of-attack, which led to an aerodynamic stall, following a total loss of engine power for reasons that could not be determined because postaccident examination of the…Sep 20, 2015 · N22721 · DestroyedNTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Sep 12, 2015 · N8185F · DestroyedNTSB CEN15FA386Accident · 1 fatalField investigationFinal reportBarrow Ted A ONE Easy · Battle Creek, MIThe pilot’s loss of airplane control due to his diverted attention to the canopy opening in flight.Aug 28, 2015 · N227TB · DestroyedNTSB CEN15FA307Accident · 4 fatalField investigationFinal reportCessna T310R · Cody, WYThe pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.Jul 18, 2015 · N72TP · Destroyed